PREVIEW / stock_daily / 2023-12-21

all stock daily files

  file:    by_date/stock_daily/2023/2023-12-21.parquet
  size:    236 KB
  rows:    7,321
  symbols: 1,230

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-12-21	AAPL	Stock	196.1	197.08	193.5	194.68	46482500.0
2023-12-21	MSFT	Stock	372.56	374.41	370.04	373.54	17708000.0
2023-12-21	NVDA	Stock	48.811	49.095	48.419	48.99	300425000.0
2023-12-21	AMZN	Stock	153.3	153.97	152.1	153.84	36305700.0
2023-12-21	GOOGL	Stock	139.49	140.685	139.18	140.42	27488284.0
2023-12-21	META	Stock	352.98	356.41	349.21	354.09	15289600.0
2023-12-21	TSLA	Stock	251.9	254.8	248.55	254.5	109594200.0
2023-12-21	TLT	Stock	99.74	99.84	98.75	98.93	65231183.0
2023-12-21	ES	Stock	60.84	61.38	60.41	60.91	1106400.0
2023-12-21	CL	Stock	77.64	77.97	76.96	77.91	5267000.0
2023-12-21	A	Stock	139.38	139.67	138.0	138.94	1685700.0
2023-12-21	AA	Stock	31.25	32.14	30.59	32.02	5566100.0
2023-12-21	AACG	Stock	0.86	0.86	0.81	0.81	12900.0
2023-12-21	AACIW-DELISTED	Stock	0.02505	0.02505	0.025	0.025	6200.0
2023-12-21	AACT	Stock	10.5	10.5	10.415	10.415	10800.0
2023-12-21	AAGR-DELISTED	Stock	0.9999	1.25	0.93	1.08	3405270.0
2023-12-21	AAGRW-DELISTED	Stock	0.031	0.04	0.031	0.031	1116.0
2023-12-21	AAL	Stock	14.21	14.43	14.2	14.35	30372600.0
2023-12-21	AAMC-DELISTED	Stock	4.356	4.39	4.2	4.38	13200.0
2023-12-21	AAME	Stock	2.03	2.03	1.97	2.01	4900.0
2023-12-21	AAMI	Stock	19.9	19.9	18.82	18.99	545500.0
2023-12-21	AAN-DELISTED	Stock	11.22	11.43	11.07	11.17	331100.0
2023-12-21	AAOI	Stock	21.19	21.86	19.51	20.74	3627200.0
2023-12-21	AAON	Stock	72.58	73.07	72.27	72.39	324800.0
2023-12-21	AAP	Stock	60.92	61.22	59.54	60.69	975600.0
2023-12-21	AAT	Stock	22.77	23.04	22.48	22.75	340900.0
2023-12-21	AATC	Stock	7.065	7.2	7.01	7.01	2543.0
2023-12-21	AAU-DELISTED	Stock	0.1473	0.148	0.1451	0.1452	164603.0
2023-12-21	AAUAF-DELISTED	Stock	0.1473	0.148	0.1451	0.1452	116273.0
2023-12-21	AAXJ	Stock	64.59	65.33	64.59	65.325	744275.0
2023-12-21	AB	Stock	31.75	32.24	30.94	31.17	359700.0
2023-12-21	ABAT	Stock	6.15	6.15	5.5	5.62	953912.0
2023-12-21	ABBNY-DELISTED	Stock	43.46	43.55	43.2101	43.54	202718.0
2023-12-21	ABBV	Stock	152.05	152.91	151.29	152.59	4036100.0
2023-12-21	ABCB	Stock	51.91	52.04	51.23	51.74	642600.0
2023-12-21	ABCL	Stock	5.53	5.74	5.5	5.69	1295900.0
2023-12-21	ABEO	Stock	4.75	4.78	4.7	4.78	99300.0
2023-12-21	ABEV	Stock	2.94	2.94	2.9	2.92	5077300.0
2023-12-21	ABG	Stock	227.46	227.59	224.14	226.28	152300.0
2023-12-21	ABLLW	Stock	0.5855	0.6062	0.56	0.56	8964.0
2023-12-21	ABLVW	Stock	0.0353	0.0353	0.035	0.035	540.0
2023-12-21	ABM	Stock	45.59	45.67	44.88	45.34	687200.0
2023-12-21	ABNB	Stock	142.37	143.49	140.31	142.09	3318500.0
2023-12-21	ABOS	Stock	3.15	3.222	3.08	3.16	325600.0
2023-12-21	ABR	Stock	15.67	16.07	15.48	16.03	4454000.0
2023-12-21	ABR.D	Stock	18.1	18.3999	17.8	18.3	16243.0
2023-12-21	ABR.E	Stock	18.46	18.46	18.11	18.34	8027.0
2023-12-21	ABR.F	Stock	18.56	18.635	18.3	18.5	34269.0
2023-12-21	ABSI	Stock	3.0	3.48	2.84	3.25	1041600.0
2023-12-21	ABT	Stock	107.42	108.68	107.18	108.48	3555600.0

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

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