Query editor
WITH metamorphos AS (SELECT metamorpho, chain, loan_asset AS asset, vault_name AS metamorpho_name, is_whitelistedFROM query_5930072),vault_data AS (SELECTmva.vault_address as metamorpho,mva.chain,from_iso8601_timestamp(date) as timestamp,CASEWHEN from_iso8601_timestamp(date) <= TIMESTAMP '2024-11-22'THEN cast(apy_no_rewards as double)ELSE cast(apy as double)END as apy,cast(apy_no_rewards as double) as apy_no_rewards,cast(apy_performance as double) as apy_performance,cast(apy_reward as double) as apy_reward,m.metamorpho_name,t.symbol as underlying_symbol,m.is_whitelistedFROM dune.morpho.dataset_morpho_vaults_apy mvaJOIN metamorphos m ON mva.vault_address = m.metamorpho AND mva.chain = m.chainJOIN tokens.erc20 t ON t.blockchain = mva.chain AND t.contract_address = m.assetWHERE from_iso8601_timestamp(date) >= TIMESTAMP '2026-01-04')SELECTmetamorpho_name,metamorpho as address,chain,timestamp as hour,apy,apy_no_rewards,apy_performance,apy_reward,underlying_symbol,is_whitelistedFROM vault_dataWhere metamorpho_name = 'Api3 Core USDC' or metamorpho_name = 'Kabu USDC'ORDER BY hour DESC, metamorpho_name;