WITH nft_allday AS (
SELECT
date_trunc('days', b.block_timestamp) AS date,
a.SEASON as SEASON,
b.NFT_ID as nft_id,
b.price as price
FROM flow.core.dim_allday_metadata a
LEFT JOIN flow.core.ez_nft_sales b
ON a.NFT_ID = b.NFT_ID
)
SELECT
SEASON,
ROUND(SUM(PRICE),2) as total_sales_volume
FROM nft_allday
WHERE date >= DATEADD(day, -30, getdate())
GROUP BY SEASON
ORDER BY total_sales_volume DESC
LIMIT 10