PREVIEW / stock_daily / 2015-09-11

all stock daily files

  file:    by_date/stock_daily/2015/2015-09-11.parquet
  size:    220 KB
  rows:    6,640
  symbols: 3,440

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
2015-09-11	AAPL	Stock	27.9475	28.5525	27.94	28.5525	199662000.0
2015-09-11	MSFT	Stock	43.14	43.59	42.94	43.48	27132500.0
2015-09-11	NVDA	Stock	0.5582	0.57	0.556	0.5662	301584000.0
2015-09-11	AMZN	Stock	26.0535	26.472	26.0305	26.472	64558000.0
2015-09-11	GOOGL	Stock	32.5105	32.7655	32.3705	32.765	34892300.0
2015-09-11	META	Stock	91.68	92.08	91.13	92.05	21185000.0
2015-09-11	TSLA	Stock	16.5093	16.6827	16.3153	16.6827	35262000.0
2015-09-11	TLT	Stock	121.47	122.08	121.33	121.39	5890921.0
2015-09-11	ES	Stock	45.35	46.09	45.14	46.09	2064000.0
2015-09-11	CL	Stock	61.38	62.11	61.38	61.92	3463100.0
2015-09-11	A	Stock	35.66	35.96	35.44	35.96	1443300.0
2015-09-11	AA.B-DELISTED	Stock	35.18	35.18	34.59	34.8	25088.0
2015-09-11	AABA-DELISTED	Stock	31.09	31.43	30.63	31.43	13092143.0
2015-09-11	AAC-DELISTED	Stock	22.94	22.97	22.2	22.48	375218.0
2015-09-11	AACG	Stock	2.37	2.46	2.36	2.36	6400.0
2015-09-11	AAIC-DELISTED	Stock	15.81	16.0	15.81	15.95	224484.0
2015-09-11	AAL	Stock	41.22	42.15	41.05	42.15	8635200.0
2015-09-11	AAMC-DELISTED	Stock	7.2088	8.9706	7.1529	8.4706	79778.0
2015-09-11	AAME	Stock	3.55	3.59	3.5	3.59	6000.0
2015-09-11	AAMI	Stock	16.18	16.32	15.98	16.31	79400.0
2015-09-11	AAOI	Stock	21.0	21.16	19.773	20.32	354400.0
2015-09-11	AAON	Stock	13.18	13.4467	13.06	13.4267	200550.0
2015-09-11	AAP	Stock	173.71	175.45	172.8	174.84	1123600.0
2015-09-11	AAT	Stock	37.88	38.68	37.88	38.56	71700.0
2015-09-11	AAU-DELISTED	Stock	0.549	0.549	0.53	0.53	41073.0
2015-09-11	AAUAF-DELISTED	Stock	0.549	0.549	0.53	0.53	41279.0
2015-09-11	AAV-DELISTED	Stock	5.44	5.49	5.12	5.2	212054.0
2015-09-11	AAVL-DELISTED	Stock	10.97	10.97	10.5545	10.63	178476.0
2015-09-11	AAWW-DELISTED	Stock	39.6	39.894	38.89	39.41	184815.0
2015-09-11	AAXJ	Stock	53.22	53.73	53.22	53.71	524211.0
2015-09-11	AAXN-DELISTED	Stock	23.45	23.8499	23.25	23.74	652268.0
2015-09-11	AB	Stock	26.01	26.36	25.87	26.34	203500.0
2015-09-11	ABAC-DELISTED	Stock	0.85	0.85	0.8	0.8	799.0
2015-09-11	ABAX-DELISTED	Stock	48.22	49.26	48.15	48.73	28521.0
2015-09-11	ABB-DELISTED	Stock	18.58	18.79	18.56	18.79	1314343.0
2015-09-11	ABBNY-DELISTED	Stock	18.58	18.8	18.56	18.8	1378605.0
2015-09-11	ABBV	Stock	59.62	59.76	58.97	59.35	9365400.0
2015-09-11	ABC-DELISTED	Stock	101.88	104.4	101.82	104.36	1771349.0
2015-09-11	ABCB	Stock	27.69	27.97	27.69	27.89	93100.0
2015-09-11	ABCD-DELISTED	Stock	4.85	5.06	4.85	5.02	50975.0
2015-09-11	ABCO-DELISTED	Stock	47.94	49.0	47.65	48.7	126392.0
2015-09-11	ABCW-DELISTED	Stock	41.21	41.54	40.91	41.54	45617.0
2015-09-11	ABDC-DELISTED	Stock	12.74	12.855	12.56	12.78	36400.0
2015-09-11	ABE-DELISTED	Stock	11.04	11.08	10.9301	10.9301	1030.0
2015-09-11	ABEO	Stock	133.0	140.0	132.0	137.0	5280.0
2015-09-11	ABEOW-DELISTED	Stock	2.12	2.21	2.1	2.21	800.0
2015-09-11	ABEV	Stock	4.91	4.93	4.82	4.83	13142000.0
2015-09-11	ABG	Stock	80.65	81.29	80.09	81.24	172800.0
2015-09-11	ABGB-DELISTED	Stock	5.9	6.03	5.58	5.6101	35216.0
2015-09-11	ABIL-DELISTED	Stock	9.96	10.0	9.96	10.0	1450.0

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

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