Farcaster

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!)

random facts and life excerpts. vulnerability is strength ✨🌈 fullstack & design, building /uno

cryptocurrency 2019 | Interested in the art of generative | AI artist

this is not a question that can be answered by a SQL query 😂

Thank you for your honesty, I think this should be clarified through some friends

Location of active (last 24h) hubs.
Total: 5060 hubs

More than 10 hubs:
- Germany	3660
- Finland 403
- USA	299
- Russian Federation	93
- France	83
- Australia	82
- UK	74
- Sweden	58
- Hong Kong	53
- India	39
- Singapore	38
- Japan	32
- Netherlands	29
- Ukraine	28
- Viet Nam	19

not sure what you mean by clarified through friends but I did come across this cast from @vrypan.eth that shows where all the hubs are located

Dad, geek, conversation liquidity provider. vrypan.net (home), /weatherxm (work), @l--o--l (fun). Also https://paragraph.xyz/@purplesubmarine

Thank you for your attention, I will follow it, maybe I will get an answer💙

not sure what you mean by clarified through friends but I did come across this cast from @vrypan.eth that shows where all the hubs are located 

https://warpcast.com/vrypan.eth/0x01cecf2a