PREVIEW / stock_daily / 2012-01-24

all stock daily files

  file:    by_date/stock_daily/2012/2012-01-24.parquet
  size:    197 KB
  rows:    6,144
  symbols: 3,540

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-01-24	AAPL	Stock	15.1821	15.1821	14.9839	15.0146	547638000.0
2012-01-24	MSFT	Stock	29.47	29.57	29.18	29.34	51703300.0
2012-01-24	NVDA	Stock	0.3628	0.375	0.3625	0.3735	730920000.0
2012-01-24	AMZN	Stock	9.25	9.4205	9.191	9.35	93476000.0
2012-01-24	TSLA	Stock	1.7753	1.8453	1.7627	1.828	12870000.0
2012-01-24	TLT	Stock	116.71	116.71	115.78	116.45	5776852.0
2012-01-24	ES	Stock	34.3	34.63	34.22	34.55	2124800.0
2012-01-24	CL	Stock	43.865	44.2	43.61	44.125	5123200.0
2012-01-24	A	Stock	29.2704	30.7511	29.1845	30.4721	7632661.0
2012-01-24	AABA-DELISTED	Stock	15.57	15.75	15.55	15.67	16491038.0
2012-01-24	AACC-DELISTED	Stock	4.49	4.52	4.29	4.4	11997.0
2012-01-24	AACG	Stock	6.25	6.25	6.1	6.18	1600.0
2012-01-24	AAIC-DELISTED	Stock	22.72	23.29	22.49	23.28	70187.0
2012-01-24	AAME	Stock	2.02	2.03	2.0	2.0	4100.0
2012-01-24	AAMRQ-DELISTED	Stock	0.5849	0.74	0.55	0.57	37025087.0
2012-01-24	AAON	Stock	5.8104	5.9585	5.7363	5.9348	157613.0
2012-01-24	AAP	Stock	74.69	75.34	74.26	75.23	615100.0
2012-01-24	AAT	Stock	21.39	21.63	21.31	21.47	176200.0
2012-01-24	AAU-DELISTED	Stock	2.55	2.6	2.42	2.46	131948.0
2012-01-24	AAUAF-DELISTED	Stock	2.55	2.6	2.42	2.46	133148.0
2012-01-24	AAV-DELISTED	Stock	3.64	3.65	3.55	3.62	807737.0
2012-01-24	AAWW-DELISTED	Stock	42.9	43.34	42.2	43.08	184866.0
2012-01-24	AAXJ	Stock	54.59	55.0	54.35	54.98	169989.0
2012-01-24	AAXN-DELISTED	Stock	4.89	4.89	4.8	4.86	338630.0
2012-01-24	AB	Stock	15.24	15.33	15.1	15.15	278100.0
2012-01-24	ABAC-DELISTED	Stock	1.66	1.685	1.62	1.62	23430.0
2012-01-24	ABAX-DELISTED	Stock	28.01	28.37	27.85	28.31	112554.0
2012-01-24	ABB-DELISTED	Stock	20.53	20.89	20.48	20.879	1891951.0
2012-01-24	ABBNY-DELISTED	Stock	20.53	20.89	20.48	20.89	2120574.0
2012-01-24	ABC-DELISTED	Stock	39.63	39.75	39.47	39.55	1934801.0
2012-01-24	ABCB	Stock	10.8	10.9	10.74	10.89	41400.0
2012-01-24	ABCD-DELISTED	Stock	3.06	3.2	3.06	3.19	14769.0
2012-01-24	ABCO-DELISTED	Stock	39.17	39.86	39.02	39.7	146294.0
2012-01-24	ABCW-DELISTED	Stock	0.251	0.3012	0.251	0.3012	23850.0
2012-01-24	ABD-DELISTED	Stock	9.83	9.98	9.75	9.8	427630.0
2012-01-24	ABE-DELISTED	Stock	18.32	18.35	18.21	18.31	7905.0
2012-01-24	ABEO	Stock	1600.0	1675.0	1500.0	1625.0	96.0
2012-01-24	ABFS-DELISTED	Stock	21.49	21.9	21.3808	21.69	280403.0
2012-01-24	ABG	Stock	23.13	23.5	23.0	23.2	343500.0
2012-01-24	ABH-DELISTED	Stock	14.89	14.9	14.68	14.74	401335.0
2012-01-24	ABM	Stock	21.51	21.83	21.3	21.64	243000.0
2012-01-24	ABMD-DELISTED	Stock	17.68	18.08	17.23	18.07	284969.0
2012-01-24	ABR	Stock	4.26	4.34	4.22	4.24	23200.0
2012-01-24	ABT	Stock	26.7249	26.864	26.7249	26.8592	15769070.0
2012-01-24	ABTL-DELISTED	Stock	3.95	3.95	3.75	3.9	21078.0
2012-01-24	ABUS	Stock	2.5	2.5	2.36	2.46	8900.0
2012-01-24	ABV-DELISTED	Stock	36.79	37.27	36.74	37.04	2560658.0
2012-01-24	ABVA-DELISTED	Stock	3.4	3.5	3.4	3.46	4087.0
2012-01-24	ABVT-DELISTED	Stock	65.59	67.02	65.29	66.92	82559.0
2012-01-24	ABX-DELISTED	Stock	46.15	46.28	45.3	45.44	6871483.0

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

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