-- Generate a continuous date range up to today

SELECT

DATEADD(day, SEQ4() - 1, '2024-06-01') AS date

FROM

TABLE(GENERATOR(ROWCOUNT => 200)) -- Adjust ROWCOUNT to cover the full date range

WHERE

DATEADD(day, SEQ4() - 1, '2024-06-01') <= CURRENT_DATE

),

protocols AS (

-- List of protocols

SELECT DISTINCT protocol

FROM external.defillama.fact_protocol_tvl

WHERE protocol IN ('Stake.ly', 'KLAYstation')

UNION ALL

SELECT 'Lair Finance'

),

all_combinations AS (

-- Cross join calendar and protocols to get all combinations

SELECT

c.date,

p.protocol

FROM

calendar c

CROSS JOIN

protocols p

),

kaia_price_tab AS (

SELECT

hour::date AS date,

AVG(price) AS token_price

FROM

kaia.price.ez_prices_hourly

WHERE

symbol = 'KLAY'

AND hour::date >= CURRENT_DATE - INTERVAL '1 year'