Query editor
WITH wrappers AS (SELECT * FROM (VALUES(0x7F1f6d132ae9057a2949A99A1e075bB7d0D4C2E3, 'ethereum'),(0x044283955140Ce7aCfa1735227E3d9AC7D624c84, 'base'),(0xCaf0959185D863c4fb650673e4afb19752568ff1, 'arbitrum'),(0x3581c5327dC454D6fE134696C24404cBF788f6bc, 'polygon'),(0x40C1425AD7a43ebeAcc567725f8A2eb55bB15F06, 'avalanche_c'),(0x313eD682E15689d07a25327F6E0D790106908dC7, 'bnb'),(0xE54116f510CA3c3F4AC9fdbC6525d06aBD56246b, 'plasma'),(0x625a12a29C7c9A1315048c8b00E0401e277C7910, 'monad')) AS t(wrapper_address, blockchain)),wrapper_txs AS (SELECT 'ethereum' AS blockchain, hash AS tx_hash, block_time, "from" AS senderFROM ethereum.transactionsWHERE "to" = 0x7F1f6d132ae9057a2949A99A1e075bB7d0D4C2E3 AND success = true AND block_time >= TIMESTAMP '2026-01-01'UNION ALLSELECT 'base', hash, block_time, "from" FROM base.transactionsWHERE "to" = 0x044283955140Ce7aCfa1735227E3d9AC7D624c84 AND success = true AND block_time >= TIMESTAMP '2026-01-01'UNION ALLSELECT 'arbitrum', hash, block_time, "from" FROM arbitrum.transactionsWHERE "to" = 0xCaf0959185D863c4fb650673e4afb19752568ff1 AND success = true AND block_time >= TIMESTAMP '2026-01-01'UNION ALLSELECT 'polygon', hash, block_time, "from" FROM polygon.transactionsWHERE "to" = 0x3581c5327dC454D6fE134696C24404cBF788f6bc AND success = true AND block_time >= TIMESTAMP '2026-01-01'UNION ALLSELECT 'avalanche_c', hash, block_time, "from" FROM avalanche_c.transactionsWHERE "to" = 0x40C1425AD7a43ebeAcc567725f8A2eb55bB15F06 AND success = true AND block_time >= TIMESTAMP '2026-01-01'UNION ALLSELECT 'bnb', hash, block_time, "from" FROM bnb.transactionsWHERE "to" = 0x313eD682E15689d07a25327F6E0D790106908dC7 AND success = true AND block_time >= TIMESTAMP '2026-01-01'UNION ALLSELECT 'plasma', hash, block_time, "from" FROM plasma.transactionsWHERE "to" = 0xE54116f510CA3c3F4AC9fdbC6525d06aBD56246b AND success = true AND block_time >= TIMESTAMP '2026-01-01'UNION ALLSELECT 'monad', hash, block_time, "from" FROM monad.transactionsWHERE "to" = 0x625a12a29C7c9A1315048c8b00E0401e277C7910 AND success = true AND block_time >= TIMESTAMP '2026-01-01'),fee_transfers AS (SELECT 'ethereum' AS blockchain, t.evt_block_time, t.evt_tx_hash, t.contract_address AS token_address, t.value AS raw_feeFROM erc20_ethereum.evt_Transfer tINNER JOIN wrapper_txs w ON w.blockchain = 'ethereum' AND w.tx_hash = t.evt_tx_hashWHERE t."to" = 0x83EBf59CABDE001c7f740C4B9bfA33893Aa483c6 AND t.evt_block_time >= TIMESTAMP '2026-01-01'UNION ALLSELECT 'base', t.evt_block_time, t.evt_tx_hash, t.contract_address, t.valueFROM erc20_base.evt_Transfer tINNER JOIN wrapper_txs w ON w.blockchain = 'base' AND w.tx_hash = t.evt_tx_hashWHERE t."to" = 0x83EBf59CABDE001c7f740C4B9bfA33893Aa483c6 AND t.evt_block_time >= TIMESTAMP '2026-01-01'UNION ALLSELECT 'arbitrum', t.evt_block_time, t.evt_tx_hash, t.contract_address, t.valueFROM erc20_arbitrum.evt_Transfer tINNER JOIN wrapper_txs w ON w.blockchain = 'arbitrum' AND w.tx_hash = t.evt_tx_hashWHERE t."to" = 0x83EBf59CABDE001c7f740C4B9bfA33893Aa483c6 AND t.evt_block_time >= TIMESTAMP '2026-01-01'UNION ALLSELECT 'polygon', t.evt_block_time, t.evt_tx_hash, t.contract_address, t.valueFROM erc20_polygon.evt_Transfer tINNER JOIN wrapper_txs w ON w.blockchain = 'polygon' AND w.tx_hash = t.evt_tx_hashWHERE t."to" = 0x83EBf59CABDE001c7f740C4B9bfA33893Aa483c6 AND t.evt_block_time >= TIMESTAMP '2026-01-01'