roketos19
Updated 2022-11-15
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
›
⌄
with pricet as (
select recorded_at::date as day,
case when symbol = 'EVMOS' then 'aevmos'
when symbol = 'ATOM' then 'uatom'
when symbol = 'JUNO' then 'ujuno'
when symbol = 'BOOT' then 'boot'
when symbol = 'STARS' then 'ustars'
when symbol = 'UMEE' then 'uumee'
when symbol = 'MNTL' then 'umntl'
when symbol = 'SCRT' then 'uscrt'
when symbol = 'HUAHUA' then 'uhuahua'
when symbol = 'KUJI' then 'ukuji'
when symbol = 'ROWAN' then 'rowan'
when symbol = 'AXL' then 'uaxl'
else lower (symbol) end as symbol1,
avg (price) as USDPrice
from osmosis.core.dim_prices
group by 1,2
union ALL
select recorded_at::date as day,
case when symbol = 'EVMOS' then 'ibc/6AE98883D4D5D5FF9E50D7130F1305DA2FFA0C652D1DD9C123657C6B4EB2DF8A'
when symbol = 'ATOM' then 'ibc/27394FB092D2ECCD56123C74F36E4C1F926001CEADA9CA97EA622B25F41E5EB2'
when symbol = 'BOOT' then 'ibc/FE2CD1E6828EC0FAB8AF39BAC45BC25B965BA67CCBC50C13A14BD610B0D1E2C4'
when symbol = 'JUNO' then 'ibc/46B44899322F3CD854D2D46DEEF881958467CDD4B3B10086DA49296BBED94BED'
when symbol = 'STARS' then 'ibc/987C17B11ABC2B20019178ACE62929FE9840202CE79498E29FE8E5CB02B7C0A4'
else lower (symbol) end as symbol1,
avg (price) as USDPrice
from osmosis.core.dim_prices
group by 1,2
union ALL
select hour::date as day,
case when symbol = 'USDC' then 'uusdc'
Run a query to Download Data