PREVIEW / stock_daily / 2012-04-10

all stock daily files

  file:    by_date/stock_daily/2012/2012-04-10.parquet
  size:    200 KB
  rows:    6,163
  symbols: 3,528

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-10	AAPL	Stock	22.8546	23.0	22.3571	22.4443	889725200.0
2012-04-10	MSFT	Stock	31.06	31.19	30.3	30.47	54131300.0
2012-04-10	NVDA	Stock	0.3595	0.3645	0.3522	0.354	470360000.0
2012-04-10	AMZN	Stock	9.6375	9.676	9.3285	9.349	89100000.0
2012-04-10	TSLA	Stock	2.21	2.2567	2.14	2.164	27715500.0
2012-04-10	TLT	Stock	115.95	117.29	115.78	116.8599	14421422.0
2012-04-10	ES	Stock	36.38	36.5	35.63	35.91	4638700.0
2012-04-10	CL	Stock	48.385	48.405	47.935	48.085	4731600.0
2012-04-10	A	Stock	31.1159	31.2876	30.0072	30.2575	6056695.0
2012-04-10	AABA-DELISTED	Stock	15.08	15.18	14.91	14.99	15200458.0
2012-04-10	AACC-DELISTED	Stock	4.89	4.98	4.84	4.9	11743.0
2012-04-10	AACG	Stock	6.47	6.96	6.36	6.96	8100.0
2012-04-10	AAIC-DELISTED	Stock	22.35	22.53	22.03	22.15	102094.0
2012-04-10	AAME	Stock	2.87	2.9	2.74	2.88	8400.0
2012-04-10	AAMRQ-DELISTED	Stock	0.4914	0.502	0.488	0.488	2260858.0
2012-04-10	AAON	Stock	5.6178	5.6178	5.4193	5.4667	279113.0
2012-04-10	AAP	Stock	89.84	89.84	87.89	88.28	927000.0
2012-04-10	AAT	Stock	22.55	22.56	22.07	22.18	136300.0
2012-04-10	AAU-DELISTED	Stock	2.3	2.37	2.21	2.32	263133.0
2012-04-10	AAUAF-DELISTED	Stock	2.3	2.37	2.21	2.32	263333.0
2012-04-10	AAV-DELISTED	Stock	3.0	3.02	2.89	2.91	626062.0
2012-04-10	AAWW-DELISTED	Stock	47.86	48.39	45.52	46.07	338888.0
2012-04-10	AAXJ	Stock	55.67	55.71	54.54	54.69	299407.0
2012-04-10	AAXN-DELISTED	Stock	3.97	4.08	3.96	4.07	461063.0
2012-04-10	AB	Stock	14.78	15.17	14.15	14.29	318700.0
2012-04-10	ABAC-DELISTED	Stock	1.62	1.65	1.61	1.62	10700.0
2012-04-10	ABAX-DELISTED	Stock	27.41	27.63	27.08	27.25	110702.0
2012-04-10	ABB-DELISTED	Stock	19.57	19.67	19.225	19.23	2606872.0
2012-04-10	ABBNY-DELISTED	Stock	19.57	19.67	19.225	19.23	2614349.0
2012-04-10	ABC-DELISTED	Stock	38.46	38.86	38.25	38.4	3267754.0
2012-04-10	ABCB	Stock	12.82	12.99	12.55	12.7	93800.0
2012-04-10	ABCD-DELISTED	Stock	2.51	2.57	2.32	2.36	32467.0
2012-04-10	ABCO-DELISTED	Stock	43.25	43.97	42.61	42.85	215717.0
2012-04-10	ABCW-DELISTED	Stock	0.8836	0.8836	0.7832	0.7832	39550.0
2012-04-10	ABD-DELISTED	Stock	11.77	11.8	11.06	11.28	586240.0
2012-04-10	ABE-DELISTED	Stock	19.18	19.18	18.91	18.91	4763.0
2012-04-10	ABEO	Stock	1400.0	1550.0	1400.0	1437.5	61.0
2012-04-10	ABFS-DELISTED	Stock	18.78	18.78	17.9	18.06	373525.0
2012-04-10	ABG	Stock	26.94	27.0	26.22	26.44	520500.0
2012-04-10	ABH-DELISTED	Stock	13.56	13.61	13.32	13.4	616714.0
2012-04-10	ABM	Stock	23.24	23.26	22.85	22.98	290900.0
2012-04-10	ABMD-DELISTED	Stock	21.08	21.3299	20.36	20.49	286084.0
2012-04-10	ABR	Stock	5.09	5.17	5.09	5.11	38400.0
2012-04-10	ABT	Stock	29.2678	29.2726	28.7544	28.8552	16635890.0
2012-04-10	ABTL-DELISTED	Stock	4.6533	4.7063	4.6162	4.6467	18460.0
2012-04-10	ABUS	Stock	2.3	2.47	2.18	2.23	19700.0
2012-04-10	ABV-DELISTED	Stock	41.08	41.15	40.72	40.92	3150018.0
2012-04-10	ABVA-DELISTED	Stock	4.11	4.25	4.11	4.2	4800.0
2012-04-10	ABVT-DELISTED	Stock	82.95	82.9698	82.84	82.88	435797.0
2012-04-10	ABX-DELISTED	Stock	41.03	41.75	40.71	41.48	9456550.0

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

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