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
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
moritz 💧🔑
@moritz
hi @canhamzacode - thanks for submitting this the number of users in your dashboard is much lower than the total number of Farcaster users, can you explain what your methodology was? also I checked a few FIDs to confirm that the reported balances match numbers onchain but this wasn't the case, e.g.: FID 238,324 is supposed to have a balance of 15,727 but I'm unable to find this user
2 replies
0 recast
1 reaction
Hamza
@canhamzacode
From what you requested, you said USD token, so I restricted the result to USD token, or what do you mean by the USD token, can you expatiate?
0 reply
0 recast
1 reaction
Hamza
@canhamzacode
So basically what I did was to query for farcaster wallet address with USDC in it. I.e wallet without USDC will not be returned For this FID, are you referring the the USDC balance
1 reply
0 recast
0 reaction
