PREVIEW / stock_daily / 2011-08-09

all stock daily files

  file:    by_date/stock_daily/2011/2011-08-09.parquet
  size:    197 KB
  rows:    6,177
  symbols: 3,586

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-08-09	AAPL	Stock	12.9036	13.3789	12.6786	13.3575	1082583600.0
2011-08-09	MSFT	Stock	24.71	25.62	24.03	25.58	126268900.0
2011-08-09	NVDA	Stock	0.304	0.3238	0.3	0.3233	1329832000.0
2011-08-09	AMZN	Stock	9.835	10.2545	9.523	10.2545	209824000.0
2011-08-09	TSLA	Stock	1.61	1.6967	1.58	1.6707	20001000.0
2011-08-09	TLT	Stock	105.01	109.37	103.0	105.87	39882328.0
2011-08-09	ES	Stock	30.74	31.99	30.02	31.93	5129200.0
2011-08-09	CL	Stock	41.715	41.74	39.31	41.65	14092800.0
2011-08-09	A	Stock	23.7983	24.4921	22.9614	24.4707	11422639.0
2011-08-09	AABA-DELISTED	Stock	11.3	12.09	11.25	12.085	47109021.0
2011-08-09	AACC-DELISTED	Stock	4.41	4.52	4.1	4.44	14418.0
2011-08-09	AACG	Stock	8.82	9.1	8.82	9.0	5800.0
2011-08-09	AAIC-DELISTED	Stock	23.43	25.14	22.5	25.11	113812.0
2011-08-09	AAME	Stock	1.68	1.93	1.62	1.87	18800.0
2011-08-09	AAON	Stock	5.843	5.8874	5.3481	5.7867	482288.0
2011-08-09	AAP	Stock	50.51	51.91	49.66	51.86	2238000.0
2011-08-09	AAT	Stock	18.95	19.05	17.79	18.7	726700.0
2011-08-09	AATI-DELISTED	Stock	5.9	6.05	5.77	6.03	587955.0
2011-08-09	AAU-DELISTED	Stock	2.82	2.9575	2.71	2.92	580998.0
2011-08-09	AAUAF-DELISTED	Stock	2.82	2.9575	2.71	2.92	581698.0
2011-08-09	AAV-DELISTED	Stock	5.2	5.69	5.2	5.6	940178.0
2011-08-09	AAWW-DELISTED	Stock	43.45	46.46	41.5	44.15	477689.0
2011-08-09	AAXJ	Stock	54.32	55.65	52.92	55.65	607440.0
2011-08-09	AAXN-DELISTED	Stock	3.72	3.89	3.55	3.89	846422.0
2011-08-09	AB	Stock	18.4	18.4	13.94	14.37	894200.0
2011-08-09	ABAC-DELISTED	Stock	2.22	2.2899	2.1	2.15	13543.0
2011-08-09	ABAX-DELISTED	Stock	20.48	22.45	19.68	22.25	482614.0
2011-08-09	ABB-DELISTED	Stock	20.84	21.9	20.39	21.9	9839033.0
2011-08-09	ABBC-DELISTED	Stock	8.1	8.58	7.8	8.57	158198.0
2011-08-09	ABBNY-DELISTED	Stock	20.84	21.9	20.39	21.88	9843705.0
2011-08-09	ABC-DELISTED	Stock	35.177	36.71	34.386	36.71	6601246.0
2011-08-09	ABCB	Stock	9.32	10.01	8.6	9.82	117400.0
2011-08-09	ABCD-DELISTED	Stock	2.67	3.21	2.48	3.21	49481.0
2011-08-09	ABCO-DELISTED	Stock	28.31	29.14	27.21	29.02	254153.0
2011-08-09	ABCW-DELISTED	Stock	0.6	0.68	0.6	0.61	24860.0
2011-08-09	ABD-DELISTED	Stock	6.8849	7.305	6.1143	7.295	557050.0
2011-08-09	ABE-DELISTED	Stock	16.65	17.15	16.24	17.15	17875.0
2011-08-09	ABEO	Stock	2062.5	2725.0	2062.5	2550.0	6.0
2011-08-09	ABFS-DELISTED	Stock	20.25	20.79	19.08	20.76	561373.0
2011-08-09	ABG	Stock	18.6	19.24	16.84	19.09	548900.0
2011-08-09	ABH-DELISTED	Stock	16.15	16.5	14.8	15.8	1082080.0
2011-08-09	ABM	Stock	17.64	19.36	17.33	19.36	814300.0
2011-08-09	ABMD-DELISTED	Stock	10.94	11.518	10.05	11.08	368314.0
2011-08-09	ABR	Stock	3.76	3.88	3.57	3.78	84900.0
2011-08-09	ABT	Stock	23.2751	23.467	22.2099	23.2991	40628804.0
2011-08-09	ABTL-DELISTED	Stock	4.4931	4.4931	4.3068	4.3569	10586.0
2011-08-09	ABUS	Stock	2.03	2.45	1.73	2.45	20900.0
2011-08-09	ABV-DELISTED	Stock	28.25	29.48	28.03	29.45	7032211.0
2011-08-09	ABVA-DELISTED	Stock	4.65	4.7	4.55	4.55	17906.0
2011-08-09	ABVT-DELISTED	Stock	57.22	60.26	55.75	60.23	473421.0

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

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