Content pfp
Content
@
0 reply
0 recast
0 reaction
moritz ๐Ÿ’ง๐Ÿ”‘ pfp
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
15 replies
0 recast
13 reactions
moritz ๐Ÿ’ง๐Ÿ”‘ pfp
moritz ๐Ÿ’ง๐Ÿ”‘
@moritz
ah forgot to tag @bountybot :)
0 reply
0 recast
1 reaction
yesyes pfp
yesyes
@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.
1 reply
0 recast
2 reactions
0xRob pfp
0xRob
@0xrob
here you go: https://dune.com/0xrob/farcaster-balances-and-token-volume
1 reply
0 recast
2 reactions
Hamza pfp
Hamza
@canhamzacode
@moritz Last minute submission haha Let me know what you think https://dune.com/canhamzacode/farcaster-user-wallet-metrics
1 reply
0 recast
1 reaction
Linda Xie pfp
Linda Xie
@linda
Is this bounty still open or is it closed?
1 reply
0 recast
1 reaction
Royal pfp
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
Linda Xie pfp
Linda Xie
@linda
@whyshock if interested
0 reply
0 recast
2 reactions
Samuel ใƒ„ pfp
Samuel ใƒ„
@samuellhuber.eth
@chasesommer.eth I see you getting paid
0 reply
0 recast
2 reactions
0xRob pfp
0xRob
@0xrob
It's not easy, but can be done. I'll give it a shot.
0 reply
0 recast
1 reaction
Bounty Bot pfp
Bounty Bot
@bountybot
@canhamzacode you have received an onchain attestation via EAS for this bounty completion
0 reply
0 recast
0 reaction
Bounty Bot pfp
Bounty Bot
@bountybot
Your bounty was marked as complete and users have the completion recorded in their profiles Please send payments promptly. You can pay users directly at https://www.bountycaster.xyz/bounty/0x378c5455ba24d70abd8a9e2b7a49b160d87b3319 Thanks for using Bountycaster! ๐ŸŽ‰
0 reply
0 recast
0 reaction
Codingsh pfp
Codingsh
@codingsh
@moritz https://dune.com/codingsh/farcaster-usd-inflow-and-outflow
1 reply
0 recast
0 reaction
Codingsh pfp
Codingsh
@codingsh
my work here https://dune.com/codingsh/farcaster-usd-inflow-and-outflow
0 reply
0 recast
0 reaction
limone.eth ๐Ÿ‹ pfp
limone.eth ๐Ÿ‹
@limone.eth
@jondar
0 reply
0 recast
2 reactions
Dallas pfp
Dallas
@dallas0
When you say total USD do you mean only on base or all Blockchain?
0 reply
0 recast
0 reaction