Content
@
0 reply
0 recast
0 reaction
moritz 💧🔑
@moritz
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
19 replies
2 recasts
12 reactions
0xRob > Devcon|DuneCon 🇹🇭
@0xrob
here you go: https://dune.com/0xrob/farcaster-balances-and-token-volume
1 reply
0 recast
2 reactions
moritz 💧🔑
@moritz
nice, the structure is exactly what I was looking for! looks like a lot of the data is wrong though - I checked 10 addresses labeled as “> 2m” and most of them hold much less I assume that’s related to some shitcoins being converted at a much higher rate than they actually are at - do you think it’s possible to limit this to a set of widely used tokens? (e.g. top 100 by volume per chain) probably more accurate that way
1 reply
0 recast
1 reaction
