0xapez_positions
99
1
2
3
4
5
6
7
8
9
10
11
›
⌄
SELECT *
--SUM(FEE_GROWTH_INSIDE0_LAST_X128 + FEE_GROWTH_INSIDE1_LAST_X128 ) AS fee,
-- Liquidity_provider
FROM 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
LIMIT 10000;
Run a query to Download Data