PREVIEW / stock_daily / 2012-05-11

all stock daily files

  file:    by_date/stock_daily/2012/2012-05-11.parquet
  size:    198 KB
  rows:    6,167
  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-05-11	AAPL	Stock	20.1786	20.5168	20.1554	20.2396	399546000.0
2012-05-11	MSFT	Stock	30.69	31.54	30.69	31.16	43459300.0
2012-05-11	NVDA	Stock	0.3362	0.342	0.329	0.3303	1435140000.0
2012-05-11	AMZN	Stock	11.2975	11.534	11.2865	11.384	83872000.0
2012-05-11	TSLA	Stock	2.166	2.2293	2.144	2.15	18319500.0
2012-05-11	TLT	Stock	119.49	119.6	118.96	119.5	5236222.0
2012-05-11	ES	Stock	36.34	36.74	36.33	36.57	1283400.0
2012-05-11	CL	Stock	49.75	49.905	49.65	49.655	4174600.0
2012-05-11	A	Stock	28.2761	28.8197	28.1831	28.2189	5398796.0
2012-05-11	AABA-DELISTED	Stock	14.87	15.44	14.8	15.2	20580728.0
2012-05-11	AACC-DELISTED	Stock	5.93	6.0	5.71	5.81	49154.0
2012-05-11	AAIC-DELISTED	Stock	23.14	23.37	23.121	23.28	36330.0
2012-05-11	AAME	Stock	2.88	2.9	2.82	2.87	900.0
2012-05-11	AAMRQ-DELISTED	Stock	0.488	0.53	0.486	0.52	2306741.0
2012-05-11	AAON	Stock	5.6622	5.7926	5.6296	5.68	119138.0
2012-05-11	AAP	Stock	88.66	90.23	88.15	88.42	708400.0
2012-05-11	AAT	Stock	23.74	24.08	23.71	23.89	57000.0
2012-05-11	AAU-DELISTED	Stock	2.0	2.039	1.991	2.0	64339.0
2012-05-11	AAUAF-DELISTED	Stock	2.0	2.039	1.991	2.0	64739.0
2012-05-11	AAV-DELISTED	Stock	3.17	3.22	3.1	3.12	129588.0
2012-05-11	AAWW-DELISTED	Stock	48.65	49.82	48.65	49.26	201075.0
2012-05-11	AAXJ	Stock	53.57	54.04	53.47	53.53	208160.0
2012-05-11	AAXN-DELISTED	Stock	5.17	5.34	5.11	5.19	559317.0
2012-05-11	AB	Stock	14.74	15.02	14.54	14.76	150000.0
2012-05-11	ABAC-DELISTED	Stock	1.62	1.7	1.52	1.6001	51941.0
2012-05-11	ABAX-DELISTED	Stock	34.64	35.01	34.31	34.82	70950.0
2012-05-11	ABB-DELISTED	Stock	16.76	17.04	16.72	16.84	3481518.0
2012-05-11	ABBNY-DELISTED	Stock	16.76	17.04	16.72	16.84	3886053.0
2012-05-11	ABC-DELISTED	Stock	36.45	37.03	36.45	36.62	1843617.0
2012-05-11	ABCB	Stock	12.37	12.59	12.22	12.4	47700.0
2012-05-11	ABCD-DELISTED	Stock	2.05	2.14	1.91	1.95	24347.0
2012-05-11	ABCO-DELISTED	Stock	46.46	47.24	46.3	46.97	296931.0
2012-05-11	ABCW-DELISTED	Stock	0.733	0.733	0.6526	0.6526	8470.0
2012-05-11	ABE-DELISTED	Stock	19.16	19.2	19.0	19.05	8524.0
2012-05-11	ABEO	Stock	1100.0	1100.0	1012.5	1100.0	21.0
2012-05-11	ABFS-DELISTED	Stock	13.49	13.56	13.31	13.42	355163.0
2012-05-11	ABG	Stock	26.23	26.7	26.02	26.07	300000.0
2012-05-11	ABH-DELISTED	Stock	11.32	11.44	11.29	11.35	266607.0
2012-05-11	ABM	Stock	22.51	22.79	22.42	22.57	128000.0
2012-05-11	ABMD-DELISTED	Stock	23.72	24.0	23.06	23.18	440119.0
2012-05-11	ABR	Stock	6.1	6.2	6.06	6.19	59000.0
2012-05-11	ABT	Stock	29.7764	29.9491	29.7572	29.7668	9041476.0
2012-05-11	ABTL-DELISTED	Stock	3.8569	4.0066	3.8078	3.9931	13920.0
2012-05-11	ABUS	Stock	2.28	2.28	2.23	2.23	1000.0
2012-05-11	ABV-DELISTED	Stock	39.58	40.02	39.3	39.41	2403298.0
2012-05-11	ABVA-DELISTED	Stock	4.49	4.5	4.49	4.5	2900.0
2012-05-11	ABVT-DELISTED	Stock	83.2	83.29	83.19	83.26	282478.0
2012-05-11	ABX-DELISTED	Stock	37.45	37.81	37.0	37.04	5970490.0
2012-05-11	ACAD	Stock	1.49	1.55	1.49	1.52	135000.0
2012-05-11	ACAS-DELISTED	Stock	9.64	9.84	9.6	9.71	2384796.0

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

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