Madidailyratio
    Updated 2022-10-27
    WITH tx_v2 as (
    SELECT
    date_trunc('day', block_timestamp) AS date,
    COUNT(DISTINCT TX_HASH) as tx_v2,
    COUNT(DISTINCT SENDER) as holders_v2
    FROM ethereum.core.ez_dex_swaps
    WHERE platform = 'uniswap-v2' and date_trunc('day', block_timestamp) >= '2021-05-05'
    GROUP BY date
    ORDER BY date ASC),

    tx_v3 as (
    SELECT
    date_trunc('day', block_timestamp) AS date,
    COUNT(DISTINCT TX_HASH) as tx_v3,
    COUNT(DISTINCT SENDER) as holders_v3
    FROM ethereum.core.ez_dex_swaps
    WHERE platform = 'uniswap-v3' and date_trunc('day', block_timestamp) >= '2021-05-05'
    GROUP BY date
    ORDER BY date ASC)


    SELECT
    a.date as date,
    b.tx_v3/a.tx_v2 as tx_ratio,
    b.holders_v3/a.holders_v2 as holder_ratio
    FROM tx_v2 a join tx_v3 b on a.date=b.date
    Run a query to Download Data