Patrick Boueri @patrickboueri.com 路 May 12
1 / 3

This is an interim update (thanks again @microcosm.blue) I finally have a publicly accessible .duckdb snapshot @ pub-5ef34deaa1e54c25a97cea1bcfbd6456.r2.dev/atproto-snap... Which contains posts (no text) / likes / follows / blocks / actors of all bluesky. Would love if you poke around it! #rstats

7 likes 3 replies

?

Replies

Patrick Boueri 路 May 12

I forgot to mention the snapshot has the past 90 days (2026-02-10 - 2026-05-11) for posts / likes. It has ALL the follows, blocks, actors in microcosm (which is not complete yet and needs to be backfilled with hubble.) The duckdb is a meaty 60GB. I'll try to think of ways to make it smaller.

Patrick Boueri 路 May 12

Making this thing has been a challenge to get right, and I'm sure there are more issues. The source is here: github.com/pboueri/atpr... My hope is that it lowers the barrier for high quality user analysis on Bluesky to help with growth, and cool ways to understand more about how we interact.

Kuba Suder 馃嚨馃嚤馃嚭馃嚘 路 May 12

I think the "when joined" chart should go back to Nov 2024 at the very least?