tiktok.video_snapshots

history · one row = one tracked video per read hour

Views, likes, comments, shares, saves over a video’s first 90 days.

• Coverage: Videos of priority-1 creators: hourly for 72 h, daily to 30 d, weekly to 90 d. Priority-2: days 1, 2, 3, 7, 14.
• Refresh: Each hour appended once, ~2-3 h after it ends.
• Sorted by video_id, slot. Filters on the leading columns are fastest.

Example

SELECT *
FROM tiktok.video_snapshots
LIMIT 100

Columns

Column	Type	Description
video_id	UInt64
slot	DateTime	the hour the read belongs to
views	UInt64
likes	UInt64
comments	UInt64
shares	UInt64
saves	UInt64
observed_at	DateTime	use this for “views per hour”