WITH nft_allday AS (
SELECT
date_trunc('days', b.block_timestamp) AS date,
a.PLAYER as PLAYER,
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
DISTINCT PLAYER as PLAYER,
SUM(PRICE) as total_sales_volume
FROM nft_allday
WHERE player !='N/A'
GROUP BY PLAYER
ORDER BY total_sales_volume DESC
LIMIT 10