Content pfp
Content
@
0 reply
20 recasts
20 reactions

Garrett pfp
Garrett
@garrett
Farcaster is almost to the millionth FID or registered account Whatโ€™s the best data source to track DAU now? Does anyone have a good dune?
6 replies
2 recasts
31 reactions

tldr (tim reilly) pfp
tldr (tim reilly)
@tldr
my mental approximation for qDAU is ~50x the number of likes on the most liked cast of the day
3 replies
1 recast
11 reactions

Pichi ๐ŸŸช๐Ÿ–๐Ÿน๐ŸŽฉ ๐Ÿก๐ŸŒธ pfp
Pichi ๐ŸŸช๐Ÿ–๐Ÿน๐ŸŽฉ ๐Ÿก๐ŸŒธ
@pichi
This is my new Bible. Whoโ€™s here daily. https://dune.com/queries/4733142
1 reply
0 recast
1 reaction

Garrett pfp
Garrett
@garrett
This seems pretty accurate from my personal experience. I had always thought that Farcaster Daily Posters oscillated between 10-20k
1 reply
0 recast
2 reactions

Pichi ๐ŸŸช๐Ÿ–๐Ÿน๐ŸŽฉ ๐Ÿก๐ŸŒธ pfp
Pichi ๐ŸŸช๐Ÿ–๐Ÿน๐ŸŽฉ ๐Ÿก๐ŸŒธ
@pichi
My gut stays its right. And the number of good accounts is even lower but I donโ€™t know how youโ€™d pull qDAU? @jc4p is it possible to cross reference this with the public spam labels? Iโ€™d like to know how many of these are level 2. My guess would be 2-3k but Iโ€™d love to know for real. @mvr would line your thoughts too
1 reply
0 recast
2 reactions

Kasra Rahjerdi pfp
Kasra Rahjerdi
@jc4p
iโ€™m like 80% sure @rish added the labels to the Dune dataset recently, will investigate and see if i can add into my query!
2 replies
0 recast
2 reactions

rish pfp
rish
@rish
Itโ€™s in our sql playground, not on dune yet
1 reply
0 recast
3 reactions

Kasra Rahjerdi pfp
Kasra Rahjerdi
@jc4p
ty!! @pichi iโ€™ll run the data for you in neyarโ€™s sql playground so we have a snapshot then add it to the dune later :)
2 replies
0 recast
3 reactions