PREVIEW / stock_daily / 2012-02-01

all stock daily files

  file:    by_date/stock_daily/2012/2012-02-01.parquet
  size:    199 KB
  rows:    6,174
  symbols: 3,563

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-02-01	AAPL	Stock	16.3718	16.3925	16.2696	16.2925	270046000.0
2012-02-01	MSFT	Stock	29.79	30.05	29.76	29.89	67409900.0
2012-02-01	NVDA	Stock	0.3735	0.3775	0.3682	0.3733	428020000.0
2012-02-01	AMZN	Stock	8.6905	8.9975	8.6	8.973	426732000.0
2012-02-01	TSLA	Stock	1.938	1.98	1.9333	1.972	7848000.0
2012-02-01	TLT	Stock	119.75	119.9	118.811	119.18	7926220.0
2012-02-01	ES	Stock	34.85	35.29	34.76	35.16	1398300.0
2012-02-01	CL	Stock	45.545	45.875	45.385	45.565	4334400.0
2012-02-01	A	Stock	30.8155	31.774	30.7368	31.6094	5801700.0
2012-02-01	AABA-DELISTED	Stock	15.57	15.8	15.53	15.72	13157214.0
2012-02-01	AACC-DELISTED	Stock	4.79	4.87	4.63	4.67	26389.0
2012-02-01	AACG	Stock	6.66	6.91	6.65	6.65	3900.0
2012-02-01	AAIC-DELISTED	Stock	22.58	23.19	22.58	23.13	39174.0
2012-02-01	AAME	Stock	2.05	2.05	2.02	2.04	6000.0
2012-02-01	AAMRQ-DELISTED	Stock	0.6785	0.679	0.53	0.592	34972877.0
2012-02-01	AAON	Stock	6.0593	6.3289	6.0059	6.3052	298688.0
2012-02-01	AAP	Stock	77.08	77.55	76.44	76.66	769800.0
2012-02-01	AAT	Stock	22.28	22.71	21.91	22.64	167100.0
2012-02-01	AAU-DELISTED	Stock	2.54	2.62	2.48	2.48	110611.0
2012-02-01	AAUAF-DELISTED	Stock	2.54	2.62	2.48	2.48	110911.0
2012-02-01	AAV-DELISTED	Stock	3.55	3.6	3.52	3.58	539542.0
2012-02-01	AAWW-DELISTED	Stock	48.08	49.47	47.83	49.07	442790.0
2012-02-01	AAXJ	Stock	55.81	56.35	55.7608	56.02	313465.0
2012-02-01	AAXN-DELISTED	Stock	4.78	4.96	4.76	4.95	427212.0
2012-02-01	AB	Stock	15.33	15.49	15.2	15.49	337700.0
2012-02-01	ABAC-DELISTED	Stock	1.5601	1.7	1.5601	1.6	12500.0
2012-02-01	ABAX-DELISTED	Stock	27.0	27.74	26.7426	27.57	128122.0
2012-02-01	ABB-DELISTED	Stock	21.34	21.75	21.27	21.575	2835037.0
2012-02-01	ABBNY-DELISTED	Stock	21.34	21.75	21.27	21.57	2839267.0
2012-02-01	ABC-DELISTED	Stock	39.23	39.9	39.13	39.8	2369854.0
2012-02-01	ABCB	Stock	10.81	10.85	10.68	10.77	88900.0
2012-02-01	ABCD-DELISTED	Stock	3.26	3.285	3.18	3.2	47269.0
2012-02-01	ABCO-DELISTED	Stock	38.65	38.8	37.91	38.23	335640.0
2012-02-01	ABCW-DELISTED	Stock	0.3012	0.3213	0.3012	0.3113	17210.0
2012-02-01	ABD-DELISTED	Stock	10.73	10.9	10.64	10.83	587960.0
2012-02-01	ABE-DELISTED	Stock	18.8	19.06	18.8	19.06	7144.0
2012-02-01	ABEO	Stock	1687.5	1725.0	1687.5	1712.5	63.0
2012-02-01	ABFS-DELISTED	Stock	18.35	19.04	18.0	18.85	460082.0
2012-02-01	ABG	Stock	23.15	23.65	23.14	23.35	267400.0
2012-02-01	ABH-DELISTED	Stock	14.54	14.9	14.49	14.75	520020.0
2012-02-01	ABM	Stock	21.8	22.4	21.73	22.4	345500.0
2012-02-01	ABMD-DELISTED	Stock	18.64	19.09	18.311	18.99	701587.0
2012-02-01	ABR	Stock	4.27	4.27	4.16	4.17	32700.0
2012-02-01	ABT	Stock	26.0339	26.1491	25.9284	26.0339	29235515.0
2012-02-01	ABTL-DELISTED	Stock	4.7632	4.8409	4.2558	4.45	56690.0
2012-02-01	ABUS	Stock	1.93	2.1	1.92	2.09	8900.0
2012-02-01	ABV-DELISTED	Stock	36.95	37.67	36.9	37.41	2874751.0
2012-02-01	ABVA-DELISTED	Stock	3.46	3.49	3.45	3.49	35160.0
2012-02-01	ABVT-DELISTED	Stock	66.8	68.48	66.8	68.26	142613.0
2012-02-01	ABX-DELISTED	Stock	49.92	49.98	49.04	49.28	5396163.0

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

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