CASE

WHEN EXTRACT(HOUR FROM block_timestamp) BETWEEN 0 AND 8 THEN 'Off-Peak'

WHEN EXTRACT(HOUR FROM block_timestamp) BETWEEN 9 AND 16 THEN 'Mid-Peak'

ELSE 'Peak'

END AS TimePeriod,

SUM(amount_in_usd) AS TotalVolume

polygon.defi.ez_dex_swaps

platform = 'quickswap-v3'

AND block_timestamp >= DATEADD(MONTH, -3, CURRENT_DATE)

GROUP BY

TimePeriod

ORDER BY

TotalVolume DESC;