tiktok.creator_daily
history · one row = one priority-1 creator per day
Daily followers, following, videos and likes.
- Coverage: Priority-1 creators only (~3M, US, >= 10k followers). Starts the day tracking starts; no backfill exists.
- Refresh: Each day appended once at D+1 02:00 UTC.
- Sorted by
creator_id, date. Filters on the leading columns are fastest.
Example
Section titled “Example”SELECT *FROM tiktok.creator_dailyLIMIT 100Columns
Section titled “Columns”| Column | Type | Description |
|---|---|---|
creator_id |
UInt64 |
|
date |
Date |
|
followers |
UInt32 |
|
following |
UInt32 |
|
videos |
UInt32 |
|
likes |
UInt64 |
|
observed_at |
DateTime |
When the numbers were read. Growth per day = change / (observed_at gap), not change / 1 — reads within a “day” can be many hours apart. |