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

Also a big shoutout to @pinatacloud for their public Hub support that helps make this possible 🫡 🤝  (https://www.pinata.cloud/farcaster)

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

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

hubs

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

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!

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

this is great brock

can you help me set this up for retrieving all the casts that have as an embed a video? this means that the url of any of its embed contains the string

stream.warpcast.com

thank you for your help

Of course! Check this sucker out: 

https://snippets.so/snip/bafkreiag45slqbxaj5x6zb6zdithspnc6bvh7leokewvflq4gjpepggevi

that is awesome 🤯 please accept the rest of my daily allowance. 26 $degen

This is amazing.. 1069 $degen ⚡️💜⚡️