Network graph analysis on OSO data

[ccerv1]

OSO is creating datasets that enable near unlimited opportunities for network graph analysis!

Our primary intermediate model -- int_events -- is indexed by to and from events for a range of different entities and event types. You can access this in BigQuery. We also have the same data, streamlined a bit, available in Clickhouse and via our API for even faster queries: timeseries_events_by_artifact_v0. The schema is:

- time
- to_artifact_id
- from_artifact_id
- event_source_id
- event_type
- event_source
- amount

Here are some specific use cases and other resources for how to do network graph analysis on OSO!

Video Tutorial

Here is a Loom Video explaining how to query the data.

Github contribution graph

select distinct
  user_artifacts.artifact_name as user,
  repo_artifacts.artifact_name as repo
from `{YOUR_PROJECT_NAME}.oso.timeseries_events_by_artifact_v0` as events
join `{YOUR_PROJECT_NAME}.oso.artifacts_v1` as user_artifacts
  on events.from_artifact_id = user_artifacts.artifact_id
join `{YOUR_PROJECT_NAME}.oso.artifacts_v1` as repo_artifacts
  on events.to_artifact_id = repo_artifacts.artifact_id
where
    events.event_type = 'COMMIT_CODE'
    and events.time > '2024-01-01'

OpenRank data challenge with Byte Explorers

There are a collection of starter notebooks here.

RPGF3 PageRank bounty

There is a playground GitHub dataset and several PageRank implementations (for repos, not developers) here

Farcaster social graph

This runs directly on top of the Farcaster dataset on OSO...

select distinct
  fid,
  target_fid
from `{YOUR_PROJECT_NAME}.farcaster.links`
where deleted_at is null
limit 10

[ccerv1]

Here is a subset of data from Farcaster and GitHub for graph analysis: https://drive.google.com/drive/folders/1Db9SqcOA1nPoFNQzZgEZfQ7FTSU3UjEB?usp=sharing