PREVIEW / stock_daily / 2014-11-12

all stock daily files

  file:    by_date/stock_daily/2014/2014-11-12.parquet
  size:    222 KB
  rows:    6,630
  symbols: 3,552

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
2014-11-12	AAPL	Stock	27.345	27.8575	27.3425	27.8125	187769600.0
2014-11-12	MSFT	Stock	48.56	48.92	48.52	48.78	22722100.0
2014-11-12	NVDA	Stock	0.4928	0.494	0.4845	0.4912	204584000.0
2014-11-12	AMZN	Stock	15.5375	15.629	15.4395	15.5755	43660000.0
2014-11-12	GOOGL	Stock	28.0575	28.0625	27.775	27.9125	21882280.0
2014-11-12	META	Stock	74.28	75.14	73.54	74.72	26536600.0
2014-11-12	TSLA	Stock	16.648	16.8227	16.372	16.6067	88062000.0
2014-11-12	TLT	Stock	119.2	119.53	118.445	118.63	4040793.0
2014-11-12	ES	Stock	49.6	50.18	49.2	49.49	2321600.0
2014-11-12	CL	Stock	68.24	68.87	68.13	68.7	2156300.0
2014-11-12	A	Stock	41.3	41.54	41.02	41.45	2504300.0
2014-11-12	AA.B-DELISTED	Stock	51.49	52.45	51.2899	52.36	74075.0
2014-11-12	AABA-DELISTED	Stock	49.33	50.63	49.215	50.59	28697776.0
2014-11-12	AAC-DELISTED	Stock	25.77	25.84	24.85	25.0	178265.0
2014-11-12	AACG	Stock	3.9	3.99	3.89	3.89	6100.0
2014-11-12	AAIC-DELISTED	Stock	27.32	27.435	27.28	27.36	126421.0
2014-11-12	AAL	Stock	43.25	43.63	42.84	43.43	7705300.0
2014-11-12	AAMC-DELISTED	Stock	170.6029	170.6029	150.6471	154.7059	78574.0
2014-11-12	AAME	Stock	3.86	3.89	3.79	3.89	3600.0
2014-11-12	AAMI	Stock	15.5	16.0	15.35	15.68	368900.0
2014-11-12	AAOI	Stock	11.71	12.35	11.7	12.32	997400.0
2014-11-12	AAON	Stock	14.0267	14.34	13.9067	14.3133	190650.0
2014-11-12	AAP	Stock	144.71	146.5	144.71	146.27	579800.0
2014-11-12	AAT	Stock	39.06	39.06	38.62	39.04	185500.0
2014-11-12	AAU-DELISTED	Stock	1.16	1.16	1.1	1.13	82422.0
2014-11-12	AAUAF-DELISTED	Stock	1.13	1.13	1.08	1.13	85587.0
2014-11-12	AAV-DELISTED	Stock	4.6	4.88	4.57	4.75	151407.0
2014-11-12	AAVL-DELISTED	Stock	32.82	34.24	32.7	33.58	21732.0
2014-11-12	AAWW-DELISTED	Stock	41.2	41.988	40.89	41.9	175633.0
2014-11-12	AAXJ	Stock	62.25	62.47	62.19	62.23	313072.0
2014-11-12	AAXN-DELISTED	Stock	19.39	20.03	19.07	19.7401	2622141.0
2014-11-12	AB	Stock	26.15	26.68	26.15	26.6	127900.0
2014-11-12	ABAC-DELISTED	Stock	2.2	2.25	2.1	2.18	30835.0
2014-11-12	ABAX-DELISTED	Stock	53.49	54.24	52.74	54.21	120107.0
2014-11-12	ABB-DELISTED	Stock	22.23	22.32	22.2	22.29	1007143.0
2014-11-12	ABBNY-DELISTED	Stock	22.23	22.32	22.2	22.28	1041931.0
2014-11-12	ABBV	Stock	63.56	64.02	63.56	63.76	5366700.0
2014-11-12	ABC-DELISTED	Stock	87.95	88.78	87.54	88.71	1144871.0
2014-11-12	ABCB	Stock	26.08	26.53	26.07	26.48	169800.0
2014-11-12	ABCD-DELISTED	Stock	1.8	1.94	1.8	1.81	15188.0
2014-11-12	ABCO-DELISTED	Stock	47.09	48.21	47.09	48.11	166146.0
2014-11-12	ABCW-DELISTED	Stock	30.3601	30.74	30.3601	30.74	3500.0
2014-11-12	ABDC-DELISTED	Stock	12.9	13.1999	12.85	13.09	69888.0
2014-11-12	ABE-DELISTED	Stock	13.73	13.83	13.73	13.81	6099.0
2014-11-12	ABEO	Stock	177.5	192.5	168.75	191.25	124.0
2014-11-12	ABEV	Stock	6.3	6.51	6.29	6.43	34182900.0
2014-11-12	ABG	Stock	73.73	76.33	73.73	76.0	347000.0
2014-11-12	ABGB-DELISTED	Stock	18.08	18.38	16.7	16.9	40631.0
2014-11-12	ABM	Stock	27.19	27.56	27.19	27.42	258600.0
2014-11-12	ABMD-DELISTED	Stock	32.98	34.0	32.59	33.61	623420.0

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

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