PREVIEW / stock_daily / 2011-10-24

all stock daily files

  file:    by_date/stock_daily/2011/2011-10-24.parquet
  size:    195 KB
  rows:    6,094
  symbols: 3,525

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
2011-10-24	AAPL	Stock	14.1493	14.5179	14.1214	14.4918	502138000.0
2011-10-24	MSFT	Stock	27.06	27.4	27.04	27.19	56897800.0
2011-10-24	NVDA	Stock	0.3635	0.3813	0.3628	0.3755	535256000.0
2011-10-24	AMZN	Stock	11.801	12.0235	11.7	11.8805	99516000.0
2011-10-24	TSLA	Stock	1.858	1.926	1.85	1.9033	14109000.0
2011-10-24	TLT	Stock	113.93	114.08	113.05	113.32	6344484.0
2011-10-24	ES	Stock	33.87	34.08	33.66	33.98	1219900.0
2011-10-24	CL	Stock	46.815	46.815	45.46	45.62	7195200.0
2011-10-24	A	Stock	25.4578	26.9886	25.3505	26.8526	8540801.0
2011-10-24	AABA-DELISTED	Stock	16.56	16.75	16.31	16.71	29212389.0
2011-10-24	AACC-DELISTED	Stock	3.05	3.25	3.02	3.1698	28081.0
2011-10-24	AACG	Stock	8.76	9.48	8.62	9.48	6800.0
2011-10-24	AAIC-DELISTED	Stock	24.45	24.766	24.34	24.68	40052.0
2011-10-24	AAME	Stock	1.85	1.93	1.8	1.89	4100.0
2011-10-24	AAON	Stock	5.7067	5.923	5.7067	5.9081	222750.0
2011-10-24	AAP	Stock	63.29	64.11	62.75	63.55	592000.0
2011-10-24	AAT	Stock	19.34	20.3	19.27	20.0	168000.0
2011-10-24	AATI-DELISTED	Stock	4.47	4.48	4.41	4.48	256273.0
2011-10-24	AAU-DELISTED	Stock	2.39	2.6	2.39	2.57	206472.0
2011-10-24	AAUAF-DELISTED	Stock	2.44	2.64	2.44	2.57	203822.0
2011-10-24	AAV-DELISTED	Stock	4.92	5.23	4.9	5.2	444433.0
2011-10-24	AAWW-DELISTED	Stock	36.73	40.986	36.47	39.29	323731.0
2011-10-24	AAXJ	Stock	52.1	53.34	51.96	52.96	456817.0
2011-10-24	AAXN-DELISTED	Stock	4.79	4.93	4.771	4.89	370854.0
2011-10-24	AB	Stock	14.38	14.53	14.31	14.51	315800.0
2011-10-24	ABAC-DELISTED	Stock	1.35	1.44	1.32	1.4	26055.0
2011-10-24	ABAX-DELISTED	Stock	24.57	25.69	24.26	25.08	119025.0
2011-10-24	ABB-DELISTED	Stock	19.36	19.72	19.34	19.63	1936900.0
2011-10-24	ABBNY-DELISTED	Stock	19.36	19.72	19.34	19.63	1943800.0
2011-10-24	ABC-DELISTED	Stock	39.83	40.65	39.71	40.65	1731268.0
2011-10-24	ABCB	Stock	9.55	9.91	9.49	9.6	113600.0
2011-10-24	ABCD-DELISTED	Stock	3.09	3.28	3.09	3.27	53384.0
2011-10-24	ABCO-DELISTED	Stock	31.22	31.32	30.97	31.08	382932.0
2011-10-24	ABCW-DELISTED	Stock	0.52	0.55	0.49	0.49	41790.0
2011-10-24	ABD-DELISTED	Stock	5.6849	6.0051	5.5047	5.9951	226280.0
2011-10-24	ABE-DELISTED	Stock	17.76	17.76	17.65	17.7191	22953.0
2011-10-24	ABEO	Stock	2100.0	2162.5	2050.0	2162.5	8.0
2011-10-24	ABFS-DELISTED	Stock	18.59	19.46	18.53	19.31	380473.0
2011-10-24	ABG	Stock	19.81	20.7	19.53	20.61	592000.0
2011-10-24	ABH-DELISTED	Stock	15.28	16.725	15.2	16.52	871437.0
2011-10-24	ABM	Stock	19.83	20.51	19.83	20.45	231000.0
2011-10-24	ABMD-DELISTED	Stock	11.72	12.51	11.72	12.49	194753.0
2011-10-24	ABR	Stock	3.51	3.63	3.51	3.59	49300.0
2011-10-24	ABT	Stock	25.7029	25.8324	25.5446	25.6453	22367862.0
2011-10-24	ABTL-DELISTED	Stock	4.45	4.7118	4.3505	4.45	16195.0
2011-10-24	ABUS	Stock	1.7	1.75	1.69	1.7	1800.0
2011-10-24	ABV-DELISTED	Stock	33.695	34.15	33.52	33.9	2825004.0
2011-10-24	ABVA-DELISTED	Stock	5.1	5.132	5.05	5.1	8865.0
2011-10-24	ABVT-DELISTED	Stock	57.72	58.01	56.92	57.7	125514.0
2011-10-24	ABX-DELISTED	Stock	45.25	46.44	45.19	46.3	6721238.0

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

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