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
Royal
@royalaid.eth
To get these amounts accurately you need to reach for something like Debank, it's a full time job keeping up with meaningful tokens in users wallets or in protocols that a user uses.
1 reply
0 recast
1 reaction
moritz 💧🔑
@moritz
definitely requires advanced data processing but seems like it's possible with @dune.eth based on the dashboard I linked above? it shows USD volumes for tokens bought / sold on DEXes by Farcaster users @mats is what I'm asking for something you think can be done with Dune? :)
0 reply
0 recast
0 reaction
