Query editor
WITH token_flow as (SELECTblock_time,bytearray_substring(topic2, 1 + 12, 20) as address, -- TObytearray_to_int256(bytearray_substring(data, 1 + 12, 32))/1e18 as amountFROM arbitrum.logsWHEREtopic0 = 0xddf252ad1be2c89b69c2b068fc378daa952ba7f163c4a11628f55a4df523b3ef ANDcontract_address = 0xfc5a1a6eb076a2c7ad06ed22c90d7e710e35ad0a ANDbytearray_substring(topic2, 1 + 12, 20) = 0x534a0076fb7c2b1f83fa21497429ad7ad3bd7587UNION ALLSELECTblock_time,bytearray_substring(topic1, 1 + 12, 20) as address, -- FROM-bytearray_to_int256(bytearray_substring(data, 1 + 12, 32))/1e18 as amountFROM arbitrum.logsWHEREtopic0 = 0xddf252ad1be2c89b69c2b068fc378daa952ba7f163c4a11628f55a4df523b3ef ANDcontract_address = 0xfc5a1a6eb076a2c7ad06ed22c90d7e710e35ad0a ANDbytearray_substring(topic1, 1 + 12, 20) = 0x534a0076fb7c2b1f83fa21497429ad7ad3bd7587),staking_flow as (-- think of the staking contract as a box, that you take and place items in.SELECTblock_time,bytearray_substring(topic2, 1 + 12, 20) as address, -- TO-bytearray_to_int256(bytearray_substring(data, 1 + 12, 32))/1e18 as amountFROM arbitrum.logsWHEREtopic0 = 0xddf252ad1be2c89b69c2b068fc378daa952ba7f163c4a11628f55a4df523b3ef ANDcontract_address = 0xfc5a1a6eb076a2c7ad06ed22c90d7e710e35ad0a ANDbytearray_substring(topic1, 1 + 12, 20) = 0x908c4d94d34924765f1edc22a1dd098397c59dd4 ANDbytearray_substring(topic2, 1 + 12, 20) = 0x534a0076fb7c2b1f83fa21497429ad7ad3bd7587UNION ALLSELECTblock_time,bytearray_substring(topic1, 1 + 12, 20) as address, -- FROMbytearray_to_int256(bytearray_substring(data, 1 + 12, 32))/1e18 as amountFROM arbitrum.logsWHEREtopic0 = 0xddf252ad1be2c89b69c2b068fc378daa952ba7f163c4a11628f55a4df523b3ef ANDcontract_address = 0xfc5a1a6eb076a2c7ad06ed22c90d7e710e35ad0a ANDbytearray_substring(topic2, 1 + 12, 20) = 0x908c4d94d34924765f1edc22a1dd098397c59dd4 ANDbytearray_substring(topic1, 1 + 12, 20) = 0x534a0076fb7c2b1f83fa21497429ad7ad3bd7587UNION ALL-- Transfer Accounts CaseSELECTblock_time,bytearray_substring(topic1, 1 + 12, 20) as address, -- TO-bytearray_to_int256(bytearray_substring(data, 1 + 12, 32))/1e18 as amountFROM arbitrum.logs as a_l JOIN (SELECT bytearray_substring(data, 1 + 12 + 4, 20) as address, hashFROM arbitrum.transactionsWHERE success and bytearray_substring(data, 1, 4) = 0x655603a4) as a_l_2 ona_l.tx_hash = a_l_2.hash andbytearray_substring(a_l.topic1, 1 + 12, 20) = a_l_2.address