Query editor
SELECT chain, contract_address pool, reserve, evt_block_time t, evt_tx_hash tx, CAST("amountMinted" AS double) amt_rawFROM (SELECT chain, contract_address, reserve, evt_block_time, evt_tx_hash, "amountMinted" FROM aave_v3_multichain.pool_evt_mintedtotreasuryUNION ALL SELECT chain, contract_address, reserve, evt_block_time, evt_tx_hash, "amountMinted" FROM aave_v3_multichain.l2pool_evt_mintedtotreasury)WHERE evt_block_time >= TIMESTAMP '2022-12-01' AND ((chain = 'ink' AND reserve = 0x0200c29006150606b650577bbe7b6248f58470c1) OR (chain = 'monad' AND reserve = 0xe7cd86e13ac4309349f30b3435a9d337750fc82d) OR (chain = 'mantle' AND reserve = 0x09bc4e0d864854c6afb6eb9a9cdf58ac190d0df9) OR (chain = 'linea' AND reserve = 0x176211869ca2b568f2a7d4ee941e073a821ee1ff) OR (chain = 'ethereum' AND reserve = 0x6c3ea9036406852006290770bedfcaba0e23a0e8) OR (chain = 'ink' AND reserve = 0x8a76fe7fa6da27f85a626c5c53730b38d13603d7) OR (chain = 'monad' AND reserve = 0xaca92e438df0b2401ff60da7e4337b687a2435da) OR (chain = 'mantle' AND reserve = 0x5d3a1ff2b6bab83b63cd9ad0787074081a52ef34) OR (chain = 'scroll' AND reserve = 0x06efdbff2a14a7c8e15944d1f4a48f9f95f663a4) OR (chain = 'plasma' AND reserve = 0x211cc4dd073734da055fbf44a2b4667d5e5fe5d2) OR (chain = 'ethereum' AND reserve = 0x8292bb45bf1ee4d140127049757c2e0ff06317ed) OR (chain = 'base' AND reserve = 0x833589fcd6edb6e08f4c7c32d4f71b54bda02913) OR (chain = 'zksync' AND reserve = 0x1d17cbcf0d6d143135ae902365d2e5e2a16538d4) OR (chain = 'gnosis' AND reserve = 0xfc421ad3c883bf9e7c4f42de845c4e4405799e73) OR (chain = 'ink' AND reserve = 0x211cc4dd073734da055fbf44a2b4667d5e5fe5d2) OR (chain = 'ethereum' AND reserve = 0xe343167631d89b6ffc58b88d6b7fb0228795491d) OR (chain = 'ethereum' AND reserve = 0x4c9edd5852cd905f086c759e8383e09bff1e68b3) OR (chain = 'polygon' AND reserve = 0x8f3cf7ad23cd3cadbd9735aff958023239c6a063) OR (chain = 'ethereum' AND reserve = 0x83f20f44975d03b1b09e64809b757c47f942beea) OR (chain = 'gnosis' AND reserve = 0x2a22f9c3b484c3629090feed35f17ff8f88f76f0) OR (chain = 'ethereum' AND reserve = 0x6b175474e89094c44da98b954eedeac495271d0f) OR (chain = 'mantle' AND reserve = 0x779ded0c9e1022225f8e0630b35a9b54be713736) OR (chain = 'polygon' AND reserve = 0x2791bca1f2de4661ed88a30c99a7a9449aa84174) OR (chain = 'plasma' AND reserve = 0xc4374775489cb9c56003bf2c9b12495fc64f0771) OR (chain = 'arbitrum' AND reserve = 0x93b346b6bc2548da6a1e7d98e9a421b42541425b) OR (chain = 'ethereum' AND reserve = 0x90d2af7d622ca3141efa4d8f1f24d86e5974cc8f) OR (chain = 'arbitrum' AND reserve = 0x17fc002b466eec40dae837fc4be5c67993ddbd6f) OR (chain = 'monad' AND reserve = 0x5d3a1ff2b6bab83b63cd9ad0787074081a52ef34) OR (chain = 'arbitrum' AND reserve = 0xfd086bc7cd5c481dcc9c85ebe478a1c0b69fcbb9) OR (chain = 'ethereum' AND reserve = 0x40d16fc0246ad3160ccc09b8d0d3a2cd28ae6c2f) OR (chain = 'base' AND reserve = 0x6bb7a212910682dcfdbd5bcbb3e28fb4e8da10ee) OR (chain = 'ethereum' AND reserve = 0xa0b86991c6218b36c1d19d4a2e9eb0ce3606eb48) OR (chain = 'optimism' AND reserve = 0x7f5c764cbc14f9669b88837ca1490cca17c31607) OR (chain = 'optimism' AND reserve = 0xc40f949f8a4e094d1b49a23ea9241d289b7b2819) OR (chain = 'mantle' AND reserve = 0x051665f2455116e929b9972c36d23070f5054ce0) OR (chain = 'gnosis' AND reserve = 0xddafbb505ad214d7b80b1f830fccc89b60fb7a83) OR (chain = 'monad' AND reserve = 0x754704bc059f8c67012fed69bc8a327a5aafb603) OR (chain = 'ethereum' AND reserve = 0xdc035d45d973e3ec169d2276ddab16f1e407384f) OR (chain = 'linea' AND reserve = 0xaca92e438df0b2401ff60da7e4337b687a2435da) OR (chain = 'ethereum' AND reserve = 0xaca92e438df0b2401ff60da7e4337b687a2435da) OR (chain = 'arbitrum' AND reserve = 0xaf88d065e77c8cc2239327c5edb3a432268e5831) OR (chain = 'celo' AND reserve = 0x48065fbbe25f71c9282ddf5e1cd6d6a887483d5e) OR (chain = 'avalanche_c' AND reserve = 0xd24c2ad096400b6fbcd2ad8b24e7acbc21a1da64) OR (chain = 'linea' AND reserve = 0xa219439258ca9da29e9cc4ce5596924745e12b93) OR (chain = 'arbitrum' AND reserve = 0xff970a61a04b1ca14834a43f5de4533ebddb5cc8) OR (chain = 'optimism' AND reserve = 0x8c6f28f2f1a3c87f0f938b96d27520d9751ec8d9) OR (chain = 'ink' AND reserve = 0x2d270e6886d130d724215a266106e6832161eaed) OR (chain = 'ink' AND reserve = 0xfc421ad3c883bf9e7c4f42de845c4e4405799e73) OR (chain = 'ethereum' AND reserve = 0xdac17f958d2ee523a2206206994597c13d831ec7) OR (chain = 'ethereum' AND reserve = 0x356b8d89c1e1239cbbb9de4815c39a1474d5ba7d) OR (chain = 'gnosis' AND reserve = 0xaf204776c7245bf4147c2612bf6e5972ee483701) OR (chain = 'ethereum' AND reserve = 0xc139190f447e929f090edeb554d95abb8b18ac1c) OR (chain = 'avalanche_c' AND reserve = 0x9702230a8ea53601f5cd2dc00fdbc13d4df4a8c7) OR (chain = 'arbitrum' AND reserve = 0xda10009cbd5d07dd0cecc66161fc93d7c9000da1) OR (chain = 'avalanche_c' AND reserve = 0xd586e7f844cea2f87f50152665bcbc2c279d8d70) OR (chain = 'monad' AND reserve = 0xfc421ad3c883bf9e7c4f42de845c4e4405799e73) OR (chain = 'avalanche_c' AND reserve = 0xfc421ad3c883bf9e7c4f42de845c4e4405799e73) OR (chain = 'plasma' AND reserve = 0x5d3a1ff2b6bab83b63cd9ad0787074081a52ef34) OR (chain = 'zksync' AND reserve = 0x493257fd37edb34451f62edf8d2a0c418852ba4c) OR (chain = 'base' AND reserve = 0xd9aaec86b65d86f6a7b5b1b0c42ffa531710b6ca) OR (chain = 'plasma' AND reserve = 0xb77e872a68c62cfc0dfb02c067ecc3da23b4bbf3) OR (chain = 'ethereum' AND reserve = 0x853d955acef822db058eb8505911ed77f175b99e) OR (chain = 'ethereum' AND reserve = 0x9d39a5de30e57443bff2a8307a4256c8797a3497) OR (chain = 'gnosis' AND reserve = 0xe91d153e0b41518a2ce8dd3d7944fa863463a97d) OR (chain = 'mantle' AND reserve = 0x211cc4dd073734da055fbf44a2b4667d5e5fe5d2) OR (chain = 'monad' AND reserve = 0xab6e5a0c3799d020c790d34f7b2c02639e238af7) OR (chain = 'zksync' AND reserve = 0xad17da2f6ac76746ef261e835c50b2651ce36da8) OR (chain = 'arbitrum' AND reserve = 0x7dff72693f6a4149b17e7c6314655f6a9f7c8b33) OR (chain = 'base' AND reserve = 0x660975730059246a68521a3e2fbd4740173100f5) OR (chain = 'sonic' AND reserve = 0x29219dd400f2bf60e5a23d13be72b486d4038894) OR (chain = 'ethereum' AND reserve = 0x5f98805a4e8be255a32880fdec7f6728c6568ba0) OR (chain = 'ethereum' AND reserve = 0xf939e0a03fb07f59a73314e73794be0e57ac1b4e) OR (chain = 'optimism' AND reserve = 0xda10009cbd5d07dd0cecc66161fc93d7c9000da1) OR (chain = 'plasma' AND reserve = 0xb8ce59fc3717ada4c02eadf9682a9e934f625ebb))