TO_DATE(BLOCK_TIMESTAMP) AS transaction_date, -- Converts timestamp to date for grouping

COUNT(TX_ID) AS total_swaps, -- Count the total number of swaps

COUNT(DISTINCT SWAPPER) AS unique_swappers -- Count unique swappers

FROM sei.defi.fact_dex_swaps;

WHERE BLOCK_TIMESTAMP >= DATEADD(DAY, -60, CURRENT_DATE)

GROUP BY transaction_date

ORDER BY transaction_date ASC;