PREVIEW / stock_daily / 2017-09-19

all stock daily files

  file:    by_date/stock_daily/2017/2017-09-19.parquet
  size:    215 KB
  rows:    6,444
  symbols: 2,940

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-19	AAPL	Stock	39.8775	39.9425	39.61	39.6825	83242400.0
2017-09-19	MSFT	Stock	75.21	75.71	75.01	75.44	16093300.0
2017-09-19	NVDA	Stock	4.6377	4.7462	4.6155	4.6838	874280000.0
2017-09-19	AMZN	Stock	48.8625	48.912	48.373	48.493	53422000.0
2017-09-19	GOOGL	Stock	46.6705	46.897	46.333	46.843	24854520.0
2017-09-19	META	Stock	170.62	172.56	170.36	172.52	13168600.0
2017-09-19	TSLA	Stock	25.3333	25.4927	24.9047	25.0067	96778500.0
2017-09-19	TLT	Stock	126.28	126.31	125.73	125.82	5554948.0
2017-09-19	ES	Stock	61.74	61.93	61.42	61.77	1447300.0
2017-09-19	CL	Stock	72.53	73.08	72.37	72.81	2727900.0
2017-09-19	A	Stock	66.25	66.45	66.0	66.17	1238000.0
2017-09-19	AA	Stock	45.22	46.44	44.86	46.2	4854100.0
2017-09-19	AAAP-DELISTED	Stock	56.9	59.6016	56.9	57.67	224609.0
2017-09-19	AABA-DELISTED	Stock	67.3	67.61	67.07	67.44	3982448.0
2017-09-19	AAC-DELISTED	Stock	11.0	11.02	10.17	10.2	113706.0
2017-09-19	AACG	Stock	4.65	4.69	4.63	4.64	6600.0
2017-09-19	AAIC-DELISTED	Stock	13.24	13.3836	13.24	13.29	386835.0
2017-09-19	AAL	Stock	45.28	45.66	44.03	44.38	6884600.0
2017-09-19	AAM.A-DELISTED	Stock	26.22	26.34	26.22	26.3	34978.0
2017-09-19	AAMC-DELISTED	Stock	28.9706	28.9706	28.5882	28.8235	7633.0
2017-09-19	AAME	Stock	3.3	3.3	3.25	3.25	1700.0
2017-09-19	AAMI	Stock	13.79	13.93	13.69	13.7	518100.0
2017-09-19	AAOI	Stock	67.25	71.29	65.36	67.23	6938000.0
2017-09-19	AAON	Stock	22.1	22.1333	21.9333	22.1333	156450.0
2017-09-19	AAP	Stock	99.0	100.71	94.24	94.85	3099100.0
2017-09-19	AAT	Stock	40.5	40.5	40.01	40.09	194400.0
2017-09-19	AAU-DELISTED	Stock	1.18	1.19	1.12	1.16	283345.0
2017-09-19	AAUAF-DELISTED	Stock	1.18	1.19	1.12	1.16	286421.0
2017-09-19	AAV-DELISTED	Stock	6.45	6.575	6.45	6.45	43638.0
2017-09-19	AAWW-DELISTED	Stock	65.85	66.15	65.65	66.1	93338.0
2017-09-19	AAXJ	Stock	73.64	73.84	73.515	73.84	618217.0
2017-09-19	AAXN-DELISTED	Stock	22.45	22.5065	22.02	22.09	362524.0
2017-09-19	AB	Stock	24.35	24.55	24.25	24.4	244700.0
2017-09-19	ABAC-DELISTED	Stock	2.31	2.4	2.2637	2.2637	6337.0
2017-09-19	ABAX-DELISTED	Stock	44.18	44.18	43.66	43.82	77419.0
2017-09-19	ABB-DELISTED	Stock	24.61	24.63	24.51	24.5899	1067977.0
2017-09-19	ABBNY-DELISTED	Stock	24.61	24.63	24.51	24.58	1245683.0
2017-09-19	ABBV	Stock	85.54	86.66	85.38	86.37	7786400.0
2017-09-19	ABC-DELISTED	Stock	80.53	81.04	79.13	79.28	1379203.0
2017-09-19	ABCB	Stock	43.7	44.15	43.6	44.0	102600.0
2017-09-19	ABCD-DELISTED	Stock	6.22	6.2673	6.1	6.21	17413.0
2017-09-19	ABCO-DELISTED	Stock	53.5	53.5	53.125	53.45	1357358.0
2017-09-19	ABDC-DELISTED	Stock	10.75	10.95	10.75	10.95	51562.0
2017-09-19	ABE-DELISTED	Stock	14.1307	14.28	14.1307	14.2	10843.0
2017-09-19	ABEO	Stock	416.25	426.25	402.75	418.75	44316.0
2017-09-19	ABEOW-DELISTED	Stock	11.35	11.9	11.33	11.9	2253.0
2017-09-19	ABEV	Stock	6.75	6.81	6.73	6.77	19737400.0
2017-09-19	ABG	Stock	58.45	59.15	58.05	58.45	79000.0
2017-09-19	ABIL-DELISTED	Stock	0.77	0.8	0.7225	0.7932	68945.0
2017-09-19	ABM	Stock	38.95	39.2	38.81	39.06	388700.0

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

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