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
19 replies
2 recasts
12 reactions
moritz πŸ’§πŸ”‘ pfp
moritz πŸ’§πŸ”‘
@moritz
ah forgot to tag @bountybot :)
1 reply
0 recast
1 reaction
0xRob > Devcon|DuneCon πŸ‡ΉπŸ‡­ pfp
0xRob > Devcon|DuneCon πŸ‡ΉπŸ‡­
@0xrob
here you go: https://dune.com/0xrob/farcaster-balances-and-token-volume
1 reply
0 recast
2 reactions
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 > Devcon|DuneCon πŸ‡ΉπŸ‡­ pfp
0xRob > Devcon|DuneCon πŸ‡ΉπŸ‡­
@0xrob
It's not easy, but can be done. I'll give it a shot.
0 reply
0 recast
1 reaction
Dallas pfp
Dallas
@dallas0
When you say total USD do you mean only on base or all Blockchain?
0 reply
0 recast
0 reaction
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
limone.eth πŸ‹ pfp
limone.eth πŸ‹
@limone.eth
@jondar
0 reply
0 recast
2 reactions
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
Bounty Bot pfp
Bounty Bot
@bountybot
Your bounty deadline just passed (2 week default unless specified). If you'd like to edit the bounty amount or deadline, please update through the bounty frame "admin" button If the bounty was completed, please update through the "admin" button
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
Bounty Bot pfp
Bounty Bot
@bountybot
@moritz updated the deadline to 09/30/2024
0 reply
0 recast
0 reaction
Bounty Bot pfp
Bounty Bot
@bountybot
Your bounty deadline just passed (2 week default unless specified). If you'd like to edit the bounty amount or deadline, please update through the bounty frame "admin" button If the bounty was completed, please update through the "admin" button
0 reply
0 recast
0 reaction
Bounty Bot pfp
Bounty Bot
@bountybot
Confirmed! On your bounty page, you can pay users and view their bounty completion history Frame buttons - Admin: manage bounty status, amount, deadline, add boost to get more attention on your bounty πŸ€– commands - @bountybot cancel - @bountybot in progress - @bountybot complete (optional: tag winners) - @bountybot shoutout (optional: tag winner and write a positive review)
1 reply
0 recast
1 reaction