Query editor
SELECTCAST(json_extract(json_parse(raw_json), '$.total24h') AS DOUBLE) AS total24h,CAST(json_extract(json_parse(raw_json), '$.total48hto24h') AS DOUBLE) AS total48hto24h,CAST(json_extract(json_parse(raw_json), '$.total7d') AS DOUBLE) AS total7d,CAST(json_extract(json_parse(raw_json), '$.totalAllTime') AS DOUBLE) AS totalAllTime,json_extract(json_parse(raw_json), '$.chains') AS chainsFROM (SELECTHTTP_GET('https://api.llama.fi/summary/aggregators/sushiswap-agg') AS raw_json) AS subquery;