cnallenzhaoUntitled Query
Updated 2022-12-01
99
1
2
3
4
5
6
7
8
9
10
11
12
13
›
⌄
SELECT
date_trunc('day', block_timestamp) as date,
CASE
WHEN LIQUIDITY_PROVIDER = '0xc36442b4a4522e871399cd717abdd847ab11fe88' THEN 'Uniswap'
ELSE 'SC'
END AS pos_type,
AVG(TOKEN1_PRICE) as price,
count(*) AS evt_cnt
FROM ethereum.uniswapv3.ez_lp_actions
WHERE date <= '2022-11-01'
AND POOL_NAME IN ('USDC-WETH 3000 60', 'USDC-WETH 500 10')
GROUP BY date, pos_type
ORDER BY date ASC
Run a query to Download Data