I downloaded all 1,680,399 posts on Bluesky
I downloaded all the posts on Bluesky as of 2023-05-01. Then I did some data analysis on the 1680399 posts from 45457 accounts.
Queries I tried
Top 10 accounts with most followers:
select * from profile order by (select count(1) from follow where "subjectDid" = profile.creator) desc limit 10;
Output:
uri | cid | creator | displayName | description | avatarCid | bannerCid | indexedAt
-------------------------------------------------------------------+-------------------------------------------------------------+----------------------------------+-----------------------------------+------------------------------------------------------------------------------------------------------------------------------------------------------+-------------------------------------------------------------+-------------------------------------------------------------+--------------------------
at://did:plc:oky5czdrnfjpqslsw2a5iclo/app.bsky.actor.profile/self | bafyreifjtax5wqyn6zl7h737mfnnk63l5kdep3t2auo75z6awwinr5pq5q | did:plc:oky5czdrnfjpqslsw2a5iclo | Jay 🦋 | CEO of Bluesky, steward of AT Protocol. Let’s build a federated republic, starting with this server. +| bafkreihquydaf5xer53afkmdefp2hpwbtqcgurxo2hsdkrpwpvm6uhkyg4 | bafkreicgnmvhtmj4arcvwhueygbwvkucd3odvom3lxtfmn6wlqbh3yf7p4 | 2023-05-02T03:23:27.059Z
| | | | +| | |
| | | | Nature, knowledge, technology. I like to think of a cybernetic forest. 🌱 🪴 🌳 | | |
at://did:plc:6fktaamhhxdqb2ypum33kbkj/app.bsky.actor.profile/self | bafyreiaugm44rvh7uc7agdqlx4yfxublurrnkjileb24lwyky4csgukz2m | did:plc:6fktaamhhxdqb2ypum33kbkj | jack | | bafkreigzezczfmvygzhf4d4el5ihh5lrt6dtdilxgcmyu3ikusit36cebi | | 2023-05-02T03:24:39.506Z
at://did:plc:z72i7hdynmk6r22z27h6tvur/app.bsky.actor.profile/self | bafyreibqffus4eyyivya3gg22leqy55cbwxyihqtyuenceevc4bwvbk4h4 | did:plc:z72i7hdynmk6r22z27h6tvur | Bluesky | Official bluesky account (check domain 👆) +| bafkreic5kmqlhrhbfnh2bx6fsetvkra4noqja5ngsnnadrvubd6jcoc3ae | bafkreif7lzr3l7ysgwfuiv7q6rtlyebup2mizdgmbhmsunowspiq7m4oee | 2023-05-02T18:08:51.736Z
| | | | +| | |
| | | | Follow for updates and announcements | | |
at://did:plc:ragtjsm2j2vknwkz3zp4oxrd/app.bsky.actor.profile/self | bafyreigyr7jtqlzftcfrfznjhmwqevzdzgih6vio3v5jl6rcbpycbqus5u | did:plc:ragtjsm2j2vknwkz3zp4oxrd | Paul Frazee (all hoity toity now) | Developer at Bluesky. The one who puts bugs in this app. | bafkreiftyjy6k3t2yi5hh7gwin4p4hkuhp3kqxbzbbzr4gjsgotvcyk73e | bafkreibhvcmv3ziagszmfdgxj3r6z3ivllcfnirhxux4stpifr3xifqjpu | 2023-05-02T03:20:44.736Z
at://did:plc:p7gxyfr5vii5ntpwo7f6dhe2/app.bsky.actor.profile/self | bafyreibx3xvykykele3dt2i2sogotsnmmckrlqisqcwqmkus6cfjjw56oa | did:plc:p7gxyfr5vii5ntpwo7f6dhe2 | Alexandria Ocasio-Cortez | Congresswoman for NY14, repping the Bronx and Queens. Grassroots progressive. Funded by everyday people, not lobbyists. A better world is possible. +| bafkreia7pjciqmezep36yotfgas23eie47sy5ymcorzd7exejlxtiox6by | | 2023-05-05T20:01:01.550Z
| | | | +| | |
| | | | ocasiocortez.com/about | | |
at://did:plc:vpkhqolt662uhesyj6nxm7ys/app.bsky.actor.profile/self | bafyreiana5uck6quyl53dux5bvpgghecynzlviqzvej6sz547fchsv5dcy | did:plc:vpkhqolt662uhesyj6nxm7ys | Uai? | Technical advisor to @bluesky, first engineer at Protocol Labs. Wizard Utopian | bafkreihxiic7f65slclhzy3aanyvrclotyvatwmd7lct4g4bwfvnzqlexa | bafkreihxbkzsboqivoqlzaii7ye5ykp3xztbwcnjuos7bbz6zd5irndnqi | 2023-05-02T03:22:09.523Z
at://did:plc:cm4bwax4evxmkiuwxvvkvlmx/app.bsky.actor.profile/self | bafyreifvf5xxqg7ggw2g2wqfh62y5e5efphna3hbljeg3mduo22up4ey44 | did:plc:cm4bwax4evxmkiuwxvvkvlmx | Thomas Pockrandt | Tech Advisor & Digital Strategist 🦾 +| bafkreidvjlqht65wd64dae5etrgh2xodgubeyoryxu7nugmcdzwv2qk4jq | bafkreid3272rix3d7o5s5umqvfo5alzmhjwzmdfne4hkommwpf5wjqpchu | 2023-05-02T06:25:23.203Z
| | | | +| | |
| | | | https://thomaspockrandt.com | | |
at://did:plc:pdac24jyypwultrppa457voe/app.bsky.actor.profile/self | bafyreicnkal36xuktylcvzkvhmzrmvklrwbm5jpuvmxfjfoeiztehkiahu | did:plc:pdac24jyypwultrppa457voe | Vishal Gulia 🌞 | Bluesky’s first memer, early adopter & investor of decentralised social. My mission is to spread humour and joy. +| bafkreihr76fl52k43wklwxtklkhr7tiww7cudjzphxauh6whvf6ohlqmri | bafkreiclaok4chj6g5kvruro7ai7kxtpmyn47lou6g23qt4uw2z2bcfequ | 2023-05-02T05:29:14.433Z
| | | | +| | |
| | | | www.diamondapp.com/u/VishalGulia | | |
at://did:plc:36tmqxxepo5jlx54peygtx6i/app.bsky.actor.profile/self | bafyreieuchpwxvnjirvsk4adcllnqjxlcor32z3236nx5duvizloevlsvm | did:plc:36tmqxxepo5jlx54peygtx6i | Cat | Cats lover | bafkreig24kwjk4kucmeqlgmux2czvgqvbax43w4ovcukfr6rv2yy36chve | bafkreiagc3lyyet62ioy476zja5azjmaax55nakfztslffsggqequjchhu | 2023-05-02T05:54:08.760Z
at://did:plc:6wpkkitfdkgthatfvspcfmjo/app.bsky.actor.profile/self | bafyreigdmlufln4autqiggpgpi4hwjtlljalrvqpzg5xc6ur6sfpjqirze | did:plc:6wpkkitfdkgthatfvspcfmjo | wint | Pussy | bafkreiggofiqpdnz6tfajmu7i5gdqyl7j27h22bqivpmkymuzwd5kcudfm | | 2023-05-05T18:33:35.121Z
(10 rows)
Top 10 accounts following the most users:
select * from profile order by (select count(1) from follow where "creator" = profile.creator) desc limit 10;
uri | cid | creator | displayName | description | avatarCid | bannerCid | indexedAt
-------------------------------------------------------------------+-------------------------------------------------------------+----------------------------------+-----------------------------+------------------------------------------------------------------------------------------------------------------+-------------------------------------------------------------+-------------------------------------------------------------+--------------------------
at://did:plc:md6i2csjmkfoie6u4ot4kjmn/app.bsky.actor.profile/self | bafyreifj6qpnx5lsh7nwoisfal2bgzojfyqymtnjicjpboiyqblr54tkje | did:plc:md6i2csjmkfoie6u4ot4kjmn | Eddie Silva | Al enthusiast | writer | Coffee lover ☕️ +| bafkreib3g5pqdsyuidrcs4k7etaibpivoj5tfgu5oqvy6fewyfrga6hnzm | bafkreiatd5br5szcttcnchjusmzqvxcrrg4pe2wjzsggwbfkogpjnwqjia | 2023-05-02T19:15:11.388Z
| | | | +| | |
| | | | Bsky Unauthorized User Counter 🫣 +| | |
| | | | +| | |
| | | | Most of the images posted here are generated by AI. +| | |
| | | | 🇺🇸 English 🇧🇷 Português | | |
at://did:plc:cm4bwax4evxmkiuwxvvkvlmx/app.bsky.actor.profile/self | bafyreifvf5xxqg7ggw2g2wqfh62y5e5efphna3hbljeg3mduo22up4ey44 | did:plc:cm4bwax4evxmkiuwxvvkvlmx | Thomas Pockrandt | Tech Advisor & Digital Strategist 🦾 +| bafkreidvjlqht65wd64dae5etrgh2xodgubeyoryxu7nugmcdzwv2qk4jq | bafkreid3272rix3d7o5s5umqvfo5alzmhjwzmdfne4hkommwpf5wjqpchu | 2023-05-02T06:25:23.203Z
| | | | +| | |
| | | | https://thomaspockrandt.com | | |
at://did:plc:2rhgf24qcpdxuscon3gwp6it/app.bsky.actor.profile/self | bafyreid5m5u5ievdwjkm32yi2xcndj3lihvnky7u65dusolgmmif4ix3w4 | did:plc:2rhgf24qcpdxuscon3gwp6it | Mr.Preet⭐ | Fullstack Developer 🇮🇳 +| bafkreiacw5l67mam5pa3utpe7ifc4ytyh4rthf5c5t2ksfqk37adtt2dtu | bafkreidfz3xzmtw3mo7dcxcwt6xaag3qxb33wccxmqxtxoy6fno54sn65a | 2023-05-02T10:03:38.126Z
| | | | +| | |
| | | | Founder: Pinsta.xyz +| | |
| | | | Co-Founder: CircleIt.app +| | |
| | | | Twitter: https://twitter.com/jsonpreet | | |
at://did:plc:gavqr7yuapgfhfr4hvosjyoh/app.bsky.actor.profile/self | bafyreihmwxxxbt367thnmpmdqjk3jmutsprculfe3nudxxuxg6a65mawsi | did:plc:gavqr7yuapgfhfr4hvosjyoh | Nelson Coffee Roaster ☕️ 🐱🎸🏍 | コーヒー豆専門店「Nelson Coffee Roaster」 +| bafkreifrqxhra4mmipyqazvzgr5fhuundm3qrx7y5pd4flrx27msjy3gji | bafkreifownbu3froekogegccc4goehgadavrilzsqk3twynyqatx7ygo7a | 2023-05-02T18:23:12.402Z
| | | | コーヒー業界30年 +| | |
| | | | 家にネコがいます🐱 +| | |
| | | | フォローは手動✋ +| | |
| | | | コーヒー豆EC☕️🫘 https://ncr.official.ec +| | |
| | | | All languages other than Japanese are machine translated. | | |
at://did:plc:4usvqnzxonnvz2hyvx2msr4h/app.bsky.actor.profile/self | bafyreibmtutsbpjm33vozzszmurjt5242djdpscjpl2wrqo7jvgfq5w5eu | did:plc:4usvqnzxonnvz2hyvx2msr4h | caleb 2 | in the clouds. He / They +| bafkreigpk7b6baruwsqpp7et6zpdhjxu7a4gnxxgrwmino2tedugpvqdwy | bafkreig7fqucnf7nnkdel56l5pgjji3q4oeof4y3rnfqdh3uocwkjwu4sa | 2023-05-02T04:49:59.907Z
| | | | +| | |
| | | | welcome to my alt, unofficial posts here. | | |
at://did:plc:f7du5s6xe4fza2gixnynvzxq/app.bsky.actor.profile/self | bafyreiakdkt7rccq3tjsqbcjtunzhhzyaupfsg4cau2t2oby4olc66fltm | did:plc:f7du5s6xe4fza2gixnynvzxq | shitpost machine 3000 | here to shitpost +| bafkreiec7nqaxcggbzvhmbvxqsp4ejkh5ehqqiiwhejffwk7dnmwyqbelm | bafkreic3gbl7ykso4ecmmn3mdi3m5kk47z6tbw6ana5a7rvpgtet6hy4pu | 2023-05-06T13:27:46.898Z
| | | | follow me for 69 years of good luck | | |
at://did:plc:sbalnchbqyuqkwpjjy3zry7f/app.bsky.actor.profile/self | bafyreiezx2zfoewcmurhc6zpaqsjxq6nfnriilvrrmlfmdquyhf2ihsdh4 | did:plc:sbalnchbqyuqkwpjjy3zry7f | Rie | Software Engineer, Professional Hugger, Femboy, 🏳️🌈 +| bafkreih5mcnl63ancqcs3smd35a62ucj2dwasbnlwmc3fvy3cmxqlzsrum | bafkreiag3g3gapj7otvk3sjkdimbcoh2i56uzq32ytcqmixnx7bxk3fsru | 2023-05-05T20:48:47.941Z
| | | | read if cute | | |
at://did:plc:pdac24jyypwultrppa457voe/app.bsky.actor.profile/self | bafyreicnkal36xuktylcvzkvhmzrmvklrwbm5jpuvmxfjfoeiztehkiahu | did:plc:pdac24jyypwultrppa457voe | Vishal Gulia 🌞 | Bluesky’s first memer, early adopter & investor of decentralised social. My mission is to spread humour and joy.+| bafkreihr76fl52k43wklwxtklkhr7tiww7cudjzphxauh6whvf6ohlqmri | bafkreiclaok4chj6g5kvruro7ai7kxtpmyn47lou6g23qt4uw2z2bcfequ | 2023-05-02T05:29:14.433Z
| | | | +| | |
| | | | www.diamondapp.com/u/VishalGulia | | |
at://did:plc:36tmqxxepo5jlx54peygtx6i/app.bsky.actor.profile/self | bafyreieuchpwxvnjirvsk4adcllnqjxlcor32z3236nx5duvizloevlsvm | did:plc:36tmqxxepo5jlx54peygtx6i | Cat | Cats lover | bafkreig24kwjk4kucmeqlgmux2czvgqvbax43w4ovcukfr6rv2yy36chve | bafkreiagc3lyyet62ioy476zja5azjmaax55nakfztslffsggqequjchhu | 2023-05-02T05:54:08.760Z
at://did:plc:u66yy4dkibtqvckpvlpvhwbk/app.bsky.actor.profile/self | bafyreicewuhqzsm2fsjk3lpijoygn44gk3jii2vsseosjpwzoldbcduike | did:plc:u66yy4dkibtqvckpvlpvhwbk | Andrew Lombardi 💙☁️ | Head geek at Mystic Coders, software engineer, startup expert, father and passionate about PKM. +| bafkreiec5kwx4wghxhp55dr6xwv4gukp63vve67q3xmsxmoeuiah32xp5q | bafkreieba2zbdtjn6ynk75q2l7l4mqk243m55smx2koaz24dla7pvqjipu | 2023-05-03T15:50:57.710Z
| | | | +| | |
| | | | Former Sr SWE at Twitter +| | |
| | | | +| | |
| | | | https://linktr.ee/kinabalu +| | |
| | | | ko-fi: https://ko-fi.com/kinabalu | | |
(10 rows)
Top 3 most reposted posts:
select * from post order by (select count(1) from repost where post.uri = repost.subject) desc limit 3;
uri | cid | creator | text | replyRoot | replyRootCid | replyParent | replyParentCid | createdAt | indexedAt | sortAt
------------------------------------------------------------------------+-------------------------------------------------------------+----------------------------------+----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+-----------+--------------+-------------+----------------+--------------------------+--------------------------+--------------------------
at://did:plc:dst5a7uf7wtatmp66p5ygzmw/app.bsky.feed.post/3juezhxkcrl2m | bafyreifg2433jfjkwn7qb34o6zrrecdygkxh22eku27scrtj3libz5chge | did:plc:dst5a7uf7wtatmp66p5ygzmw | guess where we’re complaining about it now bitch | | | | | 2023-04-27T21:15:40.989Z | 2023-05-05T17:08:48.008Z | 2023-04-27T21:15:40.989Z
at://did:plc:53kudcqj7sizx2eaclc5sicc/app.bsky.feed.post/3juhljm3c6o2p | bafyreiccsz6bh4g2chrwohruucshdgc6qdsyh45pcyvjochw5ojwhwdevi | did:plc:53kudcqj7sizx2eaclc5sicc | Reskeet if u think trans people are cool 😎 | | | | | 2023-04-28T21:44:03.137Z | 2023-05-05T22:08:30.997Z | 2023-04-28T21:44:03.137Z
at://did:plc:ragtjsm2j2vknwkz3zp4oxrd/app.bsky.feed.post/3jtqhia5mxe2z | bafyreibnoomzhzj7qhcphhdeufjur4egobufmhqpsbgowthhp4eomfzrt4 | did:plc:ragtjsm2j2vknwkz3zp4oxrd | 📢 Android is finally here! 🎉 +| | | | | 2023-04-19T17:00:27.839Z | 2023-05-02T03:20:44.736Z | 2023-04-19T17:00:27.839Z
| | | +| | | | | | |
| | | Google takes a while to update their search so here’s the direct link: +| | | | | | |
| | | +| | | | | | |
| | | https://play.google.com/store/apps/details?id=xyz.blueskyweb.app&hl=en_US | | | | | | |
(3 rows)
Top 3 most liked posts:
select * from post order by (select count(1) from "like" as l where post.uri = l.subject) desc limit 3;
uri | cid | creator | text | replyRoot | replyRootCid | replyParent | replyParentCid | createdAt | indexedAt | sortAt
------------------------------------------------------------------------+-------------------------------------------------------------+----------------------------------+----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+-----------+--------------+-------------+----------------+--------------------------+--------------------------+--------------------------
at://did:plc:dst5a7uf7wtatmp66p5ygzmw/app.bsky.feed.post/3juezhxkcrl2m | bafyreifg2433jfjkwn7qb34o6zrrecdygkxh22eku27scrtj3libz5chge | did:plc:dst5a7uf7wtatmp66p5ygzmw | guess where we’re complaining about it now bitch | | | | | 2023-04-27T21:15:40.989Z | 2023-05-05T17:08:48.008Z | 2023-04-27T21:15:40.989Z
at://did:plc:oky5czdrnfjpqslsw2a5iclo/app.bsky.feed.post/3jukkbpk5ak2m | bafyreidziqiimnaynh47bt6ybuue2csp5mk3gnpxhnv7onoe4glosdmhty | did:plc:oky5czdrnfjpqslsw2a5iclo | Nobody has a right to access an invite-only closed beta, and if they are creating an account exclusively to jump in and harass people in replies they will be removed. | | | | | 2023-04-30T01:59:43.405Z | 2023-05-02T03:23:27.059Z | 2023-04-30T01:59:43.405Z
at://did:plc:p7gxyfr5vii5ntpwo7f6dhe2/app.bsky.feed.post/3juma3uvbuv22 | bafyreic7xiwblku7pvmu5vxpjdfewphrff53dqct7e62x3mpzjhaa7fgcq | did:plc:p7gxyfr5vii5ntpwo7f6dhe2 | I just want a place to poast and roast without a) nazis and b) the New York Times writing an editorial about it like “aoc said nazis are bad. Is she wrong? We went on a diner date with harlan crow’s PR guy to find out” | | | | | 2023-04-30T18:02:49.778Z | 2023-05-05T20:01:01.550Z | 2023-04-30T18:02:49.778Z
(3 rows)
Top 3 most replied posts:
select * from post order by (select count(1) from post as reply where post.uri = "replyParent") desc limit 3;
uri | cid | creator | text | replyRoot | replyRootCid | replyParent | replyParentCid | createdAt | indexedAt | sortAt
------------------------------------------------------------------------+-------------------------------------------------------------+----------------------------------+-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+-----------+--------------+-------------+----------------+--------------------------+--------------------------+--------------------------
at://did:plc:oky5czdrnfjpqslsw2a5iclo/app.bsky.feed.post/3jt5pfybq6u2q | bafyreie22vh3vqkdt4kbcfdxfbpmwcfexqg5ovgaqemx2h7nrwelh3o6zi | did:plc:oky5czdrnfjpqslsw2a5iclo | New invite thread — +| | | | | 2023-04-12T06:01:47.209Z | 2023-05-02T03:23:27.059Z | 2023-04-12T06:01:47.209Z
| | | +| | | | | | |
| | | If you want invites, message me here instead of commenting on other threads. +| | | | | | |
| | | +| | | | | | |
| | | I got access to a cli tool why.bsky.world built to drop invites into your accounts today. 😈😇 +| | | | | | |
| | | +| | | | | | |
| | | May or may not distribute. 🪄 | | | | | | |
at://did:plc:oky5czdrnfjpqslsw2a5iclo/app.bsky.feed.post/3juflvnb3d62u | bafyreiga6tugnvel3x4eb57wbkp5gbu2gpa7eiqmbyconpaedwdy7lvx6m | did:plc:oky5czdrnfjpqslsw2a5iclo | Guys, please don't let "skeets" stick +| | | | | 2023-04-28T02:45:27.170Z | 2023-05-02T03:23:27.059Z | 2023-04-28T02:45:27.170Z
| | | +| | | | | | |
| | | The experiment in decentralized naming decisions has resulted in the worst possible term +| | | | | | |
| | | +| | | | | | |
| | | How about skoots? Can we bring back skoots? Bluesky OGs, help me out here, remember skoots? | | | | | | |
at://did:plc:p7gxyfr5vii5ntpwo7f6dhe2/app.bsky.feed.post/3jupcszqouk2o | bafyreieauaougusit3dzl5hcztnohdxlpebhqfhnj6fhv2j5oggjopaq3u | did:plc:p7gxyfr5vii5ntpwo7f6dhe2 | Right now! AMA | | | | | 2023-05-01T23:29:33.444Z | 2023-05-05T20:01:01.550Z | 2023-05-01T23:29:33.444Z | | I'm here to shitpost & talk tech mostly, but just so you know where I stand when civil war breaks out | | | | | | |
(3 rows)
Top 10 longest threads:
select count(uri), "replyRoot" from post group by "replyRoot" order by count(uri) desc limit 10;
count | replyRoot
--------+------------------------------------------------------------------------
697077 |
21347 | at://did:plc:nx3kofpg4oxmkonqr6su5lw4/app.bsky.feed.post/3juhgsu4tpi2e
8623 | at://did:plc:kcevumnk4gjxyegqwbubpajo/app.bsky.feed.post/3julld7hob62y
2412 | at://did:plc:hdfrgtchoulcxlfzl2qsqdec/app.bsky.feed.post/3juiawxjnuk2y
2046 | at://did:plc:alrwn2rkxotdsyfnn27op6e7/app.bsky.feed.post/3jtz3qo6zjl23
1984 | at://did:plc:tuett6q54evdlpvezox5j5zi/app.bsky.feed.post/3juhth2jgyl2r
1980 | at://did:plc:hsqwcidfez66lwm3gxhfv5in/app.bsky.feed.post/3jucndteqnk2l
1972 | at://did:plc:izlc5ki5pat26fiammhyfv23/app.bsky.feed.post/3jukv52q4es2a
1330 | at://did:plc:g74vihxy7k6vsjxwus7g4sn6/app.bsky.feed.post/3juh447up7i2m
1118 | at://did:plc:7owy6yfqghzcnhskb2a3cg56/app.bsky.feed.post/3jukw75cawu26
(10 rows)
How I downloaded it
- Listed all users by calling https://bsky.social/xrpc/com.atproto.sync.listRepos
- Started Bluesky’s Bsky server
- called indexRepo for every user in the list to let the Bsky server download each user’s data via the federation protocol. (code)
What I learned
- How to download Bluesky data
- How to use GNU Parallel
- How to use DigitalOcean Spaces
- (Edit:) OneDrive is a terrible way to serve files