PREVIEW / stock_daily / 2012-04-02

all stock daily files

  file:    by_date/stock_daily/2012/2012-04-02.parquet
  size:    201 KB
  rows:    6,183
  symbols: 3,555

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-02	AAPL	Stock	21.4939	22.0989	21.4421	22.0939	598351600.0
2012-04-02	MSFT	Stock	32.22	32.46	31.95	32.29	35853600.0
2012-04-02	NVDA	Stock	0.384	0.3873	0.3778	0.3833	407776000.0
2012-04-02	AMZN	Stock	9.901	9.995	9.85	9.9025	128606000.0
2012-04-02	TSLA	Stock	2.4887	2.5313	2.4353	2.4387	15429000.0
2012-04-02	TLT	Stock	113.0	113.3	112.2	112.53	8944053.0
2012-04-02	ES	Stock	37.02	37.34	36.88	37.05	1666100.0
2012-04-02	CL	Stock	48.84	49.225	48.83	49.22	5235400.0
2012-04-02	A	Stock	31.8383	32.2675	31.6309	32.0959	3161717.0
2012-04-02	AABA-DELISTED	Stock	15.21	15.51	15.11	15.45	14207952.0
2012-04-02	AACC-DELISTED	Stock	4.8	5.005	4.7	5.0	62857.0
2012-04-02	AACG	Stock	6.86	7.45	6.86	7.45	8200.0
2012-04-02	AAIC-DELISTED	Stock	22.11	22.51	22.04	22.5	137946.0
2012-04-02	AAME	Stock	2.83	2.92	2.83	2.89	1800.0
2012-04-02	AAMRQ-DELISTED	Stock	0.48	0.495	0.48	0.488	1035807.0
2012-04-02	AAON	Stock	5.9467	6.1867	5.8874	6.0415	190350.0
2012-04-02	AAP	Stock	88.75	89.77	88.07	88.98	824000.0
2012-04-02	AAT	Stock	22.71	23.6	22.71	23.54	130100.0
2012-04-02	AAU-DELISTED	Stock	2.59	2.7	2.58	2.62	92160.0
2012-04-02	AAUAF-DELISTED	Stock	2.59	2.7	2.58	2.62	92460.0
2012-04-02	AAV-DELISTED	Stock	3.33	3.41	3.33	3.41	229307.0
2012-04-02	AAWW-DELISTED	Stock	49.2	50.65	48.75	49.88	394333.0
2012-04-02	AAXJ	Stock	56.46	57.2411	56.35	57.07	229822.0
2012-04-02	AAXN-DELISTED	Stock	4.35	4.41	4.29	4.33	249953.0
2012-04-02	AB	Stock	15.52	15.78	15.43	15.61	227700.0
2012-04-02	ABAC-DELISTED	Stock	1.6402	1.67	1.6	1.62	20410.0
2012-04-02	ABAX-DELISTED	Stock	29.0	29.72	28.88	29.47	61319.0
2012-04-02	ABB-DELISTED	Stock	20.46	20.8	20.4	20.69	1609592.0
2012-04-02	ABBNY-DELISTED	Stock	20.46	20.8	20.4	20.7	1820092.0
2012-04-02	ABC-DELISTED	Stock	39.7	39.74	39.03	39.2	2278578.0
2012-04-02	ABCB	Stock	13.05	13.42	13.05	13.4	97800.0
2012-04-02	ABCD-DELISTED	Stock	2.65	2.68	2.6	2.65	17597.0
2012-04-02	ABCO-DELISTED	Stock	43.79	44.47	43.74	44.11	365181.0
2012-04-02	ABCW-DELISTED	Stock	1.0041	1.0041	0.8635	1.0041	56120.0
2012-04-02	ABD-DELISTED	Stock	12.39	12.98	12.01	12.89	558780.0
2012-04-02	ABE-DELISTED	Stock	19.38	19.95	19.3	19.69	28518.0
2012-04-02	ABEO	Stock	1350.0	1412.5	1175.0	1412.5	20.0
2012-04-02	ABFS-DELISTED	Stock	18.78	19.14	18.57	19.0	267402.0
2012-04-02	ABG	Stock	27.05	27.71	26.89	27.29	515400.0
2012-04-02	ABH-DELISTED	Stock	14.28	14.4	14.1	14.2	148663.0
2012-04-02	ABM	Stock	24.18	24.29	23.91	24.27	313300.0
2012-04-02	ABMD-DELISTED	Stock	22.14	22.52	22.1	22.38	207505.0
2012-04-02	ABR	Stock	5.6	5.6	5.53	5.56	13400.0
2012-04-02	ABT	Stock	29.335	29.4117	29.287	29.383	16959775.0
2012-04-02	ABTL-DELISTED	Stock	4.7499	4.875	4.6845	4.8001	4284.0
2012-04-02	ABUS	Stock	2.64	2.67	2.51	2.64	4000.0
2012-04-02	ABV-DELISTED	Stock	41.37	42.05	41.28	41.96	3692102.0
2012-04-02	ABVA-DELISTED	Stock	4.05	4.05	4.05	4.05	100.0
2012-04-02	ABVT-DELISTED	Stock	82.78	83.0	82.78	82.86	585887.0
2012-04-02	ABX-DELISTED	Stock	43.68	44.5	43.51	44.21	6712065.0

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

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