Query editor
-- Native transfers from tracesSELECTt.blockchain,t.block_date,t.block_time,t.tx_hash,tx."from" AS tx_from,t."from",'native' AS token_standard,0x0000000000000000000000000000000000000000 AS contract_address,t.value / 1e18 AS amountFROM evms.traces tJOIN evms.transactions txON t.tx_hash = tx.hashAND t.blockchain = tx.blockchainAND t.block_date = tx.block_dateWHEREt.block_time > TIMESTAMP '{{since_timestamp}}'AND t."from" IN (0xac4c6e212a361c968f1725b4d055b47e63f80b75,0x35e98c2b3894d71d3d4d7edb8b30e4f36e2f9179,0xd2b37aDE14708bf18904047b1E31F8166d39612b,0xE0a091CEEB255cE3Abc3B18305d48a07521e19e1,0xe89AAb725a2b2C0656248DCCcc894A04661BE55A,0x67ad43499eda05ddd799f4e6c407646c5bf2ed47)AND t."to" = 0xde7259893Af7cdbC9fD806c6ba61D22D581d5667AND t.value > 0AND t.success = trueAND t.call_type = 'call'UNION ALL-- ERC20 transfersSELECTt.blockchain,t.evt_block_date AS block_date,t.evt_block_time AS block_time,t.evt_tx_hash AS tx_hash,t.evt_tx_from AS tx_from,t."from",'erc20' AS token_standard,t.contract_address,t.value / POWER(10, COALESCE(tok.decimals, 18)) AS amountFROM evms.erc20_transfers tLEFT JOIN tokens.erc20 tokON t.contract_address = tok.contract_addressAND t.blockchain = tok.blockchainWHEREt.evt_block_time > TIMESTAMP '{{since_timestamp}}'AND t."from" IN (0xac4c6e212a361c968f1725b4d055b47e63f80b75,0x35e98c2b3894d71d3d4d7edb8b30e4f36e2f9179,0xd2b37aDE14708bf18904047b1E31F8166d39612b,0xE0a091CEEB255cE3Abc3B18305d48a07521e19e1,0xe89AAb725a2b2C0656248DCCcc894A04661BE55A,0x67ad43499eda05ddd799f4e6c407646c5bf2ed47)AND t."to" = 0xde7259893Af7cdbC9fD806c6ba61D22D581d5667AND t.contract_address != 0x2e1d332893dc16124194e598a29866d2d5e8786b