Announce something here

90west_panel_b

90west_panel_b by 90 West Data

Dataset Name: 90west_panel_b


Group: altdata
Vendor: 90 West Data
Data Starts at: 43466
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.


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.