PREVIEW / stock_daily / 2023-12-18

all stock daily files

  file:    by_date/stock_daily/2023/2023-12-18.parquet
  size:    237 KB
  rows:    7,363
  symbols: 1,256

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-18	AAPL	Stock	196.09	196.63	194.39	195.89	55751900.0
2023-12-18	MSFT	Stock	369.45	373.0	368.68	372.65	21802900.0
2023-12-18	NVDA	Stock	49.4	50.433	49.15	50.077	412587000.0
2023-12-18	AMZN	Stock	150.56	154.85	150.05	154.07	62512800.0
2023-12-18	GOOGL	Stock	132.63	137.1478	132.43	135.8	32257967.0
2023-12-18	META	Stock	337.48	347.56	337.02	344.62	18993900.0
2023-12-18	TSLA	Stock	253.78	258.74	251.36	252.08	116416500.0
2023-12-18	TLT	Stock	98.5	98.5	98.02	98.36	34746018.0
2023-12-18	ES	Stock	61.7	62.61	61.6	61.98	4266600.0
2023-12-18	CL	Stock	77.53	78.3	77.36	78.06	4212400.0
2023-12-18	A	Stock	137.59	138.19	136.86	137.53	1634700.0
2023-12-18	AA	Stock	31.44	32.31	30.52	30.52	7270400.0
2023-12-18	AACG	Stock	0.79	0.85	0.79	0.83	26300.0
2023-12-18	AACT	Stock	10.54	10.755	10.4	10.4	108800.0
2023-12-18	AAGR-DELISTED	Stock	0.572	0.583	0.456	0.4887	819947.0
2023-12-18	AAGRW-DELISTED	Stock	0.0301	0.0311	0.0301	0.0311	1868.0
2023-12-18	AAL	Stock	14.43	14.43	14.06	14.24	28471700.0
2023-12-18	AAMC-DELISTED	Stock	4.87	5.1	4.87	5.06	23200.0
2023-12-18	AAME	Stock	1.9	2.15	1.9	2.03	14800.0
2023-12-18	AAMI	Stock	19.51	19.69	19.32	19.46	115900.0
2023-12-18	AAN-DELISTED	Stock	11.27	11.315	10.96	10.97	302400.0
2023-12-18	AAOI	Stock	22.16	23.25	21.48	22.5	2612500.0
2023-12-18	AAON	Stock	71.35	71.76	70.49	70.74	593900.0
2023-12-18	AAP	Stock	62.77	62.87	59.99	60.66	1641700.0
2023-12-18	AAT	Stock	23.17	23.17	22.56	22.56	334800.0
2023-12-18	AATC	Stock	6.86	7.19	6.86	7.0	2986.0
2023-12-18	AAU-DELISTED	Stock	0.145	0.1459	0.1445	0.1451	185900.0
2023-12-18	AAUAF-DELISTED	Stock	0.145	0.1459	0.1445	0.145	190789.0
2023-12-18	AAXJ	Stock	65.78	65.85	65.53	65.77	755492.0
2023-12-18	AB	Stock	32.17	32.36	31.65	32.21	552800.0
2023-12-18	ABAT	Stock	5.07	5.8399	4.95	5.75	1200407.0
2023-12-18	ABBNY-DELISTED	Stock	43.27	43.34	42.92	43.05	379498.0
2023-12-18	ABBV	Stock	153.0	154.35	151.75	153.42	5379600.0
2023-12-18	ABCB	Stock	52.63	52.64	51.24	51.43	475200.0
2023-12-18	ABCL	Stock	5.42	5.46	5.27	5.32	1376100.0
2023-12-18	ABEO	Stock	4.86	4.9	4.7	4.7	74800.0
2023-12-18	ABEV	Stock	2.91	2.95	2.89	2.95	6964600.0
2023-12-18	ABG	Stock	233.15	234.72	221.41	223.06	342700.0
2023-12-18	ABLLW	Stock	0.58	0.58	0.551	0.579	71123.0
2023-12-18	ABLV	Stock	2.75	2.75	2.75	2.75	400.0
2023-12-18	ABM	Stock	45.91	46.08	45.24	45.8	462700.0
2023-12-18	ABNB	Stock	147.16	148.46	146.12	147.5	4175200.0
2023-12-18	ABOS	Stock	2.89	3.01	2.82	2.82	300100.0
2023-12-18	ABR	Stock	15.46	15.76	15.26	15.36	2933100.0
2023-12-18	ABR.D	Stock	17.84	17.99	17.58	17.86	20207.0
2023-12-18	ABR.E	Stock	18.3	18.3358	18.0	18.33	5650.0
2023-12-18	ABR.F	Stock	18.64	18.7965	18.515	18.6	33622.0
2023-12-18	ABSI	Stock	2.73	3.06	2.62	3.01	1185700.0
2023-12-18	ABT	Stock	107.64	108.62	107.16	108.06	5142800.0
2023-12-18	ABTC	Stock	480.0	493.5	375.0	447.0	235.86666666666667

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

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