PREVIEW / stock_daily / 2011-12-23

all stock daily files

  file:    by_date/stock_daily/2011/2011-12-23.parquet
  size:    198 KB
  rows:    6,197
  symbols: 3,589

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-23	AAPL	Stock	14.2746	14.4139	14.2675	14.4046	269399200.0
2011-12-23	MSFT	Stock	25.91	26.04	25.73	26.03	23205800.0
2011-12-23	NVDA	Stock	0.3595	0.36	0.3513	0.3542	248948000.0
2011-12-23	AMZN	Stock	8.961	8.984	8.78	8.864	69930000.0
2011-12-23	TSLA	Stock	1.8667	1.8667	1.8347	1.86	8871000.0
2011-12-23	TLT	Stock	118.5599	118.71	117.74	118.27	5409903.0
2011-12-23	ES	Stock	35.45	35.79	35.44	35.71	903600.0
2011-12-23	CL	Stock	46.18	46.575	46.18	46.545	2386400.0
2011-12-23	A	Stock	24.9213	25.3076	24.814	25.2933	1936929.0
2011-12-23	AABA-DELISTED	Stock	16.05	16.26	15.8699	16.2	17646739.0
2011-12-23	AACC-DELISTED	Stock	3.785	3.949	3.55	3.87	122730.0
2011-12-23	AACG	Stock	8.64	8.64	8.28	8.59	1400.0
2011-12-23	AAIC-DELISTED	Stock	23.48	23.5	23.19	23.33	50534.0
2011-12-23	AAME	Stock	2.0	2.03	2.0	2.03	2200.0
2011-12-23	AAON	Stock	6.4444	6.563	6.3141	6.4385	236250.0
2011-12-23	AAP	Stock	69.64	70.45	69.57	70.25	411100.0
2011-12-23	AAT	Stock	20.8	20.8	20.46	20.69	91000.0
2011-12-23	AATI-DELISTED	Stock	5.77	5.77	5.76	5.76	301301.0
2011-12-23	AAU-DELISTED	Stock	2.2	2.3	2.13	2.22	98378.0
2011-12-23	AAUAF-DELISTED	Stock	2.2	2.3	2.16	2.22	97265.0
2011-12-23	AAV-DELISTED	Stock	4.02	4.13	3.968	4.1	904691.0
2011-12-23	AAWW-DELISTED	Stock	38.68	39.1	38.25	38.88	116646.0
2011-12-23	AAXJ	Stock	50.47	50.56	50.24	50.54	620556.0
2011-12-23	AAXN-DELISTED	Stock	5.59	5.63	5.38	5.38	462470.0
2011-12-23	AB	Stock	13.34	13.54	13.34	13.54	348700.0
2011-12-23	ABAC-DELISTED	Stock	1.47	1.47	1.35	1.35	12833.0
2011-12-23	ABAX-DELISTED	Stock	27.99	28.21	27.72	28.04	55988.0
2011-12-23	ABB-DELISTED	Stock	18.47	18.75	18.41	18.74	2501038.0
2011-12-23	ABBNY-DELISTED	Stock	18.47	18.75	18.41	18.75	2647201.0
2011-12-23	ABC-DELISTED	Stock	37.31	37.46	37.12	37.4001	1334332.0
2011-12-23	ABCB	Stock	10.41	10.41	10.22	10.27	17300.0
2011-12-23	ABCD-DELISTED	Stock	3.21	3.2801	3.11	3.13	20026.0
2011-12-23	ABCO-DELISTED	Stock	37.05	37.48	36.69	37.32	246925.0
2011-12-23	ABCW-DELISTED	Stock	0.3113	0.3313	0.2811	0.3263	70670.0
2011-12-23	ABD-DELISTED	Stock	9.94	9.94	9.69	9.86	166150.0
2011-12-23	ABE-DELISTED	Stock	17.21	17.39	17.21	17.39	4601.0
2011-12-23	ABEO	Stock	1625.0	1725.0	1550.0	1725.0	37.0
2011-12-23	ABFS-DELISTED	Stock	19.44	19.44	18.91	18.95	176481.0
2011-12-23	ABG	Stock	20.72	20.91	20.63	20.88	94800.0
2011-12-23	ABH-DELISTED	Stock	14.73	14.73	14.54	14.67	157290.0
2011-12-23	ABM	Stock	21.0	21.09	20.71	21.0	177800.0
2011-12-23	ABMD-DELISTED	Stock	18.47	18.69	18.27	18.46	166095.0
2011-12-23	ABR	Stock	3.54	3.65	3.54	3.6	45700.0
2011-12-23	ABT	Stock	26.7968	26.8832	26.6481	26.8784	10969154.0
2011-12-23	ABTL-DELISTED	Stock	3.9889	4.0591	3.9111	3.9111	4390.0
2011-12-23	ABUS	Stock	1.65	1.65	1.62	1.62	2300.0
2011-12-23	ABV-DELISTED	Stock	35.91	36.13	35.65	35.99	1755618.0
2011-12-23	ABVA-DELISTED	Stock	3.4601	3.58	3.3399	3.4846	11100.0
2011-12-23	ABVT-DELISTED	Stock	65.18	65.18	64.14	64.9	103801.0
2011-12-23	ABX-DELISTED	Stock	46.34	46.37	45.81	45.99	2873797.0

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

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