flipside
Products
For Protocols
For Analysts
For Explorers
About
Log in
Become a Partner
flipside
Daily Volume of NBA Top Shots(play_type)
ML6
Daily Volume of NBA Top Shots(play_type)
Updated 2022-07-23
Copy Reference
Fork
9
1
2
3
›
⌄
select
sum
(
price
)
,
play_type
,
trunc
(
block_timestamp
,
'DAY'
)
as
dt
from
flow
.
core
.
fact_nft_sales
inner
join
flow
.
core
.
dim_topshot_metadata
on
flow
.
core
.
dim_topshot_metadata
.
nft_id
=
flow
.
core
.
fact_nft_sales
.
nft_id
group
by
2
,
3
Results
Run a query to Download Data