Getting Started

aaronjdGetting Started

Updated 2025-03-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

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;

-- this is

select

from bitcoin.price.ez_prices_hourly

where HOUR > current_date - interval '30 days'

AND name = 'bitcoin'

order by HOUR desc;

Last run: 4 minutes ago

136B