PREVIEW / stock_daily / 2011-12-15

all stock daily files

  file:    by_date/stock_daily/2011/2011-12-15.parquet
  size:    197 KB
  rows:    6,157
  symbols: 3,558

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
2011-12-15	AAPL	Stock	13.6904	13.705	13.5111	13.5336	256200000.0
2011-12-15	MSFT	Stock	25.72	25.88	25.54	25.56	46213900.0
2011-12-15	NVDA	Stock	0.3453	0.3475	0.3358	0.3365	435148000.0
2011-12-15	AMZN	Stock	9.1025	9.24	8.9765	9.063	145198000.0
2011-12-15	TSLA	Stock	1.9113	1.9447	1.8747	1.908	10504500.0
2011-12-15	TLT	Stock	120.66	121.32	120.37	120.91	5438609.0
2011-12-15	ES	Stock	34.58	34.88	34.5	34.68	1206400.0
2011-12-15	CL	Stock	44.89	45.4	44.795	45.29	3940800.0
2011-12-15	A	Stock	23.9843	24.1631	23.7411	23.927	4477375.0
2011-12-15	AABA-DELISTED	Stock	15.18	15.29	15.01	15.165	14749167.0
2011-12-15	AACC-DELISTED	Stock	3.62	3.65	3.47	3.51	15139.0
2011-12-15	AACG	Stock	8.41	9.0	8.22	8.85	10400.0
2011-12-15	AAIC-DELISTED	Stock	21.89	22.33	21.61	22.33	63093.0
2011-12-15	AAME	Stock	2.01	2.01	1.94	2.0	1700.0
2011-12-15	AAON	Stock	6.2726	6.4207	6.1689	6.3319	208238.0
2011-12-15	AAP	Stock	67.57	68.17	67.34	67.71	617400.0
2011-12-15	AAT	Stock	20.17	20.39	20.07	20.38	142400.0
2011-12-15	AATI-DELISTED	Stock	5.75	5.76	5.74	5.74	962422.0
2011-12-15	AAU-DELISTED	Stock	2.14	2.18	2.02	2.07	193818.0
2011-12-15	AAUAF-DELISTED	Stock	2.18	2.18	2.02	2.07	195118.0
2011-12-15	AAV-DELISTED	Stock	3.85	3.94	3.68	3.68	473313.0
2011-12-15	AAWW-DELISTED	Stock	36.59	37.3	35.67	36.72	225245.0
2011-12-15	AAXJ	Stock	49.58	49.76	49.13	49.2	455091.0
2011-12-15	AAXN-DELISTED	Stock	5.82	5.83	5.66	5.67	513883.0
2011-12-15	AB	Stock	12.94	13.12	12.81	13.0	607800.0
2011-12-15	ABAC-DELISTED	Stock	1.35	1.54	1.35	1.39	19070.0
2011-12-15	ABAX-DELISTED	Stock	26.74	27.19	25.6	27.1	79697.0
2011-12-15	ABB-DELISTED	Stock	17.9	17.94	17.5615	17.72	1692905.0
2011-12-15	ABBNY-DELISTED	Stock	17.9	17.94	17.5615	17.72	1696379.0
2011-12-15	ABC-DELISTED	Stock	35.86	36.31	35.72	35.78	1821074.0
2011-12-15	ABCB	Stock	10.29	10.36	10.07	10.28	40700.0
2011-12-15	ABCD-DELISTED	Stock	2.87	2.95	2.7	2.77	37569.0
2011-12-15	ABCO-DELISTED	Stock	35.06	36.44	35.06	36.04	125692.0
2011-12-15	ABCW-DELISTED	Stock	0.3564	0.3715	0.3524	0.3615	43210.0
2011-12-15	ABD-DELISTED	Stock	9.96	9.96	9.599	9.66	431700.0
2011-12-15	ABE-DELISTED	Stock	17.04	17.18	16.78	16.807	13749.0
2011-12-15	ABEO	Stock	1750.0	1812.5	1725.0	1812.5	40.0
2011-12-15	ABFS-DELISTED	Stock	17.37	17.7982	17.3	17.67	336419.0
2011-12-15	ABG	Stock	20.19	20.3	19.8	19.89	245400.0
2011-12-15	ABH-DELISTED	Stock	14.96	14.97	14.43	14.8	419647.0
2011-12-15	ABM	Stock	20.66	20.79	20.38	20.55	540600.0
2011-12-15	ABMD-DELISTED	Stock	20.3	20.3782	19.72	19.77	230306.0
2011-12-15	ABR	Stock	3.28	3.28	3.2	3.2	36500.0
2011-12-15	ABT	Stock	26.2211	26.3602	26.1827	26.3362	17019800.0
2011-12-15	ABTL-DELISTED	Stock	3.9451	3.9456	3.6974	3.9	670.0
2011-12-15	ABUS	Stock	1.62	1.67	1.6	1.6	6200.0
2011-12-15	ABV-DELISTED	Stock	35.49	35.81	35.26	35.7	2038334.0
2011-12-15	ABVA-DELISTED	Stock	3.57	3.5912	3.57	3.59	2053.0
2011-12-15	ABVT-DELISTED	Stock	64.64	65.21	63.86	65.0	159866.0
2011-12-15	ABX-DELISTED	Stock	44.99	45.5	44.12	44.17	8457291.0

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

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