PREVIEW / stock_daily / 2020-09-21

all stock daily files

  file:    by_date/stock_daily/2020/2020-09-21.parquet
  size:    226 KB
  rows:    6,890
  symbols: 2,457

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
2020-09-21	AAPL	Stock	104.54	110.19	103.1	110.08	195713800.0
2020-09-21	MSFT	Stock	197.19	202.71	196.38	202.54	39839700.0
2020-09-21	NVDA	Stock	11.925	12.5225	11.9045	12.5172	721044000.0
2020-09-21	AMZN	Stock	145.325	148.1	143.55	148.0235	122358000.0
2020-09-21	GOOGL	Stock	71.581	72.003	70.134	71.507	56908100.0
2020-09-21	META	Stock	247.54	249.95	244.13	248.15	24709400.0
2020-09-21	TSLA	Stock	151.0433	151.8933	135.69	149.7967	328430400.0
2020-09-21	TLT	Stock	164.89	165.4	164.135	164.4	11086895.0
2020-09-21	ES	Stock	78.11	78.78	77.0	78.02	1403700.0
2020-09-21	CL	Stock	75.32	75.93	74.35	75.19	3004500.0
2020-09-21	A	Stock	98.18	98.56	96.5	98.13	927900.0
2020-09-21	AA	Stock	12.96	13.09	11.985	12.3	7070400.0
2020-09-21	AACG	Stock	1.08	1.08	1.06	1.06	3900.0
2020-09-21	AACQ-DELISTED	Stock	9.93	10.08	9.93	9.95	614775.0
2020-09-21	AACQU-DELISTED	Stock	10.42	10.6	10.38	10.39	35755.0
2020-09-21	AACQW-DELISTED	Stock	1.65	1.67	1.55	1.6293	244913.0
2020-09-21	AAIC-DELISTED	Stock	2.68	2.7173	2.645	2.67	280297.0
2020-09-21	AAIC.C-DELISTED	Stock	18.75	19.18	18.75	19.18	703.0
2020-09-21	AAL	Stock	12.82	12.98	12.08	12.21	60604500.0
2020-09-21	AAM.A-DELISTED	Stock	26.11	26.22	26.02	26.11	12811.0
2020-09-21	AAM.B-DELISTED	Stock	26.87	27.0	26.75	26.86	13294.0
2020-09-21	AAMC-DELISTED	Stock	5.9162	6.0971	5.7706	5.9118	70727.0
2020-09-21	AAME	Stock	2.16	2.16	2.04	2.09	2300.0
2020-09-21	AAMI	Stock	13.09	13.29	12.63	12.91	486000.0
2020-09-21	AAOI	Stock	10.18	11.09	10.0	11.04	804100.0
2020-09-21	AAON	Stock	37.5533	37.5533	36.5667	37.3667	333000.0
2020-09-21	AAP	Stock	151.01	151.75	147.61	148.43	854800.0
2020-09-21	AAT	Stock	24.71	24.71	23.37	23.52	581300.0
2020-09-21	AAU-DELISTED	Stock	0.87	0.9131	0.84	0.9011	1439424.0
2020-09-21	AAUAF-DELISTED	Stock	0.87	0.9131	0.84	0.9007	1544516.0
2020-09-21	AAWW-DELISTED	Stock	60.22	60.63	57.75	59.05	412570.0
2020-09-21	AAXJ	Stock	76.44	77.14	76.0	77.14	759513.0
2020-09-21	AAXN-DELISTED	Stock	81.33	83.7606	80.54	83.15	420233.0
2020-09-21	AB	Stock	28.09	28.1	26.74	27.14	514700.0
2020-09-21	ABB-DELISTED	Stock	25.51	25.51	24.91	25.22	2156216.0
2020-09-21	ABBNY-DELISTED	Stock	25.5	25.5	24.91	25.22	2279569.0
2020-09-21	ABBV	Stock	89.14	89.43	87.17	89.09	7328300.0
2020-09-21	ABC-DELISTED	Stock	95.73	96.13	94.02	95.77	493303.0
2020-09-21	ABCB	Stock	22.24	22.96	21.21	21.52	479800.0
2020-09-21	ABEO	Stock	51.0	51.0	46.75	49.0	50724.0
2020-09-21	ABEV	Stock	2.34	2.38	2.3	2.36	13443100.0
2020-09-21	ABG	Stock	95.53	96.02	91.52	94.11	251600.0
2020-09-21	ABM	Stock	37.64	37.76	36.15	37.09	438000.0
2020-09-21	ABMD-DELISTED	Stock	260.26	266.27	256.17	265.83	211321.0
2020-09-21	ABR	Stock	11.89	12.09	11.33	11.36	2232100.0
2020-09-21	ABR.A-DELISTED	Stock	25.25	25.34	25.1	25.34	3672.0
2020-09-21	ABR.B-DELISTED	Stock	24.9	24.9	24.49	24.8	2104.0
2020-09-21	ABR.C-DELISTED	Stock	25.25	25.25	25.25	25.25	185.0
2020-09-21	ABT	Stock	105.8	106.46	104.46	105.95	4559800.0
2020-09-21	ABTC	Stock	126600.0	126630.0	120300.0	121800.0	3.3733333333333335

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

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