SELECT
COUNT( DISTINCT TX_HASH) AS combined_swaps,
COUNT(DISTINCT origin_from_address) AS combined_swappers,
SUM(AMOUNT_IN_USD) AS TotalVolumeUSD,
AVG (DISTINCT Tx_hash) as Average_swaps
FROM
avalanche.defi.ez_dex_swaps
WHERE
block_timestamp >= '2024-01-01'
And amount_in_usd is not NULL
and event_name = 'Swap'