Content pfp
Content
@
0 reply
20 recasts
20 reactions

erica pfp
erica
@heavygweit
hello farcaster friends i'm working on improving my sql and i thought it would be fun to practice with real data and answer real questions about the network we're all on so, if you've ever wondered something about the farcaster network and the data on it - shoot examples of questions that i can answer with a sql query: > what's the daily avg # of casts? > what % of casts are just text? > who has been the most mentioned user this week? (will answer as many as i can over the next couple of days!)
8 replies
19 recasts
111 reactions

Jason pfp
Jason
@jachian
Trying to remember if I had a nasty self join in my back pocket
1 reply
0 recast
1 reaction

erica pfp
erica
@heavygweit
i saw your q - i don't have access to session data, i'm just using what is written to the hubs!
2 replies
0 recast
1 reaction

Jason pfp
Jason
@jachian
Got it, what granularity then? Iโ€™ve not looked at the hub data to know
1 reply
0 recast
0 reaction

Jason pfp
Jason
@jachian
Ah wait I just realized.. duh cast level.. What % of MAUs are also DAUs? Can use your interpretation on what time windows to use
0 reply
0 recast
0 reaction