PREVIEW / stock_daily / 2012-01-05

all stock daily files

  file:    by_date/stock_daily/2012/2012-01-05.parquet
  size:    196 KB
  rows:    6,134
  symbols: 3,534

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-05	AAPL	Stock	14.8196	14.9482	14.7382	14.9296	271269600.0
2012-01-05	MSFT	Stock	27.38	27.73	27.29	27.68	56081400.0
2012-01-05	NVDA	Stock	0.3533	0.3695	0.3518	0.3678	563548000.0
2012-01-05	AMZN	Stock	8.797	8.9125	8.7025	8.8805	76182000.0
2012-01-05	TSLA	Stock	1.8507	1.862	1.79	1.808	15082500.0
2012-01-05	TLT	Stock	118.17	119.1	117.57	117.8	6465775.0
2012-01-05	ES	Stock	35.11	35.14	34.72	35.05	1954700.0
2012-01-05	CL	Stock	45.08	45.225	44.755	45.07	5232800.0
2012-01-05	A	Stock	25.6652	26.6953	25.5508	26.4664	6842651.0
2012-01-05	AABA-DELISTED	Stock	15.6	15.69	15.44	15.64	18821086.0
2012-01-05	AACC-DELISTED	Stock	4.11	4.2	4.01	4.1	6610.0
2012-01-05	AACG	Stock	7.36	7.36	7.36	7.36	100.0
2012-01-05	AAIC-DELISTED	Stock	20.7	21.14	20.24	21.02	93026.0
2012-01-05	AAME	Stock	1.99	2.03	1.99	2.03	2300.0
2012-01-05	AAMRQ-DELISTED	Stock	0.245	0.3739	0.24	0.335	32265987.0
2012-01-05	AAON	Stock	5.9941	6.0237	5.8489	6.0207	239625.0
2012-01-05	AAP	Stock	70.44	71.42	69.66	71.17	596900.0
2012-01-05	AAT	Stock	20.09	20.62	19.98	20.49	89500.0
2012-01-05	AATI-DELISTED	Stock	5.79	5.79	5.78	5.78	227735.0
2012-01-05	AAU-DELISTED	Stock	2.5	2.5804	2.5	2.55	68940.0
2012-01-05	AAUAF-DELISTED	Stock	2.5	2.55	2.49	2.55	70159.0
2012-01-05	AAV-DELISTED	Stock	4.34	4.37	4.26	4.32	277496.0
2012-01-05	AAWW-DELISTED	Stock	38.85	39.5	38.22	38.7	231690.0
2012-01-05	AAXJ	Stock	50.53	50.97	50.4	50.87	341646.0
2012-01-05	AAXN-DELISTED	Stock	5.13	5.1893	4.95	5.14	572378.0
2012-01-05	AB	Stock	14.1	14.83	14.0	14.8	717800.0
2012-01-05	ABAC-DELISTED	Stock	1.3988	1.41	1.31	1.4	1450.0
2012-01-05	ABAX-DELISTED	Stock	27.89	28.36	27.7	28.0	89330.0
2012-01-05	ABB-DELISTED	Stock	19.61	19.6599	19.475	19.63	1493990.0
2012-01-05	ABBNY-DELISTED	Stock	19.61	19.6599	19.475	19.64	1493990.0
2012-01-05	ABC-DELISTED	Stock	37.89	38.49	37.82	38.48	2336431.0
2012-01-05	ABCB	Stock	10.32	10.42	10.05	10.42	40700.0
2012-01-05	ABCD-DELISTED	Stock	3.04	3.21	2.94	3.13	11677.0
2012-01-05	ABCO-DELISTED	Stock	37.52	38.37	36.84	37.44	257936.0
2012-01-05	ABCW-DELISTED	Stock	0.3615	0.3916	0.3615	0.3815	38130.0
2012-01-05	ABD-DELISTED	Stock	9.57	9.62	9.24	9.36	428620.0
2012-01-05	ABE-DELISTED	Stock	17.81	17.81	17.58	17.7	1220.0
2012-01-05	ABEO	Stock	1737.5	1750.0	1737.5	1750.0	1.0
2012-01-05	ABFS-DELISTED	Stock	19.59	20.15	19.38	19.88	387243.0
2012-01-05	ABG	Stock	21.24	21.7	20.59	21.66	281500.0
2012-01-05	ABH-DELISTED	Stock	15.0	15.07	14.8	14.91	301014.0
2012-01-05	ABM	Stock	20.51	20.51	19.99	20.22	420000.0
2012-01-05	ABMD-DELISTED	Stock	18.02	18.45	17.68	18.27	159638.0
2012-01-05	ABR	Stock	3.49	3.55	3.45	3.49	25700.0
2012-01-05	ABT	Stock	27.1135	27.1519	26.96	27.0463	13119425.0
2012-01-05	ABTL-DELISTED	Stock	3.7118	3.7133	3.6129	3.6882	1336.0
2012-01-05	ABUS	Stock	1.65	1.65	1.62	1.62	2100.0
2012-01-05	ABV-DELISTED	Stock	34.94	35.02	34.68	34.8	2515766.0
2012-01-05	ABVA-DELISTED	Stock	3.5	3.5	3.5	3.5	100.0
2012-01-05	ABVT-DELISTED	Stock	65.52	65.52	64.18	64.5	130040.0

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

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