winnie-fsquery - name
Updated 2023-05-23
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
›
⌄
-- forked from Masi / BTC VS. OSMO @ https://flipsidecrypto.xyz/Masi/q/untitled-query-ZYFOFV
select 'Osmo' as token ,
trunc(RECORDED_HOUR,'day') as day,
avg(price) as price
from osmosis.core.ez_prices
where RECORDED_HOUR >= CURRENT_DATE - 180
and symbol = 'OSMO'
group by 1,2
UNION
select 'WBTC' as token,
trunc(hour,'day') as day,
avg(price) as price
from ethereum.core.fact_hourly_token_prices
where hour >= CURRENT_DATE - 180
and symbol = 'WBTC'
group by 1,2
Run a query to Download Data