PREVIEW / stock_daily / 2011-07-07

all stock daily files

  file:    by_date/stock_daily/2011/2011-07-07.parquet
  size:    198 KB
  rows:    6,139
  symbols: 3,565

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-07	AAPL	Stock	12.6668	12.7857	12.6429	12.7571	399663600.0
2011-07-07	MSFT	Stock	26.49	26.88	26.36	26.77	51946500.0
2011-07-07	NVDA	Stock	0.3938	0.3958	0.3862	0.3933	986136000.0
2011-07-07	AMZN	Stock	10.7545	10.89	10.7545	10.837	62898000.0
2011-07-07	TSLA	Stock	1.9427	2.0	1.934	1.982	19918500.0
2011-07-07	TLT	Stock	93.8279	94.145	93.55	94.04	6824639.0
2011-07-07	ES	Stock	35.76	35.76	35.22	35.36	1573100.0
2011-07-07	CL	Stock	44.43	44.515	44.275	44.39	3319000.0
2011-07-07	A	Stock	37.5036	37.6395	36.8813	37.4678	3384977.0
2011-07-07	AABA-DELISTED	Stock	15.78	15.95	15.7	15.81	20022342.0
2011-07-07	AACC-DELISTED	Stock	4.05	4.05	3.921	3.99	18939.0
2011-07-07	AACG	Stock	11.23	11.23	10.7	11.18	6400.0
2011-07-07	AAIC-DELISTED	Stock	31.25	31.33	30.34	30.45	85367.0
2011-07-07	AAME	Stock	2.05	2.05	2.02	2.02	6700.0
2011-07-07	AAON	Stock	6.7585	6.9393	6.7348	6.8681	120488.0
2011-07-07	AAP	Stock	58.37	59.67	58.37	59.52	929200.0
2011-07-07	AAT	Stock	22.96	23.25	22.85	22.99	309400.0
2011-07-07	AATI-DELISTED	Stock	6.08	6.1	6.07	6.09	209524.0
2011-07-07	AAU-DELISTED	Stock	3.82	3.84	3.6	3.61	302864.0
2011-07-07	AAUAF-DELISTED	Stock	3.82	3.84	3.6	3.61	303364.0
2011-07-07	AAV-DELISTED	Stock	8.06	8.09	7.84	7.85	221811.0
2011-07-07	AAWW-DELISTED	Stock	61.92	63.99	60.06	63.75	190622.0
2011-07-07	AAXJ	Stock	63.12	63.48	62.97	63.33	689384.0
2011-07-07	AAXN-DELISTED	Stock	4.51	4.54	4.455	4.51	187494.0
2011-07-07	AB	Stock	19.29	20.15	19.2	19.99	534400.0
2011-07-07	ABAC-DELISTED	Stock	2.516	2.88	2.44	2.78	90697.0
2011-07-07	ABAX-DELISTED	Stock	29.93	30.5	29.58	30.21	64404.0
2011-07-07	ABB-DELISTED	Stock	26.41	26.61	26.36	26.6	2362786.0
2011-07-07	ABBC-DELISTED	Stock	10.61	10.78	10.58	10.74	25484.0
2011-07-07	ABBNY-DELISTED	Stock	26.41	26.61	26.36	26.61	2363706.0
2011-07-07	ABC-DELISTED	Stock	43.36	43.47	42.84	43.04	1325009.0
2011-07-07	ABCB	Stock	9.09	9.36	9.09	9.17	57600.0
2011-07-07	ABCD-DELISTED	Stock	3.38	3.4	3.36	3.38	45499.0
2011-07-07	ABCO-DELISTED	Stock	28.69	28.69	28.51	28.53	79977.0
2011-07-07	ABCW-DELISTED	Stock	0.69	0.75	0.66	0.72	22040.0
2011-07-07	ABD-DELISTED	Stock	8.325	8.535	8.285	8.315	182680.0
2011-07-07	ABE-DELISTED	Stock	19.03	19.3	19.03	19.29	26909.0
2011-07-07	ABEO	Stock	2162.5	2225.0	2087.5	2187.5	6.0
2011-07-07	ABFS-DELISTED	Stock	27.33	27.44	26.21	26.82	1368511.0
2011-07-07	ABG	Stock	19.11	19.49	19.11	19.24	444300.0
2011-07-07	ABH-DELISTED	Stock	20.73	21.18	20.59	21.01	312497.0
2011-07-07	ABM	Stock	23.64	23.89	23.48	23.66	307500.0
2011-07-07	ABMD-DELISTED	Stock	17.0	17.37	16.72	16.83	136743.0
2011-07-07	ABR	Stock	4.69	4.8	4.66	4.73	79000.0
2011-07-07	ABT	Stock	25.6645	25.7173	25.5446	25.6885	10280325.0
2011-07-07	ABTL-DELISTED	Stock	5.8002	6.0947	5.7498	5.7498	41447.0
2011-07-07	ABUS	Stock	2.4	2.52	2.35	2.52	3300.0
2011-07-07	ABV-DELISTED	Stock	34.22	34.41	33.67	33.89	2820100.0
2011-07-07	ABVA-DELISTED	Stock	4.68	4.75	4.62	4.65	3800.0
2011-07-07	ABVT-DELISTED	Stock	70.03	70.31	68.55	68.58	348228.0

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

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