PREVIEW / stock_daily / 2011-11-07

all stock daily files

  file:    by_date/stock_daily/2011/2011-11-07.parquet
  size:    195 KB
  rows:    6,106
  symbols: 3,537

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-07	AAPL	Stock	14.2825	14.2857	14.1475	14.2761	270275600.0
2011-11-07	MSFT	Stock	26.21	26.82	26.13	26.8	42589700.0
2011-11-07	NVDA	Stock	0.3678	0.374	0.36	0.3685	613536000.0
2011-11-07	AMZN	Stock	10.842	11.01	10.7	10.85	77200000.0
2011-11-07	TSLA	Stock	2.1093	2.1333	2.05	2.0847	18994500.0
2011-11-07	TLT	Stock	116.64	118.35	116.32	117.22	9279668.0
2011-11-07	ES	Stock	34.6	34.94	33.78	34.41	1564800.0
2011-11-07	CL	Stock	44.23	44.61	43.51	44.225	4856800.0
2011-11-07	A	Stock	26.3233	27.0744	26.073	26.9957	5491064.0
2011-11-07	AABA-DELISTED	Stock	15.25	15.7	15.25	15.69	21199065.0
2011-11-07	AACC-DELISTED	Stock	3.41	3.42	3.14	3.19	15689.0
2011-11-07	AACG	Stock	9.95	9.95	9.5	9.83	2300.0
2011-11-07	AAIC-DELISTED	Stock	21.81	21.94	21.26	21.85	79321.0
2011-11-07	AAME	Stock	1.8	1.8	1.8	1.8	400.0
2011-11-07	AAON	Stock	6.4178	6.6074	6.2696	6.5333	193050.0
2011-11-07	AAP	Stock	66.09	66.66	65.39	66.45	895300.0
2011-11-07	AAT	Stock	20.15	20.19	19.29	20.1	48900.0
2011-11-07	AATI-DELISTED	Stock	3.86	3.86	3.75	3.8	292047.0
2011-11-07	AAU-DELISTED	Stock	2.8	2.8	2.67	2.73	142100.0
2011-11-07	AAUAF-DELISTED	Stock	2.8	2.8	2.7	2.73	145663.0
2011-11-07	AAV-DELISTED	Stock	5.18	5.33	5.1	5.32	319250.0
2011-11-07	AAWW-DELISTED	Stock	38.35	38.35	36.34	37.43	212257.0
2011-11-07	AAXJ	Stock	54.39	54.76	53.91	54.75	238363.0
2011-11-07	AAXN-DELISTED	Stock	5.38	5.55	5.295	5.51	313643.0
2011-11-07	AB	Stock	13.37	13.54	13.19	13.43	353800.0
2011-11-07	ABAC-DELISTED	Stock	2.06	2.1	1.91	2.1	8400.0
2011-11-07	ABAX-DELISTED	Stock	27.69	27.85	26.89	27.2	90673.0
2011-11-07	ABB-DELISTED	Stock	18.69	18.81	18.31	18.67	1703728.0
2011-11-07	ABBNY-DELISTED	Stock	18.69	18.81	18.31	18.68	1721123.0
2011-11-07	ABC-DELISTED	Stock	39.35	39.73	38.94	39.72	1467744.0
2011-11-07	ABCB	Stock	10.27	10.45	10.1	10.43	47700.0
2011-11-07	ABCD-DELISTED	Stock	3.3	3.45	3.24	3.45	18383.0
2011-11-07	ABCO-DELISTED	Stock	36.07	36.07	34.62	35.5	219271.0
2011-11-07	ABCW-DELISTED	Stock	0.5205	0.5205	0.4963	0.5195	79800.0
2011-11-07	ABD-DELISTED	Stock	7.08	7.25	6.88	7.18	153020.0
2011-11-07	ABE-DELISTED	Stock	18.39	18.4	18.21	18.305	1942.0
2011-11-07	ABEO	Stock	1650.0	1687.5	1587.5	1687.5	22.0
2011-11-07	ABFS-DELISTED	Stock	20.15	20.32	19.28	19.96	270515.0
2011-11-07	ABG	Stock	18.5	18.6	17.83	18.4	331300.0
2011-11-07	ABH-DELISTED	Stock	15.92	16.06	15.51	15.92	228255.0
2011-11-07	ABM	Stock	19.84	20.1	19.43	19.96	155700.0
2011-11-07	ABMD-DELISTED	Stock	18.4	18.86	18.15	18.75	456567.0
2011-11-07	ABR	Stock	3.55	4.03	3.55	3.98	72600.0
2011-11-07	ABT	Stock	25.487	25.7845	25.4342	25.7317	11951021.0
2011-11-07	ABTL-DELISTED	Stock	4.4489	4.55	4.3731	4.55	6134.0
2011-11-07	ABUS	Stock	1.56	1.66	1.56	1.66	5900.0
2011-11-07	ABV-DELISTED	Stock	33.53	33.69	33.09	33.41	1776222.0
2011-11-07	ABVA-DELISTED	Stock	5.15	5.15	5.11	5.15	11700.0
2011-11-07	ABVT-DELISTED	Stock	60.19	60.98	59.95	60.38	173853.0
2011-11-07	ABX-DELISTED	Stock	51.92	52.85	51.77	52.82	4903844.0

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

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