references/example-sessions.md
Sessions (listing sessions with duration, pageviews, and bounce rate)
SELECT
session_id,
$start_timestamp,
$end_timestamp,
$session_duration,
$pageview_count,
$is_bounce,
$entry_current_url,
$end_current_url
FROM
sessions
WHERE
and(less($start_timestamp, toDateTime('2026-10-30 12:03:00.003840')), greater($start_timestamp, toDateTime('2026-10-29 12:02:55.004353')))
ORDER BY
$start_timestamp DESC
LIMIT 50000