PREVIEW / stock_daily / 2023-03-20

all stock daily files

  file:    by_date/stock_daily/2023/2023-03-20.parquet
  size:    245 KB
  rows:    7,608
  symbols: 1,748

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
2023-03-20	AAPL	Stock	155.07	157.82	154.15	157.4	73641400.0
2023-03-20	MSFT	Stock	276.98	277.48	269.85	272.23	43466600.0
2023-03-20	NVDA	Stock	25.615	26.024	25.13	25.9	432747000.0
2023-03-20	AMZN	Stock	98.41	98.48	95.7	97.71	62388900.0
2023-03-20	GOOGL	Stock	100.12	101.75	99.87	101.22	32960440.0
2023-03-20	META	Stock	198.48	199.36	193.64	197.81	25186300.0
2023-03-20	TSLA	Stock	178.08	186.44	176.35	183.25	129684400.0
2023-03-20	TLT	Stock	106.88	106.96	105.72	105.91	24242781.0
2023-03-20	ES	Stock	76.03	76.78	75.78	76.18	2021300.0
2023-03-20	CL	Stock	72.44	73.3	72.39	73.08	4557500.0
2023-03-20	A	Stock	133.14	135.38	132.73	134.54	1704500.0
2023-03-20	AA	Stock	39.89	40.78	39.69	40.28	8559800.0
2023-03-20	AAC-DELISTED	Stock	10.31	10.35	10.3	10.315	208735.0
2023-03-20	AACG	Stock	1.89	1.93	1.8	1.8	10900.0
2023-03-20	AAIC-DELISTED	Stock	2.72	2.77	2.72	2.77	32881.0
2023-03-20	AAL	Stock	14.02	14.21	13.87	13.96	28076200.0
2023-03-20	AAM.A-DELISTED	Stock	21.05	22.0	20.31	20.53	23634.0
2023-03-20	AAM.B-DELISTED	Stock	21.11	21.62	20.2275	20.5	19988.0
2023-03-20	AAMC-DELISTED	Stock	14.4353	15.0059	14.4353	14.7382	31895.0
2023-03-20	AAME	Stock	2.49	2.53	2.38	2.52	9700.0
2023-03-20	AAMI	Stock	22.1	22.79	22.1	22.5	201000.0
2023-03-20	AAN-DELISTED	Stock	9.52	9.7	9.26	9.38	436900.0
2023-03-20	AAOI	Stock	2.37	2.444	2.34	2.4	75000.0
2023-03-20	AAON	Stock	59.8	60.7933	59.74	59.86	451050.0
2023-03-20	AAP	Stock	119.32	120.75	117.68	118.68	1791700.0
2023-03-20	AAT	Stock	17.65	18.2	17.34	17.55	1144500.0
2023-03-20	AATC	Stock	4.112	4.112	4.06	4.11	2572.0
2023-03-20	AAU-DELISTED	Stock	0.2124	0.2124	0.2	0.2025	185710.0
2023-03-20	AAUAF-DELISTED	Stock	0.2124	0.2124	0.2	0.2025	194380.0
2023-03-20	AAXJ	Stock	64.42	65.03	64.39	64.9	444997.0
2023-03-20	AB	Stock	34.93	35.82	34.93	35.13	554100.0
2023-03-20	ABB-DELISTED	Stock	32.38	32.76	32.32	32.56	1020785.0
2023-03-20	ABBNY-DELISTED	Stock	32.38	32.76	32.32	32.56	1150856.0
2023-03-20	ABBV	Stock	154.52	156.34	154.46	156.12	4408200.0
2023-03-20	ABC-DELISTED	Stock	152.91	154.41	152.87	153.78	739819.0
2023-03-20	ABCB	Stock	37.26	37.95	36.03	36.03	597400.0
2023-03-20	ABCL	Stock	7.33	7.615	7.29	7.57	1201700.0
2023-03-20	ABCM-DELISTED	Stock	13.78	13.82	13.14	13.44	372317.0
2023-03-20	ABEO	Stock	2.38	2.43	2.24	2.3	170300.0
2023-03-20	ABEV	Stock	2.68	2.7	2.65	2.68	26649400.0
2023-03-20	ABG	Stock	198.96	205.92	197.49	200.24	222400.0
2023-03-20	ABM	Stock	44.16	44.94	44.04	44.12	332100.0
2023-03-20	ABNB	Stock	118.06	119.02	116.625	118.4	3997700.0
2023-03-20	ABOS	Stock	3.86	3.989	3.74	3.75	102300.0
2023-03-20	ABR	Stock	11.58	12.25	11.56	11.82	8943700.0
2023-03-20	ABR.D	Stock	16.51	17.4817	16.51	16.92	27346.0
2023-03-20	ABR.E	Stock	16.85	16.8501	16.12	16.2	44412.0
2023-03-20	ABR.F	Stock	17.86	17.9628	17.65	17.65	29692.0
2023-03-20	ABSI	Stock	1.62	1.659	1.53	1.585	541900.0
2023-03-20	ABST-DELISTED	Stock	7.63	7.66	7.46	7.53	46357.0

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

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