Dataset Name: 90west_gift_cards_panela
Group: altdata
Vendor: 90 West Data
Data Starts at: 2016-01-01 00:00:00
Symbol Set: US Equities
Asset Class: Equity
Data Update Time(s): 12:05 AM EST
Data Update Frequency: day
90 West offers US Gift Card data
This data is unique to 90 West and not available through any other data vendor. Daily historical data from January 1, 2016 through present. We track 300m+ gift card transactions annually totaling $15-20B in annual US consumer spend.
Open loop gift card data is pre-paid gift cards (spend anywhere). We track date, time, location, and amount of sale (gift card funding) and subsequent date, time, location, and amount of gift card spend.
Closed loop is single merchant branded gift cards (Merchant/Product based). We track the date, time, location, and amount of gift card funding. Please see attached marketing deck for list of specific merchant tracked.
This data provides a unique view into consumer & merchant trends.
Investible Universe
We have closed loop data on approximately 75 merchants. The open loop data is similar to transaction card data (insight to hundreds of merchants), but represents the spending of a unique cohort of US consumers.
Panel A States
AA, AE, AK, AL, AP, AR, AZ, CA, CO, CT, DC, DE, FL, GA, GU, HI, IA, ID, IL, IN, KS, KY, LA, MA, MD, ME, MH, MI, MN, MO, MS, MT, NC, ND, NE, NH, NJ, NM, NV, NY, OH, OK, OR, PA, PR, RI, SC, SD, TN, TX, U, UNK, UT, VA, VI, VT, WA, WI, WV, WY.
Panel B States
AK, AL, AP, AR, AZ, CA, CO, CT, DC, DE, FL, FM, GA, HI, IA, ID, IL, IN, KS, KY, LA, MA, MD, ME, MH, MI, MN, MO, MS, MT, NC, ND, NE, NH, NJ, NM, NV, NY, OH, OK, OR, PA, PR, RI, SC, SD, TN, TX, UNK, UT, VA, VI, VT, WA, WI, WV, WY.
Panel C States
AK, AL, AR, AZ, CA, CO, CT, DC, DE, FL, GA, HI, IA, ID, IL, IN, KS, KY, LA, MA, MD, ME, MI, MN, MO, MS, MT, NC, ND, NE, NH, NJ, NM, NV, NY, OH, OK, OR, PA, RI, SC, SD, TN, TX, UNK, UT, VA, VT, WA, WI, WV, WY.
Data Contained in this Dataset
| Column | Type | Description |
|---|---|---|
| num_customers | int64 | |
| num_transactions | int64 | |
| num_unq_payees | int64 | |
| symbol | string | Trading Symbol or Ticker |
| timestamp | string | Timestamp of the Data - America/New York Time. |
| trans_avg_spend | double | |
| trans_date | string | |
| trans_merch | string | |
| trans_total_value | double | |
| _seq | uint | Internal sequence number used to keep data rows in order |
| bank_id | int64 | A simple identifier of the bank where the transactions took place. (10500, 10501, 10509, 10510, 10511, 10512, 10516, 10517, 10519, 10647, 10648) |
| merch_industry | string | |
| merch_parent | string | |
| muts | uint64 | Microseconds Unix Timestamp. An integer representation of a timestamp with microsecond precision that can be compared directly to other timestamps. |
| merch_sector | string |
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.