PREVIEW / stock_daily / 2011-07-21

all stock daily files

  file:    by_date/stock_daily/2011/2011-07-21.parquet
  size:    198 KB
  rows:    6,124
  symbols: 3,558

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-21	AAPL	Stock	13.8196	13.9307	13.7107	13.8318	526534400.0
2011-07-21	MSFT	Stock	27.04	27.31	26.65	27.1	81737400.0
2011-07-21	NVDA	Stock	0.3515	0.37	0.3462	0.3675	1143420000.0
2011-07-21	AMZN	Stock	10.837	10.8545	10.5535	10.6605	90906000.0
2011-07-21	TSLA	Stock	1.9273	1.944	1.8733	1.9133	15172500.0
2011-07-21	TLT	Stock	95.24	95.86	94.9	95.33	11095802.0
2011-07-21	ES	Stock	34.97	35.38	34.91	35.29	1661900.0
2011-07-21	CL	Stock	44.505	44.715	44.285	44.5	3847000.0
2011-07-21	A	Stock	33.7196	33.834	33.2618	33.5622	5937865.0
2011-07-21	AABA-DELISTED	Stock	13.5	13.625	13.36	13.59	29383639.0
2011-07-21	AACC-DELISTED	Stock	4.47	4.562	4.45	4.46	9074.0
2011-07-21	AACG	Stock	10.82	10.82	10.11	10.3	12800.0
2011-07-21	AAIC-DELISTED	Stock	31.5	31.88	31.47	31.69	51179.0
2011-07-21	AAME	Stock	2.05	2.09	2.05	2.05	5200.0
2011-07-21	AAON	Stock	7.0519	7.1793	6.8415	7.0637	116100.0
2011-07-21	AAP	Stock	54.99	55.19	54.5	55.07	1315000.0
2011-07-21	AAT	Stock	22.33	22.48	21.94	22.29	377800.0
2011-07-21	AATI-DELISTED	Stock	6.09	6.09	6.08	6.09	144834.0
2011-07-21	AAU-DELISTED	Stock	3.88	3.94	3.84	3.89	151907.0
2011-07-21	AAUAF-DELISTED	Stock	3.88	3.94	3.84	3.89	184657.0
2011-07-21	AAV-DELISTED	Stock	7.74	7.81	7.57	7.58	353002.0
2011-07-21	AAWW-DELISTED	Stock	54.78	55.44	53.96	54.42	285799.0
2011-07-21	AAXJ	Stock	62.0	62.78	61.96	62.65	484371.0
2011-07-21	AAXN-DELISTED	Stock	4.28	4.32	4.19	4.3	229595.0
2011-07-21	AB	Stock	18.04	18.74	18.04	18.56	289300.0
2011-07-21	ABAC-DELISTED	Stock	2.95	2.95	2.85	2.89	38108.0
2011-07-21	ABAX-DELISTED	Stock	29.28	30.08	29.07	29.97	92180.0
2011-07-21	ABB-DELISTED	Stock	24.85	25.15	24.76	24.99	5140018.0
2011-07-21	ABBC-DELISTED	Stock	10.3	10.53	10.29	10.42	43447.0
2011-07-21	ABBNY-DELISTED	Stock	24.86	25.15	24.76	25.01	5631718.0
2011-07-21	ABC-DELISTED	Stock	39.75	39.91	37.62	39.26	16468667.0
2011-07-21	ABCB	Stock	9.92	10.36	9.72	10.3	188200.0
2011-07-21	ABCD-DELISTED	Stock	3.33	3.38	3.23	3.36	35286.0
2011-07-21	ABCO-DELISTED	Stock	27.46	28.07	27.39	27.98	55296.0
2011-07-21	ABCW-DELISTED	Stock	0.69	0.71	0.68	0.68	39370.0
2011-07-21	ABD-DELISTED	Stock	7.52	7.67	7.44	7.49	235440.0
2011-07-21	ABE-DELISTED	Stock	19.29	19.3582	19.21	19.3501	8201.0
2011-07-21	ABEO	Stock	2875.0	3125.0	2875.0	3062.5	78.0
2011-07-21	ABFS-DELISTED	Stock	25.98	26.61	25.75	25.95	220588.0
2011-07-21	ABG	Stock	19.66	20.13	19.65	19.93	286300.0
2011-07-21	ABH-DELISTED	Stock	19.19	19.55	19.13	19.25	554252.0
2011-07-21	ABM	Stock	23.66	24.04	23.66	24.0	195000.0
2011-07-21	ABMD-DELISTED	Stock	16.72	17.32	16.72	17.24	218373.0
2011-07-21	ABR	Stock	4.57	4.65	4.5	4.54	46200.0
2011-07-21	ABT	Stock	25.3286	25.4678	25.2327	25.3574	14571905.0
2011-07-21	ABTL-DELISTED	Stock	5.5534	5.5584	4.9981	5.2	37207.0
2011-07-21	ABUS	Stock	2.46	2.63	2.46	2.5	2500.0
2011-07-21	ABV-DELISTED	Stock	32.03	32.16	31.49	31.89	2452884.0
2011-07-21	ABVT-DELISTED	Stock	64.56	64.76	63.8	63.84	201899.0
2011-07-21	ABX-DELISTED	Stock	49.61	49.98	49.37	49.59	10154216.0

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

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