(

SELECT NFT_ID,PLAY_CATEGORY,PLAY_TYPE

FROM flow.core.dim_topshot_metadata

)

select

date_trunc('day', BLOCK_TIMESTAMP) AS Day,

PLAY_TYPE,

SUM(PRICE) AS Volume

from flow.core.fact_nft_sales A inner join topshot_info B on A.NFT_ID=B.NFT_ID

group by 1,2