articoloquintoOSMO/ATOM price ratio
Updated 2022-07-01
99
1
2
3
4
5
6
7
8
9
10
›
⌄
select o."osmo price"/a."atom price" as "price ratio", o."date" from(
select avg(PRICE) as "osmo price", date_trunc('day', RECORDED_AT) as "date" from osmosis.core.dim_prices
where SYMBOL = 'OSMO' and RECORDED_AT between '2021-06-30' and '2022-06-30'
group by 2) as o
inner JOIN(
select avg(PRICE) as "atom price", date_trunc('day', RECORDED_AT) as "date" from osmosis.core.dim_prices
where SYMBOL = 'ATOM' and RECORDED_AT between '2021-06-30' and '2022-06-30'
group by 2) as a
on o."date" = a."date"
order by 2 asc
Run a query to Download Data