core.news_headlines
UW's headline feed, paged back to the last run. Keyed on time plus a hash of source and headline, because the vendor sends no id.
Simplify Analyticsuw_news64,627 rowsexportable| created_at ↑timestamp with time zone | headline_shatext | headlinetext | news_sourcetext | is_majorboolean | sentimenttext | tickersjsonb | tagsjsonb | meta |
|---|
| sourcetext |
|---|
| endpointtext |
|---|
| request_paramsjsonb |
|---|
| as_ofdate |
|---|
| vintage_tstimestamp with time zone |
|---|
| retrieved_attimestamp with time zone |
|---|
| 2026-07-27 02:02 | b10220cda687f1676cc918ee31f392de8d9a9d083925630221d787690… | ASTRAZENECA 2Q CORE EPS $2.63, EST. $2.48 | Tradex | true | neutral | ["AZN"] | [] | {"AZN":{"curr":{"c":"168.0101","v":2009804,"mt":"postmarket","date":"2026-07-24"},"prev":{"c":"169.26","v":1879273,"mt":"regular","date":"2026-07-24"}}} | uw_news | /api/news/headlines | {"limit":99} | 2026-09-14 | 2026-09-14 13:15 | 2026-09-14 13:15 |