PREVIEW / stock_daily / 2012-05-02

all stock daily files

  file:    by_date/stock_daily/2012/2012-05-02.parquet
  size:    200 KB
  rows:    6,216
  symbols: 3,570

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-05-02	AAPL	Stock	20.7229	20.9786	20.6736	20.9279	427389200.0
2012-05-02	MSFT	Stock	31.85	31.93	31.64	31.8	37385300.0
2012-05-02	NVDA	Stock	0.3295	0.3308	0.3195	0.3213	684008000.0
2012-05-02	AMZN	Stock	11.391	11.572	11.37	11.5125	91868000.0
2012-05-02	TSLA	Stock	2.2333	2.2927	2.226	2.2627	7459500.0
2012-05-02	TLT	Stock	117.22	117.32	116.8	117.25	3565869.0
2012-05-02	ES	Stock	36.93	37.07	36.75	37.03	1850000.0
2012-05-02	CL	Stock	49.595	50.175	49.545	50.175	3708000.0
2012-05-02	A	Stock	30.5436	30.8298	30.2575	30.7868	3348070.0
2012-05-02	AABA-DELISTED	Stock	15.58	15.77	15.54	15.67	10828037.0
2012-05-02	AACC-DELISTED	Stock	5.42	5.49	5.22	5.48	24707.0
2012-05-02	AACG	Stock	6.63	6.92	6.63	6.92	1300.0
2012-05-02	AAIC-DELISTED	Stock	23.33	23.46	23.29	23.45	43130.0
2012-05-02	AAME	Stock	2.96	2.96	2.96	2.96	500.0
2012-05-02	AAMRQ-DELISTED	Stock	0.56	0.585	0.55	0.578	1447252.0
2012-05-02	AAON	Stock	5.8519	6.0356	5.7185	5.9911	277088.0
2012-05-02	AAP	Stock	90.33	92.46	90.33	92.32	775000.0
2012-05-02	AAT	Stock	23.56	24.17	23.52	24.09	218000.0
2012-05-02	AAU-DELISTED	Stock	2.25	2.28	2.22	2.24	48060.0
2012-05-02	AAUAF-DELISTED	Stock	2.25	2.28	2.22	2.24	48060.0
2012-05-02	AAV-DELISTED	Stock	3.43	3.43	3.34	3.38	553299.0
2012-05-02	AAWW-DELISTED	Stock	46.06	47.21	45.716	46.99	205176.0
2012-05-02	AAXJ	Stock	56.41	56.76	56.32	56.72	442070.0
2012-05-02	AAXN-DELISTED	Stock	4.68	4.94	4.6	4.9	1227747.0
2012-05-02	AB	Stock	14.36	14.5	13.93	13.96	220000.0
2012-05-02	ABAC-DELISTED	Stock	1.71	1.71	1.63	1.64	23190.0
2012-05-02	ABAX-DELISTED	Stock	35.02	35.27	34.3	35.06	131665.0
2012-05-02	ABB-DELISTED	Stock	18.1	18.26	17.935	18.26	3854063.0
2012-05-02	ABBNY-DELISTED	Stock	18.1	18.27	17.935	18.27	3857741.0
2012-05-02	ABC-DELISTED	Stock	37.25	37.51	37.14	37.22	2063905.0
2012-05-02	ABCB	Stock	12.02	12.24	11.95	12.2	48200.0
2012-05-02	ABCD-DELISTED	Stock	2.23	2.26	2.16	2.24	32785.0
2012-05-02	ABCO-DELISTED	Stock	45.46	45.98	45.46	45.77	246561.0
2012-05-02	ABCW-DELISTED	Stock	0.6727	0.6727	0.6727	0.6727	1000.0
2012-05-02	ABE-DELISTED	Stock	19.37	19.6	19.37	19.5119	4567.0
2012-05-02	ABEO	Stock	1325.0	1325.0	1162.5	1275.0	21.0
2012-05-02	ABFS-DELISTED	Stock	15.27	15.59	15.19	15.52	492629.0
2012-05-02	ABG	Stock	28.1	28.57	27.81	28.45	395900.0
2012-05-02	ABH-DELISTED	Stock	12.33	12.46	12.03	12.07	462990.0
2012-05-02	ABM	Stock	22.58	22.88	22.35	22.87	250000.0
2012-05-02	ABMD-DELISTED	Stock	24.42	24.575	23.69	23.89	754335.0
2012-05-02	ABR	Stock	5.65	5.79	5.6	5.68	43000.0
2012-05-02	ABT	Stock	29.7908	30.1074	29.7908	30.0595	14596707.0
2012-05-02	ABTL-DELISTED	Stock	4.6	4.65	4.55	4.65	15618.0
2012-05-02	ABUS	Stock	2.64	2.75	2.39	2.39	7400.0
2012-05-02	ABV-DELISTED	Stock	41.75	42.01	41.55	41.84	4246055.0
2012-05-02	ABVT-DELISTED	Stock	83.0	83.16	82.99	83.12	639313.0
2012-05-02	ABX-DELISTED	Stock	39.83	39.85	39.1	39.33	8840543.0
2012-05-02	ACAD	Stock	1.53	1.59	1.52	1.57	158000.0
2012-05-02	ACAS-DELISTED	Stock	9.95	10.0	9.79	9.84	10972738.0

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

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