Farcaster Devs

Want all of Farcaster free and queryable? Tired of trying to run replicators? We've got a BigQuery dataset for you 😉 

https://console.cloud.google.com/bigquery?project=glossy-odyssey-366820&ws=!1m4!1m3!3m2!1sglossy-odyssey-366820!2sfarcaster

Syndicate

Solana

A sufficiently decentralized social network. farcaster.xyz

This dataset is a free, public good and a labor of love from us at indexing.co

We're committed to the @farcaster ecosystem 💜  Farcaster is now a first-class citizen for our indexing pipelines right alongside chains like /basese, /syndicate, and /solana 

Permissionless data == limitless opportunities

Looking for where to start? Try seeing who the most active reply guys are:

https://console.cloud.google.com/bigquery?sq=867429816176:87fef9a0cc334c199363075701d50e74

hubs

Currently, BigQuery is updated every hour with the latest snapshot of data. Depending on feedback, we'll likely try to make this truly realtime using some materialized views (any BigQuery experts out there?)

Need realtime data now? Just reach out - we can transform and pipe realtime data to your database(s) as well!

Our approach with this dataset is simple:

Normalize /hubs events to make data easier to work with. We would *love* feedback to make this as useful for the world as possible

To start, we have 5 tables available: casts, links, reactions, verifications, and profiles