PREVIEW / stock_daily / 2012-04-23

all stock daily files

  file:    by_date/stock_daily/2012/2012-04-23.parquet
  size:    199 KB
  rows:    6,167
  symbols: 3,545

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-04-23	AAPL	Stock	20.3789	20.5954	19.8793	20.4179	966529200.0
2012-04-23	MSFT	Stock	32.31	32.5	32.03	32.12	61398200.0
2012-04-23	NVDA	Stock	0.329	0.3322	0.3228	0.3308	706244000.0
2012-04-23	AMZN	Stock	9.4495	9.4495	9.2755	9.412	69620000.0
2012-04-23	TSLA	Stock	2.1907	2.198	2.114	2.1293	13362000.0
2012-04-23	TLT	Stock	118.11	118.41	117.795	117.92	5170664.0
2012-04-23	ES	Stock	36.22	36.22	36.04	36.08	2092600.0
2012-04-23	CL	Stock	49.085	49.09	48.62	48.86	3243200.0
2012-04-23	A	Stock	29.5851	29.6137	29.0129	29.5207	3058824.0
2012-04-23	AABA-DELISTED	Stock	15.41	15.47	15.29	15.33	21265585.0
2012-04-23	AACC-DELISTED	Stock	4.99	5.15	4.8201	5.0	16373.0
2012-04-23	AACG	Stock	6.36	6.4	6.35	6.35	3900.0
2012-04-23	AAIC-DELISTED	Stock	22.97	23.04	22.82	22.9	68021.0
2012-04-23	AAME	Stock	2.96	2.96	2.96	2.96	100.0
2012-04-23	AAMRQ-DELISTED	Stock	0.559	0.58	0.541	0.562	3218765.0
2012-04-23	AAON	Stock	5.6356	5.7007	5.5556	5.6326	210938.0
2012-04-23	AAP	Stock	90.59	90.78	89.32	90.59	599000.0
2012-04-23	AAT	Stock	22.56	22.64	22.45	22.5	79800.0
2012-04-23	AAU-DELISTED	Stock	2.18	2.22	2.13	2.19	107987.0
2012-04-23	AAUAF-DELISTED	Stock	2.21	2.25	2.16	2.19	106735.0
2012-04-23	AAV-DELISTED	Stock	2.82	2.89	2.8	2.83	186352.0
2012-04-23	AAWW-DELISTED	Stock	44.42	44.93	43.75	44.43	175664.0
2012-04-23	AAXJ	Stock	55.06	55.22	54.65	55.18	682286.0
2012-04-23	AAXN-DELISTED	Stock	4.02	4.05	4.0	4.02	210614.0
2012-04-23	AB	Stock	14.06	14.12	14.0	14.07	209400.0
2012-04-23	ABAC-DELISTED	Stock	1.91	2.0	1.9	1.96	21222.0
2012-04-23	ABAX-DELISTED	Stock	29.16	29.66	28.85	29.02	162455.0
2012-04-23	ABB-DELISTED	Stock	19.83	19.89	19.56	19.8725	3966360.0
2012-04-23	ABBNY-DELISTED	Stock	19.83	19.89	19.56	19.86	4214767.0
2012-04-23	ABC-DELISTED	Stock	36.4	37.68	36.28	37.5	2702486.0
2012-04-23	ABCB	Stock	12.72	12.86	12.72	12.74	63600.0
2012-04-23	ABCD-DELISTED	Stock	2.43	2.43	2.32	2.34	22109.0
2012-04-23	ABCO-DELISTED	Stock	44.05	44.38	43.47	44.04	156083.0
2012-04-23	ABCW-DELISTED	Stock	0.7129	0.753	0.6828	0.6828	3420.0
2012-04-23	ABD-DELISTED	Stock	10.92	10.92	10.56	10.68	946130.0
2012-04-23	ABE-DELISTED	Stock	19.05	19.05	18.93	19.0	5367.0
2012-04-23	ABEO	Stock	1375.0	1462.5	1362.5	1437.5	13.0
2012-04-23	ABFS-DELISTED	Stock	17.38	17.5375	17.11	17.47	249078.0
2012-04-23	ABG	Stock	26.08	26.54	25.49	26.35	585600.0
2012-04-23	ABH-DELISTED	Stock	12.98	13.07	12.79	13.05	222896.0
2012-04-23	ABM	Stock	22.87	22.91	22.53	22.78	187800.0
2012-04-23	ABMD-DELISTED	Stock	21.32	22.31	21.09	22.24	507630.0
2012-04-23	ABR	Stock	5.49	5.57	5.37	5.54	24700.0
2012-04-23	ABT	Stock	28.5721	28.7592	28.4761	28.7256	14942059.0
2012-04-23	ABTL-DELISTED	Stock	4.6	4.6	4.5233	4.6	1410.0
2012-04-23	ABUS	Stock	2.32	2.35	2.19	2.19	4200.0
2012-04-23	ABV-DELISTED	Stock	43.74	43.8	42.54	43.52	3748473.0
2012-04-23	ABVA-DELISTED	Stock	4.13	4.13	4.03	4.03	2140.0
2012-04-23	ABVT-DELISTED	Stock	83.01	83.133	82.97	83.04	233682.0
2012-04-23	ABX-DELISTED	Stock	39.72	39.78	38.46	39.68	9162963.0

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

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