flipside

    MIM price + It's Peg
    nitsMIM price + It's Peg
    Updated 2022-02-11
    with ust_price as (SELECT hour as hr , price as ust_price from ethereum.token_prices_hourly
    where symbol = 'UST' and hour> CURRENT_DATE -60 ),
    mim_price as (SELECT hour, price as mim_price from ethereum.token_prices_hourly
    where symbol = 'MIM' and hour> CURRENT_DATE -60)
    SELECT *, (mim_price-1)*100 as price_diff_mim,
    (ust_price-1)*100 as price_diff_ust
    from mim_price
    inner join ust_price
    on hour = hr
    limit 10000


    --0xa693b19d2931d498c5b318df961919bb4aee87a5 = ust wormhole
    --0xa47c8bf37f92abed4a126bda807a7b7498661acd = ust wrapped
    Run a query to Download Data