Query editor
WITH deposits AS (SELECThash, varbinary_substring(data, 1, 4) IN (0x6878bad9, 0x268a6de5) AS is_ethFROM ethereum.transactionsWHERE varbinary_substring(data, 1, 4) IN (0x6878bad9, 0x268a6de5, 0xba35d0b5, 0xc0a797d8)AND block_time > date '2022-02-01'), eth_depo_address AS (SELECT"from" AS deposit_address, "to" AS hot_address, date_trunc('day', block_time) AS ds, tx_hash, NULL AS token_addressFROM ethereum.tracesWHERE tx_hash IN (SELECT hash FROM deposits WHERE is_eth)AND value > 0AND block_time > date '2022-02-01'), erc_depo_address AS (SELECTvarbinary_substring(topic1, varbinary_length(topic1) - 19, 20) AS deposit_address, varbinary_substring(topic2, varbinary_length(topic2) - 19, 20) AS hot_address, date_trunc('day', block_time) AS ds, tx_hash, contract_address AS token_addressFROM ethereum.logsWHERE topic0 = 0xddf252ad1be2c89b69c2b068fc378daa952ba7f163c4a11628f55a4df523b3efAND data != 0x00AND tx_hash IN (SELECT hash FROM deposits WHERE NOT is_eth)AND block_time > date '2022-02-01')SELECTdeposit_address, hot_address, ds, tx_hash, token_addressFROM eth_depo_addressUNIONSELECTdeposit_address, hot_address, ds, tx_hash, token_addressFROM erc_depo_address