Query editor
WITH raw_data AS (SELECThttp_get('https://api.llama.fi/protocol/byreal') AS response),parsed_data AS (SELECTjson_parse(response) AS parsed_jsonFROM raw_data),tvl_extracted AS (SELECTCAST(json_extract(parsed_json, '$.chainTvls.Solana.tvl') AS ARRAY(JSON)) AS tvl_arrayFROM parsed_data)SELECTfrom_unixtime(CAST(json_extract_scalar(tvl_record, '$.date') AS bigint)) AS date,CAST(json_extract_scalar(tvl_record, '$.totalLiquidityUSD') AS double) AS tvl_usdFROM tvl_extracted,UNNEST(tvl_array) AS t(tvl_record)ORDER BY date DESC