eferSPoF (stETH peg)
Updated 2023-04-13
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 weth AS (
SELECT
CAST(DATE_TRUNC('day', HOUR) AS DATE) AS datetime,
AVG(PRICE) as weth_price
FROM ethereum.core.fact_hourly_token_prices
WHERE TOKEN_ADDRESS='0xc02aaa39b223fe8d0a0e5c4f27ead9083c756cc2' /* WETH */
AND datetime > CURRENT_DATE - 90
GROUP BY datetime
ORDER BY datetime DESC
),
steth AS (
SELECT
CAST(DATE_TRUNC('day', HOUR) AS DATE) AS datetime,
AVG(PRICE) as steth_price
FROM ethereum.core.fact_hourly_token_prices
WHERE TOKEN_ADDRESS='0xae7ab96520de3a18e5e111b5eaab095312d7fe84' /* stETH */
AND datetime > CURRENT_DATE - 90
GROUP BY datetime
ORDER BY datetime DESC
)
SELECT
t1.datetime,
t1.weth_price AS ETH_PRICE,
t2.steth_price AS stETH_PRICE,
t2.steth_price/t1.weth_price AS rate,
t2.steth_price/t1.weth_price <= 0.98 AS deppeged
FROM
weth t1
RIGHT JOIN steth t2 ON t1.datetime = t2.datetime
ORDER BY datetime DESC;
/*
SELECT datetime, AVG(price)
FROM (
SELECT datetime, price FROM weth
Run a query to Download Data