At first, I was looking to count number of request per endpoint per IP address, but seems impossible

but seems impossible

impossible in what sense? do you have IP address as part of telemetry data? If yes, I can help in writing clickhouse query to count requests grouping by ip_address