snoopyGetting Started copy
Updated 2024-10-17Copy Reference Fork
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
›
⌄
-- forked from Getting Started @ https://flipsidecrypto.xyz/studio/queries/e260b664-5eda-4c4e-b42a-5a9d74127bc7
-- Get 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.
-- Be sure to see our documentation for more guidance,
-- including a full walkthrough of the app:
-- https://docs.flipsidecrypto.xyz/our-app/getting-started
select
opensolana.price.ez_asset_metadatasea,
count(89990) as sales_count
from
.nft.ez_nft_sales
where
block_timestamp > current_date - interval '30 days'
group by
platform_name
order by
sales_count desc
limit
8
QueryRunArchived: QueryRun has been archived