Query editor
-- xstocks_spacexx_mint_redeem_hourly_onchain_v01---- Purpose:-- SpaceX/SPCXx-only hourly onchain mint/redeem reconciliation.---- Critical cost guardrail:-- This query must never scan the full xStocks universe hourly. Airflow must-- pass confirmed SPCXx token addresses, and the first source CTEs filter on-- those addresses plus the requested hour window.---- Parameters:-- start_ts: ISO timestamp text, inclusive, e.g. 2026-06-12 17:00:00-- end_ts: ISO timestamp text, exclusive, e.g. 2026-06-12 18:00:00-- spacex_symbol: expected SPCXx-- spacex_solana_mint_addresses: comma-separated Solana token mints, optional svm: prefix-- spacex_evm_contract_addresses: comma-separated EVM contract addresses-- spacex_evm_blockchains: comma-separated Dune blockchain names, e.g. ethereum,arbitrum,bnb,ink-- spacex_ton_master_addresses: comma-separated TON jetton masters, optional ton: prefix-- solana_backed_treasury_owner: Backed Solana treasury/owner proxy-- valuation_price_usd: optional configured valuation price; leave blank for null USD.-- This is a launch/reference reconciliation price, not issuer settlement-- or event-time market valuation.WITH params AS (SELECTCAST('{{start_ts}}' AS TIMESTAMP) AS start_ts,CAST('{{end_ts}}' AS TIMESTAMP) AS end_ts,COALESCE(NULLIF(TRIM('{{spacex_symbol}}'), ''), 'SPCXx') AS symbol,NULLIF(TRIM('{{spacex_solana_mint_addresses}}'), '') AS solana_mint_addresses,NULLIF(TRIM('{{spacex_evm_contract_addresses}}'), '') AS evm_contract_addresses,NULLIF(LOWER(TRIM('{{spacex_evm_blockchains}}')), '') AS evm_blockchains,NULLIF(TRIM('{{spacex_ton_master_addresses}}'), '') AS ton_master_addresses,COALESCE(NULLIF(TRIM('{{solana_backed_treasury_owner}}'), ''),'S7vYFFWH6BjJyEsdrPQpqpYTqLTrPRK6KW3VwsJuRaS') AS solana_backed_treasury_owner,TRY_CAST(NULLIF(TRIM('{{valuation_price_usd}}'), '') AS DOUBLE) AS valuation_price_usd),guarded_params AS (SELECT *FROM paramsWHERE start_ts IS NOT NULLAND end_ts IS NOT NULLAND start_ts < end_tsAND DATE_DIFF('hour', start_ts, end_ts) BETWEEN 1 AND 72),solana_token_addresses AS (SELECTTRIM(REGEXP_REPLACE(address_raw, '^svm:', '')) AS token_mint_addressFROM guarded_paramsCROSS JOIN UNNEST(SPLIT(COALESCE(solana_mint_addresses, ''), ',')) AS t(address_raw)WHERE TRIM(REGEXP_REPLACE(address_raw, '^svm:', '')) <> ''),evm_contract_addresses AS (SELECTLOWER(TRIM(address_raw)) AS contract_addressFROM guarded_paramsCROSS JOIN UNNEST(SPLIT(COALESCE(evm_contract_addresses, ''), ',')) AS t(address_raw)WHERE LOWER(TRIM(address_raw)) <> ''),