Query editor
-- lineaWITHchains AS (SELECT*FROMquery_3697772)SELECTdate_trunc('day', Packet.block_time) AS day,(SELECTidFROMchainsWHEREchain = bytearray_substring (Packet.data, 95, 2)) AS token,SUM((SELECTSUM(varbinary_to_uint256 (varbinary_substring (Packet2.data, 131, 32)) / 1e18)FROMlinea.logs AS Packet2WHEREPacket2.block_number = Packet.block_numberAND Packet2.tx_index = Packet.tx_indexAND Packet2.contract_address = 0x38dE71124f7a447a01D67945a51eDcE9FF491251AND Packet2.topic0 = 0xb0c632f55f1e1b3b2c3d82f41ee4716bb4c00f0f5d84cdafc141581bb8757a4fAND bytearray_substring (Packet2.data, 97, 2) = 0x0002AND varbinary_to_uint256 (bytearray_substring (Packet2.data, 131, 32)) > 0AND Packet2.index < Packet.indexAND Packet2.index > (Packet.index - 3))) AS "values"FROMlinea.logs AS PacketWHEREPacket.block_time > TIMESTAMP '2021-12-31 23:59:59'AND Packet.contract_address = 0x38dE71124f7a447a01D67945a51eDcE9FF491251AND Packet.topic0 = 0xe9bded5f24a4168e4f3bf44e00298c993b22376aad8c58c7dda9718a54cbea82AND bytearray_substring (Packet.data, 95, 2) IN (SELECTchainFROMchains)AND (SELECTcount()FROMlinea.logs AS Packet2WHEREPacket2.block_number = Packet.block_numberAND Packet2.tx_index = Packet.tx_indexAND Packet2.contract_address = 0x38dE71124f7a447a01D67945a51eDcE9FF491251AND Packet2.topic0 = 0xb0c632f55f1e1b3b2c3d82f41ee4716bb4c00f0f5d84cdafc141581bb8757a4fAND bytearray_substring (Packet2.data, 97, 2) = 0x0002