emanuelhc2023-04-05 08:43 PM
Updated 2023-04-06
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
›
⌄
WITH fee_changes AS (
SELECT
BLOCK_TIMESTAMP,
TOKEN0_SYMBOL,
TOKEN1_SYMBOL,
FEE_PERCENT,
LAG(FEE_PERCENT) OVER (PARTITION BY TOKEN0_SYMBOL, TOKEN1_SYMBOL ORDER BY BLOCK_TIMESTAMP) AS PREVIOUS_FEE_PERCENT,
INIT_PRICE_1_0_USD
FROM
ethereum.uniswapv3.ez_pools
WHERE
(TOKEN0_SYMBOL = 'USDC' OR TOKEN1_SYMBOL = 'USDC')
AND BLOCK_TIMESTAMP >= '2023-03-04 00:00:00'
AND BLOCK_TIMESTAMP <= '2023-03-11 23:59:59'
),
fee_differences AS (
SELECT
BLOCK_TIMESTAMP,
TOKEN0_SYMBOL,
TOKEN1_SYMBOL,
FEE_PERCENT,
PREVIOUS_FEE_PERCENT,
INIT_PRICE_1_0_USD,
FEE_PERCENT - COALESCE(PREVIOUS_FEE_PERCENT, 0) AS FEE_CHANGE
FROM
fee_changes
)
SELECT
BLOCK_TIMESTAMP,
TOKEN0_SYMBOL,
TOKEN1_SYMBOL,
FEE_PERCENT,
PREVIOUS_FEE_PERCENT,
INIT_PRICE_1_0_USD,
FEE_CHANGE
FROM
Run a query to Download Data