Query editor
WITH hybrid_prices AS (-- Broader Dune hybrid pricing: Coinpaprika plus sufficiently liquid, fresh DEX-derived prices.SELECT blockchain, contract_address, price, decimals, source, volume, timestampFROM prices.latestWHERE blockchain IN ('base', 'ink', 'hyperevm')AND price > 0AND decimals BETWEEN 0 AND 36AND timestamp >= NOW() - INTERVAL '7' DAYAND (source = 'coinpaprika' OR COALESCE(volume, 0) >= 10000)), yo_eur_rate AS (SELECT MAX_BY(CAST(assets AS DOUBLE) / NULLIF(CAST(shares AS DOUBLE), 0),evt_block_time) AS assets_per_shareFROM erc4626_base.evt_DepositWHERE contract_address = 0x50c749ae210d3977adc824ae11f3c7fd10c871e9AND shares > UINT256 '0'AND assets > UINT256 '0'), mc_hype_rate AS (SELECT MAX_BY(CAST(assets AS DOUBLE) / NULLIF(CAST(shares AS DOUBLE), 0),evt_block_time) AS assets_per_shareFROM erc4626_hyperevm.evt_DepositWHERE contract_address = 0xd19e3d00f8547f7d108abfd4bbb015486437b487AND shares > UINT256 '0'AND assets > UINT256 '0'), manual_prices AS (SELECT'base' AS blockchain,0x50c749ae210d3977adc824ae11f3c7fd10c871e9 AS contract_address,r.assets_per_share * p.price AS price,6 AS decimals,0 AS priorityFROM yo_eur_rate rCROSS JOIN hybrid_prices pWHERE p.blockchain = 'base'AND p.contract_address = 0x60a3e35cc302bfa44cb288bc5a4f316fdb1adb42UNION ALLSELECT'hyperevm',0xd19e3d00f8547f7d108abfd4bbb015486437b487,r.assets_per_share * p.price,18,0FROM mc_hype_rate rCROSS JOIN hybrid_prices pWHERE p.blockchain = 'hyperevm'AND p.contract_address = 0x5555555555555555555555555555555555555555), price_candidates AS (SELECT blockchain, contract_address, price, decimals, 1 AS priorityFROM hybrid_pricesUNION ALLSELECT blockchain, contract_address, price, decimals, priorityFROM manual_prices), reliable_prices AS (