PREVIEW / stock_daily / 2014-12-11

all stock daily files

  file:    by_date/stock_daily/2014/2014-12-11.parquet
  size:    223 KB
  rows:    6,668
  symbols: 3,573

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-12-11	AAPL	Stock	28.065	28.45	27.835	27.905	165606800.0
2014-12-11	MSFT	Stock	47.08	47.74	46.68	47.17	29060400.0
2014-12-11	NVDA	Stock	0.5098	0.5133	0.5055	0.5065	135652000.0
2014-12-11	AMZN	Stock	15.3945	15.632	15.3005	15.368	65258000.0
2014-12-11	GOOGL	Stock	26.5005	26.852	26.458	26.6055	41465800.0
2014-12-11	META	Stock	76.52	78.52	76.48	77.73	33462100.0
2014-12-11	TSLA	Stock	14.0353	14.362	13.882	13.9253	100416000.0
2014-12-11	TLT	Stock	123.74	124.61	123.29	124.61	7863455.0
2014-12-11	ES	Stock	51.33	52.02	51.28	51.68	1443000.0
2014-12-11	CL	Stock	68.96	69.98	68.96	69.28	2607000.0
2014-12-11	A	Stock	40.5	41.18	40.49	40.62	1640900.0
2014-12-11	AA.B-DELISTED	Stock	48.81	49.3	47.94	47.94	296812.0
2014-12-11	AABA-DELISTED	Stock	49.54	50.58	49.43	49.94	18697717.0
2014-12-11	AAC-DELISTED	Stock	29.8	31.5	29.59	29.79	54094.0
2014-12-11	AACG	Stock	3.47	3.47	3.42	3.42	12500.0
2014-12-11	AAIC-DELISTED	Stock	27.58	27.7	27.45	27.5	234880.0
2014-12-11	AAL	Stock	49.8	51.5	49.65	50.53	15054200.0
2014-12-11	AAMC-DELISTED	Stock	133.0	135.2941	128.5382	131.7971	66212.0
2014-12-11	AAME	Stock	3.83	3.88	3.66	3.88	8100.0
2014-12-11	AAMI	Stock	15.92	16.47	15.76	16.02	242700.0
2014-12-11	AAOI	Stock	9.85	10.177	9.65	9.94	306400.0
2014-12-11	AAON	Stock	14.18	14.64	14.1733	14.1867	191400.0
2014-12-11	AAP	Stock	157.34	161.27	157.34	159.16	807400.0
2014-12-11	AAT	Stock	39.57	39.84	39.46	39.52	96400.0
2014-12-11	AAU-DELISTED	Stock	1.02	1.07	0.9967	1.0	162649.0
2014-12-11	AAUAF-DELISTED	Stock	1.0	1.05	0.98	1.0	167140.0
2014-12-11	AAV-DELISTED	Stock	4.43	4.72	4.4	4.46	243431.0
2014-12-11	AAVL-DELISTED	Stock	46.76	54.17	46.68	49.88	525794.0
2014-12-11	AAWW-DELISTED	Stock	47.0	48.23	46.84	47.59	183390.0
2014-12-11	AAXJ	Stock	60.73	61.13	60.61	60.84	1333646.0
2014-12-11	AAXN-DELISTED	Stock	23.5	23.73	22.86	23.185	3333680.0
2014-12-11	AB	Stock	24.89	25.38	24.76	25.22	758100.0
2014-12-11	ABAC-DELISTED	Stock	1.961	2.0	1.95	1.9999	13900.0
2014-12-11	ABAX-DELISTED	Stock	55.78	56.8	55.28	56.59	135975.0
2014-12-11	ABB-DELISTED	Stock	21.19	21.3068	21.053	21.08	1586317.0
2014-12-11	ABBNY-DELISTED	Stock	21.19	21.3068	21.053	21.08	1682366.0
2014-12-11	ABBV	Stock	66.48	67.96	66.24	67.03	9518000.0
2014-12-11	ABC-DELISTED	Stock	91.93	92.84	91.52	92.52	1604343.0
2014-12-11	ABCB	Stock	25.43	25.83	25.17	25.49	79400.0
2014-12-11	ABCD-DELISTED	Stock	1.61	1.62	1.61	1.62	5468.0
2014-12-11	ABCO-DELISTED	Stock	42.57	44.94	41.02	44.6	2100574.0
2014-12-11	ABCW-DELISTED	Stock	30.29	30.3	30.29	30.3	300.0
2014-12-11	ABDC-DELISTED	Stock	12.05	12.2	11.86	11.96	51182.0
2014-12-11	ABE-DELISTED	Stock	13.71	13.91	13.64	13.7	8369.0
2014-12-11	ABEO	Stock	162.5	165.0	126.25	150.0	148.0
2014-12-11	ABEV	Stock	5.95	6.05	5.91	5.98	12772500.0
2014-12-11	ABG	Stock	75.98	77.65	75.06	75.36	391200.0
2014-12-11	ABGB-DELISTED	Stock	12.77	12.84	12.51	12.64	51625.0
2014-12-11	ABIL-DELISTED	Stock	9.87	9.93	9.86	9.88	600.0
2014-12-11	ABM	Stock	27.42	27.77	27.3	27.47	213100.0

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

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