0xHaM-dSwap Volume Over Time by DEXs
    Updated 2024-10-17
    SELECT
    date::date as day,
    initcap(PROTOCOL) as dex,
    sum(volume) as daily_volume,
    sum(daily_volume) over (ORDER by day) as cum_daily_volume
    FROM external.defillama.fact_dex_volume
    where chain ilike 'klaytn'
    AND day >= current_date - 181
    GROUP by 1,2
    -- ORDER by 3 DESC
    -- limit 10


    QueryRunArchived: QueryRun has been archived