PREVIEW / stock_daily / 2020-12-23

all stock daily files

  file:    by_date/stock_daily/2020/2020-12-23.parquet
  size:    240 KB
  rows:    7,264
  symbols: 2,641

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-23	AAPL	Stock	132.16	132.43	130.78	130.96	88223700.0
2020-12-23	MSFT	Stock	223.11	223.56	220.8	221.02	18699600.0
2020-12-23	NVDA	Stock	13.256	13.275	13.005	13.0093	179144000.0
2020-12-23	AMZN	Stock	160.25	160.5065	159.2085	159.2635	41876000.0
2020-12-23	GOOGL	Stock	86.1965	87.2055	86.06	86.4115	22973680.0
2020-12-23	META	Stock	266.89	272.17	266.23	268.11	14329000.0
2020-12-23	TSLA	Stock	210.7333	217.1667	207.5233	215.3267	99519000.0
2020-12-23	TLT	Stock	156.62	156.69	155.46	156.67	9266649.0
2020-12-23	ES	Stock	84.17	84.4	82.9	82.92	1609600.0
2020-12-23	CL	Stock	84.59	84.96	84.2	84.43	2690400.0
2020-12-23	A	Stock	118.0	118.89	117.22	117.3	1202100.0
2020-12-23	AA	Stock	21.8	22.66	21.8	22.22	3480700.0
2020-12-23	AACG	Stock	1.21	1.3	1.18	1.28	78500.0
2020-12-23	AACQ-DELISTED	Stock	10.44	10.45	10.32	10.42	646977.0
2020-12-23	AACQU-DELISTED	Stock	11.01	11.1599	10.96	11.07	201721.0
2020-12-23	AACQW-DELISTED	Stock	2.1	2.2	2.02	2.13	383705.0
2020-12-23	AAIC-DELISTED	Stock	3.8	3.925	3.73	3.86	180301.0
2020-12-23	AAIC.C-DELISTED	Stock	21.0	21.0	21.0	21.0	300.0
2020-12-23	AAL	Stock	15.51	16.17	15.5	15.89	62603800.0
2020-12-23	AAM.A-DELISTED	Stock	26.34	26.48	26.303	26.475	7084.0
2020-12-23	AAM.B-DELISTED	Stock	27.12	27.25	27.12	27.25	8653.0
2020-12-23	AAME	Stock	2.09	2.11	2.07	2.09	13000.0
2020-12-23	AAMI	Stock	18.97	19.22	18.8	18.82	487900.0
2020-12-23	AAN-DELISTED	Stock	17.21	17.45	16.52	16.75	798700.0
2020-12-23	AAOI	Stock	8.99	9.2	8.71	9.0	625600.0
2020-12-23	AAON	Stock	43.1	43.6333	42.6	43.4733	250050.0
2020-12-23	AAP	Stock	158.68	160.46	158.41	159.29	606500.0
2020-12-23	AAT	Stock	28.11	28.74	28.01	28.11	162000.0
2020-12-23	AAU-DELISTED	Stock	0.49	0.5194	0.486	0.51	3462712.0
2020-12-23	AAUAF-DELISTED	Stock	0.49	0.5194	0.486	0.51	3692469.0
2020-12-23	AAWW-DELISTED	Stock	56.17	56.95	55.65	55.74	149323.0
2020-12-23	AAXJ	Stock	87.17	87.225	86.82	87.17	2184729.0
2020-12-23	AAXN-DELISTED	Stock	129.04	134.73	129.04	131.84	426922.0
2020-12-23	AB	Stock	33.35	33.78	33.19	33.38	253700.0
2020-12-23	ABB-DELISTED	Stock	27.27	27.61	27.27	27.55	1708019.0
2020-12-23	ABBNY-DELISTED	Stock	27.27	27.61	27.27	27.56	1799301.0
2020-12-23	ABBV	Stock	103.06	103.93	102.91	103.28	3659100.0
2020-12-23	ABC-DELISTED	Stock	97.04	98.08	96.67	97.25	572603.0
2020-12-23	ABCB	Stock	36.39	37.63	36.13	37.53	279100.0
2020-12-23	ABCL	Stock	45.68	45.99	42.6	43.26	1407100.0
2020-12-23	ABCM-DELISTED	Stock	19.93	20.29	19.93	20.15	19696.0
2020-12-23	ABEO	Stock	39.75	46.0	39.25	45.0	171036.0
2020-12-23	ABEV	Stock	3.05	3.07	3.02	3.02	12838400.0
2020-12-23	ABG	Stock	138.95	140.65	135.6	139.79	151100.0
2020-12-23	ABM	Stock	38.82	38.82	37.97	38.2	324400.0
2020-12-23	ABMD-DELISTED	Stock	304.34	309.13	300.81	304.06	122405.0
2020-12-23	ABNB	Stock	162.814	168.25	155.5	158.01	5852500.0
2020-12-23	ABR	Stock	13.97	14.3	13.86	14.11	539400.0
2020-12-23	ABR.A-DELISTED	Stock	25.426	25.55	25.4001	25.46	3255.0
2020-12-23	ABR.B-DELISTED	Stock	25.31	25.42	25.18	25.1801	4809.0

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

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