0xapez_pool_stats TEST
Updated 2023-07-01
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
›
⌄
SELECT *
--SUM(FEE_GROWTH_INSIDE0_LAST_X128 + FEE_GROWTH_INSIDE1_LAST_X128 ) AS fee,
-- Liquidity_provider
FROM ethereum.uniswapv3.ez_pool_stats--ethereum.uniswapv3.ez_positions
--WHERE POOL_NAME LIKE '%USDC-WETH%'
-- AND LIQUIDITY_PROVIDER = '0xe4ff868e55fc3f34498fac6e78b1b6a8ea367367'
-- AND block_timestamp :: date >= current_date - 730
-- GROUP BY LIQUIDITY_PROVIDER
WHERE POOL_NAME = 'USDC-WETH 500 10'
-- OR POOL_NAME = 'USDC-WETH 10000 200'
-- OR POOL_NAME = 'USDC-WETH 3000 60'
ORDER BY BLOCK_TIMESTAMP DESC
LIMIT 10000;
Run a query to Download Data