Query editor
WITH token_mapping AS (SELECT * FROM (VALUES(0xba5ddd1f9d7f570dc94a51479a000e3bce967196, 'AAVE', 18),(0xd22a58f79e9481d1a88e00c343885a588b34b68b, 'EURS', 2),(0xda10009cbd5d07dd0cecc66161fc93d7c9000da1, 'DAI', 18),(0xf97f4df75117a78c1a5a0dbb814af92458539fb4, 'LINK', 18),(0xff970a61a04b1ca14834a43f5de4533ebddb5cc8, 'USDC.e', 6),(0x2f2a2543b76a4166549f7aab2e75bef0aefc5b0f, 'WBTC', 8),(0x82af49447d8a07e3bd95bd0d56f35241523fbab1, 'WETH', 18),(0xfd086bc7cd5c481dcc9c85ebe478a1c0b69fcbb9, 'USDT', 6),(0x5979d7b546e38e414f7e9822514be443a4800529, 'wstETH', 18),(0x3f56e0c36d275367b8c502090edf38289b3dea0d, 'MAI', 18),(0xec70dcb4a1efa46b8f2d97c310c9c4790ba5ffa8, 'rETH', 18),(0x93b346b6bc2548da6a1e7d98e9a421b42541425b, 'LUSD', 18),(0xaf88d065e77c8cc2239327c5edb3a432268e5831, 'USDC', 6),(0x17fc002b466eec40dae837fc4be5c67993ddbd6f, 'FRAX', 18),(0x912ce59144191c1204e64559fe8253a0e49e6548, 'ARB', 18),(0x35751007a407ca6feffe80b3cb397736d2cf4dbe, 'weETH', 18),(0x7dff72693f6a4149b17e7c6314655f6a9f7c8b33, 'GHO', 18),(0x2416092f143378750bb29b79ed961ab195cceea5, 'ezETH', 18),(0x4186bfc76e2e237523cbc30fd220fe055156b41f, 'rsETH', 18)) AS t(address, symbol, decimals)),-- Cross-chain price mapping for tokens missing Arbitrum pricescross_chain_mapping AS (SELECT * FROM (VALUES(0x7dff72693f6a4149b17e7c6314655f6a9f7c8b33, 0x40D16FC0246aD3160Ccc09B8D0D3A2cD28aE6C2f, 'GHO'),(0xba5ddd1f9d7f570dc94a51479a000e3bce967196, 0x7Fc66500c84A76Ad7e9c93437bFc5Ac33E2DDaE9, 'AAVE'),(0x5979d7b546e38e414f7e9822514be443a4800529, 0x7f39C581F595B53c5cb19bD0b3f8dA6c935E2Ca0, 'wstETH'),(0xec70dcb4a1efa46b8f2d97c310c9c4790ba5ffa8, 0xae78736Cd615f374D3085123A210448E74Fc6393, 'rETH'),(0x35751007a407ca6feffe80b3cb397736d2cf4dbe, 0xCd5fE23C85820F7B72D0926FC9b05b43E359b7ee, 'weETH'),(0x2416092f143378750bb29b79ed961ab195cceea5, 0xbf5495Efe5DB9ce00f80364C8B42356065D63916, 'ezETH'),(0x4186bfc76e2e237523cbc30fd220fe055156b41f, 0xA1290d69c65A6Fe4DF752f95823fae25cB99e5A7, 'rsETH'),(0xf97f4df75117a78c1a5a0dbb814af92458539fb4, 0x514910771AF9Ca656af840dff83E8264EcF986CA, 'LINK'),(0x2f2a2543b76a4166549f7aab2e75bef0aefc5b0f, 0x2260FAC5E5542a773Aa44fBCfeDf7C193bc2C599, 'WBTC'),(0x82af49447d8a07e3bd95bd0d56f35241523fbab1, 0xC02aaA39b223FE8D0A0e5C4F27eAD9083C756Cc2, 'WETH'),(0xda10009cbd5d07dd0cecc66161fc93d7c9000da1, 0x6B175474E89094C44Da98b954EedeAC495271d0F, 'DAI'),(0xff970a61a04b1ca14834a43f5de4533ebddb5cc8, 0xA0b86a33E6412b8c4f4aafE41AF7fb9e7C43d5f5, 'USDC.e'),(0xaf88d065e77c8cc2239327c5edb3a432268e5831, 0xA0b86a33E6412b8c4f4aafE41AF7fb9e7C43d5f5, 'USDC'),(0xfd086bc7cd5c481dcc9c85ebe478a1c0b69fcbb9, 0xdAC17F958D2ee523a2206206994597C13D831ec7, 'USDT'),(0x93b346b6bc2548da6a1e7d98e9a421b42541425b, 0x5f98805A4E8be255a32880FDeC7F6728C6568bA0, 'LUSD'),(0x17fc002b466eec40dae837fc4be5c67993ddbd6f, 0x853d955aCEf822Db058eb8505911ED77F175b99e, 'FRAX')) AS t(arbitrum_address, ethereum_address, symbol)),atoken_info AS (SELECTasset as reserve,aToken,evt_block_time as init_timeFROM aave_v3_arbitrum.PoolConfigurator_evt_ReserveInitialized),-- SUPPLY CALCULATION via aToken mints/burnsatoken_mints AS (SELECTai.reserve,SUM(CAST(m.value AS DOUBLE)) as total_mintedFROM atoken_info aiINNER JOIN erc20_arbitrum.evt_Transfer m ON m.contract_address = ai.aTokenWHERE m."from" = 0x0000000000000000000000000000000000000000GROUP BY ai.reserve