PREVIEW / stock_daily / 2012-04-16

all stock daily files

  file:    by_date/stock_daily/2012/2012-04-16.parquet
  size:    199 KB
  rows:    6,178
  symbols: 3,545

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-16	AAPL	Stock	21.7879	21.7957	20.6518	20.7189	1050786800.0
2012-04-16	MSFT	Stock	30.99	31.19	30.77	31.08	38124800.0
2012-04-16	NVDA	Stock	0.3565	0.3575	0.344	0.3498	463468000.0
2012-04-16	AMZN	Stock	9.4505	9.4735	9.1825	9.275	80886000.0
2012-04-16	TSLA	Stock	2.2273	2.2467	2.1393	2.15	16494000.0
2012-04-16	TLT	Stock	116.7	117.6	116.57	116.67	7734950.0
2012-04-16	ES	Stock	35.87	36.44	35.87	36.2	2289800.0
2012-04-16	CL	Stock	48.765	49.1	48.685	48.835	13182200.0
2012-04-16	A	Stock	30.4649	30.5651	29.8999	30.0358	3447188.0
2012-04-16	AABA-DELISTED	Stock	15.01	15.04	14.73	14.79	13403404.0
2012-04-16	AACC-DELISTED	Stock	5.0	5.0	4.9	5.0	24114.0
2012-04-16	AACG	Stock	6.91	7.04	6.6	6.69	6200.0
2012-04-16	AAIC-DELISTED	Stock	22.6	22.74	22.4	22.54	46757.0
2012-04-16	AAME	Stock	2.92	2.92	2.62	2.9	6900.0
2012-04-16	AAMRQ-DELISTED	Stock	0.49	0.5	0.48	0.48	1680443.0
2012-04-16	AAON	Stock	5.7748	5.9407	5.6948	5.7956	104963.0
2012-04-16	AAP	Stock	90.74	90.74	89.31	89.7	797800.0
2012-04-16	AAT	Stock	22.63	22.96	22.53	22.73	52900.0
2012-04-16	AAU-DELISTED	Stock	2.34	2.35	2.28	2.3	100644.0
2012-04-16	AAUAF-DELISTED	Stock	2.34	2.35	2.28	2.3	100844.0
2012-04-16	AAV-DELISTED	Stock	2.92	3.02	2.92	3.01	234491.0
2012-04-16	AAWW-DELISTED	Stock	47.16	47.54	46.32	46.97	125874.0
2012-04-16	AAXJ	Stock	56.15	56.29	55.5	55.72	1441112.0
2012-04-16	AAXN-DELISTED	Stock	4.09	4.15	4.05	4.1	163211.0
2012-04-16	AB	Stock	14.92	15.11	14.62	14.75	97500.0
2012-04-16	ABAC-DELISTED	Stock	1.7	1.73	1.65	1.72	71157.0
2012-04-16	ABAX-DELISTED	Stock	26.5	27.02	26.14	26.72	60806.0
2012-04-16	ABB-DELISTED	Stock	19.68	19.74	19.46	19.68	2470135.0
2012-04-16	ABBNY-DELISTED	Stock	19.68	19.74	19.46	19.66	2471175.0
2012-04-16	ABC-DELISTED	Stock	37.62	37.73	37.39	37.47	2698181.0
2012-04-16	ABCB	Stock	12.85	13.01	12.67	13.0	35600.0
2012-04-16	ABCD-DELISTED	Stock	2.39	2.45	2.29	2.36	11913.0
2012-04-16	ABCO-DELISTED	Stock	42.67	43.58	42.53	43.5	272775.0
2012-04-16	ABCW-DELISTED	Stock	0.8936	0.9438	0.8534	0.8534	4570.0
2012-04-16	ABD-DELISTED	Stock	11.6	11.98	11.42	11.78	725260.0
2012-04-16	ABE-DELISTED	Stock	19.12	19.12	18.93	18.9608	4535.0
2012-04-16	ABEO	Stock	1362.5	1437.5	1350.0	1425.0	21.0
2012-04-16	ABFS-DELISTED	Stock	17.92	18.46	17.8	18.21	256205.0
2012-04-16	ABG	Stock	27.5	27.97	26.82	27.52	284400.0
2012-04-16	ABH-DELISTED	Stock	13.54	13.57	13.36	13.4	162816.0
2012-04-16	ABM	Stock	23.35	23.67	23.11	23.47	236600.0
2012-04-16	ABMD-DELISTED	Stock	20.63	20.72	20.2	20.56	174493.0
2012-04-16	ABR	Stock	5.55	5.6	5.52	5.54	17500.0
2012-04-16	ABT	Stock	28.6537	28.8552	28.6393	28.716	12043143.0
2012-04-16	ABTL-DELISTED	Stock	4.5523	4.6024	4.2994	4.35	33524.0
2012-04-16	ABUS	Stock	2.38	2.43	2.38	2.43	1600.0
2012-04-16	ABV-DELISTED	Stock	43.14	43.17	41.94	42.43	2292855.0
2012-04-16	ABVA-DELISTED	Stock	4.23	4.23	4.23	4.23	200.0
2012-04-16	ABVT-DELISTED	Stock	83.06	83.24	83.06	83.17	118466.0
2012-04-16	ABX-DELISTED	Stock	41.58	41.91	40.78	40.81	6214331.0

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

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