thala as (

SELECT defillama.get('/protocol/thala-lsd', {}) as resp

)

,

thala_tvl as ( SELECT *

FROM (

SELECT

TO_TIMESTAMP(v.value:date::INT) AS date,

'Thala' as protocol,

v.value:totalLiquidityUSD::FLOAT AS TVL

FROM

thala,

LATERAL FLATTEN(input => resp['data']['chainTvls']['Aptos']['tvl']) AS v

,

aptos_price as ( select hour::date as date,

avg(price) as avg_price

from aptos.price.ez_prices_hourly

where symbol = 'APT'

group by 1)

,

tb1 as (select a.date,

tvl,

tvl/avg_price as tvl_apt

from thala_tvl a join aptos_price b on a.date = b.date

,

tb2 AS (

SELECT

date,

tvl_apt,

LAG(tvl_apt, 1, 0) OVER (ORDER BY date) AS prev_day_volume,

tvl_apt - LAG(tvl_apt, 1, 0) OVER (ORDER BY date) AS dailY_net

FROM