PREVIEW / stock_daily / 2011-07-26

all stock daily files

  file:    by_date/stock_daily/2011/2011-07-26.parquet
  size:    197 KB
  rows:    6,102
  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-07-26	AAPL	Stock	14.2857	14.4464	14.2743	14.4075	476582400.0
2011-07-26	MSFT	Stock	27.82	28.15	27.78	28.08	74636500.0
2011-07-26	NVDA	Stock	0.3585	0.3675	0.3548	0.36	698276000.0
2011-07-26	AMZN	Stock	10.7495	10.78	10.5175	10.709	197272000.0
2011-07-26	TSLA	Stock	1.8873	1.918	1.8647	1.8667	11409000.0
2011-07-26	TLT	Stock	95.3	95.87	95.24	95.65	7682708.0
2011-07-26	ES	Stock	35.15	35.16	34.88	34.95	925400.0
2011-07-26	CL	Stock	43.39	43.75	43.345	43.445	2804200.0
2011-07-26	A	Stock	32.7825	32.9471	31.917	32.0744	7169783.0
2011-07-26	AABA-DELISTED	Stock	13.71	13.99	13.65	13.935	19980381.0
2011-07-26	AACC-DELISTED	Stock	4.446	4.5	4.43	4.5	14489.0
2011-07-26	AACG	Stock	10.0	10.36	9.54	9.86	8800.0
2011-07-26	AAIC-DELISTED	Stock	31.07	31.26	30.88	30.93	23248.0
2011-07-26	AAME	Stock	2.05	2.05	1.98	2.05	2500.0
2011-07-26	AAON	Stock	6.88	6.9037	6.6963	6.717	140400.0
2011-07-26	AAP	Stock	56.99	57.69	56.63	57.61	1435200.0
2011-07-26	AAT	Stock	22.29	22.87	22.1	22.58	274800.0
2011-07-26	AATI-DELISTED	Stock	6.08	6.09	6.07	6.07	329718.0
2011-07-26	AAU-DELISTED	Stock	3.69	3.69	3.49	3.57	351084.0
2011-07-26	AAUAF-DELISTED	Stock	3.69	3.69	3.49	3.57	351384.0
2011-07-26	AAV-DELISTED	Stock	7.45	7.4798	7.32	7.39	236887.0
2011-07-26	AAWW-DELISTED	Stock	56.15	56.4	55.52	56.07	151237.0
2011-07-26	AAXJ	Stock	63.01	63.146	62.667	62.94	158271.0
2011-07-26	AAXN-DELISTED	Stock	4.2	4.23	4.181	4.21	195506.0
2011-07-26	AB	Stock	18.57	18.72	18.5	18.57	214200.0
2011-07-26	ABAC-DELISTED	Stock	2.78	2.83	2.65	2.7499	5890.0
2011-07-26	ABAX-DELISTED	Stock	29.66	29.67	28.49	28.59	70826.0
2011-07-26	ABB-DELISTED	Stock	25.05	25.07	24.73	24.9	3138679.0
2011-07-26	ABBC-DELISTED	Stock	10.13	10.19	9.951	9.96	33271.0
2011-07-26	ABBNY-DELISTED	Stock	25.05	25.07	24.73	24.89	3142900.0
2011-07-26	ABC-DELISTED	Stock	40.26	40.29	39.86	39.94	2133351.0
2011-07-26	ABCB	Stock	10.06	10.29	9.9	10.12	66800.0
2011-07-26	ABCD-DELISTED	Stock	3.3	3.3499	3.26	3.26	7065.0
2011-07-26	ABCO-DELISTED	Stock	28.13	28.13	27.76	27.8	63972.0
2011-07-26	ABCW-DELISTED	Stock	0.6803	0.6969	0.6797	0.6797	3730.0
2011-07-26	ABD-DELISTED	Stock	7.28	7.33	7.09	7.18	266220.0
2011-07-26	ABE-DELISTED	Stock	19.41	19.55	19.41	19.52	49195.0
2011-07-26	ABEO	Stock	2962.5	3062.5	2575.0	2812.5	44.0
2011-07-26	ABFS-DELISTED	Stock	25.05	25.19	24.11	24.57	559859.0
2011-07-26	ABG	Stock	20.57	21.48	19.8	21.4	568700.0
2011-07-26	ABH-DELISTED	Stock	19.27	19.605	19.04	19.51	348399.0
2011-07-26	ABM	Stock	23.21	23.38	22.87	22.89	218800.0
2011-07-26	ABMD-DELISTED	Stock	16.3	16.5	16.19	16.35	252178.0
2011-07-26	ABR	Stock	4.42	4.49	4.38	4.38	41100.0
2011-07-26	ABT	Stock	25.2759	25.2759	25.0168	25.036	12220717.0
2011-07-26	ABTL-DELISTED	Stock	5.1	5.2	5.1	5.15	3627.0
2011-07-26	ABUS	Stock	2.51	2.55	2.51	2.55	1300.0
2011-07-26	ABV-DELISTED	Stock	31.14	31.28	30.73	31.04	3431253.0
2011-07-26	ABVA-DELISTED	Stock	4.59	4.6	4.52	4.52	10728.0
2011-07-26	ABVT-DELISTED	Stock	63.36	64.06	63.18	63.58	152977.0

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

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