SELECT

SYMBOL_IN AS token,

CASE

WHEN MONTH(BLOCK_TIMESTAMP) = 1 THEN 'January'

WHEN MONTH(BLOCK_TIMESTAMP) = 2 THEN 'February'

WHEN MONTH(BLOCK_TIMESTAMP) = 3 THEN 'March'

WHEN MONTH(BLOCK_TIMESTAMP) = 4 THEN 'April'

WHEN MONTH(BLOCK_TIMESTAMP) = 5 THEN 'May'

WHEN MONTH(BLOCK_TIMESTAMP) = 6 THEN 'June'

WHEN MONTH(BLOCK_TIMESTAMP) = 7 THEN 'July'

WHEN MONTH(BLOCK_TIMESTAMP) = 8 THEN 'August'

WHEN MONTH(BLOCK_TIMESTAMP) = 9 THEN 'September'

WHEN MONTH(BLOCK_TIMESTAMP) = 10 THEN 'October'

WHEN MONTH(BLOCK_TIMESTAMP) = 11 THEN 'November'

WHEN MONTH(BLOCK_TIMESTAMP) = 12 THEN 'December'

END AS month_name,

SUM(AMOUNT_IN_USD) AS total_volume_usd

FROM ethereum.defi.ez_dex_swaps

WHERE YEAR(BLOCK_TIMESTAMP) = YEAR(CURRENT_DATE()) -- Filter for this year

GROUP BY SYMBOL_IN, MONTH(BLOCK_TIMESTAMP)

SELECT token, month_name, total_volume_usd

FROM token_volume_by_month

ORDER BY total_volume_usd DESC

LIMIT 10;