PREVIEW / stock_daily / 2011-08-26

all stock daily files

  file:    by_date/stock_daily/2011/2011-08-26.parquet
  size:    193 KB
  rows:    6,059
  symbols: 3,514

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-26	AAPL	Stock	13.2561	13.7071	13.2429	13.6993	641477200.0
2011-08-26	MSFT	Stock	24.51	25.34	24.42	25.25	71957000.0
2011-08-26	NVDA	Stock	0.3108	0.3285	0.3052	0.3253	732660000.0
2011-08-26	AMZN	Stock	9.562	9.986	9.48	9.9635	106214000.0
2011-08-26	TSLA	Stock	1.514	1.5967	1.4713	1.582	11427000.0
2011-08-26	TLT	Stock	108.69	109.27	107.33	108.49	11504781.0
2011-08-26	ES	Stock	33.7	34.22	32.96	34.11	2059300.0
2011-08-26	CL	Stock	43.31	44.01	42.52	43.92	4417400.0
2011-08-26	A	Stock	23.3476	25.0	22.9685	24.9428	10275300.0
2011-08-26	AABA-DELISTED	Stock	12.8	12.89	12.52	12.75	35472954.0
2011-08-26	AACC-DELISTED	Stock	4.06	4.13	3.94	3.98	11586.0
2011-08-26	AACG	Stock	8.95	9.1	8.89	8.99	7400.0
2011-08-26	AAIC-DELISTED	Stock	24.8	25.575	24.36	25.37	25578.0
2011-08-26	AAME	Stock	1.92	1.99	1.83	1.99	1000.0
2011-08-26	AAON	Stock	4.6696	4.8593	4.6519	4.8059	205200.0
2011-08-26	AAP	Stock	58.11	59.33	57.62	59.2	1014600.0
2011-08-26	AAT	Stock	18.55	18.88	18.43	18.86	68600.0
2011-08-26	AATI-DELISTED	Stock	5.9	6.04	5.87	5.92	797212.0
2011-08-26	AAU-DELISTED	Stock	3.16	3.18	2.98	3.1	286668.0
2011-08-26	AAUAF-DELISTED	Stock	3.16	3.18	2.98	3.1	287268.0
2011-08-26	AAV-DELISTED	Stock	5.39	5.55	5.32	5.52	368076.0
2011-08-26	AAWW-DELISTED	Stock	42.73	44.45	41.42	44.37	159522.0
2011-08-26	AAXJ	Stock	52.84	53.66	52.12	53.64	235775.0
2011-08-26	AAXN-DELISTED	Stock	4.1	4.34	4.08	4.26	360319.0
2011-08-26	AB	Stock	15.03	15.78	14.75	15.68	171200.0
2011-08-26	ABAC-DELISTED	Stock	2.24	2.28	2.1	2.15	23700.0
2011-08-26	ABAX-DELISTED	Stock	23.5	25.05	23.4	25.0	148652.0
2011-08-26	ABB-DELISTED	Stock	19.85	20.34	19.59	20.19	4267770.0
2011-08-26	ABBC-DELISTED	Stock	7.89	8.23	7.81	8.15	28043.0
2011-08-26	ABBNY-DELISTED	Stock	19.85	20.34	19.59	20.18	4269220.0
2011-08-26	ABC-DELISTED	Stock	37.41	38.75	36.74	38.48	2683926.0
2011-08-26	ABCB	Stock	8.75	9.0	8.75	8.93	27700.0
2011-08-26	ABCD-DELISTED	Stock	2.91	3.13	2.91	3.09	85663.0
2011-08-26	ABCO-DELISTED	Stock	29.03	30.2	28.65	29.89	121061.0
2011-08-26	ABCW-DELISTED	Stock	0.69	0.69	0.62	0.62	15440.0
2011-08-26	ABD-DELISTED	Stock	5.91	6.22	5.78	6.17	152350.0
2011-08-26	ABE-DELISTED	Stock	18.0	18.18	17.95	18.17	8799.0
2011-08-26	ABEO	Stock	2500.0	2500.0	2187.5	2487.5	6.0
2011-08-26	ABFS-DELISTED	Stock	19.2	19.68	18.66	19.55	500343.0
2011-08-26	ABG	Stock	16.91	17.84	16.69	17.59	524500.0
2011-08-26	ABH-DELISTED	Stock	15.78	16.12	15.57	16.01	216660.0
2011-08-26	ABM	Stock	19.21	19.87	18.83	19.76	169100.0
2011-08-26	ABMD-DELISTED	Stock	11.16	11.71	11.0	11.68	215914.0
2011-08-26	ABR	Stock	3.75	3.82	3.67	3.77	86900.0
2011-08-26	ABT	Stock	23.7981	24.1195	23.3327	24.062	17198416.0
2011-08-26	ABTL-DELISTED	Stock	4.4	4.4425	4.255	4.3	2502.0
2011-08-26	ABUS	Stock	1.9	1.95	1.9	1.95	2500.0
2011-08-26	ABV-DELISTED	Stock	33.32	33.36	32.61	33.2899	3062804.0
2011-08-26	ABVA-DELISTED	Stock	4.81	4.81	4.7	4.8	20150.0
2011-08-26	ABVT-DELISTED	Stock	55.84	57.56	54.73	57.42	98158.0

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

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