jackguy2023-08-24 02:01 PM
    Updated 2025-01-11
    SELECT
    date_trunc('day', block_timestamp) as day,
    sum(amount_in_usd) as volume_usd,
    count(DISTINCT origin_from_address) as swappers
    FROM ethereum.defi.ez_dex_swaps
    WHERE CONTRACT_ADDRESS LIKE lower('0x5c95d4B1C3321CF898D25949F41D50Be2dB5bc1d')
    GROUP BY 1
    QueryRunArchived: QueryRun has been archived