Here are the queries I used for calculating Farcaster dry powder, broken down step by step 👇

If anyone can find any flaws, would be helpful!

Trying to get a canonical dashboard to share with prospective developers.

@emptyblock + art, music, onchain data. former Director of Research @coinmetrics

Working on Farcaster and Warpcast. Longer thoughts at https://dwr.email

Will look at it after waking up in the morning

@nmadd 

For now - 
Simply put a "where deleted_at is null" clause to not count disconnected addresses.

Blockchain data analyst. Interested in data science and blockchain.

Analysis-
https://www.hypersub.xyz/s/yesyes-analytics-qr0v8onrvev4,
https://dune.com/yesyes

Also, the base prices table is a bit unreliable sometimes so be careful with that.