Query editor
-- Chains: 'ethereum', 'arbitrum', 'base', 'avalanche_c', 'bnb'WITHdeps AS (SELECTd.*,COUNT(*) OVER (PARTITION BY d.chain, d.evt_tx_hash) AS deposits_in_txFROM euler_v2_multichain.evault_evt_deposit dWHERE d.chain IN ('ethereum','arbitrum', 'base', 'avalanche_c', 'bnb')),borrows_ranked AS (SELECTchain,evt_tx_hash,contract_address AS borrow_vault_address,evt_index,ROW_NUMBER() OVER (PARTITION BY chain, evt_tx_hash ORDER BY evt_index) AS rnFROM euler_v2_multichain.evault_evt_borrowWHERE chain IN ('ethereum', 'arbitrum', 'base', 'avalanche_c', 'bnb')),first_borrow AS (SELECT *FROM borrows_rankedWHERE rn = 1),/* Latest vault metadata per vault (symbol/name/asset_token/decimals).This is used to power prices.hour fallback even if the daily snapshot is missing for that day. */vault_meta AS (SELECT *FROM (SELECTblockchain,vault_address,asset_token,symbol,name,decimals,ROW_NUMBER() OVER (PARTITION BY blockchain, vault_addressORDER BY day DESC) AS rnFROM dune.pibbles.result_euler_finance_indexWHERE blockchain IN ('ethereum','arbitrum','base','avalanche_c','bnb')) xWHERE rn = 1),/* Daily snapshot (RAW price) for the vault on the deposit day (when available) */vault_day_raw AS (SELECTblockchain,vault_address,DATE_TRUNC('day', day) AS day,price AS raw_price,decimals AS raw_decimalsFROM dune.pibbles.result_euler_finance_indexWHERE blockchain IN ('ethereum','arbitrum','base','avalanche_c','bnb')