That $47M held in stablecoins is looking pretty good right now...

building @emptyblock / art, music, onchain data / prev director of research @coinmetrics

full dashboard here 

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

you fixed it, you legend! 

trying to see how this changes overtime, any pointer of how to achieve easily/is that something you already have?

had to filter out about 30 spammy tokens, Dune was showing prices in the trillions!

that would be really cool to see. I'm currently using the Base balances table to just grab the most recent balance for all connected addresses. but Dune also has a daily balances table (tokens_base.balances_daily), so I think you should be able to use that to get dry powder over time. the only problem is it would be an absolutely massive query

had to filter out about 30 spammy tokens, Dune was showing prices in the trillions!

that would be really cool to see. I'm currently using the Base balances table to just grab the most recent balance for all connected addresses. but Dune also has a daily balances table (tokens_base.balances_daily), so I think you should be able to use that to get dry powder over time. the only problem is it would be an absolutely massive query

https://dune.com/queries/4709024/7826622/

Yeah i was playing around with the filtering based on volume + number of occurrences. That was a relatively easy fix.

You're right on size, it just takes too long atm.