PREVIEW / stock_daily / 2011-12-05

all stock daily files

  file:    by_date/stock_daily/2011/2011-12-05.parquet
  size:    197 KB
  rows:    6,149
  symbols: 3,552

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-05	AAPL	Stock	14.0532	14.1575	13.9425	14.0361	357210000.0
2011-12-05	MSFT	Stock	25.78	25.8	25.5	25.7	56818400.0
2011-12-05	NVDA	Stock	0.3995	0.4	0.3838	0.387	644696000.0
2011-12-05	AMZN	Stock	9.943	9.95	9.6835	9.812	118442000.0
2011-12-05	TSLA	Stock	2.2353	2.3333	2.2287	2.2947	17401500.0
2011-12-05	TLT	Stock	117.0	118.83	116.883	118.4	7862774.0
2011-12-05	ES	Stock	34.8	34.83	34.29	34.46	1282300.0
2011-12-05	CL	Stock	45.425	45.49	45.05	45.21	3482600.0
2011-12-05	A	Stock	26.8455	27.0959	26.3019	26.5093	4575235.0
2011-12-05	AABA-DELISTED	Stock	16.11	16.14	15.84	15.89	19726940.0
2011-12-05	AACC-DELISTED	Stock	3.73	3.73	3.38	3.5	51816.0
2011-12-05	AACG	Stock	9.52	9.54	9.52	9.52	1100.0
2011-12-05	AAIC-DELISTED	Stock	20.25	20.42	20.04	20.23	52425.0
2011-12-05	AAME	Stock	1.87	1.99	1.87	1.99	700.0
2011-12-05	AAON	Stock	6.4859	6.5659	6.2963	6.4563	133650.0
2011-12-05	AAP	Stock	69.52	70.55	69.3	69.92	545300.0
2011-12-05	AAT	Stock	20.45	20.98	20.18	20.41	301600.0
2011-12-05	AATI-DELISTED	Stock	5.76	5.77	5.75	5.76	332426.0
2011-12-05	AAU-DELISTED	Stock	2.6	2.64	2.5	2.56	116102.0
2011-12-05	AAUAF-DELISTED	Stock	2.56	2.6	2.481	2.56	118168.0
2011-12-05	AAV-DELISTED	Stock	4.8	4.87	4.56	4.65	303645.0
2011-12-05	AAWW-DELISTED	Stock	40.82	41.54	40.07	40.44	213362.0
2011-12-05	AAXJ	Stock	53.06	53.19	52.5454	52.81	275948.0
2011-12-05	AAXN-DELISTED	Stock	6.23	6.23	6.09	6.14	327686.0
2011-12-05	AB	Stock	13.41	13.64	13.26	13.42	443200.0
2011-12-05	ABAC-DELISTED	Stock	1.61	1.66	1.6	1.61	3630.0
2011-12-05	ABAX-DELISTED	Stock	28.18	28.47	27.64	28.23	129924.0
2011-12-05	ABB-DELISTED	Stock	19.07	19.09	18.67	18.81	3224848.0
2011-12-05	ABBNY-DELISTED	Stock	19.07	19.09	18.67	18.8	3375848.0
2011-12-05	ABC-DELISTED	Stock	37.5	37.56	36.36	36.61	3027132.0
2011-12-05	ABCB	Stock	10.07	10.29	9.95	10.25	112600.0
2011-12-05	ABCD-DELISTED	Stock	3.04	3.05	2.96	3.04	38735.0
2011-12-05	ABCO-DELISTED	Stock	36.52	36.56	35.98	36.53	109182.0
2011-12-05	ABCW-DELISTED	Stock	0.3916	0.4317	0.3916	0.4016	13870.0
2011-12-05	ABD-DELISTED	Stock	9.5	9.59	9.179	9.3	350080.0
2011-12-05	ABE-DELISTED	Stock	18.14	18.21	18.13	18.14	9999.0
2011-12-05	ABEO	Stock	1687.5	1800.0	1637.5	1787.5	9.0
2011-12-05	ABFS-DELISTED	Stock	19.24	19.67	19.06	19.35	191993.0
2011-12-05	ABG	Stock	20.5	20.75	20.3	20.57	468600.0
2011-12-05	ABH-DELISTED	Stock	15.21	15.28	14.97	15.19	377284.0
2011-12-05	ABM	Stock	22.3	22.34	21.87	22.08	678700.0
2011-12-05	ABMD-DELISTED	Stock	20.38	20.48	19.9	20.3	262494.0
2011-12-05	ABR	Stock	3.5	3.5	3.31	3.36	107000.0
2011-12-05	ABT	Stock	26.1251	26.2595	25.8996	26.0579	12370988.0
2011-12-05	ABTL-DELISTED	Stock	3.763	3.9636	3.6646	3.787	12786.0
2011-12-05	ABUS	Stock	1.64	1.69	1.64	1.69	4200.0
2011-12-05	ABV-DELISTED	Stock	34.96	35.3	34.8	35.06	2366636.0
2011-12-05	ABVA-DELISTED	Stock	3.82	3.82	3.701	3.71	2911.0
2011-12-05	ABVT-DELISTED	Stock	61.53	63.29	61.18	62.87	187428.0
2011-12-05	ABX-DELISTED	Stock	50.5	51.78	49.92	50.26	7310144.0

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

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