WITH nft_allday AS (
SELECT
date_trunc('days', b.block_timestamp) AS date,
a.PLAY_TYPE as PLAY_TYPE,
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
PLAY_TYPE,
ROUND(SUM(PRICE),2) as total_sales_volume
FROM nft_allday
WHERE date >= DATEADD(day, -30, getdate())
GROUP BY PLAY_TYPE
ORDER BY total_sales_volume DESC
LIMIT 10