Pirate King Kiba pfp
Pirate King Kiba
@kiba
I threw together a quick dune dashboard for @ampsfun yesterday. Designed the queries slightly differenlty so 1. can see who is paying and 2. support non-usdc tokens more easily Some of the numbers are different but I think thats because your query hasnt been run in 2 days @zain but maybe my code is wrong. @phil can fact check and Ill update https://dune.com/kiba/ampfun
1 reply
2 recasts
10 reactions

zain pfp
zain
@zain
Nice whats your underlying query - looks like daily volume is 2x more on yours than what @jondar and I are showing on https://dune.com/zain/ampsfun
2 replies
0 recast
2 reactions

Pirate King Kiba pfp
Pirate King Kiba
@kiba
Instead of getting all contract->user usdc transfers like you i get all user->contract txs to record the payer and all erc20s then inner join contract->user token transfers on tx hash to get payment amounts and recipient So far there has only been amps in USDC so i shouldnt have txs you don’t yet
1 reply
0 recast
0 reaction

zain pfp
zain
@zain
So why would you have 2x the volume? 😅
1 reply
0 recast
0 reaction

Pirate King Kiba pfp
Pirate King Kiba
@kiba
haha ya I have no idea I'll dig into it. If the cumulative sum was off I could think of why but not the daily totals
1 reply
0 recast
0 reaction

zain pfp
zain
@zain
Cool also if interested we created a community team so feel free to add to this board if you'd like! https://dune.com/amps_community/ampsfun
1 reply
0 recast
1 reaction