select NFT_ID

,PRICE

from flow.core.ez_nft_sales

where NFT_COLLECTION='A.e4cf4bdc1751c65d.AllDay'

and BLOCK_TIMESTAMP>='2022-11-24'

and TX_SUCCEEDED='TRUE'

),

tab2 as (

select NFT_ID

,TEAM

,PLAYER

,PLAY_TYPE

,SERIES

,SET_NAME

from flow.core.dim_allday_metadata)

select TEAM,sum(PRICE)as volume,count(distinct tab2.NFT_ID)as "Traded NFT"

from tab1

left join tab2

on tab1.NFT_ID=tab2.NFT_ID

group by 1

order by 3 desc

limit 10