PREVIEW / stock_daily / 2023-12-26

all stock daily files

  file:    by_date/stock_daily/2023/2023-12-26.parquet
  size:    235 KB
  rows:    7,344
  symbols: 1,215

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-26	AAPL	Stock	193.61	193.89	192.83	193.05	28919300.0
2023-12-26	MSFT	Stock	375.0	376.94	373.5	374.66	12673100.0
2023-12-26	NVDA	Stock	48.968	49.6	48.96	49.279	244200000.0
2023-12-26	AMZN	Stock	153.56	153.98	153.03	153.41	25067200.0
2023-12-26	GOOGL	Stock	141.59	142.68	141.19	141.52	16780333.0
2023-12-26	META	Stock	354.99	356.98	353.45	354.83	9898600.0
2023-12-26	TSLA	Stock	254.49	257.97	252.91	256.61	86892400.0
2023-12-26	TLT	Stock	98.54	98.87	98.48	98.76	24019749.0
2023-12-26	ES	Stock	60.97	61.65	60.88	61.44	951900.0
2023-12-26	CL	Stock	78.47	79.35	78.3	79.04	3572700.0
2023-12-26	A	Stock	139.31	140.47	139.09	139.81	948400.0
2023-12-26	AA	Stock	33.86	34.12	33.5	33.87	4505900.0
2023-12-26	AACG	Stock	0.84	0.87	0.84	0.84	7000.0
2023-12-26	AACT	Stock	10.45	10.45	10.45	10.45	100.0
2023-12-26	AAGR-DELISTED	Stock	0.99	1.25	0.99	1.22	1114913.0
2023-12-26	AAGRW-DELISTED	Stock	0.0201	0.028	0.0176	0.0188	44363.0
2023-12-26	AAL	Stock	14.25	14.26	14.04	14.11	22157900.0
2023-12-26	AAMC-DELISTED	Stock	4.34	4.426	4.11	4.21	19600.0
2023-12-26	AAME	Stock	2.08	2.16	1.97	2.09	18300.0
2023-12-26	AAMI	Stock	19.17	19.17	18.66	18.89	440000.0
2023-12-26	AAN-DELISTED	Stock	11.19	11.32	11.09	11.19	208500.0
2023-12-26	AAOI	Stock	21.2	23.66	21.18	22.82	3015500.0
2023-12-26	AAON	Stock	74.0	74.71	73.49	74.15	203100.0
2023-12-26	AAP	Stock	61.24	61.57	60.75	60.92	1072300.0
2023-12-26	AAT	Stock	22.75	23.07	22.59	23.04	146400.0
2023-12-26	AATC	Stock	6.925	7.0	6.78	7.0	12385.0
2023-12-26	AAU-DELISTED	Stock	0.145	0.1453	0.145	0.145	250926.0
2023-12-26	AAUAF-DELISTED	Stock	0.145	0.1453	0.145	0.145	253775.0
2023-12-26	AAXJ	Stock	65.1	65.5221	65.1	65.38	388568.0
2023-12-26	AB	Stock	31.92	31.94	31.18	31.45	332200.0
2023-12-26	ABAT	Stock	5.43	5.55	4.87	4.99	784639.0
2023-12-26	ABBNY-DELISTED	Stock	43.51	43.88	43.51	43.88	101792.0
2023-12-26	ABBV	Stock	154.25	155.28	154.13	154.62	2073400.0
2023-12-26	ABCB	Stock	52.93	53.84	52.67	53.58	330300.0
2023-12-26	ABCL	Stock	5.7	5.87	5.7	5.77	1148200.0
2023-12-26	ABEO	Stock	5.0	5.3	4.91	5.09	1064000.0
2023-12-26	ABEV	Stock	2.81	2.84	2.81	2.83	3383400.0
2023-12-26	ABG	Stock	224.81	225.67	222.83	223.33	166600.0
2023-12-26	ABLLW	Stock	0.57	0.64	0.57	0.6209	50725.0
2023-12-26	ABLV	Stock	2.75	2.785	2.75	2.785	1100.0
2023-12-26	ABLVW	Stock	0.035	0.035	0.035	0.035	100.0
2023-12-26	ABM	Stock	45.55	45.89	45.1	45.55	377800.0
2023-12-26	ABNB	Stock	141.0	141.0	137.77	138.72	4384800.0
2023-12-26	ABOS	Stock	3.63	3.74	3.555	3.7	417000.0
2023-12-26	ABR	Stock	15.84	16.3	15.7	16.17	4326500.0
2023-12-26	ABR.D	Stock	18.06	18.0999	17.81	17.82	24665.0
2023-12-26	ABR.E	Stock	17.99	18.35	17.73	17.73	5296.0
2023-12-26	ABR.F	Stock	18.8	18.89	18.7	18.7	40050.0
2023-12-26	ABSI	Stock	3.44	4.5	3.44	4.0	3527200.0
2023-12-26	ABT	Stock	108.51	109.73	108.51	109.23	2513400.0

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

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