Query editor
SELECTcount(*) AS n,sum(CASE WHEN topic2 = 0x000000000000000000000000e8c20fd0542de42dd53682c2d3bb58717b093048 THEN CAST(bytearray_to_uint256(data) AS double) ELSE 0 END) AS inflow_raw,sum(CASE WHEN topic1 = 0x000000000000000000000000e8c20fd0542de42dd53682c2d3bb58717b093048 THEN CAST(bytearray_to_uint256(data) AS double) ELSE 0 END) AS outflow_raw,max(block_number) AS last_blockFROM polygon.logsWHERE contract_address = 0xc011a7e12a19f7b1f670d46f03b03f3342e82dfbAND topic0 = 0xddf252ad1be2c89b69c2b068fc378daa952ba7f163c4a11628f55a4df523b3efAND (topic1 = 0x000000000000000000000000e8c20fd0542de42dd53682c2d3bb58717b093048 OR topic2 = 0x000000000000000000000000e8c20fd0542de42dd53682c2d3bb58717b093048)