WITH 
    '2022-05-01'::Date AS start,
    '2023-10-01'::Date AS end,
    (dateDiff('month', start, end) - 1)::UInt8 AS length,
    replaceRegexpOne(ClientRequestURI, '/$', '') AS URI,
    EdgeResponseStatus = 200 AND ClientRequestHost = 'clickhouse.com'
        AND NOT match(ClientRequestURI, '^/(api|cdn-cgi)/|\.(js|css|svg|png|gif|jpe?g|webp|xml|woff2?|ico|txt)') AS filter,
top_urls AS (
    SELECT URI FROM cloudflare_http
    WHERE filter
    GROUP BY ALL ORDER BY uniq(ClientIP) DESC LIMIT 50
),
aggregated AS (
    SELECT URI AS url, toStartOfMonth(Date) AS d, count(), uniqState(ClientIP) AS u FROM cloudflare_http
    WHERE filter AND url IN top_urls
    GROUP BY ALL
)
SELECT url, uniqMerge(u) AS uniqs,
    bar(uniqs, 0, max(uniqs)over(), 50) AS bar,
    sparkbar(length, start, end)(d, finalizeAggregation(u)) AS spark
FROM aggregated
GROUP BY ALL
ORDER BY uniqs DESC