Query editor
-- Dune query name: tokenized_stocks_xstocks_hyperevm_aum_daily_v1-- Description: xStocks HyperEVM daily AUM in USD. Mirrors the ink AUM-- query (tokenized_stocks_xstocks_ink_aum_daily_v1); only the-- chain name, measurement type, and token-universe source-- change. Token universe is inlined here (single HTTP_GET-- against Backed /rest/tokens filtered to network='HyperEVM')-- instead of referencing a separate tokens MV.-- Materialize as dune.buccaneers.result_tokenized_stocks_xstocks_hyperevm_aum_daily_v1-- Reference in tokenized_stocks_xstocks_chain_aum_daily_base_v1.WITH backed_tokens_raw AS (SELECT JSON_PARSE(HTTP_GET('https://api.backed.fi/rest/tokens')) AS js),backed_tokens_flat AS (SELECTLOWER(CAST(JSON_EXTRACT_SCALAR(deployment, '$.address') AS VARCHAR)) AS contract_address,CAST(JSON_EXTRACT_SCALAR(token, '$.symbol') AS VARCHAR) AS symbol,CAST(JSON_EXTRACT_SCALAR(token, '$.underlyingSymbol') AS VARCHAR) AS underlying_ticker,CAST(JSON_EXTRACT_SCALAR(deployment, '$.network') AS VARCHAR) AS networkFROM backed_tokens_rawCROSS JOIN UNNEST(CAST(JSON_EXTRACT(js, '$.nodes') AS ARRAY(JSON))) AS t(token)CROSS JOIN UNNEST(CAST(JSON_EXTRACT(token, '$.deployments') AS ARRAY(JSON))) AS d(deployment)),xstocks_hyperevm_tokens AS (SELECT DISTINCTcontract_address,symbol,COALESCE(NULLIF(underlying_ticker, ''), REGEXP_REPLACE(symbol, 'x$', '')) AS underlying_tickerFROM backed_tokens_flatWHERE network = 'HyperEVM'),xstocks_hyperevm_meta AS (SELECTLOWER(CAST(contract_address AS VARCHAR)) AS contract_address,COALESCE(TRY_CAST(decimals AS INTEGER), 18) AS decimalsFROM tokens.erc20WHERE blockchain = 'hyperevm'AND LOWER(CAST(contract_address AS VARCHAR)) IN (SELECT contract_addressFROM xstocks_hyperevm_tokens)),xstocks_hyperevm_supply_deltas AS (SELECTCAST(DATE_TRUNC('day', t.evt_block_time) AS DATE) AS day,LOWER(CAST(t.contract_address AS VARCHAR)) AS contract_address,CAST(SUM(CASEWHEN LOWER(CAST(t."from" AS VARCHAR)) = '0x0000000000000000000000000000000000000000'THEN CAST(t.value AS DOUBLE) / POWER(10, COALESCE(m.decimals, 18))WHEN LOWER(CAST(t."to" AS VARCHAR)) = '0x0000000000000000000000000000000000000000'THEN -CAST(t.value AS DOUBLE) / POWER(10, COALESCE(m.decimals, 18))ELSE 0END) AS DOUBLE) AS delta_unitsFROM evms.erc20_transfers tLEFT JOIN xstocks_hyperevm_meta mON LOWER(CAST(m.contract_address AS VARCHAR)) = LOWER(CAST(t.contract_address AS VARCHAR))WHERE t.blockchain = 'hyperevm'AND LOWER(CAST(t.contract_address AS VARCHAR)) IN (