Query editor
WITH h AS (SELECT 'ethereum' chain, 0x40d16fc0246ad3160ccc09b8d0d3a2cd28ae6c2f reserve, date_trunc('hour', block_time) hr,max_by(CAST(bytearray_to_uint256(bytearray_substring(data, 1, 32)) AS double) / 1e27, block_number * 100000 + index) liq,max_by(CAST(bytearray_to_uint256(bytearray_substring(data, 65, 32)) AS double) / 1e27, block_number * 100000 + index) vbrFROM ethereum.logsWHERE contract_address = 0x87870bca3f3fd6335c3f4ce8392d69350b4fa4e2 AND topic0 = 0x804c9b842b2748a22bb64b345453a3de7ca54a6ca45ce00d415894979e22897a AND topic1 = 0x00000000000000000000000040d16fc0246ad3160ccc09b8d0d3a2cd28ae6c2fAND block_date BETWEEN DATE '2024-08-08' AND DATE '2026-05-18'GROUP BY 1, 2, 3 UNION ALL SELECT 'gnosis' chain, 0xfc421ad3c883bf9e7c4f42de845c4e4405799e73 reserve, date_trunc('hour', block_time) hr,max_by(CAST(bytearray_to_uint256(bytearray_substring(data, 1, 32)) AS double) / 1e27, block_number * 100000 + index) liq,max_by(CAST(bytearray_to_uint256(bytearray_substring(data, 65, 32)) AS double) / 1e27, block_number * 100000 + index) vbrFROM gnosis.logsWHERE contract_address = 0xb50201558b00496a145fe76f7424749556e326d8 AND topic0 = 0x804c9b842b2748a22bb64b345453a3de7ca54a6ca45ce00d415894979e22897a AND topic1 = 0x000000000000000000000000fc421ad3c883bf9e7c4f42de845c4e4405799e73AND block_date BETWEEN DATE '2024-08-08' AND DATE '2026-05-18'GROUP BY 1, 2, 3 UNION ALL SELECT 'mantle' chain, 0xfc421ad3c883bf9e7c4f42de845c4e4405799e73 reserve, date_trunc('hour', block_time) hr,max_by(CAST(bytearray_to_uint256(bytearray_substring(data, 1, 32)) AS double) / 1e27, block_number * 100000 + index) liq,max_by(CAST(bytearray_to_uint256(bytearray_substring(data, 65, 32)) AS double) / 1e27, block_number * 100000 + index) vbrFROM mantle.logsWHERE contract_address = 0x458f293454fe0d67ec0655f3672301301dd51422 AND topic0 = 0x804c9b842b2748a22bb64b345453a3de7ca54a6ca45ce00d415894979e22897a AND topic1 = 0x000000000000000000000000fc421ad3c883bf9e7c4f42de845c4e4405799e73AND block_date BETWEEN DATE '2024-08-08' AND DATE '2026-05-18'GROUP BY 1, 2, 3 UNION ALL SELECT 'monad' chain, 0xfc421ad3c883bf9e7c4f42de845c4e4405799e73 reserve, date_trunc('hour', block_time) hr,max_by(CAST(bytearray_to_uint256(bytearray_substring(data, 1, 32)) AS double) / 1e27, block_number * 100000 + index) liq,max_by(CAST(bytearray_to_uint256(bytearray_substring(data, 65, 32)) AS double) / 1e27, block_number * 100000 + index) vbrFROM monad.logsWHERE contract_address = 0x69a5f9ad4f96ebf0a0c792dd42a01cc5c0102fef AND topic0 = 0x804c9b842b2748a22bb64b345453a3de7ca54a6ca45ce00d415894979e22897a AND topic1 = 0x000000000000000000000000fc421ad3c883bf9e7c4f42de845c4e4405799e73AND block_date BETWEEN DATE '2024-08-08' AND DATE '2026-05-18'GROUP BY 1, 2, 3 UNION ALL SELECT 'ink' chain, 0xfc421ad3c883bf9e7c4f42de845c4e4405799e73 reserve, date_trunc('hour', block_time) hr,max_by(CAST(bytearray_to_uint256(bytearray_substring(data, 1, 32)) AS double) / 1e27, block_number * 100000 + index) liq,max_by(CAST(bytearray_to_uint256(bytearray_substring(data, 65, 32)) AS double) / 1e27, block_number * 100000 + index) vbrFROM ink.logsWHERE contract_address = 0x2816cf15f6d2a220e789aa011d5ee4eb6c47feba AND topic0 = 0x804c9b842b2748a22bb64b345453a3de7ca54a6ca45ce00d415894979e22897a AND topic1 = 0x000000000000000000000000fc421ad3c883bf9e7c4f42de845c4e4405799e73AND block_date BETWEEN DATE '2024-08-08' AND DATE '2026-05-18'GROUP BY 1, 2, 3 UNION ALL SELECT 'avalanche_c' chain, 0xfc421ad3c883bf9e7c4f42de845c4e4405799e73 reserve, date_trunc('hour', block_time) hr,max_by(CAST(bytearray_to_uint256(bytearray_substring(data, 1, 32)) AS double) / 1e27, block_number * 100000 + index) liq,max_by(CAST(bytearray_to_uint256(bytearray_substring(data, 65, 32)) AS double) / 1e27, block_number * 100000 + index) vbrFROM avalanche_c.logsWHERE contract_address = 0x794a61358d6845594f94dc1db02a252b5b4814ad AND topic0 = 0x804c9b842b2748a22bb64b345453a3de7ca54a6ca45ce00d415894979e22897a AND topic1 = 0x000000000000000000000000fc421ad3c883bf9e7c4f42de845c4e4405799e73AND block_date BETWEEN DATE '2024-08-08' AND DATE '2026-05-18'GROUP BY 1, 2, 3 UNION ALL SELECT 'arbitrum' chain, 0x7dff72693f6a4149b17e7c6314655f6a9f7c8b33 reserve, date_trunc('hour', block_time) hr,max_by(CAST(bytearray_to_uint256(bytearray_substring(data, 1, 32)) AS double) / 1e27, block_number * 100000 + index) liq,max_by(CAST(bytearray_to_uint256(bytearray_substring(data, 65, 32)) AS double) / 1e27, block_number * 100000 + index) vbrFROM arbitrum.logsWHERE contract_address = 0x794a61358d6845594f94dc1db02a252b5b4814ad AND topic0 = 0x804c9b842b2748a22bb64b345453a3de7ca54a6ca45ce00d415894979e22897a AND topic1 = 0x0000000000000000000000007dff72693f6a4149b17e7c6314655f6a9f7c8b33AND block_date BETWEEN DATE '2024-08-08' AND DATE '2026-05-18'GROUP BY 1, 2, 3 UNION ALL SELECT 'base' chain, 0x6bb7a212910682dcfdbd5bcbb3e28fb4e8da10ee reserve, date_trunc('hour', block_time) hr,max_by(CAST(bytearray_to_uint256(bytearray_substring(data, 1, 32)) AS double) / 1e27, block_number * 100000 + index) liq,max_by(CAST(bytearray_to_uint256(bytearray_substring(data, 65, 32)) AS double) / 1e27, block_number * 100000 + index) vbrFROM base.logsWHERE contract_address = 0xa238dd80c259a72e81d7e4664a9801593f98d1c5 AND topic0 = 0x804c9b842b2748a22bb64b345453a3de7ca54a6ca45ce00d415894979e22897a AND topic1 = 0x0000000000000000000000006bb7a212910682dcfdbd5bcbb3e28fb4e8da10eeAND block_date BETWEEN DATE '2024-08-08' AND DATE '2026-05-18'GROUP BY 1, 2, 3 UNION ALL SELECT 'plasma' chain, 0xb77e872a68c62cfc0dfb02c067ecc3da23b4bbf3 reserve, date_trunc('hour', block_time) hr,max_by(CAST(bytearray_to_uint256(bytearray_substring(data, 1, 32)) AS double) / 1e27, block_number * 100000 + index) liq,max_by(CAST(bytearray_to_uint256(bytearray_substring(data, 65, 32)) AS double) / 1e27, block_number * 100000 + index) vbrFROM plasma.logsWHERE contract_address = 0x925a2a7214ed92428b5b1b090f80b25700095e12 AND topic0 = 0x804c9b842b2748a22bb64b345453a3de7ca54a6ca45ce00d415894979e22897a AND topic1 = 0x000000000000000000000000b77e872a68c62cfc0dfb02c067ecc3da23b4bbf3AND block_date BETWEEN DATE '2024-08-08' AND DATE '2026-05-18'GROUP BY 1, 2, 3 UNION ALL SELECT 'ethereum' chain, 0x5f98805a4e8be255a32880fdec7f6728c6568ba0 reserve, date_trunc('hour', block_time) hr,max_by(CAST(bytearray_to_uint256(bytearray_substring(data, 1, 32)) AS double) / 1e27, block_number * 100000 + index) liq,max_by(CAST(bytearray_to_uint256(bytearray_substring(data, 65, 32)) AS double) / 1e27, block_number * 100000 + index) vbrFROM ethereum.logsWHERE contract_address = 0x87870bca3f3fd6335c3f4ce8392d69350b4fa4e2 AND topic0 = 0x804c9b842b2748a22bb64b345453a3de7ca54a6ca45ce00d415894979e22897a AND topic1 = 0x0000000000000000000000005f98805a4e8be255a32880fdec7f6728c6568ba0AND block_date BETWEEN DATE '2023-08-07' AND DATE '2024-01-25'