SELECT

origin_from_address AS SwapperAddress,

SUM(amount_in_usd) AS TotalVolumeUSD,

CASE

WHEN EXTRACT(DOW FROM block_timestamp) IN (1, 2) THEN 'Early Week Traders'

WHEN EXTRACT(DOW FROM block_timestamp) IN (3, 4, 5) THEN 'Mid-Week Traders'

WHEN EXTRACT(DOW FROM block_timestamp) IN (0, 6) THEN 'Weekend Traders'

ELSE 'Other'

END AS TraderCategory

FROM

polygon.defi.ez_dex_swaps

WHERE

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

AND platform = 'quickswap-v3'

GROUP BY

origin_from_address, TraderCategory

TraderCategory,

COUNT(DISTINCT SwapperAddress) AS TotalTraders,

COALESCE(SUM(TotalVolumeUSD), 0) AS TotalVolumeUSD

CategorizedTraders

GROUP BY

TraderCategory

ORDER BY

TotalVolumeUSD DESC;