SELECT

livequery.live.udf_api (

'https://api.dune.com/api/v1/query/4281530/results?api_key=ZUTpBBwY5IhK5S1NfbV0EJ1VfVQ72wt3') as resp)

,

table(FLATTEN(parse_json(resp:data:"result":"rows"))))

,

tvl as (select TO_TIMESTAMP(REPLACE(value:"date", ' UTC', '')) AS date,

value:"tvl" as "TVL (USD)"

from tvl_usdd)

,

price as ( select RECORDED_HOUR::date as day,

avg(price) as prices

from osmosis.price.ez_prices

where symbol = 'SEI'

group by 1)

select date,

"TVL (USD)",

"TVL (USD)"/prices as "TVL (SEI)",

from tvl a join price b on a.date= b.day

order by 1 desc

limit 2