PREVIEW / stock_daily / 2011-09-06

all stock daily files

  file:    by_date/stock_daily/2011/2011-09-06.parquet
  size:    193 KB
  rows:    6,069
  symbols: 3,518

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-09-06	AAPL	Stock	13.1204	13.5832	13.0886	13.5621	509698000.0
2011-09-06	MSFT	Stock	25.2	25.59	25.11	25.51	54929300.0
2011-09-06	NVDA	Stock	0.3125	0.3303	0.3095	0.3295	696248000.0
2011-09-06	AMZN	Stock	10.2385	10.83	10.2235	10.809	124324000.0
2011-09-06	TSLA	Stock	1.5	1.5467	1.486	1.5293	12147000.0
2011-09-06	TLT	Stock	114.42	114.93	113.39	113.68	14016833.0
2011-09-06	ES	Stock	33.04	33.48	32.73	33.46	1295000.0
2011-09-06	CL	Stock	43.46	44.575	43.46	44.495	6368800.0
2011-09-06	A	Stock	23.4549	24.3491	22.9971	24.2632	10573214.0
2011-09-06	AABA-DELISTED	Stock	12.52	12.95	12.45	12.91	34401829.0
2011-09-06	AACC-DELISTED	Stock	4.05	4.3299	4.0	4.02	25782.0
2011-09-06	AACG	Stock	9.49	9.65	9.27	9.45	4100.0
2011-09-06	AAIC-DELISTED	Stock	23.95	25.64	23.72	25.34	51857.0
2011-09-06	AAME	Stock	1.88	2.03	1.88	1.97	12200.0
2011-09-06	AAON	Stock	4.6133	4.803	4.6074	4.7852	248063.0
2011-09-06	AAP	Stock	58.37	59.88	58.26	59.81	850200.0
2011-09-06	AAT	Stock	18.68	19.4	18.66	19.18	111400.0
2011-09-06	AATI-DELISTED	Stock	5.95	5.96	5.91	5.94	635848.0
2011-09-06	AAU-DELISTED	Stock	3.18	3.38	3.16	3.35	222146.0
2011-09-06	AAUAF-DELISTED	Stock	3.18	3.37	3.16	3.35	223686.0
2011-09-06	AAV-DELISTED	Stock	5.28	5.41	5.25	5.4	336566.0
2011-09-06	AAWW-DELISTED	Stock	44.65	44.88	42.52	43.45	346816.0
2011-09-06	AAXJ	Stock	53.3	54.88	53.29	54.81	2229835.0
2011-09-06	AAXN-DELISTED	Stock	4.13	4.34	4.13	4.32	439534.0
2011-09-06	AB	Stock	16.54	16.66	16.11	16.52	374600.0
2011-09-06	ABAC-DELISTED	Stock	2.22	2.3	2.15	2.2	15925.0
2011-09-06	ABAX-DELISTED	Stock	24.09	24.22	23.35	23.85	197215.0
2011-09-06	ABB-DELISTED	Stock	18.57	18.87	18.48	18.83	5935247.0
2011-09-06	ABBC-DELISTED	Stock	7.62	7.94	7.61	7.91	40608.0
2011-09-06	ABBNY-DELISTED	Stock	18.57	18.87	18.48	18.83	5935843.0
2011-09-06	ABC-DELISTED	Stock	37.87	39.09	37.45	39.04	3009568.0
2011-09-06	ABCB	Stock	8.39	8.72	8.38	8.5	67400.0
2011-09-06	ABCD-DELISTED	Stock	2.91	3.03	2.91	3.03	57368.0
2011-09-06	ABCO-DELISTED	Stock	28.88	29.87	28.88	29.82	95990.0
2011-09-06	ABCW-DELISTED	Stock	0.59	0.6	0.57	0.6	42860.0
2011-09-06	ABD-DELISTED	Stock	5.81	6.05	5.81	6.01	295520.0
2011-09-06	ABE-DELISTED	Stock	17.92	18.2	17.91	18.07	5093.0
2011-09-06	ABEO	Stock	2200.0	2687.5	2200.0	2500.0	7.0
2011-09-06	ABFS-DELISTED	Stock	18.44	18.77	18.07	18.38	273384.0
2011-09-06	ABG	Stock	16.11	17.34	16.1	17.25	412000.0
2011-09-06	ABH-DELISTED	Stock	15.07	15.47	15.05	15.46	211027.0
2011-09-06	ABM	Stock	18.8	19.49	18.8	19.45	304400.0
2011-09-06	ABMD-DELISTED	Stock	11.33	11.64	11.25	11.35	179404.0
2011-09-06	ABR	Stock	3.93	4.07	3.93	4.03	36100.0
2011-09-06	ABT	Stock	23.87	24.6329	23.7069	24.6089	16495415.0
2011-09-06	ABTL-DELISTED	Stock	4.65	4.6697	4.4478	4.65	4300.0
2011-09-06	ABUS	Stock	1.93	2.01	1.91	2.01	5400.0
2011-09-06	ABV-DELISTED	Stock	33.37	33.52	33.04	33.44	4068464.0
2011-09-06	ABVA-DELISTED	Stock	4.65	4.65	4.35	4.44	4713.0
2011-09-06	ABVT-DELISTED	Stock	57.14	58.13	56.33	58.08	261371.0

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

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