PREVIEW / stock_daily / 2011-07-14

all stock daily files

  file:    by_date/stock_daily/2011/2011-07-14.parquet
  size:    198 KB
  rows:    6,089
  symbols: 3,536

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
2011-07-14	AAPL	Stock	12.8932	12.9146	12.7264	12.7775	430533600.0
2011-07-14	MSFT	Stock	26.62	27.01	26.36	26.47	46382300.0
2011-07-14	NVDA	Stock	0.368	0.3703	0.3502	0.352	1088996000.0
2011-07-14	AMZN	Stock	10.679	10.7955	10.469	10.519	78050000.0
2011-07-14	TSLA	Stock	1.902	1.9307	1.8167	1.8407	17385000.0
2011-07-14	TLT	Stock	96.62	97.9	96.01	96.01	11472107.0
2011-07-14	ES	Stock	35.27	35.34	34.78	34.82	907800.0
2011-07-14	CL	Stock	43.94	44.015	43.45	43.54	5098200.0
2011-07-14	A	Stock	34.5279	34.5279	33.6481	33.8555	5226563.0
2011-07-14	AABA-DELISTED	Stock	14.9	14.99	14.6	14.63	26652835.0
2011-07-14	AACC-DELISTED	Stock	4.4	4.43	4.36	4.39	18237.0
2011-07-14	AACG	Stock	10.67	10.75	10.67	10.75	500.0
2011-07-14	AAIC-DELISTED	Stock	31.38	31.5527	30.5701	30.65	51977.0
2011-07-14	AAME	Stock	2.05	2.05	2.05	2.05	3000.0
2011-07-14	AAON	Stock	7.0252	7.1022	6.9333	6.9511	216338.0
2011-07-14	AAP	Stock	57.0	57.6	56.43	56.55	1888300.0
2011-07-14	AAT	Stock	22.48	22.48	21.52	21.78	426700.0
2011-07-14	AATI-DELISTED	Stock	6.07	6.09	6.07	6.08	417510.0
2011-07-14	AAU-DELISTED	Stock	4.17	4.26	3.85	3.87	458957.0
2011-07-14	AAUAF-DELISTED	Stock	4.18	4.27	3.86	3.86	459145.0
2011-07-14	AAV-DELISTED	Stock	7.56	7.64	7.34	7.37	241924.0
2011-07-14	AAWW-DELISTED	Stock	58.03	59.83	57.25	57.64	158930.0
2011-07-14	AAXJ	Stock	61.61	61.87	61.07	61.21	402526.0
2011-07-14	AAXN-DELISTED	Stock	4.34	4.39	4.25	4.26	172960.0
2011-07-14	AB	Stock	19.25	19.4	18.43	18.47	475700.0
2011-07-14	ABAC-DELISTED	Stock	2.9	2.91	2.8	2.87	26700.0
2011-07-14	ABAX-DELISTED	Stock	29.88	29.9	28.73	28.74	59089.0
2011-07-14	ABB-DELISTED	Stock	26.1	26.24	25.57	25.61	4487436.0
2011-07-14	ABBC-DELISTED	Stock	10.51	10.53	10.22	10.32	18920.0
2011-07-14	ABBNY-DELISTED	Stock	26.1	26.24	25.57	25.63	4489336.0
2011-07-14	ABC-DELISTED	Stock	42.48	42.9899	42.15	42.24	1400967.0
2011-07-14	ABCB	Stock	9.29	9.29	9.1	9.14	19500.0
2011-07-14	ABCD-DELISTED	Stock	3.36	3.38	3.21	3.37	17658.0
2011-07-14	ABCO-DELISTED	Stock	28.31	28.54	27.61	27.67	51403.0
2011-07-14	ABCW-DELISTED	Stock	0.681	0.689	0.6791	0.689	13110.0
2011-07-14	ABD-DELISTED	Stock	7.87	7.93	7.56	7.67	156670.0
2011-07-14	ABE-DELISTED	Stock	18.97	19.04	18.75	19.0	40043.0
2011-07-14	ABEO	Stock	2475.0	2625.0	2375.0	2612.5	21.0
2011-07-14	ABFS-DELISTED	Stock	26.35	26.69	25.64	26.16	363339.0
2011-07-14	ABG	Stock	19.43	19.64	18.64	18.79	258700.0
2011-07-14	ABH-DELISTED	Stock	19.96	20.04	19.51	19.59	160300.0
2011-07-14	ABM	Stock	23.71	23.8	23.2	23.25	202200.0
2011-07-14	ABMD-DELISTED	Stock	16.58	16.65	16.21	16.35	169667.0
2011-07-14	ABR	Stock	4.67	4.67	4.51	4.51	37400.0
2011-07-14	ABT	Stock	25.3047	25.5877	25.2903	25.5062	13061901.0
2011-07-14	ABTL-DELISTED	Stock	5.5	5.5	5.15	5.35	20787.0
2011-07-14	ABUS	Stock	2.36	2.4	2.35	2.4	16700.0
2011-07-14	ABV-DELISTED	Stock	32.04	32.06	31.52	31.8	2466129.0
2011-07-14	ABVT-DELISTED	Stock	69.5	69.5	66.94	66.97	165668.0
2011-07-14	ABX-DELISTED	Stock	49.06	49.1	47.8	47.92	8261943.0

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

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