kasadeghDaily Transaction Count
Updated 2022-07-10
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
›
⌄
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