Query editor
-- Aave DAU (v2 + v3, same definition as historical dataset) — BACKFILL 2026-07-01 .. CURRENT_DATE-2WITH ev AS (SELECT evt_block_date AS day, "user" AS usr FROM aave_v2_multichain.lendingpool_evt_deposit WHERE evt_block_date >= DATE '2026-07-01' AND evt_block_date < CURRENT_DATE - INTERVAL '1' DAYUNION ALL SELECT evt_block_date, "user" FROM aave_v2_multichain.lendingpool_evt_borrow WHERE evt_block_date >= DATE '2026-07-01' AND evt_block_date < CURRENT_DATE - INTERVAL '1' DAYUNION ALL SELECT evt_block_date, "user" FROM aave_v2_multichain.lendingpool_evt_repay WHERE evt_block_date >= DATE '2026-07-01' AND evt_block_date < CURRENT_DATE - INTERVAL '1' DAYUNION ALL SELECT evt_block_date, "user" FROM aave_v2_multichain.lendingpool_evt_withdraw WHERE evt_block_date >= DATE '2026-07-01' AND evt_block_date < CURRENT_DATE - INTERVAL '1' DAYUNION ALL SELECT evt_block_date, "user" FROM aave_v2_multichain.lendingpool_evt_liquidationcall WHERE evt_block_date >= DATE '2026-07-01' AND evt_block_date < CURRENT_DATE - INTERVAL '1' DAYUNION ALL SELECT evt_block_date, initiator FROM aave_v2_multichain.lendingpool_evt_flashloan WHERE evt_block_date >= DATE '2026-07-01' AND evt_block_date < CURRENT_DATE - INTERVAL '1' DAYUNION ALL SELECT evt_block_date, "user" FROM aave_v3_multichain.pool_evt_supply WHERE evt_block_date >= DATE '2026-07-01' AND evt_block_date < CURRENT_DATE - INTERVAL '1' DAYUNION ALL SELECT evt_block_date, "user" FROM aave_v3_multichain.pool_evt_borrow WHERE evt_block_date >= DATE '2026-07-01' AND evt_block_date < CURRENT_DATE - INTERVAL '1' DAYUNION ALL SELECT evt_block_date, "user" FROM aave_v3_multichain.pool_evt_repay WHERE evt_block_date >= DATE '2026-07-01' AND evt_block_date < CURRENT_DATE - INTERVAL '1' DAYUNION ALL SELECT evt_block_date, "user" FROM aave_v3_multichain.pool_evt_withdraw WHERE evt_block_date >= DATE '2026-07-01' AND evt_block_date < CURRENT_DATE - INTERVAL '1' DAYUNION ALL SELECT evt_block_date, "user" FROM aave_v3_multichain.pool_evt_liquidationcall WHERE evt_block_date >= DATE '2026-07-01' AND evt_block_date < CURRENT_DATE - INTERVAL '1' DAYUNION ALL SELECT evt_block_date, initiator FROM aave_v3_multichain.pool_evt_flashloan WHERE evt_block_date >= DATE '2026-07-01' AND evt_block_date < CURRENT_DATE - INTERVAL '1' DAY)SELECT day, 'Aave' AS protocol, COUNT(DISTINCT usr) AS active_usersFROM evGROUP BY 1