MLDZMNPeg analysis
Updated 2022-11-28
9
1
2
3
4
5
6
7
8
9
›
⌄
select
HOUR as hour,
SYMBOL as stablecoin,
price as hourly_price,
lag(hourly_price) ignore nulls over(partition by stablecoin ORDER BY hour ASC) as lag_price,
(hourly_price-lag_price)*100 as deviation_price
from ethereum.token_prices_hourly
where hour>= '2022-05-07'
and symbol in ('USDT','USDC','DAI','UST')
Run a query to Download Data