Dataset Name: 90west_panel_b
Group: altdata
Vendor: 90 West Data
Data Starts at: 2019-01-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 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 B - TX, MN, WI, IL - data from January 2019
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 | Trading Symbol or Ticker |
| 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) |
| trans_date | string | Transaction Date (every day of the week) |
| trans_merch | string | The name of the merchant where the transactions took place. (uppercase, over 2000 business names) |
| merch_parent | string | The parent or holding company of the merchant in the trans_merch column.(Uppercase, 300 business names) |
| merch_industry | string | Merchant Industry (eg CONSUMER SERVICES, RETAIL, CONSUMER FINANCE, RESTAURANT, GROCER, |
| 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 |
| 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 |
| num_unq_payees | uint | The count of unique payee strings that were identified to be the merchant in the trans_merch column. |