drone-mostafauser wallett copy
Updated 2023-05-04
9
1
2
3
4
5
6
7
8
9
›
⌄
SELECT POOL_NAME as DEX, count (DISTINCT TX_HASH) as TXN, 'TXN' as type FROM avalanche.core.ez_dex_swaps WHERE SENDER = '{{User_wallet}}' GROUP BY 1 UNION
SELECT POOL_NAME as DEX, count (DISTINCT BLOCK_TIMESTAMP::date) as Days, 'Days' as type FROM avalanche.core.ez_dex_swaps WHERE SENDER = '{{User_wallet}}' GROUP BY 1 UNION
SELECT POOL_NAME as DEX, sum (AMOUNT_IN_USD) as USD, 'USD Volume' as type FROM avalanche.core.ez_dex_swaps WHERE SENDER = '{{User_wallet}}' GROUP BY 1 UNION
SELECT POOL_NAME as DEX, avg (AMOUNT_IN_USD) as AVG_USD, 'AVG USD' as type FROM avalanche.core.ez_dex_swaps WHERE SENDER = '{{User_wallet}}' GROUP BY 1
Run a query to Download Data