PREVIEW / stock_daily / 2011-11-01

all stock daily files

  file:    by_date/stock_daily/2011/2011-11-01.parquet
  size:    195 KB
  rows:    6,074
  symbols: 3,518

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-11-01	AAPL	Stock	14.1932	14.2679	14.0436	14.1611	531790000.0
2011-11-01	MSFT	Stock	26.19	26.32	25.86	25.99	61182600.0
2011-11-01	NVDA	Stock	0.3565	0.3575	0.348	0.3515	790824000.0
2011-11-01	AMZN	Stock	10.4055	10.8105	10.3715	10.605	170236000.0
2011-11-01	TSLA	Stock	1.8927	1.928	1.8667	1.9253	9528000.0
2011-11-01	TLT	Stock	118.71	119.49	117.17	119.45	24400680.0
2011-11-01	ES	Stock	33.92	34.43	33.5	33.59	2934300.0
2011-11-01	CL	Stock	44.465	44.935	44.0	44.045	7302600.0
2011-11-01	A	Stock	25.2074	25.794	24.7926	25.2432	10616692.0
2011-11-01	AABA-DELISTED	Stock	14.93	15.08	14.75	14.93	40512085.0
2011-11-01	AACC-DELISTED	Stock	3.23	3.43	3.22	3.43	33943.0
2011-11-01	AACG	Stock	9.59	9.75	9.37	9.75	1500.0
2011-11-01	AAIC-DELISTED	Stock	22.13	23.11	21.69	21.99	124392.0
2011-11-01	AAME	Stock	1.8	1.8	1.72	1.8	1700.0
2011-11-01	AAON	Stock	6.0267	6.2252	5.8785	5.8993	237938.0
2011-11-01	AAP	Stock	63.51	65.56	63.02	64.82	823900.0
2011-11-01	AAT	Stock	19.74	19.89	18.97	19.11	204100.0
2011-11-01	AATI-DELISTED	Stock	4.28	4.31	4.17	4.23	277589.0
2011-11-01	AAU-DELISTED	Stock	2.65	2.73	2.5	2.68	139000.0
2011-11-01	AAUAF-DELISTED	Stock	2.65	2.73	2.5	2.67	140000.0
2011-11-01	AAV-DELISTED	Stock	5.04	5.1	4.86	4.92	542595.0
2011-11-01	AAWW-DELISTED	Stock	37.0	38.29	35.13	37.12	357766.0
2011-11-01	AAXJ	Stock	52.31	53.26	52.0	52.8	509529.0
2011-11-01	AAXN-DELISTED	Stock	4.86	5.04	4.86	4.97	541862.0
2011-11-01	AB	Stock	13.95	14.01	13.36	13.58	533800.0
2011-11-01	ABAC-DELISTED	Stock	1.68	1.84	1.67	1.82	60819.0
2011-11-01	ABAX-DELISTED	Stock	27.04	27.99	27.03	27.38	177091.0
2011-11-01	ABB-DELISTED	Stock	17.93	18.25	17.8	18.1	5867813.0
2011-11-01	ABBNY-DELISTED	Stock	17.93	18.25	17.8	18.1	6125738.0
2011-11-01	ABC-DELISTED	Stock	39.51	40.69	38.41	40.03	2750432.0
2011-11-01	ABCB	Stock	9.64	10.1	9.56	9.93	93400.0
2011-11-01	ABCD-DELISTED	Stock	3.15	3.23	3.04	3.2	51741.0
2011-11-01	ABCO-DELISTED	Stock	30.39	30.78	29.75	30.36	313058.0
2011-11-01	ABCW-DELISTED	Stock	0.5	0.53	0.49	0.5	49940.0
2011-11-01	ABD-DELISTED	Stock	6.485	6.7444	6.2855	6.505	377350.0
2011-11-01	ABE-DELISTED	Stock	17.57	17.9	17.56	17.9	4358.0
2011-11-01	ABEO	Stock	2200.0	2200.0	2037.5	2137.5	8.0
2011-11-01	ABFS-DELISTED	Stock	19.81	20.26	19.36	19.48	478220.0
2011-11-01	ABG	Stock	17.61	18.65	17.58	18.33	603600.0
2011-11-01	ABH-DELISTED	Stock	16.2	16.66	15.78	16.3	459533.0
2011-11-01	ABM	Stock	19.34	19.78	18.98	19.05	336500.0
2011-11-01	ABMD-DELISTED	Stock	14.4	15.18	14.23	14.33	366394.0
2011-11-01	ABR	Stock	3.51	3.58	3.5	3.5	35300.0
2011-11-01	ABT	Stock	25.4054	25.6693	25.2711	25.3142	18391622.0
2011-11-01	ABTL-DELISTED	Stock	4.3625	4.6132	4.2747	4.3875	27844.0
2011-11-01	ABUS	Stock	1.63	1.64	1.6	1.6	900.0
2011-11-01	ABV-DELISTED	Stock	32.84	33.95	32.66	33.66	2473687.0
2011-11-01	ABVA-DELISTED	Stock	5.29	5.3	5.06	5.15	7756.0
2011-11-01	ABVT-DELISTED	Stock	57.8	58.07	55.2	55.61	156556.0
2011-11-01	ABX-DELISTED	Stock	47.74	49.9	47.19	49.31	8357534.0

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

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