tiktok.video_trends

derived · one row = one video posted in the last 7 days

Momentum: views gained in 24 h, views per hour, virality vs the creator’s typical views, viral flag.

Coverage: Tracked creators’ videos. Filter country = ‘US’ for the deepest coverage.
Refresh: Hourly.
Sorted by country, posted_at, video_id. Filters on the leading columns are fastest.

Example

SELECT *
FROM tiktok.video_trends
LIMIT 100

Column	Type	Description
`video_id`	`UInt64`
`creator_id`	`UInt64`
`country`	`LowCardinality(String)`
`posted_at`	`DateTime`
`sound_id`	`UInt64`
`type`	`LowCardinality(String)`
`views`	`UInt64`
`engagement_rate`	`Nullable(Float32)`
`views_gained_24h`	`Nullable(Int64)`	NULL when no read ~24 h ago
`views_per_hour`	`Nullable(Float64)`	between the last two reads, by observed_at
`typical_views`	`Nullable(Float64)`	the creator’s (creator_stats)
`virality`	`Nullable(Float64)`	views / typical_views
`is_viral`	`UInt8`	views >= max(10 x typical, 100k)
`as_of`	`DateTime`