SELECT SYMBOL_IN AS Token,

COUNT(*) AS TotalTrades,

SUM(CASE WHEN BLOCK_TIMESTAMP >= DATEADD(day, -7, CURRENT_TIMESTAMP()) THEN 1 ELSE 0 END) AS Trades_7d,

SUM(CASE WHEN BLOCK_TIMESTAMP >= DATEADD(day, -30, CURRENT_TIMESTAMP()) THEN 1 ELSE 0 END) AS Trades_30d,

SUM(CASE WHEN BLOCK_TIMESTAMP >= DATEADD(day, -90, CURRENT_TIMESTAMP()) THEN 1 ELSE 0 END) AS Trades_90d

-- SUM(CASE WHEN BLOCK_TIMESTAMP >= DATEADD(day, -97, CURRENT_TIMESTAMP()) AND BLOCK_TIMESTAMP < DATEADD(day, -90, CURRENT_TIMESTAMP()) THEN 1 ELSE 0 END) AS Trades_97_90,

-- SUM(CASE WHEN BLOCK_TIMESTAMP >= DATEADD(day, -37, CURRENT_TIMESTAMP()) AND BLOCK_TIMESTAMP < DATEADD(day, -30, CURRENT_TIMESTAMP()) THEN 1 ELSE 0 END) AS Trades_37_30,

-- SUM(CASE WHEN BLOCK_TIMESTAMP >= DATEADD(day, -7, CURRENT_TIMESTAMP()) AND BLOCK_TIMESTAMP < DATEADD(day, -3, CURRENT_TIMESTAMP()) THEN 1 ELSE 0 END) AS Trades_7_3

FROM near.defi.ez_dex_swaps

WHERE PLATFORM = 'ref.finance'

GROUP BY SYMBOL_IN

SELECT Token,

Trades_7d AS Trades_Last_7_Days,

Trades_30d AS Trades_Last_30_Days,

Trades_90d AS Trades_Last_90_Days,

-- ((Trades_7d - Trades_97_90) * 100.0 / Trades_97_90) AS Change_7d,

-- ((Trades_30d - Trades_37_30) * 100.0 / Trades_37_30) AS Change_30d,

-- ((Trades_90d - Trades_7_3) * 100.0 / Trades_7_3) AS Change_90d

FROM TokenActivity

ORDER BY TotalTrades DESC;