See How to ingestFull archives: s3://tf-premium-parquet/public-postgres/farcaster/v2/full/Incremental archives: s3://tf-premium-parquet/public-postgres/farcaster/v2/incremental/
Data is exported every 30 mins and once a day. You can start by downloading a daily snapshot and then ingesting the incremental 30m files.
Originally timestamps were stored with nanoseconds, but as of April 23, 2024 they are all using microseconds.
The “messages” table is very very large and we are not currently exporting it. Please talk with us if you need the table and we can figure out the best solution for you.