kasadeghDaily Transaction Count
    Updated 2022-07-10
    with TopShot_Sale_Info_In_Conference_Finals as (

    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