DATE_TRUNC('week', BLOCK_TIMESTAMP) AS week,

COUNT(TX_HASH) AS weekly_swaps,

COUNT(DISTINCT SENDER) AS weekly_swappers

FROM

bsc.defi.ez_dex_swaps

WHERE

BLOCK_TIMESTAMP >= '2024-01-01' AND BLOCK_TIMESTAMP < '2025-01-01'

GROUP BY

DATE_TRUNC('week', BLOCK_TIMESTAMP)

ORDER BY

week;