PREVIEW / stock_daily / 2011-12-13

all stock daily files

  file:    by_date/stock_daily/2011/2011-12-13.parquet
  size:    196 KB
  rows:    6,131
  symbols: 3,540

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-13	AAPL	Stock	14.0357	14.1214	13.825	13.8861	338928800.0
2011-12-13	MSFT	Stock	25.75	26.1	25.65	25.76	54581100.0
2011-12-13	NVDA	Stock	0.368	0.3725	0.351	0.3533	516596000.0
2011-12-13	AMZN	Stock	9.428	9.484	8.925	9.0255	185946000.0
2011-12-13	TSLA	Stock	2.038	2.062	1.9273	1.9633	14911500.0
2011-12-13	TLT	Stock	117.28	119.63	117.16	119.11	8905182.0
2011-12-13	ES	Stock	34.43	35.08	34.32	34.65	2612500.0
2011-12-13	CL	Stock	45.095	45.295	44.755	44.845	4277800.0
2011-12-13	A	Stock	24.3634	24.6066	23.5837	23.7124	4265997.0
2011-12-13	AABA-DELISTED	Stock	15.54	15.74	15.35	15.42	15326564.0
2011-12-13	AACC-DELISTED	Stock	3.53	3.77	3.44	3.51	12495.0
2011-12-13	AACG	Stock	9.16	9.2	8.9	8.9	6000.0
2011-12-13	AAIC-DELISTED	Stock	22.1	22.21	21.4	21.44	57055.0
2011-12-13	AAME	Stock	2.0	2.05	2.0	2.02	6100.0
2011-12-13	AAON	Stock	6.3259	6.3704	6.0415	6.077	187988.0
2011-12-13	AAP	Stock	69.6	70.03	67.71	67.9	746100.0
2011-12-13	AAT	Stock	20.15	20.39	19.85	19.97	418400.0
2011-12-13	AATI-DELISTED	Stock	5.75	5.76	5.74	5.755	626578.0
2011-12-13	AAU-DELISTED	Stock	2.36	2.4338	2.2	2.22	193265.0
2011-12-13	AAUAF-DELISTED	Stock	2.32	2.39	2.17	2.22	202734.0
2011-12-13	AAV-DELISTED	Stock	4.05	4.0901	3.83	3.99	503784.0
2011-12-13	AAWW-DELISTED	Stock	39.45	39.768	36.31	36.7	197696.0
2011-12-13	AAXJ	Stock	50.29	50.65	49.48	49.74	374710.0
2011-12-13	AAXN-DELISTED	Stock	6.17	6.205	5.76	5.8	787033.0
2011-12-13	AB	Stock	13.6	13.65	13.07	13.24	666000.0
2011-12-13	ABAC-DELISTED	Stock	1.43	1.54	1.392	1.392	12050.0
2011-12-13	ABAX-DELISTED	Stock	27.51	27.99	26.49	26.6	107523.0
2011-12-13	ABB-DELISTED	Stock	18.38	18.52	17.85	17.98	3827265.0
2011-12-13	ABBNY-DELISTED	Stock	18.38	18.52	17.85	17.97	3840930.0
2011-12-13	ABC-DELISTED	Stock	36.06	36.5	35.77	35.87	4217713.0
2011-12-13	ABCB	Stock	10.08	10.15	9.65	9.7	52400.0
2011-12-13	ABCD-DELISTED	Stock	2.8	2.83	2.7	2.75	60178.0
2011-12-13	ABCO-DELISTED	Stock	35.07	36.05	35.07	35.27	88305.0
2011-12-13	ABCW-DELISTED	Stock	0.3514	0.3569	0.3514	0.3569	33210.0
2011-12-13	ABD-DELISTED	Stock	9.915	10.185	9.785	9.925	637960.0
2011-12-13	ABE-DELISTED	Stock	17.25	17.47	17.13	17.239	12507.0
2011-12-13	ABEO	Stock	1712.5	1800.0	1712.5	1800.0	8.0
2011-12-13	ABFS-DELISTED	Stock	18.87	19.02	17.83	17.94	294169.0
2011-12-13	ABG	Stock	21.31	21.33	19.89	19.98	301200.0
2011-12-13	ABH-DELISTED	Stock	14.89	14.97	14.7	14.73	244450.0
2011-12-13	ABM	Stock	20.66	21.13	20.4	20.47	732600.0
2011-12-13	ABMD-DELISTED	Stock	20.92	21.5	20.34	20.45	438018.0
2011-12-13	ABR	Stock	3.48	3.48	3.29	3.34	25900.0
2011-12-13	ABT	Stock	26.0771	26.3122	25.9908	26.0771	13788870.0
2011-12-13	ABTL-DELISTED	Stock	3.8487	3.9164	3.7461	3.9	32094.0
2011-12-13	ABV-DELISTED	Stock	35.42	35.54	35.0	35.23	2274094.0
2011-12-13	ABVA-DELISTED	Stock	3.65	3.69	3.5	3.6101	12675.0
2011-12-13	ABVT-DELISTED	Stock	65.99	66.59	64.89	65.19	222631.0
2011-12-13	ABX-DELISTED	Stock	47.85	48.8	46.23	46.61	8329337.0
2011-12-13	ACAD	Stock	1.05	1.06	1.0	1.01	101400.0

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

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