omer93play type flow
Updated 2022-07-25
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
›
⌄
WITH
nba_shot as (
select
--date_trunc('day',block_timestamp) as days,
play_type,
count(distinct tx_id) as sales,
sum(price) as volume
from flow.core.fact_nft_sales fns join flow.core.dim_topshot_metadata dtm on fns.nft_id=dtm.nft_id
where dtm.nft_collection like '%TopShot%'
group by 1--,2
)
SELECT
--days,
play_type,
sales--,
--volume
from nba_shot
order by 2 desc
limit 5
Run a query to Download Data