Query editor
WITHtokens AS (SELECTJSON_EXTRACT_SCALAR(token, '$.symbol') AS symbol,JSON_EXTRACT_SCALAR(token, '$.name') AS name,JSON_EXTRACT_SCALAR(token, '$.isTradingHalted') AS is_haltedFROM (SELECT JSON_PARSE(HTTP_GET('https://api.backed.fi/rest/tokens')) AS js)CROSS JOIN UNNEST(CAST(JSON_EXTRACT(js, '$.nodes') AS ARRAY(JSON))) AS t(token)),eligible AS (SELECT DISTINCT symbol, nameFROM tokensWHERE is_halted = 'false'AND name NOT LIKE 'Backed%'),raw_supply AS (SELECTCAST(json_extract_scalar(r, '$.chain') AS VARCHAR) AS chain,CAST(json_extract_scalar(r, '$.tokenAddress') AS VARCHAR) AS token_address,CAST(json_extract_scalar(r, '$.tokenSymbol') AS VARCHAR) AS symbol,CAST(json_extract_scalar(r, '$.day') AS DATE) AS day,CAST(json_extract_scalar(r, '$.circulatingSupplyRaw') AS DOUBLE) AS circ_supply_rawFROM UNNEST(CAST(JSON_PARSE(HTTP_GET('https://api.backed.fi/rest/token-statistics/daily-supply/last-day'))AS ARRAY(JSON))) AS t(r)),filtered AS (SELECT rs.*FROM raw_supply rsJOIN eligible e ON e.symbol = rs.symbol),deduped AS (SELECT *FROM (SELECT f.*,ROW_NUMBER() OVER (PARTITION BY symbol, chain ORDER BY day DESC) AS rnFROM filtered f)WHERE rn = 1),scaled_supply AS (SELECTchain, symbol, token_address, day,CASEWHEN chain IN ('Solana', 'Ton') THEN circ_supply_raw / POWER(10, 8)ELSE circ_supply_raw / POWER(10, 18)END AS circ_supplyFROM deduped),prices AS (SELECTCAST(symbol AS VARCHAR) AS symbol,MAX(price) AS price