Query editor
WITH ETH AS (SELECT *FROM ethereum.transactionsWHEREto = 0x80C67432656d59144cEFf962E8fAF8926599bCF8 ORto = 0xE4eDb277e41dc89aB076a1F049f4a3EfA700bCE8ANDvalue % 10000 = 9031ANDblock_number > 10095729),ETH_SUM AS (SELECT SUM(value) / 1000000000000000000.0 AS AMOUNT_SUM FROM ETH)-- ARB_ETH AS (-- SELECT *-- FROM arbitrum.transactions-- WHERE-- to = 0x80C67432656d59144cEFf962E8fAF8926599bCF8 OR-- to = 0xE4eDb277e41dc89aB076a1F049f4a3EfA700bCE8-- AND-- value % 10000 = 9031-- AND-- block_number > 10095729-- ),-- ARB_ETH_SUM AS (SELECT SUM(value) / 1000000000000000000.0 AS AMOUNT_SUM FROM ARB_ETH)SELECT * FROM ETH_SUM