keshanUST and MIM
Updated 2022-02-07
99
1
2
3
4
5
6
7
8
9
10
›
⌄
select hour,
max(case when symbol='UST' then price end) as UST,
max(case when symbol='MIM' then price end) as MIM,
100 * (MIM - UST)/MIM as "MIM Deviation from UST",
100 * (MIM - 1) as "MIM Deviation from USD"
from ethereum.token_prices_hourly
where (symbol = 'MIM' or symbol = 'UST')
and date_trunc('day', hour) >= date_trunc('day', CURRENT_DATE) - 21
group by 1
Run a query to Download Data