CryptoIciclestETH/ETH Fluctuation - stETH <> WETH Swap Ratio
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
›
⌄
-- 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
swaps as (
select
amount_out/amount_in as weth_steth_ratio,
block_timestamp,
iff(weth_steth_ratio < 1,'<1','>=1') as type
from ethereum.core.ez_dex_swaps
where symbol_in = 'stETH'
and symbol_out = 'WETH'
and block_timestamp >= {{date_start}}
and amount_in > 0.1 -- Filter out small amounts
)
select * from swaps
Run a query to Download Data