MLDZMNPeg analysis
    Updated 2022-11-28
    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