a7badc58-d704-4f33-a7c7-aa7e9d10a85efees_per_block
Updated 2022-11-15Copy Reference Fork
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
›
⌄
SELECT BLOCK_NUMBER, LEG, SUM(FEES_PAID) as BLOCK_FEES_PAID, array_agg(distinct TICK) as TICKS
FROM
(
SELECT BLOCK_NUMBER, TX_HASH, TICK,
CASE
WHEN AMOUNT0_ADJUSTED < 0 THEN AMOUNT1_ADJUSTED
ELSE AMOUNT0_ADJUSTED
END as INPUT_AMOUNT,
CASE
WHEN AMOUNT0_ADJUSTED < 0 THEN 'QUOTE'
ELSE 'BASE'
END as LEG,
SPLIT(POOL_NAME,' ')[1]/1000000 as FEE_RATE,
INPUT_AMOUNT * FEE_RATE as FEES_PAID
FROM ethereum.uniswapv3.ez_swaps
WHERE POOL_ADDRESS = '0x88e6a0c2ddd26feeb64f039a2c41296fcb3f5640'
)
GROUP BY BLOCK_NUMBER, LEG
ORDER BY BLOCK_NUMBER DESC
Run a query to Download Data