Dataset Name: 90west_panel_a
Group: altdata
Vendor: 90 West Data
Data Starts at: 2018-04-01 00:00:00
Symbol Set: US Equities
Asset Class: Equity
Data Update Time(s): 12:05 AM EST
Data Update Frequency: day
US consumer and transaction data delivered daily. This data is aggregated at the merchant level and mapped to 3,000 merchants, including 300 US stock tickers. Data provides insights into company specific trends as well as industry level or macro level insights. Panel A - PA, OH, CT, Mid-Atl - data from April 2018
Data Contained in this Dataset
| Column | Type | Description |
|---|---|---|
| _seq | uint | Internal sequence number used to keep data rows in order |
| merch_industry | string | Merchant Industry (eg CONSUMER SERVICES, RETAIL, CONSUMER FINANCE, RESTAURANT, GROCER, |
| merch_parent | string | The parent or holding company of the merchant in the trans_merch column.(Uppercase, 300 business names) |
| muts | uint64 | Microseconds Unix Timestamp. An integer representation of a timestamp with microsecond precision that can be compared directly to other timestamps. |
| bank_id | uint | A simple identifier of the bank where the transactions took place. (10500, 10501, 10509, 10510, 10511, 10512, 10516, 10517, 10519, 10647, 10648) |
| merch_sector | string | Merchant Sector (Over 200 sectors - eg SOFTWARE, HOME IMPROVEMENT, PRISON SERVICES, CASUAL DINING, APPAREL, CONVENIENCE, VIDEO CONFERENCING, ELECTRONIC PAYMENTS, VIDEO STREAMING, FITNESS CLUB, VIDEO GAMES) |
| num_customers | uint | Number of unique customers that transacted at the merchant in trans_merch column on the date in trans_date . Range 1, inf |
| num_transactions | uint | Number of unique transactions that the customers in the num_customers column transacted at the merchant in the trans_merch column on the date in the trans_date column. Range 1, inf |
| num_unq_payees | uint | The count of unique payee strings that were identified to be the merchant in the trans_merch column. |
| symbol | string | Trading Symbol or Ticker |
| timestamp | string | Timestamp of the Data - America/New York Time. |
| trans_date | string | Transaction Date (every day of the week) |
| trans_total_value | double | Total dollar value of all transactions at the merchant in the trans_merch column on the date in the trans_date column. Range 1, inf |
| trans_avg_spend | double | Average dollar value of all transactions at the merchant in the trans_merch column on the date in the trans_date column. Range 1, inf |
| trans_merch | string | The name of the merchant where the transactions took place. (uppercase, over 2000 business names) |
Important Dataset Notes
This dataset is not available for direct online purchase. Please contact sales directly at sales@CloudQuant.com. The data is available through our normal sales department who can provide you with current pricing and a quote for accessing this valuable dataset. This may be due to a number of reasons such as dataset intended use, size of the company (or investment fund) using the dataset, or for simple legal requirements that CloudQuant needs to ensure are in place prior to licensing the dataset to you.