PREVIEW / stock_daily / 2012-01-26

all stock daily files

  file:    by_date/stock_daily/2012/2012-01-26.parquet
  size:    197 KB
  rows:    6,142
  symbols: 3,546

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-26	AAPL	Stock	16.0129	16.0282	15.8264	15.8796	323985200.0
2012-01-26	MSFT	Stock	29.61	29.7	29.4	29.5	49102800.0
2012-01-26	NVDA	Stock	0.3768	0.381	0.3658	0.3678	799672000.0
2012-01-26	AMZN	Stock	9.465	9.7425	9.4365	9.666	117472000.0
2012-01-26	TSLA	Stock	1.8713	1.972	1.8667	1.9293	19066500.0
2012-01-26	TLT	Stock	116.65	117.71	116.59	117.71	7638469.0
2012-01-26	ES	Stock	35.05	35.28	34.86	35.27	1529500.0
2012-01-26	CL	Stock	44.93	46.07	44.87	45.675	9754800.0
2012-01-26	A	Stock	31.6667	32.0815	30.3863	30.515	8088409.0
2012-01-26	AABA-DELISTED	Stock	15.66	15.69	15.415	15.53	15153404.0
2012-01-26	AACC-DELISTED	Stock	4.68	4.68	4.28	4.43	5827.0
2012-01-26	AACG	Stock	6.3	6.3	6.3	6.3	200.0
2012-01-26	AAIC-DELISTED	Stock	23.41	23.77	23.08	23.14	75386.0
2012-01-26	AAME	Stock	2.02	2.05	2.02	2.03	5200.0
2012-01-26	AAMRQ-DELISTED	Stock	0.65	0.67	0.6325	0.66	14680828.0
2012-01-26	AAON	Stock	5.9733	6.0444	5.9289	6.0444	126225.0
2012-01-26	AAP	Stock	76.46	76.49	74.89	75.06	577800.0
2012-01-26	AAT	Stock	21.51	21.97	21.36	21.93	83400.0
2012-01-26	AAU-DELISTED	Stock	2.66	2.72	2.5298	2.55	337852.0
2012-01-26	AAUAF-DELISTED	Stock	2.63	2.69	2.5	2.55	342378.0
2012-01-26	AAV-DELISTED	Stock	3.75	3.84	3.68	3.78	670455.0
2012-01-26	AAWW-DELISTED	Stock	45.71	47.46	45.71	46.9	658692.0
2012-01-26	AAXJ	Stock	55.79	56.01	55.19	55.38	890629.0
2012-01-26	AAXN-DELISTED	Stock	4.84	4.84	4.64	4.7	676225.0
2012-01-26	AB	Stock	14.87	15.13	14.86	15.03	349500.0
2012-01-26	ABAC-DELISTED	Stock	1.6	1.7399	1.5999	1.62	7203.0
2012-01-26	ABAX-DELISTED	Stock	28.91	29.24	28.71	29.2	149954.0
2012-01-26	ABB-DELISTED	Stock	21.43	21.47	21.21	21.29	1686363.0
2012-01-26	ABBNY-DELISTED	Stock	21.43	21.47	21.21	21.3	1712480.0
2012-01-26	ABC-DELISTED	Stock	38.88	39.33	37.53	39.01	6369790.0
2012-01-26	ABCB	Stock	10.96	10.96	10.58	10.83	40600.0
2012-01-26	ABCD-DELISTED	Stock	3.21	3.23	3.16	3.2	25136.0
2012-01-26	ABCO-DELISTED	Stock	39.54	39.86	39.44	39.8	146477.0
2012-01-26	ABCW-DELISTED	Stock	0.2761	0.3213	0.2761	0.3012	10870.0
2012-01-26	ABD-DELISTED	Stock	9.8	9.85	9.63	9.65	327750.0
2012-01-26	ABE-DELISTED	Stock	18.49	18.61	18.251	18.43	24139.0
2012-01-26	ABEO	Stock	1587.5	1625.0	1587.5	1625.0	87.0
2012-01-26	ABFS-DELISTED	Stock	22.11	22.79	21.89	22.5	558828.0
2012-01-26	ABG	Stock	23.36	23.49	22.81	23.04	185600.0
2012-01-26	ABH-DELISTED	Stock	14.5	14.55	14.275	14.28	1314577.0
2012-01-26	ABM	Stock	21.83	21.97	21.41	21.76	178000.0
2012-01-26	ABMD-DELISTED	Stock	18.5	18.5	17.9	18.05	248631.0
2012-01-26	ABR	Stock	4.24	4.29	4.21	4.22	26500.0
2012-01-26	ABT	Stock	26.6001	26.6049	26.2595	26.3266	15182159.0
2012-01-26	ABTL-DELISTED	Stock	4.0495	4.3005	4.0495	4.3005	14042.0
2012-01-26	ABUS	Stock	2.35	2.42	2.35	2.42	8800.0
2012-01-26	ABV-DELISTED	Stock	37.19	37.33	36.95	37.13	2533418.0
2012-01-26	ABVA-DELISTED	Stock	3.4	3.44	3.35	3.43	4891.0
2012-01-26	ABVT-DELISTED	Stock	67.0	67.0	66.29	66.64	54955.0
2012-01-26	ABX-DELISTED	Stock	49.48	49.89	48.61	48.84	11727399.0

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

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