PREVIEW / stock_daily / 2012-03-29

all stock daily files

  file:    by_date/stock_daily/2012/2012-03-29.parquet
  size:    200 KB
  rows:    6,185
  symbols: 3,556

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-29	AAPL	Stock	21.885	22.02	21.6868	21.7807	608238400.0
2012-03-29	MSFT	Stock	32.06	32.19	31.81	32.12	37038500.0
2012-03-29	NVDA	Stock	0.3785	0.3838	0.3738	0.3808	372700000.0
2012-03-29	AMZN	Stock	10.064	10.2655	10.0315	10.2305	114224000.0
2012-03-29	TSLA	Stock	2.546	2.546	2.4687	2.4887	11946000.0
2012-03-29	TLT	Stock	114.02	114.19	113.58	114.13	7692976.0
2012-03-29	ES	Stock	36.72	37.22	36.24	37.21	2031700.0
2012-03-29	CL	Stock	47.825	48.435	47.765	48.345	4815000.0
2012-03-29	A	Stock	31.5451	31.8526	31.4378	31.8026	3199183.0
2012-03-29	AABA-DELISTED	Stock	15.19	15.34	15.11	15.3	9734947.0
2012-03-29	AACC-DELISTED	Stock	4.95	4.95	4.41	4.86	70238.0
2012-03-29	AACG	Stock	6.4	6.98	6.35	6.5	12200.0
2012-03-29	AAIC-DELISTED	Stock	22.48	22.55	22.1	22.37	197662.0
2012-03-29	AAME	Stock	2.78	2.85	2.76	2.85	3800.0
2012-03-29	AAMRQ-DELISTED	Stock	0.465	0.492	0.46	0.4725	1112857.0
2012-03-29	AAON	Stock	6.1096	6.1274	5.9881	6.0533	148838.0
2012-03-29	AAP	Stock	88.59	88.82	87.28	87.98	774800.0
2012-03-29	AAT	Stock	22.48	22.63	22.35	22.61	101000.0
2012-03-29	AAU-DELISTED	Stock	2.54	2.566	2.46	2.55	128289.0
2012-03-29	AAUAF-DELISTED	Stock	2.54	2.566	2.46	2.55	128389.0
2012-03-29	AAV-DELISTED	Stock	3.31	3.41	3.24	3.4	348264.0
2012-03-29	AAWW-DELISTED	Stock	47.77	49.39	47.39	49.25	238435.0
2012-03-29	AAXJ	Stock	55.87	56.005	55.23	55.9	323046.0
2012-03-29	AAXN-DELISTED	Stock	4.36	4.44	4.28	4.34	317054.0
2012-03-29	AB	Stock	15.44	15.44	15.15	15.28	108900.0
2012-03-29	ABAC-DELISTED	Stock	1.65	1.69	1.62	1.62	19900.0
2012-03-29	ABAX-DELISTED	Stock	29.3	29.51	29.065	29.46	48675.0
2012-03-29	ABB-DELISTED	Stock	19.96	20.06	19.88	20.01	5036076.0
2012-03-29	ABBNY-DELISTED	Stock	19.96	20.06	19.88	20.0	5157637.0
2012-03-29	ABC-DELISTED	Stock	38.84	39.27	38.83	39.2	1755023.0
2012-03-29	ABCB	Stock	13.17	13.33	13.17	13.3	217900.0
2012-03-29	ABCD-DELISTED	Stock	2.67	2.73	2.65	2.73	5372.0
2012-03-29	ABCO-DELISTED	Stock	44.51	44.54	43.78	44.23	151652.0
2012-03-29	ABCW-DELISTED	Stock	0.8133	0.9036	0.7832	0.9036	67200.0
2012-03-29	ABD-DELISTED	Stock	12.55	12.79	12.47	12.64	359850.0
2012-03-29	ABE-DELISTED	Stock	19.02	19.1	18.9	19.09	18734.0
2012-03-29	ABEO	Stock	1325.0	1412.5	1325.0	1412.5	4.0
2012-03-29	ABFS-DELISTED	Stock	18.8	19.1281	18.79	19.08	221306.0
2012-03-29	ABG	Stock	27.0	27.22	26.65	27.2	308200.0
2012-03-29	ABH-DELISTED	Stock	14.45	14.62	14.21	14.49	128745.0
2012-03-29	ABM	Stock	24.08	24.46	23.93	24.42	242900.0
2012-03-29	ABMD-DELISTED	Stock	22.24	22.35	21.81	22.19	150873.0
2012-03-29	ABR	Stock	5.84	5.84	5.57	5.62	50600.0
2012-03-29	ABT	Stock	29.1383	29.287	29.0759	29.2582	11088787.0
2012-03-29	ABTL-DELISTED	Stock	4.8063	4.8063	4.6812	4.6937	13801.0
2012-03-29	ABUS	Stock	2.64	2.65	2.62	2.64	6400.0
2012-03-29	ABV-DELISTED	Stock	41.32	41.83	40.69	41.65	4950840.0
2012-03-29	ABVA-DELISTED	Stock	4.17	4.17	4.17	4.17	1200.0
2012-03-29	ABVT-DELISTED	Stock	83.01	83.19	82.98	83.1	271573.0
2012-03-29	ABX-DELISTED	Stock	43.05	43.14	42.2	43.13	9065429.0

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

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