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.
uw_news70,712 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-28 10:02 | e7a4740bac8bebe72af6cd4fe76ade340002a05a58e9abe21a1cbe574… | US CB Consumer Confidence July 2026 Report | Tradex | true | neutral | ["CB"] | [] | {"CB":{"curr":{"c":"363.985","v":170066,"mt":"regular","date":"2026-07-28"},"prev":{"c":"358.91","v":1358294,"mt":"regular","date":"2026-07-27"}}} | uw_news | /api/news/headlines | {"limit":99} | 2026-09-14 | 2026-09-14 13:15 | 2026-09-14 13:15 |