XenonX-d5y2pHGetting Started
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
›
⌄
-- Get started with Flipside by running your first query:
-- the SQL statement below will get you a list of NFT
-- projects on Ethereum, ranked by how many mints
-- they've had in the past week.
-- Be sure to see our documentation for more guidance,
-- including a full walkthrough of the app:
-- https://docs.flipsidecrypto.com/our-app/getting-started
select
project_name,
count(*) as mint_count
from
ethereum.core.ez_nft_mints
where
project_name is not null
and block_timestamp > current_date - interval '7 days'
group by
project_name
order by
mint_count desc
limit
8;
Run a query to Download Data