TheLaughingManSEI price test
Updated 2023-11-16
999
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 astro_price as (
SELECT
TO_TIMESTAMP(value[0]::string) as day,
'Astro' as symbol,
'ibc/0EC78B75D318EA0AAB6160A12AEE8F3C7FEA3CFEAD001A3B103E11914709F4CE' as token_address,
6 as decimal,
value[1] as price
from (SELECT livequery.live.udf_api('https://api.coingecko.com/api/v3/coins/astroport-fi/market_chart?vs_currency=usd&days=150') as resp)
,LATERAL FLATTEN (input => resp:data:prices)
UNION
Select
TO_TIMESTAMP(value[0]::string) as day,
'SEI' as symbol,
'usei' as token_address,
6 as decimal,
value[1] as price
from (SELECT livequery.live.udf_api('https://api.coingecko.com/api/v3/coins/sei-network/market_chart?vs_currency=usd&days=150') as resp)
,LATERAL FLATTEN (input => resp:data:prices)
)
,
price_i as (
select
trunc(day,'hour') as hourly,
symbol,
token_address,
avg(price) as prices
from astro_price
where day >= '2023-08-15'
group by 1,2,3
)
,
-- ATOM and Osmo Prices
Run a query to Download Data