PREVIEW / stock_daily / 2011-12-09

all stock daily files

  file:    by_date/stock_daily/2011/2011-12-09.parquet
  size:    196 KB
  rows:    6,134
  symbols: 3,553

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-12-09	AAPL	Stock	14.0304	14.0729	13.9654	14.0579	296993200.0
2011-12-09	MSFT	Stock	25.52	25.87	25.5	25.7	53788500.0
2011-12-09	NVDA	Stock	0.3645	0.3755	0.3595	0.3725	555840000.0
2011-12-09	AMZN	Stock	9.5605	9.6975	9.42	9.6515	103176000.0
2011-12-09	TSLA	Stock	2.036	2.0747	2.0187	2.0693	18592500.0
2011-12-09	TLT	Stock	119.07	119.13	116.63	116.71	9855172.0
2011-12-09	ES	Stock	33.74	34.39	33.62	34.3	1632100.0
2011-12-09	CL	Stock	45.24	45.51	45.135	45.23	2969400.0
2011-12-09	A	Stock	24.9285	25.3791	24.6423	25.2718	3554415.0
2011-12-09	AABA-DELISTED	Stock	15.61	15.96	15.6001	15.94	13417613.0
2011-12-09	AACC-DELISTED	Stock	3.4	3.58	3.39	3.4	9586.0
2011-12-09	AACG	Stock	9.09	9.1	8.56	9.0	13600.0
2011-12-09	AAIC-DELISTED	Stock	21.16	21.89	21.16	21.73	42300.0
2011-12-09	AAME	Stock	1.96	1.99	1.96	1.99	400.0
2011-12-09	AAON	Stock	6.1274	6.4326	6.1274	6.3615	332775.0
2011-12-09	AAP	Stock	69.97	70.77	69.79	70.28	774400.0
2011-12-09	AAT	Stock	20.05	20.49	19.89	20.44	413000.0
2011-12-09	AATI-DELISTED	Stock	5.74	5.75	5.73	5.74	1548072.0
2011-12-09	AAU-DELISTED	Stock	2.47	2.504	2.44	2.48	152533.0
2011-12-09	AAUAF-DELISTED	Stock	2.47	2.504	2.44	2.48	153493.0
2011-12-09	AAV-DELISTED	Stock	4.26	4.29	4.15	4.16	350215.0
2011-12-09	AAWW-DELISTED	Stock	38.6	40.3	38.2178	40.02	205608.0
2011-12-09	AAXJ	Stock	50.96	51.81	50.87	51.68	921058.0
2011-12-09	AAXN-DELISTED	Stock	6.23	6.39	6.23	6.32	478817.0
2011-12-09	AB	Stock	13.19	13.63	13.15	13.38	865900.0
2011-12-09	ABAC-DELISTED	Stock	1.5199	1.54	1.48	1.48	5600.0
2011-12-09	ABAX-DELISTED	Stock	27.0	27.85	26.99	27.65	87038.0
2011-12-09	ABB-DELISTED	Stock	18.55	18.87	18.54	18.78	1792926.0
2011-12-09	ABBNY-DELISTED	Stock	18.55	18.87	18.54	18.78	1804046.0
2011-12-09	ABC-DELISTED	Stock	36.38	36.7	36.22	36.36	2078752.0
2011-12-09	ABCB	Stock	10.07	10.38	10.07	10.33	60100.0
2011-12-09	ABCD-DELISTED	Stock	2.97	3.08	2.87	2.98	41260.0
2011-12-09	ABCO-DELISTED	Stock	35.8	36.47	35.47	36.19	151795.0
2011-12-09	ABCW-DELISTED	Stock	0.3815	0.3815	0.3815	0.3815	10060.0
2011-12-09	ABD-DELISTED	Stock	9.9	10.111	9.75	9.97	500780.0
2011-12-09	ABE-DELISTED	Stock	17.54	17.71	17.52	17.6824	3957.0
2011-12-09	ABEO	Stock	1737.5	1800.0	1700.0	1800.0	46.0
2011-12-09	ABFS-DELISTED	Stock	18.75	19.4	18.4846	19.27	229305.0
2011-12-09	ABG	Stock	20.26	21.11	20.21	20.99	613700.0
2011-12-09	ABH-DELISTED	Stock	15.09	15.1	14.92	15.06	123455.0
2011-12-09	ABM	Stock	20.73	21.44	20.73	21.03	770700.0
2011-12-09	ABMD-DELISTED	Stock	20.21	21.1697	19.82	21.11	368219.0
2011-12-09	ABR	Stock	3.23	3.35	3.2	3.3	11500.0
2011-12-09	ABT	Stock	26.0483	26.2643	25.9044	26.1827	10290746.0
2011-12-09	ABTL-DELISTED	Stock	3.6963	3.8037	3.613	3.8037	3430.0
2011-12-09	ABUS	Stock	1.69	1.69	1.62	1.66	600.0
2011-12-09	ABV-DELISTED	Stock	35.45	36.0	35.43	35.93	2195602.0
2011-12-09	ABVA-DELISTED	Stock	3.71	3.74	3.71	3.74	300.0
2011-12-09	ABVT-DELISTED	Stock	63.28	66.03	63.28	65.79	255815.0
2011-12-09	ABX-DELISTED	Stock	49.55	50.08	49.11	49.82	5232109.0

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

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