Mrfti2024-03-18 03:57 PM
    Updated 2024-09-29
    select
    date_trunc('hour', block_timestamp) as time,
    sum(amount_in) as "Traded $ETHFI",
    sum ("Traded $ETHFI") over (order by time) as "Cumulative trading volume"
    from
    ethereum.defi.ez_dex_swaps
    where
    token_in = lower('0xFe0c30065B384F05761f15d0CC899D4F9F9Cc0eB')
    group by 1
    order by 1

    Auto-refreshes every 12 hours
    QueryRunArchived: QueryRun has been archived