CryptoIciclestETH/ETH Fluctuation - Price Diff
Updated 2022-06-11
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
›
⌄
-- stETH/ETH Fluctuation
-- Payout 150 USDC
-- Grand Prize 450 USDC
-- Level Advanced
-- Analyze the price of stETH in ETH denomination and find meaningful correlations that explain its fluctuation.
-- Possible correlations could be with ETH’s price in USD, ETH’s gas price, volume in the curve pool, Curve stETH/ETH pool composition, etc.
-- Example Txs Swap of ETH to stETH:
-- https://etherscan.io/tx/0xe7c901ad4228b00ab4f1d336ab7609a258e64c5d4fb31041472d04491b2d7a28
-- Primary ETH-stETH Contract: https://etherscan.io/address/0xdc24316b9ae028f1497c275eb9192a3ea0f67022
with steth_price as (
select
date_trunc('hour', hour) as date,
avg(price) as price
from ethereum.token_prices_hourly
where token_address = '0xae7ab96520de3a18e5e111b5eaab095312d7fe84' -- stETH
and hour >= {{date_start}}
group by date
),
eth_price as (
select
date_trunc('hour', hour) as date,
avg(price) as price
from ethereum.token_prices_hourly
where symbol = 'WETH'
and hour >= {{date_start}}
group by date
),
swaps as (
select
amount_out/amount_in as weth_steth_ratio,
*
from ethereum.core.ez_dex_swaps
where symbol_in = 'stETH'
Run a query to Download Data