select t1.block_timestamp::date as day,t1.TX_ID, t2.EVENT_CONTRACT as NFT_COLLECTION_NAME,t1.PRICE, t3.*

from flow.core.fact_nft_sales t1

join flow.core.dim_contract_labels t2

on t1.NFT_COLLECTION=t2.EVENT_CONTRACT

join flow.core.dim_topshot_metadata as t3

on t3.NFT_ID=t1.NFT_ID

where day BETWEEN '2022-05-10' and '2022-06-5' and t1.CONTRACT_NAME ='TopShot'

select day,count(distinct TX_ID) as Total_Transaction_Count,sum(price) as Total_Sale_Volume from TopShot_Sale_Info_In_Conference_Finals

group by day

order by day