PREVIEW / stock_daily / 2014-06-16

all stock daily files

  file:    by_date/stock_daily/2014/2014-06-16.parquet
  size:    219 KB
  rows:    6,553
  symbols: 3,548

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-06-16	AAPL	Stock	22.8775	23.1875	22.8625	23.05	142244000.0
2014-06-16	MSFT	Stock	41.04	41.61	41.04	41.5	24205300.0
2014-06-16	NVDA	Stock	0.4862	0.4902	0.4828	0.487	198620000.0
2014-06-16	AMZN	Stock	16.243	16.4345	16.176	16.381	48996000.0
2014-06-16	GOOGL	Stock	27.8625	27.8995	27.5	27.615	39436840.0
2014-06-16	META	Stock	64.16	64.88	63.75	64.19	31046000.0
2014-06-16	TSLA	Stock	13.784	15.0327	13.7507	14.974	198696000.0
2014-06-16	TLT	Stock	112.21	112.63	112.1	112.43	5184901.0
2014-06-16	ES	Stock	45.25	46.08	45.25	45.76	1242700.0
2014-06-16	CL	Stock	67.63	68.18	67.33	68.09	1810000.0
2014-06-16	A	Stock	41.8956	42.103	41.5951	41.7167	1641811.0
2014-06-16	AABA-DELISTED	Stock	35.0	35.49	34.77	34.8	31682116.0
2014-06-16	AACG	Stock	4.66	4.75	4.43	4.54	2100.0
2014-06-16	AAIC-DELISTED	Stock	27.77	27.87	27.71	27.83	245171.0
2014-06-16	AAL	Stock	39.68	41.29	39.67	41.06	13633600.0
2014-06-16	AAMC-DELISTED	Stock	323.5235	325.4338	317.3676	321.7647	27713.0
2014-06-16	AAME	Stock	3.83	3.9	3.7	3.75	4600.0
2014-06-16	AAOI	Stock	21.9	22.8	21.75	22.71	172200.0
2014-06-16	AAON	Stock	14.1689	14.3378	13.9067	14.2889	201375.0
2014-06-16	AAP	Stock	124.36	125.29	124.15	125.01	443900.0
2014-06-16	AAT	Stock	33.87	34.16	33.68	33.94	115900.0
2014-06-16	AAU-DELISTED	Stock	1.45	1.47	1.4	1.43	172224.0
2014-06-16	AAUAF-DELISTED	Stock	1.45	1.47	1.4	1.43	173555.0
2014-06-16	AAV-DELISTED	Stock	6.98	7.23	6.95	7.01	703624.0
2014-06-16	AAWW-DELISTED	Stock	37.12	37.8	36.57	36.95	151511.0
2014-06-16	AAXJ	Stock	62.51	62.75	62.5	62.64	630373.0
2014-06-16	AAXN-DELISTED	Stock	13.84	13.955	13.65	13.78	455992.0
2014-06-16	AB	Stock	25.31	25.64	25.03	25.29	353900.0
2014-06-16	ABAC-DELISTED	Stock	2.12	2.18	2.089	2.14	37310.0
2014-06-16	ABAX-DELISTED	Stock	43.28	43.82	43.17	43.77	100756.0
2014-06-16	ABB-DELISTED	Stock	23.21	23.305	23.18	23.28	1247844.0
2014-06-16	ABBNY-DELISTED	Stock	23.21	23.305	23.18	23.27	1301315.0
2014-06-16	ABBV	Stock	54.18	54.31	53.45	54.0	4410400.0
2014-06-16	ABC-DELISTED	Stock	71.61	72.1	71.23	71.53	1134146.0
2014-06-16	ABCB	Stock	21.52	21.55	21.07	21.29	70400.0
2014-06-16	ABCD-DELISTED	Stock	2.02	2.08	2.02	2.05	15386.0
2014-06-16	ABCO-DELISTED	Stock	49.8	50.18	49.63	49.91	328105.0
2014-06-16	ABDC-DELISTED	Stock	14.4	14.55	14.4	14.41	23687.0
2014-06-16	ABE-DELISTED	Stock	14.5	14.52	14.41	14.41	9429.0
2014-06-16	ABEO	Stock	400.0	412.5	400.0	400.0	30.0
2014-06-16	ABEV	Stock	7.11	7.14	6.97	7.0	13411000.0
2014-06-16	ABG	Stock	62.1	63.3	62.04	63.14	648100.0
2014-06-16	ABGB-DELISTED	Stock	27.85	28.15	27.73	28.0	8686.0
2014-06-16	ABM	Stock	26.45	26.59	26.23	26.29	174300.0
2014-06-16	ABMD-DELISTED	Stock	23.02	23.38	22.85	23.29	207577.0
2014-06-16	ABR	Stock	7.06	7.09	7.0	7.06	124100.0
2014-06-16	ABR.A-DELISTED	Stock	24.59	24.59	24.27	24.3	10794.0
2014-06-16	ABR.B-DELISTED	Stock	23.81	23.85	23.756	23.85	7121.0
2014-06-16	ABR.C-DELISTED	Stock	25.08	25.09	25.0	25.083	3880.0
2014-06-16	ABRN-DELISTED	Stock	24.99	25.05	24.96	24.98	11577.0

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

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