Getting Started

smartymetricsGetting Started

Updated 2024-09-10

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

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

Last run: 19 minutes ago

136B