Arashhwrap 13
Updated 2023-02-21
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
›
⌄
--ibc/F4A070A6D78496D53127EA85C094A9EC87DFC1F36071B8CCDDBD020F933D213D BNB
--ibc/EA1D43981D5C9A1C4AAEA9C23BB1D4FA126BA9BC7020A25E0AE4AA841EA25DC5 ibc/65381C5F3FD21442283D56925E62EA524DED8B6927F0FF94E21E0020954C40B5 ETH
--ibc/D1542AA8762DB13087D8364F3EA6509FD6F009A34F00426AF9E4F9FA85CBBF1F ibc/C9B0D48FD2C5B91135F118FF2484551888966590D7BDC20F6A87308DBA670796 BTC
--ibc/AB589511ED0DD5FA56171A39978AFBF1371DB986EC1C3526CE138A16377E39BB matic
-- ibc/6F62F01D913E3FFE472A38C78235B8F021B511BC6596ADFF02615C8F83D3B373 avax
--ibc/5E2DFDF1734137302129EA1C1BA21A580F96F778D4F021815EA4F6DB378DA1A4 fantom
--ibc/1E26DB0E5122AED464D98462BD384FCCB595732A66B3970AE6CE0B58BAE0FC49 GLMR
with price as
(select
case
when id='moonbeam' then 'WGLMR'
when id='wmatic' then 'WMATIC'
when id='avalanche-2' then 'WAVAX'
when id='bitcoin' then 'WBTC'
when id='fantom' then 'WFTM'
when id='oec-binance-coin' then 'WBNB'
when id='ethereum' then 'WETH'
end as token , avg(CLOSE) as price ,
date_trunc('day',RECORDED_HOUR ) as datee
from
crosschain.core.fact_hourly_prices
where
ID in ('moonbeam','wmatic','avalanche-2','bitcoin','fantom','oec-binance-coin','ethereum')
group by 1,3
)
,
t2 as
(select
case when FROM_CURRENCY = 'ibc/F4A070A6D78496D53127EA85C094A9EC87DFC1F36071B8CCDDBD020F933D213D' then 'WBNB'
Run a query to Download Data