PREVIEW / stock_daily / 2023-12-05

all stock daily files

  file:    by_date/stock_daily/2023/2023-12-05.parquet
  size:    236 KB
  rows:    7,365
  symbols: 1,283

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-05	AAPL	Stock	190.21	194.4	190.18	193.42	66628400.0
2023-12-05	MSFT	Stock	366.45	373.08	365.62	372.52	23065000.0
2023-12-05	NVDA	Stock	45.466	46.6	45.271	46.566	371718000.0
2023-12-05	AMZN	Stock	143.55	148.57	143.13	146.88	46822400.0
2023-12-05	GOOGL	Stock	128.95	132.14	128.25	130.99	27384784.0
2023-12-05	META	Stock	318.98	321.88	315.39	318.29	16952100.0
2023-12-05	TSLA	Stock	233.87	246.66	233.7	238.72	137971100.0
2023-12-05	TLT	Stock	93.63	94.62	93.565	94.61	73588581.0
2023-12-05	ES	Stock	60.6	60.87	59.62	60.19	2029700.0
2023-12-05	CL	Stock	79.0	79.03	77.54	77.68	4075300.0
2023-12-05	A	Stock	127.81	128.63	125.77	127.88	1933600.0
2023-12-05	AA	Stock	26.5	26.53	25.13	25.24	7715800.0
2023-12-05	AACG	Stock	0.9	0.9	0.85	0.85	4600.0
2023-12-05	AACIW-DELISTED	Stock	0.0699	0.0699	0.022	0.0253	21185.0
2023-12-05	AACT	Stock	10.42	10.42	10.37	10.37	31700.0
2023-12-05	AAIC-DELISTED	Stock	4.74	4.74	4.67	4.67	97653.0
2023-12-05	AAIC.C-DELISTED	Stock	24.4	24.4	24.4	24.4	100.0
2023-12-05	AAL	Stock	13.22	13.29	13.01	13.13	40142400.0
2023-12-05	AAMC-DELISTED	Stock	3.25	3.42	3.2	3.29	20600.0
2023-12-05	AAME	Stock	1.91	1.91	1.88	1.91	2600.0
2023-12-05	AAMI	Stock	17.85	17.93	17.6	17.92	115300.0
2023-12-05	AAN-DELISTED	Stock	9.71	10.185	9.67	9.97	775300.0
2023-12-05	AAOI	Stock	16.43	16.725	15.8	16.13	1636300.0
2023-12-05	AAON	Stock	64.47	64.47	63.17	63.41	573400.0
2023-12-05	AAP	Stock	55.4	55.42	52.32	53.16	1580500.0
2023-12-05	AAT	Stock	21.27	21.4	20.93	21.39	342300.0
2023-12-05	AATC	Stock	6.7	7.35	6.675	7.3	26229.0
2023-12-05	AAU-DELISTED	Stock	0.148	0.1494	0.145	0.145	130632.0
2023-12-05	AAUAF-DELISTED	Stock	0.148	0.1494	0.145	0.145	134721.0
2023-12-05	AAXJ	Stock	64.23	64.4106	64.02	64.35	424666.0
2023-12-05	AB	Stock	28.55	28.75	28.02	28.43	423800.0
2023-12-05	ABAT	Stock	4.52	4.52	4.05	4.08	772727.0
2023-12-05	ABBNY-DELISTED	Stock	40.36	40.5899	40.25	40.39	865476.0
2023-12-05	ABBV	Stock	144.11	145.08	142.66	144.57	3961700.0
2023-12-05	ABCB	Stock	46.07	46.33	45.64	45.76	251000.0
2023-12-05	ABCL	Stock	4.89	4.89	4.47	4.5	1733100.0
2023-12-05	ABCM-DELISTED	Stock	23.99	24.0	23.98	23.98	7349069.0
2023-12-05	ABEO	Stock	4.66	4.66	4.36	4.56	171800.0
2023-12-05	ABEV	Stock	2.84	2.9	2.83	2.87	8602200.0
2023-12-05	ABG	Stock	220.07	222.14	215.31	217.22	196800.0
2023-12-05	ABLLW	Stock	0.3712	0.3999	0.3575	0.3575	8806.0
2023-12-05	ABM	Stock	42.84	42.84	42.3	42.47	392100.0
2023-12-05	ABNB	Stock	132.68	135.705	132.66	133.71	4202200.0
2023-12-05	ABOS	Stock	2.66	2.7	2.62	2.66	309400.0
2023-12-05	ABR	Stock	13.67	13.95	13.52	13.67	6230900.0
2023-12-05	ABR.D	Stock	17.29	17.4	17.11	17.11	11832.0
2023-12-05	ABR.E	Stock	17.13	17.299	16.99	17.09	19809.0
2023-12-05	ABR.F	Stock	19.3	19.3	19.21	19.24	31935.0
2023-12-05	ABSI	Stock	2.07	2.15	1.85	2.12	1450000.0
2023-12-05	ABT	Stock	105.0	105.25	103.95	104.35	4315500.0

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

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