Query editor
-- optimismWITHchains AS (SELECT*FROMquery_3697772)SELECTdate_trunc('day', Packet.block_time) AS day,(SELECTidFROMchainsWHEREchain = bytearray_substring (Packet.data, 31, 2)) AS token,SUM(varbinary_to_uint256 (varbinary_substring (Packet.data, 195, 32)) / 1e18) AS "values"FROMoptimism.logs AS PacketWHEREPacket.block_time > TIMESTAMP '2021-12-31 23:59:59'AND Packet.contract_address = 0x66A71Dcef29A0fFBDBE3c6a460a3B5BC225Cd675AND Packet.topic0 = 0xb8a7262132db1f61626604a31c3de81dc1a5bb0f1511dfa70d626ab1b88b52c2AND bytearray_substring (Packet.data, 31, 2) IN (SELECTchainFROMchains)AND varbinary_to_uint256 (varbinary_substring (Packet.data, 195, 32)) > 0GROUP BY1,2UNION ALLSELECTdate_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)FROMoptimism.logs AS Packet2WHEREPacket2.block_number = Packet.block_numberAND Packet2.tx_index = Packet.tx_indexAND Packet2.contract_address = 0x4D73AdB72bC3DD368966edD0f0b2148401A178E2