0x22d4eCc2c2B99e7df4AD7B7D3bd56e5f7B56894CGetting Started
Updated 2024-10-24
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
›
⌄
-- 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
BLOCK_NUMBER
AMOUNT0_USD
from
ethereum.uniswapv3.ez_swaps
where
POOL_ADDRESS = '0x3f23d2a1a1ecc72a9b03480be7a1981196aadbf7' AND
block_timestamp > current_date - interval '30 days'
limit 200
QueryRunArchived: QueryRun has been archived