PREVIEW / stock_daily / 2012-03-23

all stock daily files

  file:    by_date/stock_daily/2012/2012-03-23.parquet
  size:    198 KB
  rows:    6,126
  symbols: 3,511

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-03-23	AAPL	Stock	21.4461	21.4929	21.2286	21.2875	430488800.0
2012-03-23	MSFT	Stock	32.1	32.11	31.72	32.01	35912200.0
2012-03-23	NVDA	Stock	0.36	0.3648	0.3575	0.3638	315456000.0
2012-03-23	AMZN	Stock	9.6005	9.81	9.59	9.752	119680000.0
2012-03-23	TSLA	Stock	2.284	2.3087	2.21	2.272	17559000.0
2012-03-23	TLT	Stock	112.69	113.39	112.66	113.21	8465542.0
2012-03-23	ES	Stock	36.41	36.83	36.31	36.74	1662900.0
2012-03-23	CL	Stock	48.1	48.165	47.815	47.97	2988400.0
2012-03-23	A	Stock	31.166	31.6881	30.8655	31.6881	4710421.0
2012-03-23	AABA-DELISTED	Stock	15.51	15.59	15.31	15.38	8078720.0
2012-03-23	AACC-DELISTED	Stock	4.75	4.75	4.62	4.75	14202.0
2012-03-23	AACG	Stock	6.35	6.89	6.35	6.89	1900.0
2012-03-23	AAIC-DELISTED	Stock	22.76	22.98	22.76	22.86	230236.0
2012-03-23	AAME	Stock	2.81	2.84	2.65	2.8	1200.0
2012-03-23	AAMRQ-DELISTED	Stock	0.4905	0.5	0.47	0.49	1489605.0
2012-03-23	AAON	Stock	6.0089	6.3496	5.9585	6.2756	189675.0
2012-03-23	AAP	Stock	89.01	89.17	88.31	88.99	523200.0
2012-03-23	AAT	Stock	22.68	23.05	22.49	22.96	105000.0
2012-03-23	AAU-DELISTED	Stock	2.58	2.68	2.54	2.64	79797.0
2012-03-23	AAUAF-DELISTED	Stock	2.58	2.68	2.54	2.63	80097.0
2012-03-23	AAV-DELISTED	Stock	3.61	3.61	3.481	3.5	390326.0
2012-03-23	AAWW-DELISTED	Stock	48.67	49.06	47.48	48.91	207124.0
2012-03-23	AAXJ	Stock	56.3	56.59	56.08	56.54	146837.0
2012-03-23	AAXN-DELISTED	Stock	4.56	4.56	4.28	4.33	679996.0
2012-03-23	AB	Stock	14.77	15.49	14.77	15.42	314400.0
2012-03-23	ABAC-DELISTED	Stock	1.69	1.72	1.62	1.72	17901.0
2012-03-23	ABAX-DELISTED	Stock	28.18	28.71	28.15	28.61	58685.0
2012-03-23	ABB-DELISTED	Stock	20.15	20.39	20.02	20.32	1545278.0
2012-03-23	ABBNY-DELISTED	Stock	20.13	20.39	20.02	20.34	1545078.0
2012-03-23	ABC-DELISTED	Stock	38.14	39.2	38.14	38.96	2905459.0
2012-03-23	ABCB	Stock	13.14	13.35	13.08	13.27	54000.0
2012-03-23	ABCD-DELISTED	Stock	2.72	2.95	2.675	2.87	19313.0
2012-03-23	ABCO-DELISTED	Stock	43.1	43.36	42.64	43.35	118714.0
2012-03-23	ABCW-DELISTED	Stock	0.7229	0.743	0.7028	0.7229	26950.0
2012-03-23	ABD-DELISTED	Stock	12.46	12.63	12.36	12.49	374850.0
2012-03-23	ABE-DELISTED	Stock	19.24	19.24	19.17	19.19	1945.0
2012-03-23	ABEO	Stock	1262.5	1362.5	1262.5	1362.5	33.0
2012-03-23	ABFS-DELISTED	Stock	18.88	19.21	18.88	19.02	164435.0
2012-03-23	ABG	Stock	26.66	26.67	26.0	26.64	243000.0
2012-03-23	ABH-DELISTED	Stock	14.83	15.09	14.71	15.09	109598.0
2012-03-23	ABM	Stock	23.38	23.89	23.22	23.82	362500.0
2012-03-23	ABMD-DELISTED	Stock	22.99	23.05	22.62	23.0	300944.0
2012-03-23	ABR	Stock	5.64	5.7	5.52	5.62	42000.0
2012-03-23	ABT	Stock	28.8168	29.0471	28.812	28.9799	13572113.0
2012-03-23	ABTL-DELISTED	Stock	4.899	5.049	4.899	4.95	712.0
2012-03-23	ABUS	Stock	2.21	2.35	2.21	2.3	14700.0
2012-03-23	ABV-DELISTED	Stock	42.29	42.75	41.75	42.72	2116097.0
2012-03-23	ABVA-DELISTED	Stock	4.0	4.0101	4.0	4.0101	505.0
2012-03-23	ABVT-DELISTED	Stock	83.57	83.57	82.94	83.09	1282495.0
2012-03-23	ABX-DELISTED	Stock	43.41	43.98	43.09	43.76	6579988.0

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

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