PREVIEW / stock_daily / 2012-01-23

all stock daily files

  file:    by_date/stock_daily/2012/2012-01-23.parquet
  size:    197 KB
  rows:    6,147
  symbols: 3,553

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-01-23	AAPL	Stock	15.0954	15.3018	15.0821	15.2646	306062400.0
2012-01-23	MSFT	Stock	29.55	29.95	29.35	29.73	76078100.0
2012-01-23	NVDA	Stock	0.3558	0.3655	0.3513	0.3652	562792000.0
2012-01-23	AMZN	Stock	9.5395	9.5865	9.2615	9.3045	91706000.0
2012-01-23	TSLA	Stock	1.7873	1.814	1.7733	1.7847	8919000.0
2012-01-23	TLT	Stock	116.13	116.64	115.55	116.24	7274802.0
2012-01-23	ES	Stock	34.25	34.62	34.19	34.43	1692800.0
2012-01-23	CL	Stock	44.29	44.475	44.08	44.185	4333600.0
2012-01-23	A	Stock	29.2418	29.4778	28.9914	29.3276	4743554.0
2012-01-23	AABA-DELISTED	Stock	15.85	15.93	15.64	15.7	17192918.0
2012-01-23	AACC-DELISTED	Stock	4.35	4.62	4.35	4.5	5950.0
2012-01-23	AACG	Stock	6.07	6.29	6.03	6.25	12300.0
2012-01-23	AAIC-DELISTED	Stock	22.53	22.82	22.53	22.79	49863.0
2012-01-23	AAME	Stock	2.01	2.02	2.01	2.02	500.0
2012-01-23	AAMRQ-DELISTED	Stock	0.477	0.594	0.471	0.574	24501231.0
2012-01-23	AAON	Stock	5.92	5.9467	5.8163	5.8726	80325.0
2012-01-23	AAP	Stock	74.77	75.04	74.18	74.9	771700.0
2012-01-23	AAT	Stock	21.29	21.64	21.18	21.46	62000.0
2012-01-23	AAU-DELISTED	Stock	2.53	2.54	2.38	2.43	96014.0
2012-01-23	AAUAF-DELISTED	Stock	2.57	2.58	2.42	2.43	94753.0
2012-01-23	AAV-DELISTED	Stock	3.51	3.69	3.51	3.67	1076113.0
2012-01-23	AAWW-DELISTED	Stock	43.32	44.55	43.0001	43.43	157753.0
2012-01-23	AAXJ	Stock	54.65	55.17	54.65	54.84	302224.0
2012-01-23	AAXN-DELISTED	Stock	4.92	4.98	4.86	4.9	209651.0
2012-01-23	AB	Stock	15.09	15.53	14.91	15.43	394100.0
2012-01-23	ABAC-DELISTED	Stock	1.76	1.8	1.61	1.68	29125.0
2012-01-23	ABAX-DELISTED	Stock	28.18	28.28	27.98	28.1	34068.0
2012-01-23	ABB-DELISTED	Stock	21.33	21.455	21.23	21.38	2176924.0
2012-01-23	ABBNY-DELISTED	Stock	21.33	21.455	21.23	21.38	2178224.0
2012-01-23	ABC-DELISTED	Stock	39.99	40.22	39.46	39.79	2528945.0
2012-01-23	ABCB	Stock	10.93	10.97	10.78	10.93	8000.0
2012-01-23	ABCD-DELISTED	Stock	3.2	3.2	3.05	3.085	13316.0
2012-01-23	ABCO-DELISTED	Stock	39.18	39.38	38.93	39.2	255280.0
2012-01-23	ABCW-DELISTED	Stock	0.251	0.2811	0.2109	0.2209	144870.0
2012-01-23	ABD-DELISTED	Stock	9.98	10.12	9.86	9.92	365780.0
2012-01-23	ABE-DELISTED	Stock	18.47	18.9	18.17	18.3801	17044.0
2012-01-23	ABEO	Stock	1700.0	1700.0	1450.0	1562.5	140.0
2012-01-23	ABFS-DELISTED	Stock	22.07	22.07	21.45	21.79	331616.0
2012-01-23	ABG	Stock	23.32	23.56	22.69	23.22	287700.0
2012-01-23	ABH-DELISTED	Stock	15.43	15.43	14.88	14.94	323080.0
2012-01-23	ABM	Stock	21.25	21.69	21.12	21.68	374000.0
2012-01-23	ABMD-DELISTED	Stock	18.58	18.58	17.78	17.81	251103.0
2012-01-23	ABR	Stock	4.22	4.34	4.22	4.23	23100.0
2012-01-23	ABT	Stock	26.8064	26.8064	26.6145	26.7345	12147770.0
2012-01-23	ABTL-DELISTED	Stock	4.0526	4.0526	3.8987	3.95	2239.0
2012-01-23	ABUS	Stock	2.55	2.55	2.5	2.54	2300.0
2012-01-23	ABV-DELISTED	Stock	37.1	37.23	36.71	36.82	2473615.0
2012-01-23	ABVA-DELISTED	Stock	3.45	3.45	3.4	3.4	2245.0
2012-01-23	ABVT-DELISTED	Stock	65.79	66.72	65.79	65.93	127262.0
2012-01-23	ABX-DELISTED	Stock	46.12	47.0	46.12	46.96	9121463.0

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

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