Query editor
-- =================================================================-- VIEW: vw.hype_token_daily_price-- =================================================================-- DESCRIPTION: Historical $HYPE price based on CoinGecko API v3 data.-- The query selects only last daily price available.-- =================================================================WITH-- >> STEP 1: Execute API call & Parse JSON payload once.raw_json_data AS (SELECTjson_parse(http_get('https://api.coingecko.com/api/v3/coins/hyperliquid/market_chart?vs_currency=usd&days=365')) AS api_response),-- >> STEP 2: Extract & Unzip data efficiently.unnested_data AS (SELECTfrom_unixtime(CAST(json_extract_scalar(price_item, '$[0]') AS BIGINT) / 1000) AS timestamp_utc,CAST(json_extract_scalar(price_item, '$[1]') AS DOUBLE) AS price_usdFROMraw_json_dataCROSS JOINUNNEST(CAST(json_extract(api_response, '$.prices') AS ARRAY(JSON))) AS t(price_item)),-- >> STEP 3: Identify last daily price available.daily_latest_snapshot AS (SELECTtimestamp_utc,price_usd,ROW_NUMBER() OVER (PARTITION BY CAST(timestamp_utc AS DATE)ORDER BY timestamp_utc DESC) AS rnFROM unnested_data)-- Finaly query, creating the SQL View.SELECTCAST(D.timestamp_utc AS DATE) AS day,D.price_usdFROM daily_latest_snapshot AS DWHERE D.rn = 1ORDER BY D.timestamp_utc DESC;