PREVIEW / stock_daily / 2017-09-15

all stock daily files

  file:    by_date/stock_daily/2017/2017-09-15.parquet
  size:    216 KB
  rows:    6,471
  symbols: 2,945

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-09-15	AAPL	Stock	39.6175	40.2425	39.5	39.97	196458400.0
2017-09-15	MSFT	Stock	74.83	75.39	74.07	75.31	38578400.0
2017-09-15	NVDA	Stock	4.3215	4.5028	4.3162	4.5028	1364792000.0
2017-09-15	AMZN	Stock	49.6505	49.8125	49.2015	49.3395	75204000.0
2017-09-15	GOOGL	Stock	47.0045	47.0875	46.5625	46.7645	39885300.0
2017-09-15	META	Stock	170.88	172.34	170.26	171.64	15660500.0
2017-09-15	TSLA	Stock	24.9673	25.3333	24.8467	25.3207	81307500.0
2017-09-15	TLT	Stock	127.0	127.01	126.54	126.86	9769178.0
2017-09-15	ES	Stock	62.81	63.17	62.5	62.86	2129600.0
2017-09-15	CL	Stock	72.33	72.62	71.72	72.28	4662400.0
2017-09-15	A	Stock	65.68	66.13	65.62	65.96	2296000.0
2017-09-15	AA	Stock	44.76	45.09	44.22	44.65	5441600.0
2017-09-15	AAAP-DELISTED	Stock	57.3	58.14	55.89	56.69	180947.0
2017-09-15	AABA-DELISTED	Stock	66.39	66.66	66.015	66.45	8028945.0
2017-09-15	AAC-DELISTED	Stock	11.42	11.519	11.21	11.39	206822.0
2017-09-15	AACG	Stock	4.7	4.7	4.68	4.7	1100.0
2017-09-15	AAIC-DELISTED	Stock	13.16	13.235	13.09	13.17	704216.0
2017-09-15	AAL	Stock	45.3	46.04	45.19	46.0	14846200.0
2017-09-15	AAM.A-DELISTED	Stock	26.26	26.27	26.15	26.27	37078.0
2017-09-15	AAMC-DELISTED	Stock	31.75	31.75	28.6618	28.6618	36815.0
2017-09-15	AAME	Stock	3.3	3.3	3.2	3.25	2400.0
2017-09-15	AAMI	Stock	13.65	13.85	13.51	13.73	2564900.0
2017-09-15	AAOI	Stock	57.25	58.9	56.9	58.3	1873700.0
2017-09-15	AAON	Stock	21.8	22.0	21.6	21.9667	471000.0
2017-09-15	AAP	Stock	99.77	99.77	98.26	99.51	2586900.0
2017-09-15	AAT	Stock	40.79	40.79	40.31	40.58	373300.0
2017-09-15	AAU-DELISTED	Stock	1.24	1.299	1.1741	1.2	401515.0
2017-09-15	AAUAF-DELISTED	Stock	1.24	1.299	1.1741	1.2	418526.0
2017-09-15	AAV-DELISTED	Stock	6.55	6.55	6.325	6.4	47980.0
2017-09-15	AAWW-DELISTED	Stock	65.9	66.35	64.95	65.8	279850.0
2017-09-15	AAXJ	Stock	72.79	73.18	72.72	73.12	474067.0
2017-09-15	AAXN-DELISTED	Stock	22.59	22.73	21.945	22.29	1189083.0
2017-09-15	AB	Stock	23.8	24.25	23.8	24.2	311600.0
2017-09-15	ABAC-DELISTED	Stock	2.111	2.35	2.111	2.35	17081.0
2017-09-15	ABAX-DELISTED	Stock	44.3	44.595	43.72	44.24	211833.0
2017-09-15	ABB-DELISTED	Stock	24.39	24.46	24.355	24.43	960798.0
2017-09-15	ABBNY-DELISTED	Stock	24.39	24.46	24.355	24.43	996615.0
2017-09-15	ABBV	Stock	89.39	89.69	86.52	87.37	20441500.0
2017-09-15	ABC-DELISTED	Stock	80.47	81.73	80.02	81.59	2405660.0
2017-09-15	ABCB	Stock	43.2	43.48	42.7	43.35	479700.0
2017-09-15	ABCD-DELISTED	Stock	6.22	6.25	5.93	6.15	102046.0
2017-09-15	ABCO-DELISTED	Stock	53.65	53.7	53.5	53.55	722679.0
2017-09-15	ABDC-DELISTED	Stock	10.88	11.0	10.78	10.93	59056.0
2017-09-15	ABE-DELISTED	Stock	14.1361	14.2	14.13	14.13	10539.0
2017-09-15	ABEO	Stock	362.5	431.25	362.5	430.0	173004.0
2017-09-15	ABEOW-DELISTED	Stock	9.25	12.5	9.25	11.7	14841.0
2017-09-15	ABEV	Stock	6.73	6.82	6.7	6.81	27233900.0
2017-09-15	ABG	Stock	58.45	59.1	58.15	58.45	353100.0
2017-09-15	ABIL-DELISTED	Stock	0.7949	0.7949	0.7119	0.76	144628.0
2017-09-15	ABM	Stock	39.91	39.91	39.22	39.56	544300.0

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

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