PREVIEW / stock_daily / 2012-03-09

all stock daily files

  file:    by_date/stock_daily/2012/2012-03-09.parquet
  size:    198 KB
  rows:    6,148
  symbols: 3,527

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-09	AAPL	Stock	19.4361	19.5621	19.3968	19.4704	418919200.0
2012-03-09	MSFT	Stock	32.1	32.16	31.92	31.99	34628400.0
2012-03-09	NVDA	Stock	0.3725	0.3753	0.3685	0.3705	367836000.0
2012-03-09	AMZN	Stock	9.3395	9.36	9.172	9.216	90212000.0
2012-03-09	TSLA	Stock	2.2133	2.354	2.2133	2.316	23301000.0
2012-03-09	TLT	Stock	115.49	115.99	114.9	115.97	6975597.0
2012-03-09	ES	Stock	36.67	36.93	36.5	36.84	1085400.0
2012-03-09	CL	Stock	46.89	47.05	46.645	46.99	3145400.0
2012-03-09	A	Stock	31.6452	32.2389	31.6452	31.867	4278579.0
2012-03-09	AABA-DELISTED	Stock	14.63	14.7	14.61	14.63	9422220.0
2012-03-09	AACC-DELISTED	Stock	4.49	4.9	4.43	4.68	111779.0
2012-03-09	AACG	Stock	6.18	6.39	6.01	6.06	1600.0
2012-03-09	AAIC-DELISTED	Stock	23.58	23.9981	22.87	23.87	65140.0
2012-03-09	AAME	Stock	2.85	2.96	2.84	2.9	21400.0
2012-03-09	AAMRQ-DELISTED	Stock	0.515	0.528	0.4	0.489	1739281.0
2012-03-09	AAON	Stock	5.3659	5.5556	5.3185	5.4756	121500.0
2012-03-09	AAP	Stock	87.05	87.76	86.75	87.27	803700.0
2012-03-09	AAT	Stock	22.04	22.31	21.71	21.91	226200.0
2012-03-09	AAU-DELISTED	Stock	2.79	3.04	2.78	2.89	200905.0
2012-03-09	AAUAF-DELISTED	Stock	2.79	3.04	2.78	2.89	201505.0
2012-03-09	AAV-DELISTED	Stock	3.69	3.73	3.61	3.69	802440.0
2012-03-09	AAWW-DELISTED	Stock	43.49	44.03	42.81	43.94	254075.0
2012-03-09	AAXJ	Stock	57.52	57.64	57.3	57.45	269447.0
2012-03-09	AAXN-DELISTED	Stock	4.07	4.12	4.03	4.05	439961.0
2012-03-09	AB	Stock	15.31	15.55	15.2	15.5	507100.0
2012-03-09	ABAC-DELISTED	Stock	1.54	1.73	1.54	1.63	78433.0
2012-03-09	ABAX-DELISTED	Stock	27.33	27.87	27.21	27.4	66046.0
2012-03-09	ABB-DELISTED	Stock	20.18	20.32	20.11	20.23	2636512.0
2012-03-09	ABBNY-DELISTED	Stock	20.18	20.32	20.11	20.24	2636612.0
2012-03-09	ABC-DELISTED	Stock	37.45	37.95	37.38	37.87	3602224.0
2012-03-09	ABCB	Stock	11.75	12.15	11.75	11.97	43300.0
2012-03-09	ABCD-DELISTED	Stock	3.04	3.08	2.69	2.81	26596.0
2012-03-09	ABCO-DELISTED	Stock	41.49	42.22	41.4	41.59	123896.0
2012-03-09	ABCW-DELISTED	Stock	0.4819	0.5121	0.4016	0.5121	28010.0
2012-03-09	ABD-DELISTED	Stock	11.56	12.02	11.54	11.82	222190.0
2012-03-09	ABE-DELISTED	Stock	19.4	19.5	19.3	19.4	11734.0
2012-03-09	ABEO	Stock	1325.0	1437.5	1325.0	1437.5	11.0
2012-03-09	ABFS-DELISTED	Stock	17.77	18.59	17.64	18.52	325781.0
2012-03-09	ABG	Stock	27.09	27.6	26.89	27.2	385200.0
2012-03-09	ABH-DELISTED	Stock	14.6	15.02	14.6	14.94	271410.0
2012-03-09	ABM	Stock	23.11	23.56	22.96	23.2	392300.0
2012-03-09	ABMD-DELISTED	Stock	21.18	21.96	21.1	21.87	424590.0
2012-03-09	ABR	Stock	5.34	5.35	5.32	5.35	41800.0
2012-03-09	ABT	Stock	27.5885	27.8236	27.5453	27.8044	16453939.0
2012-03-09	ABTL-DELISTED	Stock	4.8	4.8465	4.651	4.75	1980.0
2012-03-09	ABUS	Stock	2.39	2.42	2.22	2.4	35600.0
2012-03-09	ABV-DELISTED	Stock	40.82	41.25	40.74	40.99	1428326.0
2012-03-09	ABVA-DELISTED	Stock	4.02	4.186	4.01	4.1	2100.0
2012-03-09	ABVT-DELISTED	Stock	69.78	71.58	69.77	71.56	305408.0
2012-03-09	ABX-DELISTED	Stock	45.71	46.19	45.43	45.82	7511872.0

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

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