Announce something here

90west_panel_b_demo

90west_panel_b_demo by 90 West Data

Regular price
$0.00 USD
Sale price
$0.00 USD
Regular price
Sold out
Unit price
per 






Dataset Name: 90west_panel_b_demo


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

Demo data for 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
panel_date string The year, month and last day of the month that the panel is generated for.
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)
age_group string Age group of people transacting at the merchant. (0-20, 21-30, 31-40, 41-50, 51-60, 61-70, 71-80, 81+, UNK)
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.