farid-c9j0VMTotal Volume Generated By Play Types
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
›
⌄
With metadata as (
Select PLAY_TYPE as Type, NFT_ID as NFT
From flow.core.dim_topshot_metadata
),
nft_sales as (
Select (BLOCK_TIMESTAMP::DATE) AS DAYS,NFT_ID as NFT, PRICE as Vol,TX_ID as Tx
From flow.core.fact_nft_sales
where nft_collection='A.0b2a3299cc857e29.TopShot' and TX_SUCCEEDED='TRUE'
group by 1
)
Select (a.BLOCK_TIMESTAMP::DATE) AS DAYS,
a.type, SUM (b.Vol) as total_volume,
Count (distinct b.Tx) as Total_Tx
From metadata a INNER JOIN nft_sales b on a.NFT=b.NFT
GROUP BY 1,2
Run a query to Download Data