PREVIEW / stock_daily / 2012-04-11

all stock daily files

  file:    by_date/stock_daily/2012/2012-04-11.parquet
  size:    199 KB
  rows:    6,177
  symbols: 3,543

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-04-11	AAPL	Stock	22.7214	22.7454	22.2621	22.3643	696614800.0
2012-04-11	MSFT	Stock	30.43	30.53	30.23	30.35	43014000.0
2012-04-11	NVDA	Stock	0.3588	0.3662	0.3575	0.3585	372960000.0
2012-04-11	AMZN	Stock	9.4815	9.5985	9.3395	9.3985	86756000.0
2012-04-11	TSLA	Stock	2.216	2.2193	2.134	2.206	16582500.0
2012-04-11	TLT	Stock	115.71	116.06	115.35	115.46	8712928.0
2012-04-11	ES	Stock	36.22	36.24	35.4	35.72	3883300.0
2012-04-11	CL	Stock	48.485	48.705	48.27	48.27	7085000.0
2012-04-11	A	Stock	30.7368	30.8011	30.329	30.3791	3398678.0
2012-04-11	AABA-DELISTED	Stock	15.08	15.08	14.84	14.87	11034938.0
2012-04-11	AACC-DELISTED	Stock	4.98	4.98	4.9	4.95	15416.0
2012-04-11	AACG	Stock	6.97	7.38	6.95	7.38	2300.0
2012-04-11	AAIC-DELISTED	Stock	22.36	22.53	22.11	22.5	56641.0
2012-04-11	AAME	Stock	2.82	2.9	2.78	2.9	3600.0
2012-04-11	AAMRQ-DELISTED	Stock	0.485	0.5	0.485	0.498	1172764.0
2012-04-11	AAON	Stock	5.5556	5.5911	5.4667	5.5852	288225.0
2012-04-11	AAP	Stock	88.69	89.7	88.32	89.66	935800.0
2012-04-11	AAT	Stock	22.4	22.75	22.32	22.74	105000.0
2012-04-11	AAU-DELISTED	Stock	2.35	2.4	2.21	2.27	84254.0
2012-04-11	AAUAF-DELISTED	Stock	2.35	2.4	2.21	2.29	84854.0
2012-04-11	AAV-DELISTED	Stock	2.94	2.95	2.7743	2.82	690337.0
2012-04-11	AAWW-DELISTED	Stock	46.77	47.274	46.0	46.58	258673.0
2012-04-11	AAXJ	Stock	55.4	55.58	55.22	55.35	323803.0
2012-04-11	AAXN-DELISTED	Stock	4.07	4.14	4.07	4.14	319341.0
2012-04-11	AB	Stock	14.43	14.44	14.29	14.39	106700.0
2012-04-11	ABAC-DELISTED	Stock	1.63	1.67	1.63	1.66	4888.0
2012-04-11	ABAX-DELISTED	Stock	27.51	27.62	27.33	27.54	108016.0
2012-04-11	ABB-DELISTED	Stock	19.69	19.69	19.47	19.55	2318223.0
2012-04-11	ABBNY-DELISTED	Stock	19.69	19.69	19.47	19.55	3891912.0
2012-04-11	ABC-DELISTED	Stock	38.72	38.85	38.52	38.76	2473087.0
2012-04-11	ABCB	Stock	12.85	13.11	12.85	13.1	54300.0
2012-04-11	ABCD-DELISTED	Stock	2.38	2.63	2.356	2.63	24334.0
2012-04-11	ABCO-DELISTED	Stock	43.14	43.14	42.5	42.82	221716.0
2012-04-11	ABCW-DELISTED	Stock	0.8032	0.9237	0.8032	0.8836	34440.0
2012-04-11	ABD-DELISTED	Stock	11.45	11.75	11.37	11.69	482350.0
2012-04-11	ABE-DELISTED	Stock	19.2	19.22	19.05	19.05	5011.0
2012-04-11	ABEO	Stock	1425.0	1475.0	1412.5	1475.0	34.0
2012-04-11	ABFS-DELISTED	Stock	18.32	18.66	18.13	18.52	398183.0
2012-04-11	ABG	Stock	26.74	27.43	26.57	27.33	189300.0
2012-04-11	ABH-DELISTED	Stock	13.38	13.6	13.3	13.44	378899.0
2012-04-11	ABM	Stock	23.23	23.42	23.1	23.4	170900.0
2012-04-11	ABMD-DELISTED	Stock	20.72	20.98	20.55	20.9	125173.0
2012-04-11	ABR	Stock	5.16	5.45	5.11	5.42	38400.0
2012-04-11	ABT	Stock	28.716	28.9847	28.5913	28.6249	14080242.0
2012-04-11	ABTL-DELISTED	Stock	4.595	4.6699	4.595	4.605	10593.0
2012-04-11	ABUS	Stock	2.45	2.45	2.36	2.36	2200.0
2012-04-11	ABV-DELISTED	Stock	41.3	42.18	41.17	42.13	3097504.0
2012-04-11	ABVA-DELISTED	Stock	4.18	4.18	4.18	4.18	100.0
2012-04-11	ABVT-DELISTED	Stock	83.16	83.17	82.9	83.0	485510.0
2012-04-11	ABX-DELISTED	Stock	41.87	41.87	40.98	41.03	5147631.0

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

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