PREVIEW / stock_daily / 2019-11-04

all stock daily files

  file:    by_date/stock_daily/2019/2019-11-04.parquet
  size:    221 KB
  rows:    6,594
  symbols: 2,462

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-11-04	AAPL	Stock	64.3325	64.4625	63.845	64.375	103272000.0
2019-11-04	MSFT	Stock	144.83	145.0	144.16	144.55	16912000.0
2019-11-04	NVDA	Stock	5.1462	5.275	5.123	5.2625	376716000.0
2019-11-04	AMZN	Stock	90.0505	90.753	90.0505	90.233	55438000.0
2019-11-04	GOOGL	Stock	63.8055	64.625	63.8055	64.4805	30632440.0
2019-11-04	META	Stock	194.55	197.37	193.81	194.72	16371300.0
2019-11-04	TSLA	Stock	20.9867	21.4627	20.6173	21.1647	131805000.0
2019-11-04	TLT	Stock	138.97	139.14	138.53	138.71	11134604.0
2019-11-04	ES	Stock	82.61	82.73	81.0	81.42	1574200.0
2019-11-04	CL	Stock	66.53	66.98	65.24	65.41	6528500.0
2019-11-04	A	Stock	77.68	77.85	76.73	76.74	1010200.0
2019-11-04	AA	Stock	22.28	22.985	22.02	22.91	3741000.0
2019-11-04	AACG	Stock	1.77	1.82	1.73	1.74	6000.0
2019-11-04	AAIC-DELISTED	Stock	5.86	5.91	5.83	5.85	267616.0
2019-11-04	AAIC.C-DELISTED	Stock	21.35	21.4416	21.35	21.43	3126.0
2019-11-04	AAL	Stock	30.71	30.99	30.47	30.95	5888600.0
2019-11-04	AAM.A-DELISTED	Stock	26.496	26.5799	26.45	26.55	12337.0
2019-11-04	AAM.B-DELISTED	Stock	27.01	27.2	27.01	27.19	10377.0
2019-11-04	AAMC-DELISTED	Stock	3.8853	3.8853	3.8853	3.8853	1911.0
2019-11-04	AAME	Stock	2.34	2.34	2.11	2.19	6000.0
2019-11-04	AAMI	Stock	10.16	10.54	10.16	10.53	853700.0
2019-11-04	AAOI	Stock	9.72	10.76	9.711	10.6	1131600.0
2019-11-04	AAON	Stock	33.0667	33.2	32.6067	33.0733	274500.0
2019-11-04	AAP	Stock	165.84	167.37	164.59	166.61	708700.0
2019-11-04	AAT	Stock	48.95	48.98	48.24	48.41	388900.0
2019-11-04	AAU-DELISTED	Stock	0.52	0.52	0.5	0.5009	169960.0
2019-11-04	AAUAF-DELISTED	Stock	0.52	0.52	0.5	0.5009	181105.0
2019-11-04	AAWW-DELISTED	Stock	23.31	25.145	23.27	25.13	786755.0
2019-11-04	AAXJ	Stock	71.25	71.34	71.06	71.1	532798.0
2019-11-04	AAXN-DELISTED	Stock	53.15	53.3485	51.48	51.84	523540.0
2019-11-04	AB	Stock	29.23	29.35	29.01	29.18	271100.0
2019-11-04	ABB-DELISTED	Stock	21.42	21.58	21.42	21.58	1358011.0
2019-11-04	ABBNY-DELISTED	Stock	21.42	21.58	21.42	21.58	1419924.0
2019-11-04	ABBV	Stock	82.95	83.32	82.14	82.99	9127900.0
2019-11-04	ABC-DELISTED	Stock	87.2	87.73	85.46	87.52	630589.0
2019-11-04	ABCB	Stock	43.82	44.45	43.5	43.95	446000.0
2019-11-04	ABDC-DELISTED	Stock	8.32	8.89	8.2902	8.82	42340.0
2019-11-04	ABEO	Stock	64.25	68.25	64.0	66.25	8636.0
2019-11-04	ABEOW-DELISTED	Stock	0.15	0.1863	0.14	0.16	9402.0
2019-11-04	ABEV	Stock	4.36	4.4	4.35	4.36	7088200.0
2019-11-04	ABG	Stock	108.36	108.64	106.84	108.14	171400.0
2019-11-04	ABIL-DELISTED	Stock	0.462	0.465	0.4011	0.42	26164.0
2019-11-04	ABM	Stock	36.82	37.12	36.51	36.78	270500.0
2019-11-04	ABMD-DELISTED	Stock	218.08	220.55	214.11	220.55	488414.0
2019-11-04	ABR	Stock	14.2	14.25	14.11	14.16	1738300.0
2019-11-04	ABR.A-DELISTED	Stock	26.24	26.24	25.95	26.05	2946.0
2019-11-04	ABR.C-DELISTED	Stock	26.19	26.4688	26.09	26.2199	12911.0
2019-11-04	ABT	Stock	83.04	83.21	82.22	82.22	5508000.0
2019-11-04	ABTC	Stock	150300.0	150300.0	142980.0	144600.0	0.5066666666666666
2019-11-04	ABTS	Stock	30.0	32.1	30.0	32.1	373.0

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

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