Chuqs_emxtxCombined transactions
    Updated 2024-08-23
    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'

    QueryRunArchived: QueryRun has been archived