flipside
Insights
Studio
Quests
For Chains
For Analysts
For Explorers
About
Log in
Sign up
flipside
2023-07-02 12:19 PM
greyswan
2023-07-02 12:19 PM
Updated 2023-07-02
Copy Reference
Fork
99
1
2
3
4
5
6
7
8
9
10
11
12
13
›
⌄
select
count
(
distinct
mint
)
as
trades
,
label
from
solana
.
core
.
fact_nft_sales
left
join
solana
.
core
.
dim_labels
on
mint
=
address
where
succeeded
=
True
and
block_timestamp
>=
CURRENT_DATE
-
30
group
by
label
order
by
count
(
distinct
mint
)
desc
Results
Run a query to Download Data