Farcaster dry power Dune dashboard from @nmadd

https://dune.com/empty_block/farcaster-dry-powder

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

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

This is very cool!

one thing - 
use a query  like to get the connected addresses - 
select JSON_EXTRACT_scalar(claim, '$.address'), fid from dune.neynar.dataset_farcaster_verifications
where length(JSON_EXTRACT_scalar(claim, '$.address')) = 42 and deleted_at is null

(this has a deleted_at column which allows you to filter out disconnected addresses)

Blockchain data analyst. Interested in data science and blockchain.

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