Query editor
WITH px AS (SELECT chain, contract_address prov, id, "proxyAddress" proxy FROM aave_v3_multichain.pooladdressesprovider_evt_proxycreated),cfg AS (SELECT chain, prov, proxy cfg FROM px WHERE id = 0x504f4f4c5f434f4e464947555241544f52000000000000000000000000000000),pl AS (SELECT chain, prov, proxy pool FROM px WHERE id = 0x504f4f4c00000000000000000000000000000000000000000000000000000000)SELECT ri.chain, pl.pool, ri.asset, tk.symbol, tk.decimals, min(ri.evt_block_time) t_initFROM aave_v3_multichain.poolconfigurator_evt_reserveinitialized riJOIN cfg ON cfg.chain = ri.chain AND cfg.cfg = ri.contract_addressJOIN pl ON pl.chain = cfg.chain AND pl.prov = cfg.provLEFT JOIN tokens.erc20 tk ON tk.blockchain = ri.chain AND tk.contract_address = ri.assetGROUP BY 1, 2, 3, 4, 5