PREVIEW / stock_daily / 2019-09-17

all stock daily files

  file:    by_date/stock_daily/2019/2019-09-17.parquet
  size:    221 KB
  rows:    6,588
  symbols: 2,508

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
2019-09-17	AAPL	Stock	54.99	55.205	54.78	55.175	73274800.0
2019-09-17	MSFT	Stock	136.96	137.52	136.43	137.39	17814200.0
2019-09-17	NVDA	Stock	4.512	4.531	4.4652	4.5268	223048000.0
2019-09-17	AMZN	Stock	90.354	91.1995	90.205	91.1275	39648000.0
2019-09-17	GOOGL	Stock	61.5815	61.75	61.1675	61.494	20944020.0
2019-09-17	META	Stock	186.66	188.32	185.54	188.08	9671100.0
2019-09-17	TSLA	Stock	16.1647	16.3733	16.0247	16.3193	57981000.0
2019-09-17	TLT	Stock	138.36	139.6	138.02	139.03	9287893.0
2019-09-17	ES	Stock	82.38	83.43	82.38	83.15	1654000.0
2019-09-17	CL	Stock	69.57	70.7	69.53	69.86	3381800.0
2019-09-17	A	Stock	76.95	76.97	76.28	76.4	2716800.0
2019-09-17	AA	Stock	22.0	22.35	21.55	22.03	3653900.0
2019-09-17	AABA-DELISTED	Stock	70.17	70.27	70.15	70.19	3167563.0
2019-09-17	AAC-DELISTED	Stock	0.84	0.85	0.7803	0.8146	102504.0
2019-09-17	AACG	Stock	1.81	1.83	1.81	1.81	17500.0
2019-09-17	AAIC-DELISTED	Stock	5.53	5.53	5.35	5.43	363029.0
2019-09-17	AAIC.C-DELISTED	Stock	21.35	21.704	21.35	21.45	9056.0
2019-09-17	AAL	Stock	28.02	29.25	27.92	28.64	12683400.0
2019-09-17	AAM.A-DELISTED	Stock	26.2	26.3116	26.2	26.25	11945.0
2019-09-17	AAM.B-DELISTED	Stock	26.34	26.49	26.34	26.4456	7055.0
2019-09-17	AAMC-DELISTED	Stock	3.0088	3.0265	2.7971	2.9618	18384.0
2019-09-17	AAME	Stock	2.74	2.74	2.65	2.74	1900.0
2019-09-17	AAMI	Stock	10.42	10.55	10.28	10.55	660000.0
2019-09-17	AAOI	Stock	11.29	11.35	10.93	11.3	343900.0
2019-09-17	AAON	Stock	33.6733	34.2267	33.3467	34.0933	131100.0
2019-09-17	AAP	Stock	155.44	157.0	153.74	156.07	841000.0
2019-09-17	AAT	Stock	46.78	47.49	46.78	47.45	577800.0
2019-09-17	AAU-DELISTED	Stock	0.71	0.78	0.71	0.7412	197651.0
2019-09-17	AAUAF-DELISTED	Stock	0.71	0.78	0.71	0.7412	202933.0
2019-09-17	AAWW-DELISTED	Stock	26.34	26.8038	25.17	25.73	626157.0
2019-09-17	AAXJ	Stock	67.53	68.085	67.48	68.05	418253.0
2019-09-17	AAXN-DELISTED	Stock	66.42	66.48	65.18	66.1	264794.0
2019-09-17	AB	Stock	29.53	29.94	29.44	29.48	179000.0
2019-09-17	ABB-DELISTED	Stock	20.15	20.37	20.13	20.37	1380548.0
2019-09-17	ABBNY-DELISTED	Stock	20.15	20.37	20.13	20.36	1450051.0
2019-09-17	ABBV	Stock	70.51	72.09	70.36	71.6	9013500.0
2019-09-17	ABC-DELISTED	Stock	84.17	84.56	83.145	83.19	757895.0
2019-09-17	ABCB	Stock	38.96	39.02	38.33	38.76	324400.0
2019-09-17	ABDC-DELISTED	Stock	8.83	8.87	8.75	8.77	52693.0
2019-09-17	ABEO	Stock	75.5	76.5	70.5	73.0	19696.0
2019-09-17	ABEV	Stock	4.65	4.79	4.65	4.77	13526400.0
2019-09-17	ABG	Stock	98.74	101.34	98.29	100.92	140800.0
2019-09-17	ABIL-DELISTED	Stock	0.62	0.62	0.571	0.6	40870.0
2019-09-17	ABM	Stock	36.49	36.97	36.37	36.49	182500.0
2019-09-17	ABMD-DELISTED	Stock	189.71	191.8	188.33	190.64	229205.0
2019-09-17	ABR	Stock	12.83	12.87	12.8	12.86	600200.0
2019-09-17	ABR.A-DELISTED	Stock	26.09	26.09	25.9927	25.9927	1000.0
2019-09-17	ABR.B-DELISTED	Stock	25.9	25.9	25.64	25.7679	5452.0
2019-09-17	ABR.C-DELISTED	Stock	26.96	26.96	26.96	26.96	100.0
2019-09-17	ABT	Stock	83.4	84.5	83.21	83.58	3578300.0

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

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