PREVIEW / stock_daily / 2019-09-30

all stock daily files

  file:    by_date/stock_daily/2019/2019-09-30.parquet
  size:    220 KB
  rows:    6,583
  symbols: 2,484

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-30	AAPL	Stock	55.225	56.145	55.1975	55.9925	103909600.0
2019-09-30	MSFT	Stock	138.05	139.22	137.78	139.03	17280900.0
2019-09-30	NVDA	Stock	4.32	4.362	4.2885	4.3518	186184000.0
2019-09-30	AMZN	Stock	86.3495	86.873	85.461	86.7955	52894000.0
2019-09-30	GOOGL	Stock	61.03	61.3702	60.671	61.057	25892180.0
2019-09-30	META	Stock	177.87	178.67	176.85	178.08	10740000.0
2019-09-30	TSLA	Stock	16.2	16.2653	15.7407	16.058	88197000.0
2019-09-30	TLT	Stock	141.88	143.09	141.84	143.08	8410379.0
2019-09-30	ES	Stock	85.5	85.93	85.18	85.47	2284600.0
2019-09-30	CL	Stock	73.15	74.28	73.15	73.51	3387800.0
2019-09-30	A	Stock	76.37	77.11	76.33	76.63	1684600.0
2019-09-30	AA	Stock	20.53	20.55	19.95	20.07	3276600.0
2019-09-30	AABA-DELISTED	Stock	19.56	19.605	19.31	19.47	16682169.0
2019-09-30	AAC-DELISTED	Stock	0.6869	0.7	0.66	0.68	22039.0
2019-09-30	AACG	Stock	1.67	1.69	1.63	1.63	10100.0
2019-09-30	AAIC-DELISTED	Stock	5.43	5.52	5.42	5.49	532574.0
2019-09-30	AAIC.C-DELISTED	Stock	21.21	21.3277	20.8905	21.24	17751.0
2019-09-30	AAL	Stock	27.35	27.41	26.82	26.97	5109800.0
2019-09-30	AAM.A-DELISTED	Stock	26.5514	26.71	26.45	26.71	30498.0
2019-09-30	AAM.B-DELISTED	Stock	26.8354	26.94	26.72	26.75	68805.0
2019-09-30	AAMC-DELISTED	Stock	3.1029	3.1668	2.6794	2.7441	71964.0
2019-09-30	AAME	Stock	2.77	2.77	2.77	2.77	100.0
2019-09-30	AAMI	Stock	9.98	10.0	9.825	9.91	483400.0
2019-09-30	AAOI	Stock	11.13	11.26	10.84	11.22	514200.0
2019-09-30	AAON	Stock	30.4733	31.1267	30.24	30.6267	336900.0
2019-09-30	AAP	Stock	161.64	165.97	161.46	165.4	982800.0
2019-09-30	AAT	Stock	46.86	47.22	46.69	46.74	319800.0
2019-09-30	AAU-DELISTED	Stock	0.67	0.677	0.612	0.654	259886.0
2019-09-30	AAUAF-DELISTED	Stock	0.67	0.677	0.612	0.654	266886.0
2019-09-30	AAWW-DELISTED	Stock	24.84	25.53	24.67	25.2	305599.0
2019-09-30	AAXJ	Stock	66.49	66.72	66.3	66.32	708511.0
2019-09-30	AAXN-DELISTED	Stock	58.28	58.55	56.7	56.79	710049.0
2019-09-30	AB	Stock	29.54	29.54	29.12	29.35	117900.0
2019-09-30	ABB-DELISTED	Stock	19.67	19.7	19.605	19.66	866323.0
2019-09-30	ABBNY-DELISTED	Stock	19.67	19.7	19.605	19.67	1042958.0
2019-09-30	ABBV	Stock	74.95	76.44	74.95	75.72	8315100.0
2019-09-30	ABC-DELISTED	Stock	81.0	83.41	81.0	82.33	861798.0
2019-09-30	ABCB	Stock	40.4	40.65	40.18	40.24	487800.0
2019-09-30	ABDC-DELISTED	Stock	8.94	8.95	8.86	8.9	29636.0
2019-09-30	ABEO	Stock	61.0	62.5	55.25	56.5	17720.0
2019-09-30	ABEOW-DELISTED	Stock	0.23	0.24	0.22	0.22	400.0
2019-09-30	ABEV	Stock	4.72	4.72	4.61	4.62	14098300.0
2019-09-30	ABG	Stock	100.74	103.0	100.74	102.33	142600.0
2019-09-30	ABIL-DELISTED	Stock	0.56	0.6	0.56	0.57	8493.0
2019-09-30	ABM	Stock	36.41	36.8	36.22	36.32	318500.0
2019-09-30	ABMD-DELISTED	Stock	175.79	180.43	174.0	178.0	467185.0
2019-09-30	ABR	Stock	13.05	13.13	13.02	13.11	1115100.0
2019-09-30	ABR.B-DELISTED	Stock	26.05	26.05	25.8	26.0199	1127.0
2019-09-30	ABR.C-DELISTED	Stock	26.3	26.3	26.2776	26.3	2500.0
2019-09-30	ABT	Stock	82.19	84.39	82.19	83.67	4340900.0

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

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