PREVIEW / stock_daily / 2011-09-02

all stock daily files

  file:    by_date/stock_daily/2011/2011-09-02.parquet
  size:    192 KB
  rows:    6,031
  symbols: 3,484

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-02	AAPL	Stock	13.3836	13.5	13.2796	13.3589	438939200.0
2011-09-02	MSFT	Stock	25.78	26.0	25.66	25.8	43894400.0
2011-09-02	NVDA	Stock	0.3245	0.329	0.3205	0.323	471356000.0
2011-09-02	AMZN	Stock	10.447	10.5345	10.35	10.5	84640000.0
2011-09-02	TSLA	Stock	1.5773	1.5993	1.512	1.538	11548500.0
2011-09-02	TLT	Stock	111.39	112.58	110.66	112.51	16557316.0
2011-09-02	ES	Stock	33.83	34.32	33.72	33.72	2113900.0
2011-09-02	CL	Stock	44.675	44.825	44.245	44.26	4411400.0
2011-09-02	A	Stock	24.9642	25.093	24.3133	24.6066	7926660.0
2011-09-02	AABA-DELISTED	Stock	13.11	13.13	12.86	12.87	20291565.0
2011-09-02	AACC-DELISTED	Stock	4.0	4.06	3.83	4.06	39644.0
2011-09-02	AACG	Stock	9.29	9.53	9.22	9.47	2600.0
2011-09-02	AAIC-DELISTED	Stock	24.8	24.92	24.298	24.55	56840.0
2011-09-02	AAME	Stock	1.63	1.97	1.63	1.7	1500.0
2011-09-02	AAON	Stock	4.9422	5.0904	4.7407	4.7467	244350.0
2011-09-02	AAP	Stock	59.38	59.91	58.94	59.44	826600.0
2011-09-02	AAT	Stock	19.52	19.85	19.03	19.07	148900.0
2011-09-02	AATI-DELISTED	Stock	5.93	5.98	5.93	5.96	336862.0
2011-09-02	AAU-DELISTED	Stock	3.21	3.39	3.19	3.24	286156.0
2011-09-02	AAUAF-DELISTED	Stock	3.21	3.39	3.19	3.24	286556.0
2011-09-02	AAV-DELISTED	Stock	5.65	5.67	5.44	5.51	201564.0
2011-09-02	AAWW-DELISTED	Stock	47.9	48.41	46.21	46.56	292420.0
2011-09-02	AAXJ	Stock	55.12	55.32	54.56	54.71	172358.0
2011-09-02	AAXN-DELISTED	Stock	4.22	4.29	4.2	4.21	357695.0
2011-09-02	AB	Stock	16.75	17.03	16.67	16.75	353400.0
2011-09-02	ABAC-DELISTED	Stock	2.17	2.35	2.17	2.3058	44723.0
2011-09-02	ABAX-DELISTED	Stock	24.55	25.23	24.23	24.9	166646.0
2011-09-02	ABB-DELISTED	Stock	20.71	20.765	20.2	20.27	5357246.0
2011-09-02	ABBC-DELISTED	Stock	8.23	8.29	7.8	7.86	63909.0
2011-09-02	ABBNY-DELISTED	Stock	20.71	20.765	20.2	20.27	5389646.0
2011-09-02	ABC-DELISTED	Stock	38.84	39.6	38.75	38.82	1934493.0
2011-09-02	ABCB	Stock	8.55	8.76	8.45	8.47	93800.0
2011-09-02	ABCD-DELISTED	Stock	2.93	3.01	2.91	2.91	34035.0
2011-09-02	ABCO-DELISTED	Stock	29.45	30.29	28.84	29.78	175626.0
2011-09-02	ABCW-DELISTED	Stock	0.61	0.63	0.59	0.59	87360.0
2011-09-02	ABD-DELISTED	Stock	6.42	6.51	6.08	6.11	340120.0
2011-09-02	ABE-DELISTED	Stock	18.33	18.56	18.33	18.33	3689.0
2011-09-02	ABEO	Stock	2187.5	2750.0	2187.5	2500.0	1.0
2011-09-02	ABFS-DELISTED	Stock	19.35	19.59	18.97	19.05	203114.0
2011-09-02	ABG	Stock	17.66	17.69	16.74	16.84	538600.0
2011-09-02	ABH-DELISTED	Stock	15.88	15.88	15.58	15.61	209581.0
2011-09-02	ABM	Stock	19.59	19.97	19.24	19.48	325800.0
2011-09-02	ABMD-DELISTED	Stock	12.0	12.36	11.65	11.74	163775.0
2011-09-02	ABR	Stock	3.96	4.11	3.95	4.02	50500.0
2011-09-02	ABT	Stock	24.7865	24.8249	24.4698	24.489	10891622.0
2011-09-02	ABTL-DELISTED	Stock	4.7015	4.7015	4.5014	4.6485	4238.0
2011-09-02	ABUS	Stock	2.02	2.03	1.91	1.91	24200.0
2011-09-02	ABV-DELISTED	Stock	34.39	34.57	34.06	34.42	3156910.0
2011-09-02	ABVA-DELISTED	Stock	4.52	4.85	4.52	4.6	9883.0
2011-09-02	ABVT-DELISTED	Stock	58.51	59.45	58.01	59.07	206948.0

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

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