PREVIEW / stock_daily / 2012-02-28

all stock daily files

  file:    by_date/stock_daily/2012/2012-02-28.parquet
  size:    200 KB
  rows:    6,179
  symbols: 3,556

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-02-28	AAPL	Stock	18.8557	19.1218	18.7804	19.1218	600387200.0
2012-02-28	MSFT	Stock	31.41	31.93	31.38	31.87	45230600.0
2012-02-28	NVDA	Stock	0.3868	0.3913	0.3793	0.3833	699884000.0
2012-02-28	AMZN	Stock	8.945	9.2145	8.8975	9.19	115290000.0
2012-02-28	TSLA	Stock	2.2427	2.296	2.2113	2.254	9183000.0
2012-02-28	TLT	Stock	118.87	119.14	117.94	118.15	6615652.0
2012-02-28	ES	Stock	35.49	35.54	35.18	35.37	1861000.0
2012-02-28	CL	Stock	46.335	46.52	46.14	46.485	3728200.0
2012-02-28	A	Stock	31.1159	31.2661	30.8941	31.2089	2960545.0
2012-02-28	AABA-DELISTED	Stock	14.94	14.99	14.76	14.9	14485279.0
2012-02-28	AACC-DELISTED	Stock	4.63	4.88	4.58	4.75	35463.0
2012-02-28	AACG	Stock	5.64	6.9	5.52	6.2	42000.0
2012-02-28	AAIC-DELISTED	Stock	22.91	23.23	22.91	23.04	53047.0
2012-02-28	AAME	Stock	2.25	3.03	2.25	2.71	111300.0
2012-02-28	AAMRQ-DELISTED	Stock	0.511	0.519	0.51	0.515	1719099.0
2012-02-28	AAON	Stock	5.7689	5.8548	5.6533	5.68	76950.0
2012-02-28	AAP	Stock	84.56	86.09	84.42	85.77	814300.0
2012-02-28	AAT	Stock	22.24	22.31	21.86	21.95	65400.0
2012-02-28	AAU-DELISTED	Stock	2.87	3.33	2.83	3.24	850814.0
2012-02-28	AAUAF-DELISTED	Stock	2.87	3.33	2.83	3.25	853114.0
2012-02-28	AAV-DELISTED	Stock	3.97	4.0	3.88	3.9	341281.0
2012-02-28	AAWW-DELISTED	Stock	42.97	43.83	42.58	43.0	305016.0
2012-02-28	AAXJ	Stock	57.46	57.79	57.37	57.75	913648.0
2012-02-28	AAXN-DELISTED	Stock	4.05	4.205	4.05	4.17	436522.0
2012-02-28	AB	Stock	13.99	14.12	13.84	13.99	269700.0
2012-02-28	ABAC-DELISTED	Stock	1.71	1.73	1.68	1.73	11980.0
2012-02-28	ABAX-DELISTED	Stock	26.8	27.243	26.7	26.95	49156.0
2012-02-28	ABB-DELISTED	Stock	20.68	20.97	20.6216	20.89	1744485.0
2012-02-28	ABBNY-DELISTED	Stock	20.68	20.97	20.6216	20.89	1746807.0
2012-02-28	ABC-DELISTED	Stock	37.71	37.8705	37.58	37.71	1982299.0
2012-02-28	ABCB	Stock	11.68	11.73	11.64	11.7	35000.0
2012-02-28	ABCD-DELISTED	Stock	3.06	3.1	2.99	3.03	9045.0
2012-02-28	ABCO-DELISTED	Stock	40.62	40.98	40.11	40.66	380433.0
2012-02-28	ABCW-DELISTED	Stock	0.4317	0.4317	0.4016	0.4016	28010.0
2012-02-28	ABD-DELISTED	Stock	12.245	12.475	12.175	12.245	332340.0
2012-02-28	ABE-DELISTED	Stock	18.85	19.17	18.85	19.17	35684.0
2012-02-28	ABEO	Stock	1662.5	1712.5	1600.0	1712.5	9.0
2012-02-28	ABFS-DELISTED	Stock	18.09	18.19	17.68	17.85	406604.0
2012-02-28	ABG	Stock	25.72	26.38	25.46	26.32	560400.0
2012-02-28	ABH-DELISTED	Stock	15.14	15.41	15.11	15.34	136982.0
2012-02-28	ABM	Stock	23.58	23.61	23.08	23.2	143300.0
2012-02-28	ABMD-DELISTED	Stock	21.99	22.0	21.1	21.43	295789.0
2012-02-28	ABR	Stock	4.73	4.73	4.58	4.65	36400.0
2012-02-28	ABT	Stock	27.1999	27.411	27.1423	27.3678	12279283.0
2012-02-28	ABTL-DELISTED	Stock	5.0505	5.152	4.9495	5.0	15776.0
2012-02-28	ABUS	Stock	2.45	2.45	2.4	2.4	2200.0
2012-02-28	ABV-DELISTED	Stock	40.5	40.66	40.26	40.42	1387638.0
2012-02-28	ABVA-DELISTED	Stock	3.65	3.81	3.65	3.78	5600.0
2012-02-28	ABVT-DELISTED	Stock	72.76	73.64	68.51	71.23	457729.0
2012-02-28	ABX-DELISTED	Stock	48.88	49.67	48.57	49.48	5973203.0

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

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