PREVIEW / stock_daily / 2011-08-03

all stock daily files

  file:    by_date/stock_daily/2011/2011-08-03.parquet
  size:    198 KB
  rows:    6,121
  symbols: 3,547

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-03	AAPL	Stock	13.9636	14.0554	13.6514	14.0204	732508000.0
2011-08-03	MSFT	Stock	26.83	27.0	26.48	26.92	64581200.0
2011-08-03	NVDA	Stock	0.3612	0.3715	0.3578	0.3703	765236000.0
2011-08-03	AMZN	Stock	10.6485	10.7415	10.277	10.498	163942000.0
2011-08-03	TSLA	Stock	1.8333	1.8553	1.756	1.8133	26917500.0
2011-08-03	TLT	Stock	101.57	103.42	101.36	101.74	21180047.0
2011-08-03	ES	Stock	33.36	33.49	32.81	33.05	2311900.0
2011-08-03	CL	Stock	42.23	42.29	41.82	42.16	6139000.0
2011-08-03	A	Stock	27.9542	28.1259	27.1102	28.0401	6587236.0
2011-08-03	AABA-DELISTED	Stock	12.78	13.07	12.525	13.01	25871053.0
2011-08-03	AACC-DELISTED	Stock	4.77	4.95	4.75	4.8	10744.0
2011-08-03	AACG	Stock	9.91	10.32	9.91	9.94	700.0
2011-08-03	AAIC-DELISTED	Stock	27.09	27.75	26.37	27.51	61007.0
2011-08-03	AAME	Stock	1.96	1.99	1.83	1.95	2500.0
2011-08-03	AAON	Stock	6.5807	6.7852	6.5126	6.6785	314550.0
2011-08-03	AAP	Stock	53.35	54.52	52.61	54.35	1273600.0
2011-08-03	AAT	Stock	21.47	21.51	20.67	21.33	119200.0
2011-08-03	AATI-DELISTED	Stock	6.05	6.07	6.01	6.04	475757.0
2011-08-03	AAU-DELISTED	Stock	3.57	3.62	3.48	3.51	204870.0
2011-08-03	AAUAF-DELISTED	Stock	3.57	3.62	3.48	3.5	205870.0
2011-08-03	AAV-DELISTED	Stock	6.8	6.86	6.6	6.82	692754.0
2011-08-03	AAWW-DELISTED	Stock	51.15	53.0	49.59	50.04	522459.0
2011-08-03	AAXJ	Stock	60.8	60.97	59.84	60.79	516938.0
2011-08-03	AAXN-DELISTED	Stock	4.17	4.29	4.04	4.26	503220.0
2011-08-03	AB	Stock	16.18	16.66	15.88	16.57	348800.0
2011-08-03	ABAC-DELISTED	Stock	2.57	2.639	2.53	2.56	12858.0
2011-08-03	ABAX-DELISTED	Stock	22.03	22.59	21.49	22.39	190888.0
2011-08-03	ABB-DELISTED	Stock	23.4	23.47	22.72	23.14	7150652.0
2011-08-03	ABBC-DELISTED	Stock	9.71	9.86	9.49	9.83	32870.0
2011-08-03	ABBNY-DELISTED	Stock	23.4	23.47	22.72	23.13	7350809.0
2011-08-03	ABC-DELISTED	Stock	37.85	38.21	37.39	38.16	4550379.0
2011-08-03	ABCB	Stock	9.97	10.23	9.78	10.12	60100.0
2011-08-03	ABCD-DELISTED	Stock	3.11	3.24	3.05	3.235	51700.0
2011-08-03	ABCO-DELISTED	Stock	27.84	29.94	26.55	28.64	487880.0
2011-08-03	ABCW-DELISTED	Stock	0.6024	0.63	0.6009	0.63	16750.0
2011-08-03	ABD-DELISTED	Stock	7.94	8.19	7.83	8.1	359550.0
2011-08-03	ABE-DELISTED	Stock	18.75	18.96	18.49	18.96	30885.0
2011-08-03	ABEO	Stock	2750.0	2862.5	2625.0	2800.0	14.0
2011-08-03	ABFS-DELISTED	Stock	23.99	23.99	22.87	23.58	907140.0
2011-08-03	ABG	Stock	20.78	21.5	20.0	21.43	558300.0
2011-08-03	ABH-DELISTED	Stock	17.4	17.86	17.1	17.67	1012659.0
2011-08-03	ABM	Stock	21.51	21.7	20.89	21.25	586700.0
2011-08-03	ABMD-DELISTED	Stock	15.15	15.28	14.8959	15.24	176859.0
2011-08-03	ABR	Stock	4.29	4.98	4.23	4.36	57500.0
2011-08-03	ABT	Stock	24.0236	24.1627	23.6829	24.1291	20149854.0
2011-08-03	ABTL-DELISTED	Stock	4.9535	5.0515	4.8495	4.9	12940.0
2011-08-03	ABUS	Stock	2.25	2.3	2.2	2.22	15400.0
2011-08-03	ABV-DELISTED	Stock	29.79	30.29	29.5	30.28	3670342.0
2011-08-03	ABVA-DELISTED	Stock	5.13	5.13	5.01	5.02	4090.0
2011-08-03	ABVT-DELISTED	Stock	59.21	60.09	57.56	59.99	233309.0

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

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