Getting Started

wyeeehGetting Started

Updated 2023-04-28

-- 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

-- count(*) as mint_count

from

ethereum.core.ez_dex_swaps

where

BLOCK_NUMBER = 16950634

and (

-- TOKEN_IN = '0xc02aaa39b223fe8d0a0e5c4f27ead9083c756cc2'

-- or TOKEN_OUT = '0xc02aaa39b223fe8d0a0e5c4f27ead9083c756cc2'

TOKEN_IN = '0x744d70fdbe2ba4cf95131626614a1763df805b9e'

or TOKEN_OUT = '0x744d70fdbe2ba4cf95131626614a1763df805b9e'

);

-- -- 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