PREVIEW / stock_daily / 2016-02-22

all stock daily files

  file:    by_date/stock_daily/2016/2016-02-22.parquet
  size:    219 KB
  rows:    6,596
  symbols: 3,353

schema

  date         DATE
  symbol       VARCHAR
  asset_type   VARCHAR
  open         DOUBLE
  high         DOUBLE
  low          DOUBLE
  close        DOUBLE
  volume       DOUBLE

sample rows

date	symbol	asset_type	open	high	low	close	volume
2016-02-22	AAPL	Stock	24.0775	24.225	23.98	24.22	137123200.0
2016-02-22	MSFT	Stock	52.28	53.0	52.28	52.65	25008300.0
2016-02-22	NVDA	Stock	0.772	0.7968	0.7705	0.788	449668000.0
2016-02-22	AMZN	Stock	27.11	28.0325	27.054	27.975	111332000.0
2016-02-22	GOOGL	Stock	36.4755	36.7423	36.1725	36.4525	37516480.0
2016-02-22	META	Stock	105.49	108.25	105.34	107.16	35709700.0
2016-02-22	TSLA	Stock	11.3413	11.9273	11.3233	11.8493	75901500.0
2016-02-22	TLT	Stock	131.1	131.11	130.7	130.94	5054326.0
2016-02-22	ES	Stock	54.83	55.51	54.66	55.34	1283500.0
2016-02-22	CL	Stock	67.46	68.39	67.39	67.61	2900800.0
2016-02-22	A	Stock	37.88	38.19	37.78	38.03	1792500.0
2016-02-22	AA.B-DELISTED	Stock	28.55	30.73	28.55	30.66	54636.0
2016-02-22	AAAP-DELISTED	Stock	31.21	32.5	29.735	31.8	83644.0
2016-02-22	AABA-DELISTED	Stock	30.68	31.21	30.39	31.17	20496851.0
2016-02-22	AAC-DELISTED	Stock	21.86	23.13	21.46	22.68	348405.0
2016-02-22	AACG	Stock	4.89	4.89	4.59	4.61	14500.0
2016-02-22	AAIC-DELISTED	Stock	11.8	11.928	11.71	11.87	193314.0
2016-02-22	AAL	Stock	40.14	40.93	40.07	40.84	9997300.0
2016-02-22	AAMC-DELISTED	Stock	5.5029	5.8353	5.5029	5.6765	37369.0
2016-02-22	AAME	Stock	4.2	4.2	4.07	4.07	1300.0
2016-02-22	AAMI	Stock	11.48	11.72	11.48	11.56	180100.0
2016-02-22	AAOI	Stock	16.24	16.57	16.01	16.32	140400.0
2016-02-22	AAON	Stock	14.0933	14.3267	13.9733	14.26	181800.0
2016-02-22	AAP	Stock	145.25	148.47	145.03	147.87	904000.0
2016-02-22	AAT	Stock	36.27	36.69	36.05	36.41	144900.0
2016-02-22	AAU-DELISTED	Stock	0.79	0.82	0.7601	0.7714	170841.0
2016-02-22	AAUAF-DELISTED	Stock	0.79	0.82	0.7601	0.7714	171706.0
2016-02-22	AAV-DELISTED	Stock	5.32	5.41	5.29	5.31	83669.0
2016-02-22	AAVL-DELISTED	Stock	5.56	5.69	5.26	5.51	480421.0
2016-02-22	AAWW-DELISTED	Stock	35.54	37.05	35.16	36.86	273576.0
2016-02-22	AAXJ	Stock	49.86	50.23	49.74	50.21	890760.0
2016-02-22	AAXN-DELISTED	Stock	17.24	17.32	17.05	17.27	1068424.0
2016-02-22	AB	Stock	18.97	18.97	18.61	18.85	147700.0
2016-02-22	ABAC-DELISTED	Stock	0.6462	0.651	0.6462	0.651	500.0
2016-02-22	ABAX-DELISTED	Stock	39.7	39.7799	39.27	39.3925	214642.0
2016-02-22	ABB-DELISTED	Stock	17.81	17.93	17.8	17.89	1632793.0
2016-02-22	ABBNY-DELISTED	Stock	17.81	17.93	17.8	17.89	1664488.0
2016-02-22	ABBV	Stock	54.29	55.32	53.74	55.28	9381800.0
2016-02-22	ABC-DELISTED	Stock	86.86	87.89	86.83	87.7	1812961.0
2016-02-22	ABCB	Stock	26.45	26.66	25.95	26.5	225400.0
2016-02-22	ABCD-DELISTED	Stock	3.98	4.27	3.98	4.23	85187.0
2016-02-22	ABCO-DELISTED	Stock	38.02	38.66	36.69	36.78	421097.0
2016-02-22	ABCW-DELISTED	Stock	42.0	42.2	41.78	41.85	194591.0
2016-02-22	ABDC-DELISTED	Stock	9.18	9.6	9.18	9.24	30045.0
2016-02-22	ABE-DELISTED	Stock	10.632	10.632	10.57	10.575	1541.0
2016-02-22	ABEO	Stock	67.25	67.25	57.25	62.0	10672.0
2016-02-22	ABEOW-DELISTED	Stock	0.53	0.5301	0.5	0.5019	1984.0
2016-02-22	ABEV	Stock	4.66	4.75	4.63	4.7	13643500.0
2016-02-22	ABG	Stock	52.38	55.06	52.17	54.49	570100.0
2016-02-22	ABGB-DELISTED	Stock	0.802	0.845	0.761	0.82	16787.0

> showing 50 of 6,596 rows — these rows as CSV

> unlock the full archive -- $79 one-time