CTE_1 AS (

WITH raw_data AS (

SELECT livequery.live.udf_api('https://api.coingecko.com/api/v3/coins/solana/market_chart?vs_currency=usd&days=max') AS resp

)

SELECT

'prices' AS key,

TO_TIMESTAMP(value[0]::string) AS day_price,

value[1] AS price

FROM

raw_data,

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

SELECT * FROM CTE_1

WHERE day_price BETWEEN (SELECT MIN(day_price) FROM CTE_1) AND DATEADD(DAY, 180, (SELECT MIN(day_price) FROM CTE_1));