Query editor
WITH subgraphs(chain, sub_url) as (VALUES('arbitrum', 'https://api.dolomite.io/tokens/42161')-- ('berachain', 'https://api.dolomite.io/tokens/80094'),-- ('zkevm', 'https://api.dolomite.io/tokens/1101'),-- ('mantle', 'https://api.dolomite.io/tokens/5000')), raw_response_data as (SELECT chain, http_get(sub_url, ARRAY['Content-Type: application/json']) as raw_dataFROM subgraphs), data_array as (SELECT chain,json_extract(json_parse(raw_data), '$.tokens') AS parsed_json_arrayFROM raw_response_data)SELECT chain as blockchain, from_hex(json_extract_scalar(market_data, '$.id')) as token_address, CAST(json_extract_scalar(market_data, '$.marketId') AS UINT256) as market_id, json_extract_scalar(market_data, '$.cleanSymbol') as symbol_name, CAST(json_extract_scalar(market_data, '$.decimals') AS INTEGER) as decimals, CAST(json_extract_scalar(market_data, '$.isIsolationMode') AS BOOLEAN) as is_isolationFROM data_array, UNNEST(CAST(parsed_json_array as array(json))) as t(market_data)