cryptonomical117ETH_UNI_test
Updated 2024-05-10Copy Reference Fork
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
›
⌄
⌄
⌄
⌄
⌄
SELECT
*
FROM ethereum.uniswapv3.ez_positions
WHERE
BLOCK_NUMBER = 18678134
-- BLOCK_TIMESTAMP BETWEEN '2023-01-01' AND '2023-12-01'
LIMIT 10;
SELECT DISTINCT POOL_NAME, TOKEN0_SYMBOL, TOKEN1_SYMBOL
FROM ethereum.uniswapv3.ez_positions
WHERE
BLOCK_TIMESTAMP BETWEEN '2023-01-01' AND '2023-12-01'
;
SELECT
DISTINCT liquidity_provider
FROM ethereum.uniswapv3.ez_positions
WHERE
BLOCK_TIMESTAMP BETWEEN '2023-01-01' AND '2023-12-30'
;
SELECT
*
FROM ethereum.uniswapv3.ez_lp_actions
WHERE
(token0_symbol = 'USDC' AND token1_symbol = 'USDT') OR
(token1_symbol = 'USDT' AND token1_symbol = 'USDC')
LIMIT 100
;
SELECT
*
FROM ethereum.uniswapv3.ez_positions
WHERE
QueryRunArchived: QueryRun has been archived