MadiCompare v2/v3
    Updated 2022-10-27
    SELECT
    -- date_trunc('day',BLOCK_TIMESTAMP) as date,
    -- platform,
    'Uniswap v2' as Version,
    COUNT(distinct TX_HASH) as tx_count,
    sum(IFF(abs(AMOUNT_IN_USD) > pow(10,9), abs(AMOUNT_IN_USD)/pow(10,18), abs(AMOUNT_IN_USD))) as AMOUNT_USD,
    median(IFF(abs(AMOUNT_IN_USD) > pow(10,9), abs(AMOUNT_IN_USD)/pow(10,18), abs(AMOUNT_IN_USD))) as median_AMOUNT_USD
    FROM
    ethereum.core.ez_dex_swaps
    WHERE platform = 'uniswap-v2' and date_trunc('day',BLOCK_TIMESTAMP) >= '2021-05-05'


    UNION ALL

    SELECT
    -- date_trunc('day',BLOCK_TIMESTAMP) as date,
    -- platform,
    'Uniswap v3' as Version,
    COUNT(distinct TX_HASH) as tx_count,
    sum(IFF(abs(AMOUNT_IN_USD) > pow(10,9), abs(AMOUNT_IN_USD)/pow(10,18), abs(AMOUNT_IN_USD))) as AMOUNT_USD,
    median(IFF(abs(AMOUNT_IN_USD) > pow(10,9), abs(AMOUNT_IN_USD)/pow(10,18), abs(AMOUNT_IN_USD))) as median_AMOUNT_USD
    FROM
    ethereum.core.ez_dex_swaps
    WHERE platform = 'uniswap-v3' and date_trunc('day',BLOCK_TIMESTAMP) >= '2021-05-04'


    Run a query to Download Data