PREVIEW / stock_daily / 2012-05-10

all stock daily files

  file:    by_date/stock_daily/2012/2012-05-10.parquet
  size:    197 KB
  rows:    6,162
  symbols: 3,532

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-05-10	AAPL	Stock	20.5207	20.5671	20.3014	20.3757	333200000.0
2012-05-10	MSFT	Stock	30.86	31.02	30.45	30.74	43839200.0
2012-05-10	NVDA	Stock	0.3158	0.3163	0.3055	0.3105	597092000.0
2012-05-10	AMZN	Stock	11.1955	11.454	11.0975	11.3345	92968000.0
2012-05-10	TSLA	Stock	2.198	2.312	2.16	2.1973	83344500.0
2012-05-10	TLT	Stock	118.02	118.62	117.44	118.52	6303209.0
2012-05-10	ES	Stock	36.3	36.54	36.09	36.46	1388100.0
2012-05-10	CL	Stock	49.765	49.995	49.565	49.825	4669400.0
2012-05-10	A	Stock	29.0486	29.2561	28.3834	28.4263	3291731.0
2012-05-10	AABA-DELISTED	Stock	15.4	15.54	15.3	15.44	10874647.0
2012-05-10	AACC-DELISTED	Stock	5.7	5.95	5.66	5.95	17966.0
2012-05-10	AACG	Stock	6.5	6.5	6.5	6.5	100.0
2012-05-10	AAIC-DELISTED	Stock	23.28	23.37	23.12	23.3	43126.0
2012-05-10	AAME	Stock	2.9	2.9	2.87	2.9	900.0
2012-05-10	AAMRQ-DELISTED	Stock	0.507	0.51	0.4852	0.49	3075494.0
2012-05-10	AAON	Stock	5.763	5.7956	5.6415	5.7422	280125.0
2012-05-10	AAP	Stock	88.91	89.83	88.43	89.07	718000.0
2012-05-10	AAT	Stock	24.01	24.14	23.73	23.97	138100.0
2012-05-10	AAU-DELISTED	Stock	2.05	2.1109	2.02	2.02	98900.0
2012-05-10	AAUAF-DELISTED	Stock	2.03	2.09	2.0	2.02	100393.0
2012-05-10	AAV-DELISTED	Stock	3.29	3.34	3.19	3.21	226551.0
2012-05-10	AAWW-DELISTED	Stock	49.72	50.9715	48.82	49.24	240377.0
2012-05-10	AAXJ	Stock	54.52	54.52	54.13	54.19	650342.0
2012-05-10	AAXN-DELISTED	Stock	5.06	5.25	4.98	5.25	637561.0
2012-05-10	AB	Stock	14.35	15.18	14.18	14.82	341300.0
2012-05-10	ABAC-DELISTED	Stock	1.64	1.73	1.63	1.63	4200.0
2012-05-10	ABAX-DELISTED	Stock	34.8	35.36	34.53	34.89	52459.0
2012-05-10	ABB-DELISTED	Stock	17.3	17.36	17.08	17.13	3440212.0
2012-05-10	ABBNY-DELISTED	Stock	17.3	17.36	17.08	17.14	3692153.0
2012-05-10	ABC-DELISTED	Stock	36.36	37.12	36.28	36.58	4669907.0
2012-05-10	ABCB	Stock	12.38	12.68	12.35	12.52	31000.0
2012-05-10	ABCD-DELISTED	Stock	1.9	2.05	1.9	2.05	6999.0
2012-05-10	ABCO-DELISTED	Stock	46.25	46.5	45.84	46.48	290964.0
2012-05-10	ABCW-DELISTED	Stock	0.7129	0.7129	0.5824	0.6526	17220.0
2012-05-10	ABE-DELISTED	Stock	19.4	19.4	19.01	19.24	9564.0
2012-05-10	ABEO	Stock	1125.0	1137.5	1000.0	1100.0	36.0
2012-05-10	ABFS-DELISTED	Stock	14.01	14.1295	13.51	13.56	380264.0
2012-05-10	ABG	Stock	26.24	26.78	26.09	26.53	276100.0
2012-05-10	ABH-DELISTED	Stock	11.63	11.72	11.0	11.38	413751.0
2012-05-10	ABM	Stock	22.72	22.91	22.59	22.73	171000.0
2012-05-10	ABMD-DELISTED	Stock	23.81	24.39	23.76	24.0	367449.0
2012-05-10	ABR	Stock	6.2	6.2	6.1	6.17	50100.0
2012-05-10	ABT	Stock	29.5509	29.9395	29.5317	29.8532	14424343.0
2012-05-10	ABTL-DELISTED	Stock	4.0051	4.0608	3.8051	4.0	18574.0
2012-05-10	ABUS	Stock	2.28	2.29	2.24	2.24	9100.0
2012-05-10	ABV-DELISTED	Stock	40.18	40.5	39.6	39.78	2848728.0
2012-05-10	ABVA-DELISTED	Stock	4.45	4.5	4.45	4.49	21700.0
2012-05-10	ABVT-DELISTED	Stock	83.22	83.25	83.16	83.23	319353.0
2012-05-10	ABX-DELISTED	Stock	38.1	38.24	37.39	37.77	7715817.0
2012-05-10	ACAD	Stock	1.48	1.54	1.47	1.5	92000.0

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

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