PREVIEW / stock_daily / 2011-06-14

all stock daily files

  file:    by_date/stock_daily/2011/2011-06-14.parquet
  size:    198 KB
  rows:    6,150
  symbols: 3,581

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-06-14	AAPL	Stock	11.7857	11.9018	11.7611	11.8729	334569200.0
2011-06-14	MSFT	Stock	24.3	24.45	24.19	24.22	42894500.0
2011-06-14	NVDA	Stock	0.4288	0.438	0.4268	0.4285	534576000.0
2011-06-14	AMZN	Stock	9.4495	9.536	9.3535	9.498	79206000.0
2011-06-14	TSLA	Stock	1.9027	1.98	1.9013	1.9067	23601000.0
2011-06-14	TLT	Stock	95.74	95.9	95.13	95.19	8672662.0
2011-06-14	ES	Stock	34.15	34.19	33.82	34.07	1255200.0
2011-06-14	CL	Stock	42.765	43.43	42.675	43.3	6611400.0
2011-06-14	A	Stock	34.5851	35.6867	34.485	35.0286	6710959.0
2011-06-14	AABA-DELISTED	Stock	15.26	15.56	15.1875	15.19	21557873.0
2011-06-14	AACC-DELISTED	Stock	3.34	3.36	3.26	3.3	29198.0
2011-06-14	AACG	Stock	10.5	10.69	10.5	10.55	28300.0
2011-06-14	AAIC-DELISTED	Stock	29.2	29.2	29.0	29.08	36357.0
2011-06-14	AAME	Stock	1.85	2.05	1.82	2.05	18000.0
2011-06-14	AAON	Stock	6.2696	6.3348	6.1807	6.2963	206550.0
2011-06-14	AAP	Stock	57.27	57.55	56.58	57.25	3024600.0
2011-06-14	AAT	Stock	21.48	21.72	21.45	21.72	83900.0
2011-06-14	AATI-DELISTED	Stock	6.04	6.05	6.04	6.04	477295.0
2011-06-14	AAU-DELISTED	Stock	3.09	3.25	3.05	3.14	425080.0
2011-06-14	AAUAF-DELISTED	Stock	3.08	3.25	3.05	3.14	425780.0
2011-06-14	AAV-DELISTED	Stock	7.88	8.12	7.88	8.07	281540.0
2011-06-14	AAWW-DELISTED	Stock	57.65	58.23	57.1	57.69	217608.0
2011-06-14	AAXJ	Stock	61.58	61.89	61.48	61.68	349963.0
2011-06-14	AAXN-DELISTED	Stock	4.39	4.49	4.29	4.34	561145.0
2011-06-14	AB	Stock	19.53	19.79	19.52	19.52	260100.0
2011-06-14	ABAC-DELISTED	Stock	2.01	2.2199	2.01	2.1	39467.0
2011-06-14	ABAX-DELISTED	Stock	27.82	28.43	27.57	28.28	88073.0
2011-06-14	ABB-DELISTED	Stock	25.75	26.13	25.72	25.95	4508042.0
2011-06-14	ABBC-DELISTED	Stock	10.28	10.55	10.28	10.47	55944.0
2011-06-14	ABBNY-DELISTED	Stock	25.75	26.13	25.72	25.95	4606072.0
2011-06-14	ABC-DELISTED	Stock	41.08	41.36	40.82	41.24	2024445.0
2011-06-14	ABCB	Stock	8.63	8.72	8.58	8.64	115100.0
2011-06-14	ABCD-DELISTED	Stock	3.16	3.2	3.09	3.2	771938.0
2011-06-14	ABCO-DELISTED	Stock	24.01	24.56	23.88	24.49	89732.0
2011-06-14	ABCW-DELISTED	Stock	0.7	0.7	0.61	0.66	36810.0
2011-06-14	ABD-DELISTED	Stock	7.27	7.82	7.21	7.64	366550.0
2011-06-14	ABE-DELISTED	Stock	18.57	18.69	18.57	18.5701	3537.0
2011-06-14	ABEO	Stock	2550.0	2600.0	2412.5	2525.0	74.0
2011-06-14	ABFS-DELISTED	Stock	21.85	22.38	21.82	22.34	364220.0
2011-06-14	ABG	Stock	15.28	16.04	15.2	15.85	294600.0
2011-06-14	ABH-DELISTED	Stock	22.79	22.975	22.6	22.78	761682.0
2011-06-14	ABM	Stock	22.03	22.57	21.99	22.41	219000.0
2011-06-14	ABMD-DELISTED	Stock	16.42	16.69	16.17	16.47	124484.0
2011-06-14	ABR	Stock	4.22	4.35	3.91	4.17	338800.0
2011-06-14	ABT	Stock	24.8201	24.8201	24.537	24.6089	17939975.0
2011-06-14	ABTL-DELISTED	Stock	5.3	5.5	5.05	5.15	69488.0
2011-06-14	ABUS	Stock	2.75	2.8	2.7	2.79	3200.0
2011-06-14	ABV-DELISTED	Stock	31.66	32.08	31.5	31.95	1791904.0
2011-06-14	ABVA-DELISTED	Stock	5.16	5.19	5.0	5.04	7131.0
2011-06-14	ABVT-DELISTED	Stock	73.5	73.73	72.5	73.25	137152.0

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

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