Query editor
-- Morpho DAU — BACKFILL 2026-07-01 .. CURRENT_DATE-2WITH metamorphos AS (SELECT CAST(metaMorpho AS VARBINARY) AS metamorpho, chain AS blockchainFROM metamorpho_factory_multichain.metamorphofactory_evt_createmetamorphoUNION ALLSELECT CAST(metaMorpho AS VARBINARY), chainFROM metamorpho_factory_multichain.metamorphov1_1factory_evt_createmetamorpho),vault_users AS (SELECT CAST(time AS DATE) AS day, CAST(usr AS VARBINARY) AS usrFROM dune.morpho.result_morpho_vaults_interactions_multichainWHERE time >= TIMESTAMP '2026-07-01'AND time < CAST(CURRENT_DATE - INTERVAL '1' DAY AS timestamp)),market_users AS (SELECT CAST(mu.time AS DATE) AS day, CAST(mu.usr AS VARBINARY) AS usrFROM dune.morpho.result_morpho_interactions_multichain_all_chains muWHERE mu.time >= TIMESTAMP '2026-07-01'AND mu.time < CAST(CURRENT_DATE - INTERVAL '1' DAY AS timestamp)AND mu.action IN ('borrow', 'supply', 'collat')AND NOT EXISTS (SELECT 1 FROM metamorphos mmWHERE mm.metamorpho = CAST(mu.usr AS VARBINARY)AND mm.blockchain = mu.blockchain))SELECT day, 'Morpho' AS protocol, COUNT(DISTINCT usr) AS active_usersFROM (SELECT day, usr FROM vault_users UNION ALL SELECT day, usr FROM market_users)GROUP BY 1