shreexTotal Metrics For Playtypes
Updated 2022-10-13
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
›
⌄
with playtypes as (
select
play_type as p_t,
nft_id as nft_idd,
season,
team,
player
from flow.core.dim_topshot_metadata
)
select
p_t as play_type,
team,
sum(price) as volume,
count(distinct tx_id) as number_of_sales,
count(distinct buyer ) as unique_buyers,
count(distinct seller) as unique_sellers
from flow.core.ez_nft_sales inner join playtypes on nft_id=nft_idd
where nft_collection = 'A.0b2a3299cc857e29.TopShot'
and currency = 'A.ead892083b3e2c6c.DapperUtilityCoin'
and tx_succeeded = 'TRUE' and nft_id=nft_idd
GROUP BY p_t,team