flipside
GROWTH MCP
IDG PLAYBOOK
JOURNEYS
INSIGHTS
About
Log in
GET STARTED
flipside
Eth NFT Market Place By Sales In The Last 30days
chibest
Eth NFT Market Place By Sales In The Last 30days
Updated 2024-03-16
Copy Reference
Fork
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
›
⌄
-- I'm getting started with Flipside by running your first query:
-- the SQL statement below will get you a list of NFT
-- platforms on Ethereum, ranked by how many sales
-- they've had in the past month.
select
platform_name
,
count
(
*
)
as
sales_count
from
ethereum
.
nft
.
ez_nft_sales
where
block_timestamp
>
current_date
-
interval
'30 days'
group
by
platform_name
order
by
sales_count
desc
limit
8
Results
Last run: 20 days ago
PLATFORM_NAME
SALES_COUNT
1
opensea
334067
2
blur
29067
3
nftx
2371
4
element
703
5
magic eden
410
6
sudoswap
316
7
rarible
207
8
larva labs
103
1
8
136B
1s