PREVIEW / stock_daily / 2023-12-28

all stock daily files

  file:    by_date/stock_daily/2023/2023-12-28.parquet
  size:    236 KB
  rows:    7,369
  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-28	AAPL	Stock	194.14	194.66	193.17	193.58	34049900.0
2023-12-28	MSFT	Stock	375.37	376.46	374.16	375.28	14327000.0
2023-12-28	NVDA	Stock	49.643	49.884	49.412	49.522	246587000.0
2023-12-28	AMZN	Stock	153.72	154.08	152.95	153.38	27057000.0
2023-12-28	GOOGL	Stock	140.78	141.14	139.75	140.23	16045712.0
2023-12-28	META	Stock	359.7	361.9	357.81	358.32	11798800.0
2023-12-28	TSLA	Stock	263.66	265.13	252.71	253.18	113619900.0
2023-12-28	TLT	Stock	100.09	100.57	99.56	99.78	36212985.0
2023-12-28	ES	Stock	61.04	62.06	61.04	61.96	937700.0
2023-12-28	CL	Stock	79.44	79.49	78.92	79.24	2317100.0
2023-12-28	A	Stock	140.54	140.81	139.65	139.77	892600.0
2023-12-28	AA	Stock	34.68	34.812	34.198	34.55	3909900.0
2023-12-28	AACG	Stock	1.18	1.18	1.04	1.14	125500.0
2023-12-28	AACT	Stock	10.42	10.42	10.42	10.42	2400.0
2023-12-28	AAGR-DELISTED	Stock	1.22	1.32	1.2	1.25	498987.0
2023-12-28	AAGRW-DELISTED	Stock	0.04	0.04	0.021	0.021	8737.0
2023-12-28	AAL	Stock	13.92	14.04	13.82	13.98	17093400.0
2023-12-28	AAMC-DELISTED	Stock	4.52	4.85	4.41	4.42	25700.0
2023-12-28	AAME	Stock	2.13	2.21	2.01	2.2	17600.0
2023-12-28	AAMI	Stock	19.15	19.36	18.96	19.25	422800.0
2023-12-28	AAN-DELISTED	Stock	11.1	11.22	11.02	11.17	229200.0
2023-12-28	AAOI	Stock	22.48	22.75	21.51	21.9	1662100.0
2023-12-28	AAON	Stock	73.88	74.46	73.57	74.23	162500.0
2023-12-28	AAP	Stock	61.31	62.15	60.98	61.49	895600.0
2023-12-28	AAT	Stock	22.68	23.01	22.65	22.97	271100.0
2023-12-28	AATC	Stock	7.01	7.05	6.925	7.05	7436.0
2023-12-28	AAU-DELISTED	Stock	0.145	0.1454	0.145	0.145	142439.0
2023-12-28	AAUAF-DELISTED	Stock	0.145	0.1454	0.145	0.145	122896.0
2023-12-28	AAXJ	Stock	66.41	66.775	66.41	66.5	406032.0
2023-12-28	AB	Stock	31.07	31.54	30.93	31.37	352000.0
2023-12-28	ABAT	Stock	4.96	5.07	4.8601	4.97	233247.0
2023-12-28	ABBNY-DELISTED	Stock	44.31	44.48	43.82	43.82	107641.0
2023-12-28	ABBV	Stock	155.25	155.63	154.54	154.75	2601200.0
2023-12-28	ABCB	Stock	53.34	53.76	53.22	53.7	356500.0
2023-12-28	ABCL	Stock	5.79	5.98	5.76	5.93	1585300.0
2023-12-28	ABEO	Stock	5.08	5.18	5.06	5.14	157700.0
2023-12-28	ABEV	Stock	2.84	2.84	2.81	2.82	6784300.0
2023-12-28	ABG	Stock	223.45	228.04	222.52	227.48	139700.0
2023-12-28	ABLLW	Stock	0.63	0.75	0.6069	0.7	133849.0
2023-12-28	ABLV	Stock	3.29	3.39	2.55	2.79	38200.0
2023-12-28	ABLVW	Stock	0.015	0.0384	0.0149	0.0366	22900.0
2023-12-28	ABM	Stock	45.19	45.53	44.96	45.25	249500.0
2023-12-28	ABNB	Stock	136.55	137.19	135.695	137.0	2770800.0
2023-12-28	ABOS	Stock	3.85	3.95	3.78	3.83	446100.0
2023-12-28	ABR	Stock	15.96	16.13	15.69	15.81	2839400.0
2023-12-28	ABR.D	Stock	17.74	18.0	17.73	17.85	29453.0
2023-12-28	ABR.E	Stock	17.742	18.12	17.68	17.86	7564.0
2023-12-28	ABR.F	Stock	18.81	18.96	18.74	18.96	21394.0
2023-12-28	ABSI	Stock	4.9	5.47	4.55	4.6	3017700.0
2023-12-28	ABT	Stock	109.85	110.71	109.72	110.4	3206100.0

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

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