PREVIEW / stock_daily / 2011-08-02

all stock daily files

  file:    by_date/stock_daily/2011/2011-08-02.parquet
  size:    197 KB
  rows:    6,101
  symbols: 3,537

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-02	AAPL	Stock	14.2018	14.2107	13.8696	13.8896	639539600.0
2011-08-02	MSFT	Stock	26.98	27.45	26.76	26.8	63883100.0
2011-08-02	NVDA	Stock	0.3618	0.3845	0.3605	0.3605	1356432000.0
2011-08-02	AMZN	Stock	11.016	11.1215	10.565	10.585	131734000.0
2011-08-02	TSLA	Stock	1.9127	1.9467	1.818	1.8227	23241000.0
2011-08-02	TLT	Stock	99.22	101.57	98.89	101.54	20850511.0
2011-08-02	ES	Stock	34.09	34.21	33.53	33.53	1368700.0
2011-08-02	CL	Stock	41.915	42.65	41.885	42.39	7853600.0
2011-08-02	A	Stock	28.8627	29.4278	27.8398	27.8541	7940221.0
2011-08-02	AABA-DELISTED	Stock	12.96	13.18	12.75	12.76	25673135.0
2011-08-02	AACC-DELISTED	Stock	4.83	4.89	4.55	4.61	15189.0
2011-08-02	AACG	Stock	9.98	10.27	9.98	9.98	16000.0
2011-08-02	AAIC-DELISTED	Stock	28.29	28.29	27.07	27.09	85898.0
2011-08-02	AAME	Stock	1.82	2.0	1.82	1.95	8800.0
2011-08-02	AAON	Stock	6.7111	6.7941	6.5481	6.557	222413.0
2011-08-02	AAP	Stock	54.08	54.94	53.18	53.24	1016300.0
2011-08-02	AAT	Stock	21.91	21.94	21.51	21.51	133300.0
2011-08-02	AATI-DELISTED	Stock	6.04	6.06	6.02	6.04	431530.0
2011-08-02	AAU-DELISTED	Stock	3.42	3.57	3.41	3.505	312358.0
2011-08-02	AAUAF-DELISTED	Stock	3.42	3.57	3.41	3.505	314358.0
2011-08-02	AAV-DELISTED	Stock	7.05	7.12	6.79	6.8	489794.0
2011-08-02	AAWW-DELISTED	Stock	50.75	55.56	49.15	51.2	1217204.0
2011-08-02	AAXJ	Stock	62.17	62.25	61.19	61.22	267803.0
2011-08-02	AAXN-DELISTED	Stock	4.23	4.34	4.145	4.15	325494.0
2011-08-02	AB	Stock	16.66	16.66	16.16	16.29	876900.0
2011-08-02	ABAC-DELISTED	Stock	2.57	2.82	2.57	2.6	36080.0
2011-08-02	ABAX-DELISTED	Stock	22.42	22.55	21.89	21.93	346922.0
2011-08-02	ABB-DELISTED	Stock	23.3	23.68	23.1	23.1	5946107.0
2011-08-02	ABBC-DELISTED	Stock	9.9	9.96	9.67	9.67	36644.0
2011-08-02	ABBNY-DELISTED	Stock	23.3	23.68	23.1	23.12	6046035.0
2011-08-02	ABC-DELISTED	Stock	37.72	37.89	37.44	37.72	5920950.0
2011-08-02	ABCB	Stock	10.19	10.3	9.97	9.99	53800.0
2011-08-02	ABCD-DELISTED	Stock	3.17	3.25	3.1	3.1	24335.0
2011-08-02	ABCO-DELISTED	Stock	26.24	26.34	25.18	25.21	157598.0
2011-08-02	ABCW-DELISTED	Stock	0.65	0.66	0.6	0.61	83690.0
2011-08-02	ABD-DELISTED	Stock	8.25	8.49	7.89	7.92	355560.0
2011-08-02	ABE-DELISTED	Stock	18.9	19.0901	18.79	18.79	33732.0
2011-08-02	ABFS-DELISTED	Stock	24.69	25.27	23.87	23.92	1483713.0
2011-08-02	ABG	Stock	21.54	21.57	20.8	20.84	712900.0
2011-08-02	ABH-DELISTED	Stock	17.7	17.9	17.29	17.42	564843.0
2011-08-02	ABM	Stock	22.11	22.42	21.52	21.55	371200.0
2011-08-02	ABMD-DELISTED	Stock	15.74	15.95	15.15	15.16	136662.0
2011-08-02	ABR	Stock	4.25	4.4	4.24	4.33	41100.0
2011-08-02	ABT	Stock	24.1243	24.2059	23.9276	24.086	20054606.0
2011-08-02	ABTL-DELISTED	Stock	4.9467	4.9967	4.8518	4.9033	7107.0
2011-08-02	ABUS	Stock	2.32	2.33	2.23	2.3	11200.0
2011-08-02	ABV-DELISTED	Stock	30.33	30.4	29.95	29.97	3201859.0
2011-08-02	ABVA-DELISTED	Stock	5.15	5.15	5.05	5.1	10459.0
2011-08-02	ABVT-DELISTED	Stock	60.0	60.98	58.93	58.99	197184.0
2011-08-02	ABX-DELISTED	Stock	48.86	49.045	48.0	48.58	9311699.0

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

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