PREVIEW / stock_daily / 2012-10-11

all stock daily files

  file:    by_date/stock_daily/2012/2012-10-11.parquet
  size:    199 KB
  rows:    6,139
  symbols: 3,481

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
2012-10-11	AAPL	Stock	23.0893	23.1143	22.4321	22.4321	546081200.0
2012-10-11	MSFT	Stock	29.22	29.25	28.87	28.95	41488500.0
2012-10-11	NVDA	Stock	0.3198	0.3208	0.316	0.3185	320516000.0
2012-10-11	AMZN	Stock	12.4	12.465	12.0945	12.211	68946000.0
2012-10-11	META	Stock	19.88	19.96	19.61	19.75	21817300.0
2012-10-11	TSLA	Stock	1.9293	1.932	1.8833	1.888	6759000.0
2012-10-11	TLT	Stock	121.96	123.66	121.89	123.66	5194434.0
2012-10-11	ES	Stock	39.22	39.23	38.81	38.87	1133200.0
2012-10-11	CL	Stock	54.215	54.31	53.93	54.015	2968400.0
2012-10-11	A	Stock	27.0172	27.3104	26.917	26.917	4202528.0
2012-10-11	AABA-DELISTED	Stock	15.94	16.02	15.84	15.92	12947282.0
2012-10-11	AACC-DELISTED	Stock	7.4	7.64	7.4	7.52	5968.0
2012-10-11	AACG	Stock	4.76	5.1	4.73	5.04	6800.0
2012-10-11	AAIC-DELISTED	Stock	22.84	22.97	22.55	22.69	170151.0
2012-10-11	AAME	Stock	2.84	2.86	2.75	2.75	1600.0
2012-10-11	AAMRQ-DELISTED	Stock	0.3801	0.39	0.3801	0.384	429365.0
2012-10-11	AAON	Stock	5.7304	5.7304	5.5556	5.5674	102263.0
2012-10-11	AAP	Stock	69.55	69.55	68.15	68.49	571500.0
2012-10-11	AAT	Stock	27.71	27.76	27.59	27.74	232000.0
2012-10-11	AAU-DELISTED	Stock	2.46	2.56	2.46	2.54	85083.0
2012-10-11	AAUAF-DELISTED	Stock	2.46	2.56	2.46	2.54	85283.0
2012-10-11	AAV-DELISTED	Stock	3.9	3.98	3.87	3.9	104334.0
2012-10-11	AAWW-DELISTED	Stock	53.01	53.4	52.43	52.64	136474.0
2012-10-11	AAXJ	Stock	56.4	56.52	56.22	56.27	302732.0
2012-10-11	AAXN-DELISTED	Stock	6.0	6.0	5.88	5.915	254716.0
2012-10-11	AB	Stock	15.57	15.97	15.56	15.91	234400.0
2012-10-11	ABAC-DELISTED	Stock	1.36	1.48	1.35	1.48	1250.0
2012-10-11	ABAX-DELISTED	Stock	36.84	36.97	36.081	36.81	82828.0
2012-10-11	ABB-DELISTED	Stock	18.97	19.04	18.785	18.79	1335382.0
2012-10-11	ABBNY-DELISTED	Stock	18.96	19.04	18.785	18.81	1352619.0
2012-10-11	ABC-DELISTED	Stock	39.51	39.7	39.335	39.49	1682702.0
2012-10-11	ABCB	Stock	12.8	12.86	12.62	12.71	15300.0
2012-10-11	ABCD-DELISTED	Stock	0.9999	1.0	0.97	0.97	49474.0
2012-10-11	ABCO-DELISTED	Stock	47.91	48.18	46.76	47.11	137119.0
2012-10-11	ABCW-DELISTED	Stock	0.38	0.38	0.38	0.38	14000.0
2012-10-11	ABE-DELISTED	Stock	20.6	20.68	20.5901	20.5901	2799.0
2012-10-11	ABEO	Stock	500.0	500.0	437.5	487.5	36.0
2012-10-11	ABFS-DELISTED	Stock	8.21	8.47	8.19	8.27	257572.0
2012-10-11	ABG	Stock	30.26	30.29	29.53	29.61	171700.0
2012-10-11	ABM	Stock	18.42	18.48	18.31	18.31	438400.0
2012-10-11	ABMD-DELISTED	Stock	20.54	20.7	20.04	20.24	510535.0
2012-10-11	ABR	Stock	5.69	5.73	5.65	5.7	128000.0
2012-10-11	ABT	Stock	33.6628	33.7683	33.2981	33.3077	10342018.0
2012-10-11	ABTL-DELISTED	Stock	3.84	3.9	3.84	3.9	1201.0
2012-10-11	ABUS	Stock	3.81	3.94	3.81	3.91	9900.0
2012-10-11	ABV-DELISTED	Stock	40.22	40.42	40.03	40.03	1560184.0
2012-10-11	ABVA-DELISTED	Stock	4.39	4.75	4.36	4.6	11834.0
2012-10-11	ABX-DELISTED	Stock	40.34	40.41	39.87	39.92	5646383.0
2012-10-11	ACAD	Stock	2.43	2.49	2.38	2.45	1081800.0
2012-10-11	ACAS-DELISTED	Stock	11.79	11.79	11.62	11.65	2116110.0

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

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