SELECT PLATFORM as DEX, count (DISTINCT TX_HASH) as TXN, 'TXN' as type FROM avalanche.core.ez_dex_swaps WHERE ORIGIN_FROM_ADDRESS = '{{User_wallet}}' GROUP BY 1 UNION

SELECT PLATFORM as DEX, count (DISTINCT BLOCK_TIMESTAMP::date) as Days, 'Days' as type FROM avalanche.core.ez_dex_swaps WHERE ORIGIN_FROM_ADDRESS = '{{User_wallet}}' GROUP BY 1 UNION

SELECT PLATFORM as DEX, sum (AMOUNT_IN_USD) as USD, 'USD Volume' as type FROM avalanche.core.ez_dex_swaps WHERE ORIGIN_FROM_ADDRESS = '{{User_wallet}}' GROUP BY 1 UNION

SELECT PLATFORM as DEX, avg (AMOUNT_IN_USD) as AVG_USD, 'AVG USD' as type FROM avalanche.core.ez_dex_swaps WHERE ORIGIN_FROM_ADDRESS = '{{User_wallet}}' GROUP BY 1