MLDZMNDDU9
    Updated 2023-08-12

    SELECT
    date_trunc('month', block_timestamp) as month,
    PLATFORM,
    sum(CASE WHEN TOKEN_IN = lower('0x3845badAde8e6dFF049820680d1F14bD3903a5d0') THEN amount_in ELSE 0 END) + sum(CASE WHEN TOKEN_OUT =lower('0x3845badAde8e6dFF049820680d1F14bD3903a5d0') THEN amount_out ELSE 0 END) as volume,
    count(DISTINCT origin_from_address) as no_swapers
    FROM ethereum.core.ez_dex_swaps
    WHERE block_timestamp >= '2022-01-01'
    AND (TOKEN_IN = lower('0x3845badAde8e6dFF049820680d1F14bD3903a5d0') OR TOKEN_OUT = lower('0x3845badAde8e6dFF049820680d1F14bD3903a5d0'))
    GROUP BY 1,2
    Run a query to Download Data