flipside
FLIPSIDEAI
IDG PLAYBOOK
JOURNEYS
INSIGHTS
About
Log in
GET STARTED
flipside
Untitled Query
mu-tafa
Untitled Query
Updated 2022-07-25
Copy Reference
Fork
9
1
2
3
4
5
6
›
⌄
SELECT
sum
(
a
.
price
)
as
volume
,
date_trunc
(
day
,
a
.
block_timestamp
)
as
date
from
flow
.
core
.
fact_nft_sales
a
left
join
flow
.
core
.
dim_topshot_metadata
b
on
a
.
nft_id
=
b
.
nft_id
where
b
.
play_type
=
'3 Pointer'
group
by
date
Results
Run a query to Download Data