PREVIEW / stock_daily / 2017-12-14

all stock daily files

  file:    by_date/stock_daily/2017/2017-12-14.parquet
  size:    217 KB
  rows:    6,499
  symbols: 2,901

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
2017-12-14	AAPL	Stock	43.1	43.2825	42.9125	43.055	81906000.0
2017-12-14	MSFT	Stock	85.43	85.87	84.53	84.69	19306000.0
2017-12-14	NVDA	Stock	4.648	4.7335	4.615	4.6618	438164000.0
2017-12-14	AMZN	Stock	58.1855	58.8965	58.1225	58.713	64286000.0
2017-12-14	GOOGL	Stock	52.7745	53.354	52.6798	52.8735	30962780.0
2017-12-14	META	Stock	178.29	180.36	177.68	178.39	13591000.0
2017-12-14	TSLA	Stock	22.734	23.1627	22.46	22.526	86998500.0
2017-12-14	TLT	Stock	127.05	127.98	126.7866	127.87	6884986.0
2017-12-14	ES	Stock	64.91	65.2	64.25	64.78	1749100.0
2017-12-14	CL	Stock	73.35	73.5	73.01	73.24	1873600.0
2017-12-14	A	Stock	66.68	67.09	66.37	66.51	1774600.0
2017-12-14	AA	Stock	42.0	42.375	41.96	42.35	3684200.0
2017-12-14	AAAP-DELISTED	Stock	81.63	81.75	81.57	81.61	301166.0
2017-12-14	AABA-DELISTED	Stock	70.6	70.62	68.84	69.2	16094701.0
2017-12-14	AAC-DELISTED	Stock	8.64	8.88	8.4	8.47	197082.0
2017-12-14	AACG	Stock	5.42	5.74	5.08	5.26	19800.0
2017-12-14	AAIC-DELISTED	Stock	12.38	12.47	12.2332	12.3	459110.0
2017-12-14	AAL	Stock	50.59	51.36	50.08	50.21	4503100.0
2017-12-14	AAM.A-DELISTED	Stock	26.11	26.12	26.0	26.11	15976.0
2017-12-14	AAMC-DELISTED	Stock	24.1176	24.1176	23.2206	23.2206	3917.0
2017-12-14	AAME	Stock	3.08	3.45	3.08	3.4	5900.0
2017-12-14	AAMI	Stock	16.18	16.26	16.07	16.2	480000.0
2017-12-14	AAOI	Stock	40.17	40.75	39.0	39.09	877900.0
2017-12-14	AAON	Stock	23.4667	23.5	22.9333	23.0333	190950.0
2017-12-14	AAP	Stock	103.23	103.9	99.77	100.2	1111400.0
2017-12-14	AAT	Stock	39.19	39.34	38.75	38.76	191500.0
2017-12-14	AAU-DELISTED	Stock	0.92	0.9618	0.92	0.9209	360809.0
2017-12-14	AAUAF-DELISTED	Stock	0.92	0.9618	0.92	0.9209	372508.0
2017-12-14	AAV-DELISTED	Stock	3.9	4.095	3.9	4.0	347192.0
2017-12-14	AAWW-DELISTED	Stock	57.9	59.15	56.95	57.05	222036.0
2017-12-14	AAXJ	Stock	75.91	76.04	75.49	75.49	1409686.0
2017-12-14	AAXN-DELISTED	Stock	25.59	25.92	25.34	25.44	400217.0
2017-12-14	AB	Stock	25.05	25.15	24.7	24.85	329400.0
2017-12-14	ABAC-DELISTED	Stock	3.08	3.14	2.931	3.1	6658.0
2017-12-14	ABAX-DELISTED	Stock	47.3	47.87	47.155	47.8	174511.0
2017-12-14	ABB-DELISTED	Stock	26.23	26.325	26.085	26.115	2844943.0
2017-12-14	ABBNY-DELISTED	Stock	26.23	26.325	26.085	26.1	3057492.0
2017-12-14	ABBV	Stock	97.33	97.44	95.65	96.3	3985800.0
2017-12-14	ABC-DELISTED	Stock	88.35	90.8	88.205	89.4	2567181.0
2017-12-14	ABCB	Stock	47.3	47.7	46.2	46.35	240600.0
2017-12-14	ABCD-DELISTED	Stock	5.55	5.64	5.19	5.33	153367.0
2017-12-14	ABDC-DELISTED	Stock	8.26	8.39	8.26	8.35	84078.0
2017-12-14	ABE-DELISTED	Stock	14.2152	14.25	14.08	14.1504	4043.0
2017-12-14	ABEO	Stock	400.0	418.75	393.75	402.5	19404.0
2017-12-14	ABEOW-DELISTED	Stock	11.51	11.51	11.45	11.45	300.0
2017-12-14	ABEV	Stock	6.25	6.28	6.2	6.22	7838000.0
2017-12-14	ABG	Stock	65.25	66.6	62.95	63.5	348900.0
2017-12-14	ABIL-DELISTED	Stock	0.41	0.44	0.38	0.411	79693.0
2017-12-14	ABLX-DELISTED	Stock	24.19	24.2171	23.85	24.04	102029.0
2017-12-14	ABM	Stock	39.62	39.71	36.61	38.18	2461400.0

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

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