date_trunc('hour',TO_TIMESTAMP(value[0]::string)) as price_date,

'SEI' as symbol,

value[1] as hourly_price

from (

SELECT livequery.live.udf_api(

'https://api.coingecko.com/api/v3/coins/sei-network/market_chart/range?vs_currency=usd&from=1692050400&to=1692381600&precision=6') as resp),

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

union all

(select

RECORDED_HOUR as price_date,

symbol,

PRICE as hourly_price

from osmosis.price.ez_prices

where symbol = 'SEI')),

Dagora_marketplace as (

select

date_trunc('hour',BLOCK_TIMESTAMP) as date,

tx_id,

msg_index,

MSG_TYPE,

MSG_GROUP

from sei.core.fact_msg_attributes a

where msg_type = 'wasm'

and ATTRIBUTE_KEY = '_contract_address'

and ATTRIBUTE_VALUE = 'sei1pdwlx9h8nc3fp6073mweug654wfkxjaelgkum0a9wtsktwuydw5sduczvz'

and BLOCK_TIMESTAMP >= '2023-08-15'

),

details as (

select

date_trunc('hour',BLOCK_TIMESTAMP) as date,

tx_id,

msg_index,