PREVIEW / stock_daily / 2012-03-05

all stock daily files

  file:    by_date/stock_daily/2012/2012-03-05.parquet
  size:    198 KB
  rows:    6,137
  symbols: 3,517

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-05	AAPL	Stock	19.4793	19.5529	18.7857	19.0414	809124400.0
2012-03-05	MSFT	Stock	32.01	32.05	31.62	31.8	45240000.0
2012-03-05	NVDA	Stock	0.3818	0.3825	0.3688	0.3715	514848000.0
2012-03-05	AMZN	Stock	8.95	9.091	8.909	9.013	93654000.0
2012-03-05	TSLA	Stock	2.29	2.2933	2.2307	2.2513	7005000.0
2012-03-05	TLT	Stock	116.96	117.4399	116.22	116.22	6923588.0
2012-03-05	ES	Stock	35.98	36.55	35.95	36.51	1954200.0
2012-03-05	CL	Stock	46.5	46.765	46.475	46.675	2335000.0
2012-03-05	A	Stock	31.1874	31.2661	30.4363	30.6009	4990860.0
2012-03-05	AABA-DELISTED	Stock	14.66	14.95	14.52	14.63	11684918.0
2012-03-05	AACC-DELISTED	Stock	4.84	5.0	4.3	4.54	95990.0
2012-03-05	AACG	Stock	5.91	6.08	5.9	5.99	1100.0
2012-03-05	AAIC-DELISTED	Stock	22.97	23.18	22.79	23.03	62757.0
2012-03-05	AAME	Stock	2.8	2.81	2.7	2.79	18100.0
2012-03-05	AAMRQ-DELISTED	Stock	0.492	0.495	0.46	0.464	4598502.0
2012-03-05	AAON	Stock	5.3185	5.5081	5.3126	5.4993	161325.0
2012-03-05	AAP	Stock	86.69	87.36	86.49	86.84	1679600.0
2012-03-05	AAT	Stock	21.67	22.19	21.55	22.18	198100.0
2012-03-05	AAU-DELISTED	Stock	2.93	2.95	2.75	2.79	187773.0
2012-03-05	AAUAF-DELISTED	Stock	2.93	2.95	2.75	2.79	188272.0
2012-03-05	AAV-DELISTED	Stock	3.91	3.91	3.75	3.77	286694.0
2012-03-05	AAWW-DELISTED	Stock	42.06	42.57	41.73	42.5	237994.0
2012-03-05	AAXJ	Stock	57.47	57.59	57.1412	57.24	1122192.0
2012-03-05	AAXN-DELISTED	Stock	4.07	4.09	4.01	4.04	330221.0
2012-03-05	AB	Stock	14.17	14.73	13.92	14.65	458200.0
2012-03-05	ABAC-DELISTED	Stock	1.7532	1.7532	1.61	1.61	24335.0
2012-03-05	ABAX-DELISTED	Stock	26.44	26.9284	26.4	26.7883	96190.0
2012-03-05	ABB-DELISTED	Stock	20.5	20.52	20.3	20.38	1860625.0
2012-03-05	ABBNY-DELISTED	Stock	20.5	20.52	20.3	20.39	1861827.0
2012-03-05	ABC-DELISTED	Stock	36.54	36.875	36.46	36.55	2204983.0
2012-03-05	ABCB	Stock	11.16	11.74	11.16	11.63	54800.0
2012-03-05	ABCD-DELISTED	Stock	2.88	2.92	2.83	2.87	8209.0
2012-03-05	ABCO-DELISTED	Stock	40.0	41.21	39.83	41.16	250562.0
2012-03-05	ABCW-DELISTED	Stock	0.3916	0.4317	0.3916	0.4317	6500.0
2012-03-05	ABD-DELISTED	Stock	11.96	12.01	11.45	11.59	303580.0
2012-03-05	ABE-DELISTED	Stock	19.55	19.61	19.46	19.47	12595.0
2012-03-05	ABEO	Stock	1562.5	1600.0	1487.5	1537.5	13.0
2012-03-05	ABFS-DELISTED	Stock	17.79	18.04	17.77	17.9	156960.0
2012-03-05	ABG	Stock	26.51	26.86	26.08	26.72	403900.0
2012-03-05	ABH-DELISTED	Stock	15.1	15.27	14.9929	15.13	112617.0
2012-03-05	ABM	Stock	22.53	22.73	22.24	22.41	339800.0
2012-03-05	ABMD-DELISTED	Stock	20.42	20.44	20.15	20.19	500420.0
2012-03-05	ABR	Stock	4.95	5.0	4.91	4.97	72700.0
2012-03-05	ABT	Stock	27.4733	27.5837	27.4254	27.4829	11895998.0
2012-03-05	ABTL-DELISTED	Stock	4.951	5.1026	4.7742	4.85	46786.0
2012-03-05	ABUS	Stock	2.52	2.52	2.25	2.44	13500.0
2012-03-05	ABV-DELISTED	Stock	39.83	39.91	39.425	39.78	1404902.0
2012-03-05	ABVA-DELISTED	Stock	3.8	4.01	3.8	3.851	3700.0
2012-03-05	ABVT-DELISTED	Stock	69.62	70.99	69.59	70.66	135920.0
2012-03-05	ABX-DELISTED	Stock	47.24	47.24	46.33	46.76	6950227.0

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

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