PREVIEW / stock_daily / 2011-10-13

all stock daily files

  file:    by_date/stock_daily/2011/2011-10-13.parquet
  size:    192 KB
  rows:    6,046
  symbols: 3,500

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-10-13	AAPL	Stock	14.4636	14.5868	14.3875	14.5868	426185200.0
2011-10-13	MSFT	Stock	26.76	27.2	26.62	27.18	43823500.0
2011-10-13	NVDA	Stock	0.3635	0.3873	0.3625	0.3865	854832000.0
2011-10-13	AMZN	Stock	11.85	11.984	11.7615	11.8075	96670000.0
2011-10-13	TSLA	Stock	1.842	1.898	1.8293	1.8627	15652500.0
2011-10-13	TLT	Stock	115.0301	116.55	114.96	115.63	11264000.0
2011-10-13	ES	Stock	32.4	32.99	32.19	32.94	1491300.0
2011-10-13	CL	Stock	45.6	45.84	45.33	45.555	3413400.0
2011-10-13	A	Stock	23.8412	23.8984	22.8112	23.226	11806529.0
2011-10-13	AABA-DELISTED	Stock	15.73	16.37	15.54	15.93	32163274.0
2011-10-13	AACC-DELISTED	Stock	3.13	3.14	3.1093	3.12	2492.0
2011-10-13	AACG	Stock	8.73	9.16	8.73	8.95	9900.0
2011-10-13	AAIC-DELISTED	Stock	24.66	24.99	24.24	24.82	25763.0
2011-10-13	AAME	Stock	1.8	1.83	1.8	1.83	1100.0
2011-10-13	AAON	Stock	5.5081	5.5526	5.36	5.4963	131288.0
2011-10-13	AAP	Stock	59.95	60.36	59.25	59.8	682800.0
2011-10-13	AAT	Stock	18.53	18.61	17.82	18.34	154200.0
2011-10-13	AATI-DELISTED	Stock	4.44	4.48	4.44	4.47	211325.0
2011-10-13	AAU-DELISTED	Stock	2.6	2.65	2.37	2.47	387976.0
2011-10-13	AAUAF-DELISTED	Stock	2.6	2.65	2.37	2.49	388676.0
2011-10-13	AAV-DELISTED	Stock	4.5	4.63	4.36	4.6	331743.0
2011-10-13	AAWW-DELISTED	Stock	35.65	35.65	33.67	34.61	272629.0
2011-10-13	AAXJ	Stock	51.11	51.44	50.6	51.23	302517.0
2011-10-13	AAXN-DELISTED	Stock	4.55	4.59	4.52	4.56	216612.0
2011-10-13	AB	Stock	14.17	14.17	13.47	14.05	389500.0
2011-10-13	ABAC-DELISTED	Stock	1.73	1.7899	1.71	1.71	7158.0
2011-10-13	ABAX-DELISTED	Stock	23.88	24.0	23.42	23.84	74920.0
2011-10-13	ABB-DELISTED	Stock	19.26	19.29	18.96	19.24	2373715.0
2011-10-13	ABBNY-DELISTED	Stock	19.27	19.29	18.96	19.23	2377615.0
2011-10-13	ABC-DELISTED	Stock	37.53	37.98	37.36	37.98	2048166.0
2011-10-13	ABCB	Stock	9.45	9.52	9.27	9.48	40000.0
2011-10-13	ABCD-DELISTED	Stock	3.01	3.14	2.98	3.13	26388.0
2011-10-13	ABCO-DELISTED	Stock	31.32	31.8	31.19	31.58	212460.0
2011-10-13	ABCW-DELISTED	Stock	0.49	0.55	0.49	0.52	10920.0
2011-10-13	ABD-DELISTED	Stock	5.515	5.5851	5.3549	5.505	116610.0
2011-10-13	ABE-DELISTED	Stock	17.35	17.489	17.27	17.41	24038.0
2011-10-13	ABEO	Stock	2287.5	2287.5	2000.0	2250.0	16.0
2011-10-13	ABFS-DELISTED	Stock	17.32	17.64	17.14	17.5	210723.0
2011-10-13	ABG	Stock	19.3	19.55	18.82	19.09	294000.0
2011-10-13	ABH-DELISTED	Stock	15.92	16.07	15.48	15.98	92623.0
2011-10-13	ABM	Stock	20.01	20.02	19.47	19.94	126300.0
2011-10-13	ABMD-DELISTED	Stock	12.25	12.25	11.96	12.03	111629.0
2011-10-13	ABR	Stock	3.27	3.36	3.27	3.35	45500.0
2011-10-13	ABT	Stock	25.2039	25.2087	24.8632	25.0216	10081075.0
2011-10-13	ABTL-DELISTED	Stock	4.35	4.45	4.25	4.45	6633.0
2011-10-13	ABUS	Stock	1.8	1.8	1.8	1.8	100.0
2011-10-13	ABV-DELISTED	Stock	32.92	33.09	32.56	32.88	2312614.0
2011-10-13	ABVA-DELISTED	Stock	4.99	5.05	4.99	5.0	22177.0
2011-10-13	ABVT-DELISTED	Stock	58.6	58.6	57.38	58.16	50270.0
2011-10-13	ABX-DELISTED	Stock	47.66	47.71	46.4899	46.99	5321454.0

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

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