PREVIEW / stock_daily / 2012-02-13

all stock daily files

  file:    by_date/stock_daily/2012/2012-02-13.parquet
  size:    200 KB
  rows:    6,180
  symbols: 3,559

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-13	AAPL	Stock	17.8404	17.9939	17.7532	17.95	517216000.0
2012-02-13	MSFT	Stock	30.63	30.77	30.43	30.58	33319800.0
2012-02-13	NVDA	Stock	0.4075	0.409	0.3955	0.4038	610668000.0
2012-02-13	AMZN	Stock	9.3585	9.625	9.284	9.5795	121428000.0
2012-02-13	TSLA	Stock	2.1033	2.1373	2.06	2.0993	17368500.0
2012-02-13	TLT	Stock	116.6	117.37	116.435	117.14	6422849.0
2012-02-13	ES	Stock	35.34	35.46	34.92	34.99	1245600.0
2012-02-13	CL	Stock	45.75	45.995	45.625	45.82	2681600.0
2012-02-13	A	Stock	31.9671	31.9742	31.1302	31.3591	4791645.0
2012-02-13	AABA-DELISTED	Stock	16.13	16.24	16.05	16.11	9620730.0
2012-02-13	AACC-DELISTED	Stock	4.58	4.58	4.4001	4.48	30511.0
2012-02-13	AACG	Stock	6.97	6.97	6.79	6.84	2200.0
2012-02-13	AAIC-DELISTED	Stock	23.79	23.92	23.32	23.5	47176.0
2012-02-13	AAME	Stock	2.1	2.3	2.09	2.25	42100.0
2012-02-13	AAMRQ-DELISTED	Stock	0.6	0.619	0.58	0.582	4000617.0
2012-02-13	AAON	Stock	5.6948	5.7748	5.6267	5.7185	129938.0
2012-02-13	AAP	Stock	80.2	80.39	79.25	79.43	830800.0
2012-02-13	AAT	Stock	22.19	22.25	21.87	22.09	185300.0
2012-02-13	AAU-DELISTED	Stock	2.575	2.6249	2.55	2.58	242715.0
2012-02-13	AAUAF-DELISTED	Stock	2.58	2.63	2.55	2.57	242542.0
2012-02-13	AAV-DELISTED	Stock	3.71	3.78	3.69	3.78	179095.0
2012-02-13	AAWW-DELISTED	Stock	50.01	51.18	49.59	50.6	474707.0
2012-02-13	AAXJ	Stock	56.99	57.08	56.6604	56.79	921020.0
2012-02-13	AAXN-DELISTED	Stock	4.84	4.87	4.71	4.765	240022.0
2012-02-13	AB	Stock	14.42	14.46	13.75	14.08	1154300.0
2012-02-13	ABAC-DELISTED	Stock	1.659	1.66	1.5824	1.59	15260.0
2012-02-13	ABAX-DELISTED	Stock	27.83	28.14	27.3	27.39	67071.0
2012-02-13	ABB-DELISTED	Stock	21.76	21.77	21.54	21.73	1280870.0
2012-02-13	ABBNY-DELISTED	Stock	21.76	21.77	21.54	21.71	1331875.0
2012-02-13	ABC-DELISTED	Stock	37.67	38.05	36.91	37.22	8219249.0
2012-02-13	ABCB	Stock	11.1	11.22	11.0	11.22	19400.0
2012-02-13	ABCD-DELISTED	Stock	3.12	3.19	3.05	3.19	7088.0
2012-02-13	ABCO-DELISTED	Stock	36.72	37.24	36.68	36.72	101736.0
2012-02-13	ABCW-DELISTED	Stock	0.4016	0.4016	0.4016	0.4016	700.0
2012-02-13	ABD-DELISTED	Stock	11.14	11.4	11.13	11.3	619910.0
2012-02-13	ABE-DELISTED	Stock	19.19	19.27	19.06	19.25	16043.0
2012-02-13	ABEO	Stock	1700.0	1750.0	1687.5	1750.0	12.0
2012-02-13	ABFS-DELISTED	Stock	19.11	19.34	18.88	19.07	201462.0
2012-02-13	ABG	Stock	24.93	25.32	24.45	24.66	497600.0
2012-02-13	ABH-DELISTED	Stock	15.36	15.36	15.11	15.34	119727.0
2012-02-13	ABM	Stock	22.44	22.7	22.37	22.67	238300.0
2012-02-13	ABMD-DELISTED	Stock	23.53	24.74	23.4	24.18	673755.0
2012-02-13	ABR	Stock	4.54	4.64	4.54	4.64	29500.0
2012-02-13	ABT	Stock	26.4754	26.5329	26.437	26.4658	8062734.0
2012-02-13	ABTL-DELISTED	Stock	4.6495	4.9995	4.5995	4.7005	80968.0
2012-02-13	ABUS	Stock	2.44	2.44	2.29	2.37	8400.0
2012-02-13	ABV-DELISTED	Stock	37.52	38.0	37.48	37.94	1589616.0
2012-02-13	ABVA-DELISTED	Stock	3.48	3.5	3.46	3.5	4300.0
2012-02-13	ABVT-DELISTED	Stock	70.13	70.93	68.93	70.89	184007.0
2012-02-13	ABX-DELISTED	Stock	48.42	48.52	47.6	48.01	4329698.0

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

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