PREVIEW / stock_daily / 2019-09-19

all stock daily files

  file:    by_date/stock_daily/2019/2019-09-19.parquet
  size:    221 KB
  rows:    6,604
  symbols: 2,513

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-19	AAPL	Stock	55.5025	55.94	55.0925	55.24	88242400.0
2019-09-19	MSFT	Stock	140.3	142.37	140.07	141.07	35772100.0
2019-09-19	NVDA	Stock	4.5055	4.524	4.4128	4.4235	245476000.0
2019-09-19	AMZN	Stock	91.051	91.6285	90.895	91.075	40630000.0
2019-09-19	GOOGL	Stock	61.616	62.217	61.6155	61.9375	16940040.0
2019-09-19	META	Stock	188.66	191.1	188.15	190.14	10392700.0
2019-09-19	TSLA	Stock	16.4	16.5293	16.3227	16.44	71937000.0
2019-09-19	TLT	Stock	140.76	140.99	139.97	140.04	13434396.0
2019-09-19	ES	Stock	83.31	83.4	82.99	83.23	1918400.0
2019-09-19	CL	Stock	70.94	71.11	70.66	70.95	3831300.0
2019-09-19	A	Stock	77.58	78.15	77.32	78.07	1743700.0
2019-09-19	AA	Stock	21.3	22.21	21.3	21.94	2990600.0
2019-09-19	AABA-DELISTED	Stock	70.27	70.45	70.25	70.43	4787228.0
2019-09-19	AAC-DELISTED	Stock	0.825	0.8476	0.755	0.7997	85446.0
2019-09-19	AACG	Stock	1.8	1.81	1.78	1.79	20000.0
2019-09-19	AAIC-DELISTED	Stock	5.6	5.64	5.53	5.56	255133.0
2019-09-19	AAIC.C-DELISTED	Stock	21.2999	21.3	21.07	21.2	10355.0
2019-09-19	AAL	Stock	28.63	28.74	28.16	28.3	5102700.0
2019-09-19	AAM.A-DELISTED	Stock	26.34	26.48	26.3138	26.47	13104.0
2019-09-19	AAM.B-DELISTED	Stock	26.4276	26.65	26.4249	26.64	15274.0
2019-09-19	AAMC-DELISTED	Stock	3.1765	3.1765	3.0147	3.0147	8524.0
2019-09-19	AAME	Stock	2.76	2.91	2.61	2.66	3600.0
2019-09-19	AAMI	Stock	10.5	10.83	10.49	10.56	1309600.0
2019-09-19	AAOI	Stock	11.01	11.123	10.88	10.95	202500.0
2019-09-19	AAON	Stock	33.7133	33.8133	33.0	33.0467	223350.0
2019-09-19	AAP	Stock	153.73	154.56	152.31	152.8	705700.0
2019-09-19	AAT	Stock	47.29	47.84	47.15	47.33	816100.0
2019-09-19	AAU-DELISTED	Stock	0.73	0.7304	0.7148	0.72	91294.0
2019-09-19	AAUAF-DELISTED	Stock	0.73	0.7304	0.7148	0.72	112836.0
2019-09-19	AAWW-DELISTED	Stock	25.91	25.923	24.45	24.61	592324.0
2019-09-19	AAXJ	Stock	67.63	67.9	67.435	67.55	438088.0
2019-09-19	AAXN-DELISTED	Stock	65.0	65.41	62.25	63.16	626468.0
2019-09-19	AB	Stock	29.4	29.65	29.34	29.4	85900.0
2019-09-19	ABB-DELISTED	Stock	20.29	20.3	20.155	20.17	672191.0
2019-09-19	ABBNY-DELISTED	Stock	20.29	20.3	20.155	20.18	782251.0
2019-09-19	ABBV	Stock	71.4	71.91	71.21	71.67	5541200.0
2019-09-19	ABC-DELISTED	Stock	83.25	85.2004	82.853	84.63	1056740.0
2019-09-19	ABCB	Stock	39.51	39.96	39.1	39.15	392500.0
2019-09-19	ABDC-DELISTED	Stock	8.95	8.96	8.84	8.91	27566.0
2019-09-19	ABEO	Stock	79.75	87.75	78.0	81.0	74276.0
2019-09-19	ABEOW-DELISTED	Stock	0.37	0.37	0.37	0.37	2800.0
2019-09-19	ABEV	Stock	4.71	4.76	4.64	4.64	32608600.0
2019-09-19	ABG	Stock	101.3	101.74	100.34	100.49	127500.0
2019-09-19	ABIL-DELISTED	Stock	0.6376	0.6376	0.5896	0.6078	23020.0
2019-09-19	ABM	Stock	36.4	36.79	36.16	36.26	271800.0
2019-09-19	ABMD-DELISTED	Stock	191.52	193.65	189.32	192.25	269039.0
2019-09-19	ABR	Stock	12.97	13.12	12.95	13.08	1118900.0
2019-09-19	ABR.A-DELISTED	Stock	26.0131	26.09	26.0131	26.036	3310.0
2019-09-19	ABR.B-DELISTED	Stock	25.7958	25.87	25.7958	25.87	400.0
2019-09-19	ABR.C-DELISTED	Stock	26.6	26.65	26.39	26.4	2926.0

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

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