Data

dune

I remember seeing a /dune dashboard visualizing the asset distribution (segmented by total value, type of assets, etc.) in addresses connected to Farcaster accounts but can't seem to find it now

does anyone have the link?

ok, I couldn’t find this so I’m starting a bounty to make it happen :)

the closest I came across is this dashboard from @yesyes https://dune.com/yesyes/farcaster-users-onchain-activities

I'm looking for a /dune dashboard that shows:
- total USD amount of tokens in Farcaster user wallets
- USD amount of monthly token inflows in Farcaster user wallets
- USD amount of monthly token outflows in Farcaster user wallets

for each of these: 

(1) visualize distribution of USD amounts - i.e. how many users have: 
- < $100
- $100-$1k
- $1k-$10k
- $10k-$50k
- $50k-$200k
- $200k-$500k
- $500k-$2m
- > $2m

(2) add a table to show these amounts for each user (searchable by username)

- 250 USDC for the first Dune dashboard showing all of these metrics

- 50 USDC for sharing a third party dashboard that already covers this (needs to cover everything requested, 10 USDC for something that covers it only partly)

feel free to reach out with any questions!

https://warpcast.com/moritz/0x68323b6d

Blockchain data analyst. Interested in data science and blockchain.

Analysis -https://dune.com/yesyes, https://paragraph.xyz/@yesyes



Hey, I am working on a similar problem using dune API and python!  Making a dune dashboard would be too slow imo but happy to see others try it.

oh nice! if it isn't on Dune but can be freely accessed & visualised some other way that's fine too for the bounty! would love to see it :)