PREVIEW / stock_daily / 2011-09-30

all stock daily files

  file:    by_date/stock_daily/2011/2011-09-30.parquet
  size:    194 KB
  rows:    6,102
  symbols: 3,538

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-30	AAPL	Stock	13.8257	13.8889	13.6136	13.6186	547640800.0
2011-09-30	MSFT	Stock	25.2	25.5	24.88	24.89	54060500.0
2011-09-30	NVDA	Stock	0.322	0.3238	0.3123	0.3128	677784000.0
2011-09-30	AMZN	Stock	10.9095	11.15	10.7605	10.8115	131006000.0
2011-09-30	TSLA	Stock	1.6533	1.6593	1.566	1.626	20041500.0
2011-09-30	TLT	Stock	120.02	120.91	118.99	120.8	13547246.0
2011-09-30	ES	Stock	33.88	34.42	33.65	33.65	2150000.0
2011-09-30	CL	Stock	44.515	44.995	44.315	44.34	5520800.0
2011-09-30	A	Stock	22.7682	23.0043	22.2103	22.3534	5866288.0
2011-09-30	AABA-DELISTED	Stock	13.21	13.44	13.11	13.17	30400476.0
2011-09-30	AACC-DELISTED	Stock	3.37	3.42	3.26	3.37	104035.0
2011-09-30	AACG	Stock	8.99	9.02	8.98	9.0	1100.0
2011-09-30	AAIC-DELISTED	Stock	24.51	25.0	24.0	24.05	22952.0
2011-09-30	AAME	Stock	1.88	1.9	1.88	1.9	1000.0
2011-09-30	AAON	Stock	4.7852	4.8711	4.6519	4.6667	204525.0
2011-09-30	AAP	Stock	58.56	59.5	58.07	58.1	879800.0
2011-09-30	AAT	Stock	18.21	18.29	17.94	17.95	219700.0
2011-09-30	AATI-DELISTED	Stock	4.29	4.45	4.25	4.32	460634.0
2011-09-30	AAU-DELISTED	Stock	2.68	2.705	2.55	2.55	254328.0
2011-09-30	AAUAF-DELISTED	Stock	2.67	2.7	2.55	2.56	256116.0
2011-09-30	AAV-DELISTED	Stock	3.84	3.86	3.67	3.75	882851.0
2011-09-30	AAWW-DELISTED	Stock	35.3	36.3	33.01	33.26	386915.0
2011-09-30	AAXJ	Stock	47.86	48.092	46.64	46.64	296893.0
2011-09-30	AAXN-DELISTED	Stock	4.34	4.475	4.31	4.31	439710.0
2011-09-30	AB	Stock	14.34	14.36	13.65	13.65	276500.0
2011-09-30	ABAC-DELISTED	Stock	1.3	1.41	1.22	1.35	19309.0
2011-09-30	ABAX-DELISTED	Stock	23.17	24.09	22.88	22.89	234704.0
2011-09-30	ABB-DELISTED	Stock	17.33	17.6	17.07	17.07	2799467.0
2011-09-30	ABBC-DELISTED	Stock	7.48	7.57	7.16	7.2	42123.0
2011-09-30	ABBNY-DELISTED	Stock	17.33	17.6	17.07	17.08	2837585.0
2011-09-30	ABC-DELISTED	Stock	37.47	38.29	37.15	37.29	3119703.0
2011-09-30	ABCB	Stock	8.65	8.84	8.65	8.71	56200.0
2011-09-30	ABCD-DELISTED	Stock	2.99	3.05	2.99	3.0	38231.0
2011-09-30	ABCO-DELISTED	Stock	31.65	32.65	31.4	32.26	174185.0
2011-09-30	ABCW-DELISTED	Stock	0.53	0.5334	0.4995	0.5	11480.0
2011-09-30	ABD-DELISTED	Stock	4.76	4.97	4.74	4.77	306280.0
2011-09-30	ABE-DELISTED	Stock	17.09	17.09	16.8	16.8	6646.0
2011-09-30	ABEO	Stock	2500.0	2562.5	2312.5	2562.5	7.0
2011-09-30	ABFS-DELISTED	Stock	16.92	17.23	16.09	16.13	363814.0
2011-09-30	ABG	Stock	17.04	17.51	16.49	16.49	337500.0
2011-09-30	ABH-DELISTED	Stock	14.86	15.38	14.85	15.01	483726.0
2011-09-30	ABM	Stock	19.41	19.94	19.06	19.06	469800.0
2011-09-30	ABMD-DELISTED	Stock	10.7	11.41	10.7	11.02	261928.0
2011-09-30	ABR	Stock	3.7	3.78	3.7	3.78	49700.0
2011-09-30	ABT	Stock	24.7145	25.0696	24.537	24.537	17204252.0
2011-09-30	ABTL-DELISTED	Stock	4.3038	4.3043	4.1041	4.2462	752.0
2011-09-30	ABUS	Stock	2.0	2.0	1.8	1.8	3300.0
2011-09-30	ABV-DELISTED	Stock	30.92	30.93	30.29	30.655	4399317.0
2011-09-30	ABVT-DELISTED	Stock	53.68	54.78	53.46	53.59	134648.0
2011-09-30	ABX-DELISTED	Stock	45.9	47.6	45.61	46.67	7152585.0

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

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