PREVIEW / stock_daily / 2011-08-29

all stock daily files

  file:    by_date/stock_daily/2011/2011-08-29.parquet
  size:    195 KB
  rows:    6,107
  symbols: 3,549

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-29	AAPL	Stock	13.8636	13.9821	13.8571	13.9275	405269200.0
2011-08-29	MSFT	Stock	25.53	25.86	25.37	25.84	38863200.0
2011-08-29	NVDA	Stock	0.3345	0.3353	0.3268	0.334	601528000.0
2011-08-29	AMZN	Stock	10.141	10.3335	10.1275	10.3265	90220000.0
2011-08-29	TSLA	Stock	1.6147	1.6567	1.6013	1.6473	12051000.0
2011-08-29	TLT	Stock	106.7	107.4	106.6	106.99	6764296.0
2011-08-29	ES	Stock	34.47	34.81	34.36	34.68	1293100.0
2011-08-29	CL	Stock	44.21	44.9	44.14	44.885	4597800.0
2011-08-29	A	Stock	25.3505	26.3662	25.2146	26.2661	10804862.0
2011-08-29	AABA-DELISTED	Stock	12.9	13.68	12.69	13.68	30771518.0
2011-08-29	AACC-DELISTED	Stock	4.11	4.11	3.77	4.02	44486.0
2011-08-29	AACG	Stock	8.97	9.19	8.56	9.0	4700.0
2011-08-29	AAIC-DELISTED	Stock	25.76	27.08	25.76	26.63	89787.0
2011-08-29	AAME	Stock	1.98	1.99	1.95	1.99	800.0
2011-08-29	AAON	Stock	4.9511	5.1526	4.8474	5.1407	178200.0
2011-08-29	AAP	Stock	60.0	60.24	59.56	60.19	955300.0
2011-08-29	AAT	Stock	19.04	19.76	18.88	19.65	118700.0
2011-08-29	AATI-DELISTED	Stock	5.96	6.045	5.94	5.98	842166.0
2011-08-29	AAU-DELISTED	Stock	3.12	3.1401	3.0097	3.11	195727.0
2011-08-29	AAUAF-DELISTED	Stock	3.11	3.13	3.0	3.12	197653.0
2011-08-29	AAV-DELISTED	Stock	5.59	5.7998	5.59	5.71	368281.0
2011-08-29	AAWW-DELISTED	Stock	44.92	47.32	44.91	47.28	186017.0
2011-08-29	AAXJ	Stock	54.55	55.39	54.527	55.37	213685.0
2011-08-29	AAXN-DELISTED	Stock	4.34	4.5	4.27	4.49	505296.0
2011-08-29	AB	Stock	16.09	17.13	16.0	16.94	437000.0
2011-08-29	ABAC-DELISTED	Stock	2.12	2.4396	2.1	2.4	26075.0
2011-08-29	ABAX-DELISTED	Stock	25.25	25.86	24.854	25.7	111393.0
2011-08-29	ABB-DELISTED	Stock	20.49	20.76	20.3401	20.75	1771684.0
2011-08-29	ABBC-DELISTED	Stock	8.27	8.7	8.27	8.68	37515.0
2011-08-29	ABBNY-DELISTED	Stock	20.49	20.76	20.3401	20.74	1773444.0
2011-08-29	ABC-DELISTED	Stock	38.79	39.32	38.79	39.21	1508687.0
2011-08-29	ABCB	Stock	9.01	9.32	8.92	9.28	67800.0
2011-08-29	ABCD-DELISTED	Stock	3.13	3.14	3.08	3.1	91722.0
2011-08-29	ABCO-DELISTED	Stock	30.1	30.33	29.85	30.27	206519.0
2011-08-29	ABCW-DELISTED	Stock	0.609	0.6689	0.609	0.611	41460.0
2011-08-29	ABD-DELISTED	Stock	6.28	6.65	6.24	6.6	299380.0
2011-08-29	ABE-DELISTED	Stock	18.25	18.4	18.19	18.4	6916.0
2011-08-29	ABEO	Stock	2487.5	2487.5	2450.0	2487.5	6.0
2011-08-29	ABFS-DELISTED	Stock	19.78	20.48	19.78	20.44	197342.0
2011-08-29	ABG	Stock	17.87	18.61	17.82	18.59	309300.0
2011-08-29	ABH-DELISTED	Stock	16.23	17.08	16.15	17.01	301280.0
2011-08-29	ABM	Stock	19.98	20.78	19.89	20.7	238800.0
2011-08-29	ABMD-DELISTED	Stock	11.86	12.2	11.71	12.15	135501.0
2011-08-29	ABR	Stock	3.81	3.96	3.76	3.94	76100.0
2011-08-29	ABT	Stock	24.2683	24.585	24.2011	24.5706	9571905.0
2011-08-29	ABTL-DELISTED	Stock	4.4098	4.4902	4.3006	4.4902	9235.0
2011-08-29	ABUS	Stock	1.84	1.91	1.72	1.81	48900.0
2011-08-29	ABV-DELISTED	Stock	33.77	34.35	33.67	34.31	2874156.0
2011-08-29	ABVA-DELISTED	Stock	4.8	4.89	4.8	4.89	681.0
2011-08-29	ABVT-DELISTED	Stock	58.14	60.17	58.14	60.0	136075.0

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

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