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
11 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

zain pfp
zain
@zain
Example below. Just added a daily refresh on thanks for the suggestion!
0 reply
0 recast
1 reaction

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