with base as (

SELECT

-- PARSE_JSON(defillama.get('/protocol/raydium', {})) as data

PARSE_JSON(livequery.live.udf_api('https://drive.google.com/uc?export=download&id=1PUS-GnwF3meRzyKUUy3Yqx7NxeNNQ-UX')) as data

, base2 as (

select tvl.value:date as raw_date, tvl.value:totalLiquidityUSD as tvl

from base

join lateral flatten (input => data:data:chainTvls:Solana:tvl) tvl

, base3 as (

select to_date(raw_date::string) as date,

case

when date BETWEEN '2023-01-01' and '2023-03-31' then '2023_Q1'

when date BETWEEN '2023-04-01' and '2023-06-30' then '2023_Q2'

when date BETWEEN '2023-07-01' and '2023-09-30' then '2023_Q3'

when date BETWEEN '2023-10-01' and '2023-12-31' then '2023_Q4'

when date BETWEEN '2024-01-01' and '2024-03-31' then '2024_Q1'

when date BETWEEN '2024-04-01' and '2024-06-30' then '2024_Q2'

end as date_type,

tvl

from base2

where date >= '2023-01-01'

, base_avg as(

select date_type,

avg(tvl) as "AVG TVL by Period"

from base3

group by 1

select *