moritz 💧🔑 on Warpcast

Content pfp

0 reply

0 recast

0 reaction

moritz 💧🔑 pfp

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

10 replies

2 recasts

13 reactions

moritz 💧🔑 pfp

moritz 💧🔑

ah forgot to tag @bountybot :)

1 reply

0 recast

1 reaction

yesyes pfp

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.

1 reply

0 recast

2 reactions

0xRob 🛡️ pfp

here you go: https://dune.com/0xrob/farcaster-balances-and-token-volume

1 reply

0 recast

2 reactions

Linda Xie pfp

Is this bounty still open or is it closed?

1 reply

0 recast

1 reaction

Royal pfp

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

Hamza pfp

@moritz Last minute submission haha Let me know what you think https://dune.com/canhamzacode/farcaster-user-wallet-metrics

1 reply

0 recast

0 reaction

Linda Xie pfp

@whyshock if interested

0 reply

0 recast

2 reactions

Samuel pfp

@samuellhuber.eth

@chasesommer.eth I see you getting paid

0 reply

0 recast

2 reactions

0xRob 🛡️ pfp

It's not easy, but can be done. I'll give it a shot.

0 reply

0 recast

1 reaction

limone.eth 🍋 pfp

limone.eth 🍋

0 reply

0 recast

2 reactions