PREVIEW / stock_daily / 2012-08-09

all stock daily files

  file:    by_date/stock_daily/2012/2012-08-09.parquet
  size:    199 KB
  rows:    6,153
  symbols: 3,500

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-08-09	AAPL	Stock	22.0661	22.2046	22.0643	22.1689	221642400.0
2012-08-09	MSFT	Stock	30.39	30.65	30.3	30.5	24920800.0
2012-08-09	NVDA	Stock	0.3562	0.3685	0.3558	0.3678	822300000.0
2012-08-09	AMZN	Stock	11.6965	11.7995	11.675	11.703	30962000.0
2012-08-09	META	Stock	20.75	21.17	20.61	21.01	15610700.0
2012-08-09	TSLA	Stock	1.968	2.0	1.942	1.9607	10089000.0
2012-08-09	TLT	Stock	124.77	125.3	123.75	125.07	7557271.0
2012-08-09	ES	Stock	39.41	39.5	39.04	39.2	915300.0
2012-08-09	CL	Stock	52.53	52.705	52.385	52.475	3117600.0
2012-08-09	A	Stock	29.0129	29.3062	28.927	29.1845	3063298.0
2012-08-09	AABA-DELISTED	Stock	16.16	16.16	15.98	16.01	8556025.0
2012-08-09	AACC-DELISTED	Stock	5.81	5.96	5.81	5.93	45628.0
2012-08-09	AACG	Stock	4.58	4.58	4.25	4.39	2900.0
2012-08-09	AAIC-DELISTED	Stock	22.89	23.0	22.89	23.0	50929.0
2012-08-09	AAME	Stock	2.66	2.72	2.66	2.7	5200.0
2012-08-09	AAMRQ-DELISTED	Stock	0.492	0.498	0.485	0.49	907893.0
2012-08-09	AAON	Stock	5.8815	5.8874	5.7481	5.7956	189338.0
2012-08-09	AAP	Stock	67.08	70.0	66.87	67.92	3157800.0
2012-08-09	AAT	Stock	26.12	26.33	25.89	26.04	165300.0
2012-08-09	AAU-DELISTED	Stock	2.14	2.175	2.09	2.16	134770.0
2012-08-09	AAUAF-DELISTED	Stock	2.14	2.18	2.09	2.16	137730.0
2012-08-09	AAV-DELISTED	Stock	3.65	3.65	3.34	3.38	530865.0
2012-08-09	AAWW-DELISTED	Stock	51.35	52.23	51.2501	52.08	255945.0
2012-08-09	AAXJ	Stock	54.37	54.72	54.35	54.42	154433.0
2012-08-09	AAXN-DELISTED	Stock	5.64	5.7	5.6	5.69	293819.0
2012-08-09	AB	Stock	12.01	12.51	11.94	12.22	164400.0
2012-08-09	ABAC-DELISTED	Stock	0.9599	1.09	0.9599	1.0	50130.0
2012-08-09	ABAX-DELISTED	Stock	37.8	38.1	37.38	37.84	42696.0
2012-08-09	ABB-DELISTED	Stock	17.8	17.93	17.76	17.88	2966119.0
2012-08-09	ABBNY-DELISTED	Stock	17.8	17.93	17.76	17.88	3050663.0
2012-08-09	ABC-DELISTED	Stock	38.45	39.36	38.45	38.69	3062114.0
2012-08-09	ABCB	Stock	11.75	11.82	11.34	11.45	72700.0
2012-08-09	ABCD-DELISTED	Stock	1.02	1.02	0.9201	0.98	85657.0
2012-08-09	ABCO-DELISTED	Stock	42.53	42.66	42.27	42.39	302457.0
2012-08-09	ABCW-DELISTED	Stock	0.39	0.39	0.36	0.365	16160.0
2012-08-09	ABE-DELISTED	Stock	19.55	19.56	19.48	19.53	23534.0
2012-08-09	ABEO	Stock	525.0	612.5	512.5	612.5	5.0
2012-08-09	ABFS-DELISTED	Stock	10.36	10.64	10.31	10.62	245612.0
2012-08-09	ABG	Stock	26.75	27.33	26.38	27.0	414600.0
2012-08-09	ABM	Stock	18.88	19.04	18.79	18.96	185200.0
2012-08-09	ABMD-DELISTED	Stock	21.56	22.14	21.51	22.01	473279.0
2012-08-09	ABR	Stock	5.63	5.75	5.52	5.56	101700.0
2012-08-09	ABT	Stock	31.5133	31.6524	31.4557	31.5325	7844935.0
2012-08-09	ABTL-DELISTED	Stock	3.62	3.8	3.402	3.68	50530.0
2012-08-09	ABUS	Stock	3.6	3.75	3.41	3.7	46300.0
2012-08-09	ABV-DELISTED	Stock	38.57	38.62	38.3	38.39	1606289.0
2012-08-09	ABX-DELISTED	Stock	34.03	34.36	33.65	34.13	4734466.0
2012-08-09	ACAD	Stock	1.52	1.55	1.5	1.51	210100.0
2012-08-09	ACAS-DELISTED	Stock	10.86	10.96	10.8	10.89	3310922.0
2012-08-09	ACAT-DELISTED	Stock	44.44	44.73	43.12	43.75	210467.0

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

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