With Yin as (SELECT trunc(BLOCK_TIMESTAMP, 'hour') as Hourly, TX_HASH, ORIGIN_FROM_ADDRESS, POOL_NAME, AMOUNT_IN_USD, AMOUNT_OUT_USD, AMOUNT_IN, AMOUNT_OUT, PLATFORM, TOKEN_IN, TOKEN_OUT, SYMBOL_IN, SYMBOL_OUT, FROM avalanche.defi.ez_dex_swaps WHERE BLOCK_TIMESTAMP :: date >= '2023-01-01') , Yang as (select Hour, TOKEN_ADDRESS, PRICE from avalanche.price.ez_prices_hourly ) , Ren as ( select hourly, tx_hash, origin_from_address, pool_name, amount_in_usd, amount_out_usd, TOKEN_IN, TOKEN_out, symbol_in, symbol_out, amount_in*b.price as amt_in_usd, amount_out*c.price as amt_out_usd, case when amount_in_usd is null then amount_out_usd else amount_in_usd end as volume_1, case when amt_in_usd is null then amt_out_usd else amt_in_usd end as volume_2, case when volume_2 is null then volume_1 else volume_2 end as volume_usd from Yin a left outer join Yang b on a.hourly = b.hour and a.token_in = b.token_address left outer join Yang c on a.hourly = c.hour and a.token_out = c.token_address ) select hourly::date as date, case when hourly::date >= '2022-01-01' and hourly::date < '2022-04-01' then 'Q1-2022' when hourly::date >= '2022-04-01' and hourly::date < '2022-07-01' then 'Q2-2022' when hourly::date >= '2022-07-01' and hourly::date < '2022-10-01' then 'Q3-2022' when hourly::date >= '2022-10-01' and hourly::date < '2023-01-01' then 'Q4-2022' when hourly::date >= '2023-01-01' and hourly::date < '2023-04-01' then 'Q1-2023' when hourly::date >= '2023-04-01' and hourly::date < '2023-07-01' then 'Q2-2023' when hourly::date >= '2023-07-01' and hourly::date < '2023-10-01' then 'Q3-2023' when hourly::date >= '2023-10-01' and hourly::date < '2024-01-01' then 'Q4-2023' when hourly::date >= '2024-01-01' and hourly::date < '2024-04-01' then 'Q1-2024' when hourly::date >= '2024-04-01' and hourly::date < '2024-07-01' then 'Q2-2024' when hourly::date >= '2024-07-01' and hourly::date < '2024-10-01' then 'Q3-2024' when hourly::date >= '2024-10-01' and hourly::date < '2025-01-01' then 'Q4-2024' end as type, sum(volume_usd) as volume, sum(volume) over (partition by type order by date asc) as "Cumulative Volume", sum(volume) over (order by date asc) as "Cumulative VolumeII" from Ren where volume_usd < 100000000 group by 1,2 order by 1 asc

Avalanche Break-Down