PREVIEW / stock_daily / 2012-02-14

all stock daily files

  file:    by_date/stock_daily/2012/2012-02-14.parquet
  size:    199 KB
  rows:    6,162
  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-02-14	AAPL	Stock	18.0236	18.1986	17.9286	18.195	460398400.0
2012-02-14	MSFT	Stock	30.33	30.46	29.85	30.25	59644000.0
2012-02-14	NVDA	Stock	0.4038	0.4095	0.4003	0.406	453756000.0
2012-02-14	AMZN	Stock	9.554	9.6785	9.305	9.565	190542000.0
2012-02-14	TSLA	Stock	2.116	2.2527	2.0933	2.2113	27162000.0
2012-02-14	TLT	Stock	117.44	118.28	117.23	117.76	8271310.0
2012-02-14	ES	Stock	34.94	34.95	34.67	34.9	1086300.0
2012-02-14	CL	Stock	45.745	45.955	45.625	45.95	2877400.0
2012-02-14	A	Stock	31.2876	31.6524	31.0014	31.3162	3659405.0
2012-02-14	AABA-DELISTED	Stock	16.07	16.1	14.92	15.37	86619049.0
2012-02-14	AACC-DELISTED	Stock	4.53	4.53	4.4	4.49	26052.0
2012-02-14	AACG	Stock	6.92	7.0	6.84	6.84	2300.0
2012-02-14	AAIC-DELISTED	Stock	23.45	23.45	22.75	22.99	46478.0
2012-02-14	AAME	Stock	2.23	2.27	2.23	2.23	15100.0
2012-02-14	AAMRQ-DELISTED	Stock	0.57	0.585	0.5325	0.559	7750598.0
2012-02-14	AAON	Stock	5.6741	5.8993	5.4785	5.5467	365175.0
2012-02-14	AAP	Stock	79.33	79.88	78.94	79.77	774000.0
2012-02-14	AAT	Stock	22.02	22.02	21.42	21.59	237900.0
2012-02-14	AAU-DELISTED	Stock	2.6	2.62	2.5297	2.59	178709.0
2012-02-14	AAUAF-DELISTED	Stock	2.59	2.61	2.52	2.6	182097.0
2012-02-14	AAV-DELISTED	Stock	3.78	3.83	3.73	3.77	196518.0
2012-02-14	AAWW-DELISTED	Stock	50.57	50.61	49.6	50.45	399426.0
2012-02-14	AAXJ	Stock	56.76	56.78	56.38	56.77	210710.0
2012-02-14	AAXN-DELISTED	Stock	4.74	4.77	4.54	4.58	411460.0
2012-02-14	AB	Stock	13.98	14.05	13.53	13.76	871400.0
2012-02-14	ABAC-DELISTED	Stock	1.6	1.68	1.58	1.58	30262.0
2012-02-14	ABAX-DELISTED	Stock	27.25	27.46	26.89	27.02	100220.0
2012-02-14	ABB-DELISTED	Stock	21.49	21.54	21.22	21.45	2116074.0
2012-02-14	ABBNY-DELISTED	Stock	21.49	21.54	21.22	21.44	2116536.0
2012-02-14	ABC-DELISTED	Stock	37.14	37.8	37.14	37.54	4642325.0
2012-02-14	ABCB	Stock	11.13	11.27	10.71	10.89	29200.0
2012-02-14	ABCD-DELISTED	Stock	3.17	3.21	3.12	3.16	70401.0
2012-02-14	ABCO-DELISTED	Stock	36.7	38.42	36.7	38.12	631870.0
2012-02-14	ABCW-DELISTED	Stock	0.3012	0.4016	0.3012	0.3213	4830.0
2012-02-14	ABD-DELISTED	Stock	11.22	11.36	11.05	11.27	539630.0
2012-02-14	ABE-DELISTED	Stock	19.3	19.3	18.78	18.95	53554.0
2012-02-14	ABEO	Stock	1750.0	1750.0	1687.5	1737.5	4.0
2012-02-14	ABFS-DELISTED	Stock	18.95	19.01	18.55	18.64	205196.0
2012-02-14	ABG	Stock	26.86	27.2	25.53	26.5	887800.0
2012-02-14	ABH-DELISTED	Stock	15.32	15.34	15.04	15.16	173148.0
2012-02-14	ABM	Stock	22.57	22.62	22.34	22.56	146100.0
2012-02-14	ABMD-DELISTED	Stock	24.05	24.16	23.66	24.0	325503.0
2012-02-14	ABR	Stock	4.63	4.74	4.6	4.68	53700.0
2012-02-14	ABT	Stock	26.4658	26.485	26.2643	26.4274	11748020.0
2012-02-14	ABTL-DELISTED	Stock	4.75	4.9	4.7495	4.9	36281.0
2012-02-14	ABUS	Stock	2.43	2.5	2.32	2.36	4000.0
2012-02-14	ABV-DELISTED	Stock	37.84	37.91	37.25	37.71	2516791.0
2012-02-14	ABVA-DELISTED	Stock	3.49	3.55	3.48	3.5	19000.0
2012-02-14	ABVT-DELISTED	Stock	70.55	70.87	69.51	70.0605	85868.0
2012-02-14	ABX-DELISTED	Stock	48.16	48.26	47.1	47.6	7168274.0

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

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