mahdir007Position Collected Fees
Updated 2022-12-24
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
›
⌄
-- select table1.NF_TOKEN_ID, table1.BLOCK_TIMESTAMP, table2.TOKEN0_BALANCE_USD, table2.TOKEN1_BALANCE_USD
-- FROM ethereum.uniswapv3.ez_position_collected_fees table1
-- INNER JOIN flipside_prod_db.uniswapv3.pool_stats table2
-- ON table1.BLOCK_TIMESTAMP = table2.BLOCK_TIMESTAMP AND table1.POOL_ADDRESS = table2.POOL_ADDRESS
-- WHERE table1.BLOCK_TIMESTAMP > '2022-07-11 06:05:28'
-- ORDER BY table1.BLOCK_TIMESTAMP
-- -- 7/11/2022 6:05:27 AM
-- select AMOUNT0_USD, AMOUNT1_USD, BLOCK_TIMESTAMP, POOL_NAME
-- FROM ethereum.uniswapv3.ez_swaps
-- WHERE (BLOCK_TIMESTAMP >= '2022-07-10 00:00:00' AND BLOCK_TIMESTAMP <= '2022-07-10 23:59:59') AND POOL_ADDRESS = '0x5777d92f208679db4b9778590fa3cab3ac9e2168'
-- ORDER BY BLOCK_TIMESTAMP
select AMOUNT0_USD, AMOUNT1_USD, BLOCK_TIMESTAMP, POOL_ADDRESS, TX_HASH, TOKEN0_SYMBOL, TOKEN1_SYMBOL
from ethereum.uniswapv3.ez_swaps
where POOL_ADDRESS = '0x5777d92f208679db4b9778590fa3cab3ac9e2168' AND BLOCK_TIMESTAMP <= '2022-09-22 00:00:00' AND BLOCK_TIMESTAMP >= '2022-09-21'
ORDER BY BLOCK_TIMESTAMP
Run a query to Download Data