sum(AMOUNT_IN_USD) as volume,

count(DISTINCT ORIGIN_FROM_ADDRESS) as swappers,

count(DISTINCT TX_HASH) as swaps,

count(DISTINCT POOL_NAME) AS pools_overall,

count(DISTINCT TOKEN_OUT) AS tokens_overall,

count(DISTINCT PLATFORM) as platform_overall,

volume/swaps as avg_swap_value

FROM avalanche.defi.ez_dex_swaps

where AMOUNT_IN_USD is not null