PREVIEW / stock_daily / 2014-09-22

all stock daily files

  file:    by_date/stock_daily/2014/2014-09-22.parquet
  size:    222 KB
  rows:    6,654
  symbols: 3,593

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
2014-09-22	AAPL	Stock	25.45	25.535	25.145	25.265	211153600.0
2014-09-22	MSFT	Stock	47.3	47.38	46.98	47.06	38686100.0
2014-09-22	NVDA	Stock	0.4868	0.4868	0.4718	0.4723	221464000.0
2014-09-22	AMZN	Stock	16.4245	16.4745	16.053	16.225	62194000.0
2014-09-22	GOOGL	Stock	30.125	30.19	29.656	29.8635	35702020.0
2014-09-22	META	Stock	77.0	77.53	75.95	76.8	31961000.0
2014-09-22	TSLA	Stock	17.0	17.068	16.314	16.6687	123211500.0
2014-09-22	TLT	Stock	114.66	115.04	114.441	114.74	6617434.0
2014-09-22	ES	Stock	45.32	45.39	44.9	44.91	1081800.0
2014-09-22	CL	Stock	65.45	65.89	65.31	65.69	2871100.0
2014-09-22	A	Stock	41.5808	41.6237	40.9657	41.166	2357867.0
2014-09-22	AABA-DELISTED	Stock	39.77	40.04	38.22	38.65	102477037.0
2014-09-22	AACG	Stock	4.47	4.51	4.32	4.5	6800.0
2014-09-22	AAIC-DELISTED	Stock	27.5	27.59	27.31	27.33	405259.0
2014-09-22	AAL	Stock	37.0	37.0	35.44	35.58	10964300.0
2014-09-22	AAMC-DELISTED	Stock	206.4706	218.5294	206.4706	212.3559	25857.0
2014-09-22	AAME	Stock	3.75	3.94	3.7	3.9	4100.0
2014-09-22	AAOI	Stock	17.94	17.94	17.03	17.1	165900.0
2014-09-22	AAON	Stock	12.1333	12.1333	11.9467	12.0	161250.0
2014-09-22	AAP	Stock	131.0	131.14	129.27	130.9	1155500.0
2014-09-22	AAT	Stock	33.41	33.58	33.12	33.39	145000.0
2014-09-22	AAU-DELISTED	Stock	1.4	1.45	1.3	1.37	366649.0
2014-09-22	AAUAF-DELISTED	Stock	1.4	1.45	1.3	1.37	369828.0
2014-09-22	AAV-DELISTED	Stock	5.3	5.3	5.0703	5.13	880337.0
2014-09-22	AAVL-DELISTED	Stock	31.1	33.46	29.9005	32.89	135586.0
2014-09-22	AAWW-DELISTED	Stock	34.93	35.39	34.69	34.78	170783.0
2014-09-22	AAXJ	Stock	63.46	63.55	62.8	62.91	825048.0
2014-09-22	AAXN-DELISTED	Stock	16.0	16.07	15.3	15.96	2565594.0
2014-09-22	AB	Stock	27.48	27.59	26.87	27.08	218200.0
2014-09-22	ABAC-DELISTED	Stock	1.9	1.97	1.82	1.95	83277.0
2014-09-22	ABAX-DELISTED	Stock	52.65	52.66	52.0305	52.57	71582.0
2014-09-22	ABB-DELISTED	Stock	23.17	23.17	22.89	23.0	1715679.0
2014-09-22	ABBNY-DELISTED	Stock	23.17	23.17	22.89	23.01	1985145.0
2014-09-22	ABBV	Stock	59.23	59.3	58.41	58.71	9045900.0
2014-09-22	ABC-DELISTED	Stock	77.35	77.56	76.75	77.18	1107377.0
2014-09-22	ABCB	Stock	22.19	22.36	21.84	21.91	49400.0
2014-09-22	ABCD-DELISTED	Stock	1.41	1.5	1.36	1.48	104947.0
2014-09-22	ABCO-DELISTED	Stock	46.83	46.83	45.63	45.88	338245.0
2014-09-22	ABDC-DELISTED	Stock	13.85	13.94	13.6	13.62	28360.0
2014-09-22	ABE-DELISTED	Stock	14.16	14.24	14.11	14.13	14220.0
2014-09-22	ABEO	Stock	337.5	337.5	300.0	337.5	3.0
2014-09-22	ABEV	Stock	6.78	6.89	6.75	6.86	15181200.0
2014-09-22	ABG	Stock	65.55	67.16	65.22	66.84	697400.0
2014-09-22	ABGB-DELISTED	Stock	28.59	28.59	27.77	27.93	4239.0
2014-09-22	ABM	Stock	27.12	27.28	26.82	27.17	211500.0
2014-09-22	ABMD-DELISTED	Stock	25.19	25.265	24.82	25.0	176188.0
2014-09-22	ABR	Stock	6.92	6.92	6.65	6.7	66600.0
2014-09-22	ABR.A-DELISTED	Stock	24.6	24.6923	24.6	24.6	2000.0
2014-09-22	ABR.B-DELISTED	Stock	24.1799	24.18	24.069	24.18	6513.0
2014-09-22	ABR.C-DELISTED	Stock	25.14	25.14	25.14	25.14	400.0

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

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