PREVIEW / stock_daily / 2011-11-08

all stock daily files

  file:    by_date/stock_daily/2011/2011-11-08.parquet
  size:    196 KB
  rows:    6,103
  symbols: 3,536

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-08	AAPL	Stock	14.3646	14.5714	14.3414	14.5082	400442000.0
2011-11-08	MSFT	Stock	27.01	27.2	26.69	27.16	47822500.0
2011-11-08	NVDA	Stock	0.3733	0.3793	0.3672	0.377	549728000.0
2011-11-08	AMZN	Stock	10.96	10.9675	10.7605	10.8995	78290000.0
2011-11-08	TSLA	Stock	2.0913	2.1333	2.048	2.1227	17518500.0
2011-11-08	TLT	Stock	116.75	117.54	115.5	115.72	7539784.0
2011-11-08	ES	Stock	34.41	34.48	33.94	34.42	2025100.0
2011-11-08	CL	Stock	44.46	44.8	44.25	44.72	5662200.0
2011-11-08	A	Stock	27.196	27.7468	26.8598	27.7182	5024692.0
2011-11-08	AABA-DELISTED	Stock	15.9	16.18	15.81	15.97	24503573.0
2011-11-08	AACC-DELISTED	Stock	3.26	3.3	3.04	3.17	39237.0
2011-11-08	AACG	Stock	9.99	9.99	9.72	9.99	3800.0
2011-11-08	AAIC-DELISTED	Stock	21.99	22.49	21.58	22.12	57261.0
2011-11-08	AAME	Stock	1.75	1.8	1.59	1.8	4100.0
2011-11-08	AAON	Stock	6.5659	6.7763	6.3259	6.717	292275.0
2011-11-08	AAP	Stock	66.88	67.89	65.75	67.69	1278000.0
2011-11-08	AAT	Stock	20.1	20.94	19.47	20.6	123500.0
2011-11-08	AATI-DELISTED	Stock	3.86	3.86	3.79	3.84	376772.0
2011-11-08	AAU-DELISTED	Stock	2.72	2.9601	2.68	2.96	345586.0
2011-11-08	AAUAF-DELISTED	Stock	2.76	3.0	2.72	2.96	341595.0
2011-11-08	AAV-DELISTED	Stock	5.38	5.5	5.29	5.4	303787.0
2011-11-08	AAWW-DELISTED	Stock	37.78	39.03	36.95	38.88	230124.0
2011-11-08	AAXJ	Stock	54.46	55.1	54.03	55.0	240952.0
2011-11-08	AAXN-DELISTED	Stock	5.55	5.65	5.43	5.6	414759.0
2011-11-08	AB	Stock	13.39	13.58	13.26	13.48	498900.0
2011-11-08	ABAC-DELISTED	Stock	1.97	2.18	1.94	2.17	6237.0
2011-11-08	ABAX-DELISTED	Stock	27.35	27.9	26.92	27.75	65469.0
2011-11-08	ABB-DELISTED	Stock	18.95	19.17	18.73	19.122	2298996.0
2011-11-08	ABBNY-DELISTED	Stock	18.95	19.17	18.73	19.12	2378496.0
2011-11-08	ABC-DELISTED	Stock	39.8	39.8	39.09	39.58	1438130.0
2011-11-08	ABCB	Stock	10.49	10.67	10.34	10.66	38900.0
2011-11-08	ABCD-DELISTED	Stock	3.5099	3.53	3.3578	3.49	53345.0
2011-11-08	ABCO-DELISTED	Stock	35.5	36.04	35.09	35.97	220935.0
2011-11-08	ABCW-DELISTED	Stock	0.4905	0.5205	0.4905	0.5195	61500.0
2011-11-08	ABD-DELISTED	Stock	7.26	7.31	7.01	7.26	170060.0
2011-11-08	ABE-DELISTED	Stock	18.25	18.58	18.25	18.25	2590.0
2011-11-08	ABEO	Stock	1625.0	1675.0	1625.0	1675.0	27.0
2011-11-08	ABFS-DELISTED	Stock	20.16	20.42	19.52	20.36	366722.0
2011-11-08	ABG	Stock	18.61	18.61	17.85	18.3	391200.0
2011-11-08	ABH-DELISTED	Stock	15.89	16.36	15.5701	16.13	295036.0
2011-11-08	ABM	Stock	20.17	20.84	19.76	20.77	220200.0
2011-11-08	ABMD-DELISTED	Stock	18.88	19.38	18.7	19.28	578369.0
2011-11-08	ABR	Stock	3.95	4.02	3.82	3.88	50500.0
2011-11-08	ABT	Stock	25.7749	26.0627	25.6645	26.0339	13460609.0
2011-11-08	ABTL-DELISTED	Stock	4.4023	4.4977	4.3728	4.4977	2608.0
2011-11-08	ABUS	Stock	1.62	1.7	1.62	1.7	60700.0
2011-11-08	ABV-DELISTED	Stock	33.21	33.71	33.06	33.68	1918152.0
2011-11-08	ABVA-DELISTED	Stock	5.2	5.2	5.12	5.16	8143.0
2011-11-08	ABVT-DELISTED	Stock	61.11	61.31	60.25	61.05	261285.0
2011-11-08	ABX-DELISTED	Stock	52.21	53.26	52.02	52.05	7380261.0

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

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