flipside

    DYDX Unlock 7
    jackguyDYDX Unlock 7
    Updated 2023-01-21

    SELECT
    -- date_trunc('day', block_timestamp) as day,
    PLATFORM,
    sum(CASE WHEN TOKEN_IN = lower('0x92D6C1e31e14520e676a687F0a93788B716BEff5') THEN amount_in ELSE 0 END) + sum(CASE WHEN TOKEN_OUT = lower('0x92D6C1e31e14520e676a687F0a93788B716BEff5') THEN amount_out ELSE 0 END) as volume,
    count(DISTINCT origin_from_address) as USER
    FROM ethereum.core.ez_dex_swaps
    WHERE block_timestamp >= CURRENT_DATE - interval '180 days' AND (TOKEN_IN = lower('0x92D6C1e31e14520e676a687F0a93788B716BEff5') OR TOKEN_OUT = lower('0x92D6C1e31e14520e676a687F0a93788B716BEff5'))
    GROUP BY 1--,2
    Run a query to Download Data