hessHourly Price of Lava
Updated 2024-07-31
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
›
⌄
with transfer as (select *, case when receiver like 'axelar%' then 'Axelar'
when receiver like 'osmo%' then 'Osmo' end as type
from lava.core.fact_transfers
where TRANSFER_TYPE = 'IBC_TRANSFER_IN'
)
,
price as ( select recorded_hour as hour,
'ibc/0471F1C4E7AFD3F07702BEF6DC365268D64570F7C1FDC98EA6098DD6DE59817B' as currency,
symbol,
price
from osmosis.price.ez_prices
where symbol ilike '%lav%')
Select trunc(TO_TIMESTAMP(value[0]::string),'hour') as hour, 'SEI' as token, avg(value[1]) as avg_price
from (
SELECT livequery.live.udf_api(
'https://api.coingecko.com/api/v3/coins/lava-network/market_chart?vs_currency=usd&days=90') as resp
)
,LATERAL FLATTEN (input => resp:data:prices)
group by all
QueryRunArchived: QueryRun has been archived