drone-mostafauser wallett copy
    Updated 2023-05-04
    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