TO_TIMESTAMP(value[0]::string) as date,

'SEI' as symbol

, value[1] as avg_price

from (

SELECT livequery.live.udf_api(

'https://api.coingecko.com/api/v3/coins/sei-network/market_chart?vs_currency=usd&days=90&interval=daily&precision=3') as resp

,LATERAL FLATTEN (input => resp:data:prices)

select date(RECORDED_HOUR) as date,

symbol,

avg(price) as avg_price

from osmosis.price.ez_prices

where symbol in ('ATOM','OSMO')

and RECORDED_HOUR::Date >= '2023-08-15'

group by 1,2

select date(RECORDED_HOUR) as date,

symbol,

avg(CLOSE) as avg_price

from solana.price.ez_token_prices_hourly

where token_address = 'So11111111111111111111111111111111111111112'

and RECORDED_HOUR::Date >= '2023-08-15'

group by 1,2

select date(hour) as date,

symbol,

avg(price) as avg_price

from ethereum.price.ez_hourly_token_prices

where symbol in ('WETH','WMATIC','WAVAX')

and hour::date >= '2023-08-15'

group by 1,2

,

sei as ( select date(block_timestamp) as date,'SEI' as chain, tx_succeeded, GAS_USED, block_id, tx_id as tx_hash, tx_from as user,