PREVIEW / stock_daily / 2020-10-29

all stock daily files

  file:    by_date/stock_daily/2020/2020-10-29.parquet
  size:    227 KB
  rows:    6,936
  symbols: 2,458

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-10-29	AAPL	Stock	112.37	116.93	112.2	115.32	146129200.0
2020-10-29	MSFT	Stock	204.07	207.36	203.37	204.72	31432600.0
2020-10-29	NVDA	Stock	12.8385	13.1928	12.75	13.024	320080000.0
2020-10-29	AMZN	Stock	160.0635	162.8625	158.2	160.5505	131930000.0
2020-10-29	GOOGL	Stock	75.851	79.4368	75.8275	77.844	55406860.0
2020-10-29	META	Stock	276.55	283.6	273.78	280.83	32368100.0
2020-10-29	TSLA	Stock	136.6533	139.3533	135.4867	136.9433	67965900.0
2020-10-29	TLT	Stock	160.73	160.83	158.47	159.14	11932379.0
2020-10-29	ES	Stock	88.35	89.6	87.13	88.46	1614800.0
2020-10-29	CL	Stock	76.54	77.44	75.56	76.67	3939600.0
2020-10-29	A	Stock	102.27	103.06	100.77	102.02	1421900.0
2020-10-29	AA	Stock	12.21	12.79	12.15	12.75	5620900.0
2020-10-29	AACG	Stock	1.11	1.11	1.09	1.09	13200.0
2020-10-29	AACQ-DELISTED	Stock	9.62	9.6571	9.595	9.65	611013.0
2020-10-29	AACQU-DELISTED	Stock	10.04	10.04	10.0	10.02	950.0
2020-10-29	AACQW-DELISTED	Stock	1.08	1.19	1.08	1.1301	41827.0
2020-10-29	AAIC-DELISTED	Stock	2.47	2.5148	2.44	2.49	146748.0
2020-10-29	AAIC.C-DELISTED	Stock	18.61	18.89	18.61	18.85	4497.0
2020-10-29	AAL	Stock	10.96	11.29	10.89	11.16	44070600.0
2020-10-29	AAM.A-DELISTED	Stock	25.99	26.13	25.99	26.0	8357.0
2020-10-29	AAM.B-DELISTED	Stock	27.0	27.0	26.63	26.63	3780.0
2020-10-29	AAMC-DELISTED	Stock	6.75	7.0588	6.75	6.9118	2173.0
2020-10-29	AAME	Stock	2.08	2.08	2.08	2.08	1400.0
2020-10-29	AAMI	Stock	13.4	13.8	12.865	13.55	790400.0
2020-10-29	AAOI	Stock	9.57	9.62	9.33	9.36	534100.0
2020-10-29	AAON	Stock	38.0667	39.5	37.7467	39.32	280350.0
2020-10-29	AAP	Stock	145.73	147.52	144.23	146.0	719900.0
2020-10-29	AAT	Stock	21.01	21.68	20.73	21.19	372200.0
2020-10-29	AAU-DELISTED	Stock	0.92	0.99	0.91	0.9851	766596.0
2020-10-29	AAUAF-DELISTED	Stock	0.92	0.99	0.91	0.98	790418.0
2020-10-29	AAWW-DELISTED	Stock	59.42	62.42	59.29	61.41	285341.0
2020-10-29	AAXJ	Stock	79.36	79.98	79.1	79.65	779897.0
2020-10-29	AAXN-DELISTED	Stock	102.85	104.12	101.75	103.41	393046.0
2020-10-29	AB	Stock	29.91	30.02	29.23	29.89	792400.0
2020-10-29	ABB-DELISTED	Stock	24.35	24.52	24.1278	24.23	1528871.0
2020-10-29	ABBNY-DELISTED	Stock	24.35	24.52	24.1278	24.23	1749050.0
2020-10-29	ABBV	Stock	80.5	81.37	79.11	80.67	8876700.0
2020-10-29	ABC-DELISTED	Stock	95.01	95.4	92.235	94.59	998698.0
2020-10-29	ABCB	Stock	28.0	29.23	27.43	29.08	363100.0
2020-10-29	ABCM-DELISTED	Stock	19.08	19.83	19.08	19.12	113540.0
2020-10-29	ABEO	Stock	28.25	28.75	27.0	27.0	119992.0
2020-10-29	ABEV	Stock	2.33	2.35	2.2	2.26	35438900.0
2020-10-29	ABG	Stock	105.6	106.41	102.57	103.04	196600.0
2020-10-29	ABM	Stock	34.98	35.99	34.62	35.41	296100.0
2020-10-29	ABMD-DELISTED	Stock	268.5	270.0	254.28	254.61	611730.0
2020-10-29	ABR	Stock	11.26	11.67	11.11	11.64	1200000.0
2020-10-29	ABR.A-DELISTED	Stock	25.07	25.28	25.07	25.2436	1760.0
2020-10-29	ABR.B-DELISTED	Stock	24.95	25.2	24.95	25.2	935.0
2020-10-29	ABR.C-DELISTED	Stock	25.46	25.46	25.38	25.4308	500.0
2020-10-29	ABST-DELISTED	Stock	11.8	11.9	11.25	11.65	170811.0

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

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