Query editor
SELECT chain, contract_address pool, reserve, count(*) n, min(evt_block_time) t0, max(evt_block_time) t1FROM (SELECT chain, contract_address, reserve, evt_block_time FROM aave_v3_multichain.pool_evt_supplyUNION ALL SELECT chain, contract_address, reserve, evt_block_time FROM aave_v3_multichain.l2pool_evt_supply)GROUP BY 1, 2, 3