Query editor
WITH parsed_data AS (SELECTTRY_CAST(json_extract_scalar(item, '$.date') AS date) as date,json_extract_scalar(item, '$.address') as address,TRY_CAST(json_extract_scalar(item, '$.swapVol') AS double) AS volume,TRY_CAST(json_extract_scalar(item, '$.swapFee') AS double) AS feeFROM UNNEST(CAST(TRY(json_parse(HTTP_GET('https://api.woofi.com/solana_stat?filter_days=90'))) AS ARRAY(JSON))) AS t(item))SELECTdate AS date,sum(volume / 1e6) as volumeFROM parsed_dataWHEREdate >= DATE '2025-05-09'GROUP BYdate