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
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
moritz 💧🔑
@moritz
I see, thanks for clarifying with USD amount of tokens, I meant the $ value of the tokens a user holds, not just USDC - I understand it might be difficult to cover all possible tokens but it should ideally cover the top 20 tokens by market cap (e.g. ETH, rETH, wstETH, USDT, DAI, etc.) also it's unclear which chains you are checking this for regarding the FID: I wasn't even able to find a connected address when querying the fname API: https://docs.farcaster.xyz/reference/fname/api
1 reply
0 recast
0 reaction
