Query editor
WITHarbitrum_wallets AS (SELECTbytearray_substring (topic2, 13, 20) AS wallet,COUNT(topic3) AS tokens_mintedFROMarbitrum.logsWHEREcontract_address = 0xd4Feff615c0E90f06340Be95d30e1f397779A184AND block_time >= TIMESTAMP '2023-08-02 16:00:00'AND block_time < TIMESTAMP '2023-08-05 15:00:00'AND topic0 = 0xddf252ad1be2c89b69c2b068fc378daa952ba7f163c4a11628f55a4df523b3efAND topic1 = 0x0000000000000000000000000000000000000000000000000000000000000000AND (SELECTsubstr(data, 1, 4)FROMarbitrum.transactionsWHEREhash = tx_hash) = 0xefef39a1GROUP BYtopic2),avalanche_wallets AS (SELECTbytearray_substring (topic2, 13, 20) AS wallet,COUNT(topic3) AS tokens_mintedFROMavalanche_c.logsWHEREcontract_address = 0xd4Feff615c0E90f06340Be95d30e1f397779A184AND block_time >= TIMESTAMP '2023-08-02 16:00:00'AND block_time < TIMESTAMP '2023-08-05 16:00:00'AND topic0 = 0xddf252ad1be2c89b69c2b068fc378daa952ba7f163c4a11628f55a4df523b3efAND topic1 = 0x0000000000000000000000000000000000000000000000000000000000000000AND (SELECTsubstr(data, 1, 4)FROMavalanche_c.transactionsWHEREhash = tx_hash) = 0xefef39a1GROUP BYtopic2),bnb_wallets AS (SELECTbytearray_substring (topic2, 13, 20) AS wallet,COUNT(topic3) AS tokens_mintedFROMbnb.logsWHEREcontract_address = 0xd4Feff615c0E90f06340Be95d30e1f397779A184AND block_time >= TIMESTAMP '2023-08-02 16:00:00'AND block_time < TIMESTAMP '2023-08-05 16:00:00'AND topic0 = 0xddf252ad1be2c89b69c2b068fc378daa952ba7f163c4a11628f55a4df523b3efAND topic1 = 0x0000000000000000000000000000000000000000000000000000000000000000AND (