modijislefttesticleGetting Started
Updated 2024-10-25
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
›
⌄
-- 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 *
FROM ethereum.uniswapv3.ez_positions
WHERE
TOKEN0_SYMBOL = 'USDC' AND
TOKEN1_SYMBOL = 'WETH' AND
TICK_UPPER - TICK_LOWER <= 50 AND
LIQUIDITY_PROVIDER = '0x5c4a0fc2c04d2d7a8a499faa48c49412b3a22431' AND
NF_TOKEN_ID = 803195
ORDER BY BLOCK_NUMBER DESC
LIMIT 100
QueryRunArchived: QueryRun has been archived