Dataset Name: moodys_news_by_service_name_lookback
Group: news
Vendor: Moody's Analytics
Data Starts at: 2014-01-01 00:00:00
Data Currently Ends at: ongoing, contact sales for full data set.
Symbol Set: service_name
Asset Class: Equity,Fixed Income,Options,FX,Futures
Data Update Frequency: intraday
Data Contained in this Dataset
| Column | Type | Description |
|---|---|---|
| _seq | uint | Internal sequence number used to keep data rows in order |
| timestamp | string | Timestamp of the Data - America/New York Time. |
| muts | uint64 | Microseconds Unix Timestamp. An integer representation of a timestamp with microsecond precision that can be compared directly to other timestamps. |
| symbol | string | for each Moodys dataset this will be the by… so for by symbol it will be a symbol, for by CUSIP it will be a CUSIP and so on |
| company_name | string | Company Name |
| exchange | string | Exchange. Ie Null, NYSE, OTC-PINK, NASDAQ-NMS, LSE, Bombay, NEO, Frankfurt, EuronextParis, Tokyo, SaoPaulo, TorontoVE, Toronto, Korea, Malaysia, Australia, MoscowInterbank, CNSX, Johannesburg, Milan. |
| micexchangecode | string | ISO Market Identifier Code for the Exchange. ISO 10383, ISO 20022. ie XXXX, XNYS, PINX, XNAS, Null, XLON, XBOM, NEOE, XFRA, XPAR, XTKS, BVMF, XTSX, XTSE, XKRX, XKLS, XASX, XMIC, XCNQ, XJSE, |
| necoid | string | NECOID |
| isin | string | ISIN |
| cusip | string | CUSIP (Committee on Uniform Security Identification Procedures) identifier |
| company_symbol | string | Company Trading Symbol |
| acorn | string | ACORN Acquire Media Organizational Number - All companies are given an Acquire Media specific identifier |
| tickerhierarchy | string | Related to company mentioned in stories. Where REFERENCE=Primary Ticker and SYNONYM=Secondary Ticker |
| title | string | Display News Headline Title - suitable for title bar of a browser window / list of news stories - may be shorter than the full headline (data 'hedline') |
| distributor | string | The required distributor element contains a printable name of the story's upstream provider (the one who sent the story to Acquire Media) ie ie ContentEngine, SyndiGate Media Inc., Information Solutions, Pedia Content Solutions, HT Media, NewsBank, ACI Information Group, ProQuest Information & Learning, Targeted News Service, Public Technologies. |
| received_date | string | Date and Time Received by Moodys |
| publish_date | string | Date and Time Published by Moodys |
| provider_name | string | A string identifying the provider, typically the news story publisher, or perhaps a news aggregator upstream from Acquire Media. ie ContentEngine, SyndiGate Media Inc., Information Solutions, Pedia Content Solutions, HT Media, NewsBank, ACI Information Group, ProQuest Information & Learning, Targeted News Service, Public Technologies, Tribune Content Agency, Zack Investment Research, Business Monitor International, M2 Communications, PR Newswire, Multimedia Investments Ltd, Thai News Service, Gale Group, Canjex Publishing Ltd, Business Wire, |
| amx_company_record | string | AMX - Acquire Media XML - Company Record Data - A tag comprising of everything related to a company, mentioned in news story |
| data | string | Full body of the news article, contains all the data in JSONB |