NakedCollector2024-07-06 07:06 PM
    Updated 2024-07-06
    select
    date_trunc('month',BLOCK_TIMESTAMP) as date,
    PLATFORM,
    (sum(AMOUNT_IN_USD) + sum(AMOUNT_OUT_USD)) as Volume
    from
    crosschain.defi.ez_dex_swaps where date >= CURRENT_DATE - INTERVAL '30 days'

    group by 1 ,2
    QueryRunArchived: QueryRun has been archived