PREVIEW / stock_daily / 2012-05-08

all stock daily files

  file:    by_date/stock_daily/2012/2012-05-08.parquet
  size:    200 KB
  rows:    6,204
  symbols: 3,565

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-08	AAPL	Stock	20.3421	20.4107	19.9546	20.2921	497252000.0
2012-05-08	MSFT	Stock	30.48	30.78	30.17	30.5	46328300.0
2012-05-08	NVDA	Stock	0.309	0.3135	0.3035	0.3115	462312000.0
2012-05-08	AMZN	Stock	11.1575	11.2695	10.91	11.195	90448000.0
2012-05-08	TSLA	Stock	2.1667	2.182	1.958	2.0127	46458000.0
2012-05-08	TLT	Stock	118.69	119.51	118.66	118.79	6051598.0
2012-05-08	ES	Stock	35.69	36.26	35.63	36.23	2420200.0
2012-05-08	CL	Stock	49.65	49.73	49.415	49.59	3518000.0
2012-05-08	A	Stock	29.0773	29.1273	28.269	28.8054	5999098.0
2012-05-08	AABA-DELISTED	Stock	15.31	15.44	15.09	15.37	18363623.0
2012-05-08	AACC-DELISTED	Stock	5.56	5.69	5.56	5.65	14257.0
2012-05-08	AACG	Stock	6.75	6.75	6.31	6.45	2600.0
2012-05-08	AAIC-DELISTED	Stock	23.0	23.26	22.92	23.12	60854.0
2012-05-08	AAME	Stock	2.87	2.9	2.77	2.9	3700.0
2012-05-08	AAMRQ-DELISTED	Stock	0.545	0.555	0.521	0.525	1492342.0
2012-05-08	AAON	Stock	5.6326	5.7956	5.6326	5.76	137700.0
2012-05-08	AAP	Stock	90.2	90.2	87.81	89.18	1012000.0
2012-05-08	AAT	Stock	23.82	24.18	23.8	23.99	118300.0
2012-05-08	AAU-DELISTED	Stock	2.08	2.13	1.86	2.03	642969.0
2012-05-08	AAUAF-DELISTED	Stock	2.08	2.13	1.86	2.03	645069.0
2012-05-08	AAV-DELISTED	Stock	3.2	3.2	3.05	3.16	213437.0
2012-05-08	AAWW-DELISTED	Stock	50.46	51.09	50.12	51.0	240479.0
2012-05-08	AAXJ	Stock	55.11	55.13	54.27	54.83	337434.0
2012-05-08	AAXN-DELISTED	Stock	4.78	5.06	4.73	5.06	977160.0
2012-05-08	AB	Stock	14.27	14.39	14.14	14.27	149600.0
2012-05-08	ABAC-DELISTED	Stock	1.68	1.78	1.631	1.67	13975.0
2012-05-08	ABAX-DELISTED	Stock	34.51	35.17	34.33	35.08	68168.0
2012-05-08	ABB-DELISTED	Stock	17.43	17.6	17.3	17.57	2515278.0
2012-05-08	ABBNY-DELISTED	Stock	17.43	17.6	17.3	17.56	2538575.0
2012-05-08	ABC-DELISTED	Stock	35.68	36.22	35.48	36.17	4735137.0
2012-05-08	ABCB	Stock	11.92	12.36	11.92	12.23	42100.0
2012-05-08	ABCD-DELISTED	Stock	2.11	2.32	2.0	2.06	34989.0
2012-05-08	ABCO-DELISTED	Stock	46.25	46.85	45.91	46.47	295770.0
2012-05-08	ABCW-DELISTED	Stock	0.7028	0.7028	0.6024	0.6526	25690.0
2012-05-08	ABE-DELISTED	Stock	19.22	19.318	19.19	19.31	3578.0
2012-05-08	ABEO	Stock	1175.0	1200.0	1100.0	1187.5	31.0
2012-05-08	ABFS-DELISTED	Stock	14.4	14.645	14.17	14.3	422212.0
2012-05-08	ABG	Stock	26.49	26.49	25.46	25.64	459800.0
2012-05-08	ABH-DELISTED	Stock	12.3	12.41	12.07	12.09	263768.0
2012-05-08	ABM	Stock	22.3	22.68	22.3	22.6	134400.0
2012-05-08	ABMD-DELISTED	Stock	23.21	23.5	22.86	23.11	439249.0
2012-05-08	ABR	Stock	6.25	6.26	6.04	6.22	54200.0
2012-05-08	ABT	Stock	29.858	30.0739	29.6516	30.0355	13424552.0
2012-05-08	ABTL-DELISTED	Stock	3.9639	4.1512	3.8981	4.05	19824.0
2012-05-08	ABUS	Stock	2.29	2.36	2.29	2.36	5500.0
2012-05-08	ABV-DELISTED	Stock	41.5	41.55	40.79	40.989	2846659.0
2012-05-08	ABVA-DELISTED	Stock	4.43	4.52	4.42	4.5	22275.0
2012-05-08	ABVT-DELISTED	Stock	83.16	83.2	83.14	83.16	350942.0
2012-05-08	ABX-DELISTED	Stock	37.26	37.4	36.2	36.72	9523726.0
2012-05-08	ACAD	Stock	1.49	1.54	1.45	1.54	209100.0

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

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