PREVIEW / stock_daily / 2020-12-30

all stock daily files

  file:    by_date/stock_daily/2020/2020-12-30.parquet
  size:    239 KB
  rows:    7,260
  symbols: 2,632

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-12-30	AAPL	Stock	135.58	135.99	133.4	133.72	96452100.0
2020-12-30	MSFT	Stock	225.23	225.63	221.47	221.68	20272300.0
2020-12-30	NVDA	Stock	12.9903	13.2138	12.8968	13.1458	225396000.0
2020-12-30	AMZN	Stock	167.05	167.105	164.1235	164.2925	64186000.0
2020-12-30	GOOGL	Stock	88.25	88.388	86.4	86.8125	21026160.0
2020-12-30	META	Stock	277.95	278.08	271.71	271.87	11803800.0
2020-12-30	TSLA	Stock	224.0	232.2	222.7867	231.5933	128538000.0
2020-12-30	TLT	Stock	156.82	157.53	156.68	157.5	9097313.0
2020-12-30	ES	Stock	84.8	85.83	84.8	85.33	838700.0
2020-12-30	CL	Stock	85.18	85.34	84.55	84.73	2158000.0
2020-12-30	A	Stock	117.86	118.9	117.33	117.39	1127000.0
2020-12-30	AA	Stock	22.07	23.18	21.98	22.95	3435000.0
2020-12-30	AACG	Stock	1.17	1.21	1.16	1.19	21800.0
2020-12-30	AACQ-DELISTED	Stock	10.52	10.62	10.42	10.46	1074340.0
2020-12-30	AACQU-DELISTED	Stock	11.22	11.47	11.17	11.22	131009.0
2020-12-30	AACQW-DELISTED	Stock	2.52	2.5499	2.32	2.355	300296.0
2020-12-30	AAIC-DELISTED	Stock	3.76	3.84	3.7	3.75	301207.0
2020-12-30	AAIC.C-DELISTED	Stock	20.7501	20.9999	20.7501	20.925	988.0
2020-12-30	AAL	Stock	15.85	16.2	15.72	16.15	49520200.0
2020-12-30	AAM.A-DELISTED	Stock	26.48	26.79	26.43	26.78	29085.0
2020-12-30	AAM.B-DELISTED	Stock	27.34	27.481	27.18	27.43	28201.0
2020-12-30	AAMC-DELISTED	Stock	7.0588	7.3529	6.8953	6.8953	54849.0
2020-12-30	AAME	Stock	2.12	2.15	2.1	2.1	7000.0
2020-12-30	AAMI	Stock	18.94	19.33	18.94	19.15	543800.0
2020-12-30	AAN-DELISTED	Stock	17.08	18.3	17.01	18.12	413800.0
2020-12-30	AAOI	Stock	8.85	8.9	8.58	8.6	535300.0
2020-12-30	AAON	Stock	44.74	45.7533	44.1533	44.3267	276600.0
2020-12-30	AAP	Stock	156.64	159.7	156.64	157.66	599600.0
2020-12-30	AAT	Stock	28.34	28.81	28.15	28.36	132800.0
2020-12-30	AAU-DELISTED	Stock	0.46	0.48	0.46	0.4798	1144962.0
2020-12-30	AAUAF-DELISTED	Stock	0.46	0.48	0.46	0.474	1193544.0
2020-12-30	AAWW-DELISTED	Stock	54.07	54.8899	53.93	54.62	200013.0
2020-12-30	AAXJ	Stock	89.5	89.94	89.34	89.7	790788.0
2020-12-30	AAXN-DELISTED	Stock	123.95	126.46	123.57	123.88	286432.0
2020-12-30	AB	Stock	33.05	33.37	33.0	33.23	190500.0
2020-12-30	ABB-DELISTED	Stock	27.85	28.085	27.84	27.93	875874.0
2020-12-30	ABBNY-DELISTED	Stock	27.85	28.085	27.84	27.93	946168.0
2020-12-30	ABBV	Stock	105.11	106.23	105.1	105.27	5328400.0
2020-12-30	ABC-DELISTED	Stock	97.21	97.56	96.4	96.98	471295.0
2020-12-30	ABCB	Stock	37.28	38.18	37.04	37.96	322000.0
2020-12-30	ABCL	Stock	38.59	41.1	37.62	41.1	851300.0
2020-12-30	ABCM-DELISTED	Stock	20.52	23.48	20.48	22.51	239416.0
2020-12-30	ABEO	Stock	38.75	40.75	36.75	40.25	89720.0
2020-12-30	ABEV	Stock	3.1	3.12	3.05	3.05	9659600.0
2020-12-30	ABG	Stock	138.99	147.57	138.99	145.94	149600.0
2020-12-30	ABM	Stock	37.84	38.18	37.64	37.74	207200.0
2020-12-30	ABMD-DELISTED	Stock	324.59	328.83	318.23	324.04	191790.0
2020-12-30	ABNB	Stock	151.34	152.813	145.6	148.43	3462400.0
2020-12-30	ABR	Stock	14.13	14.34	14.06	14.13	561600.0
2020-12-30	ABR.B-DELISTED	Stock	25.25	25.2674	25.2101	25.22	2147.0

> showing 50 of 7,260 rows — these rows as CSV

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