PREVIEW / stock_daily / 2023-10-16

all stock daily files

  file:    by_date/stock_daily/2023/2023-10-16.parquet
  size:    234 KB
  rows:    7,342
  symbols: 1,333

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-10-16	AAPL	Stock	176.75	179.08	176.51	178.72	52517000.0
2023-10-16	MSFT	Stock	331.05	336.14	330.6	332.64	22158000.0
2023-10-16	NVDA	Stock	45.063	46.225	44.912	46.095	375099000.0
2023-10-16	AMZN	Stock	130.69	133.07	130.43	132.55	42832900.0
2023-10-16	GOOGL	Stock	138.17	139.63	137.99	139.095	28501871.0
2023-10-16	META	Stock	318.64	321.82	315.52	321.15	16536100.0
2023-10-16	TSLA	Stock	250.05	255.4	248.48	253.92	88917200.0
2023-10-16	TLT	Stock	86.19	86.37	85.9	86.2	38309794.0
2023-10-16	ES	Stock	55.25	56.44	53.85	56.2	3413700.0
2023-10-16	CL	Stock	71.62	72.26	71.07	72.15	6437400.0
2023-10-16	A	Stock	111.04	112.79	109.64	111.5	1675500.0
2023-10-16	AA	Stock	27.2	27.445	26.783	26.81	4977700.0
2023-10-16	AAC-DELISTED	Stock	10.78	10.78	10.7511	10.78	33586.0
2023-10-16	AACG	Stock	1.1	1.15	1.1	1.1	1500.0
2023-10-16	AACT	Stock	10.3	10.3	10.29	10.29	128800.0
2023-10-16	AAIC-DELISTED	Stock	4.38	4.47	4.375	4.46	62950.0
2023-10-16	AAIC.C-DELISTED	Stock	23.9049	23.995	23.9	23.9566	4300.0
2023-10-16	AAL	Stock	11.82	12.05	11.72	11.94	35242600.0
2023-10-16	AAMC-DELISTED	Stock	3.8824	3.9471	3.8294	3.8294	18190.0
2023-10-16	AAME	Stock	1.91	1.99	1.8	1.82	6800.0
2023-10-16	AAMI	Stock	17.54	17.88	17.54	17.76	105300.0
2023-10-16	AAN-DELISTED	Stock	9.44	9.92	9.42	9.89	369700.0
2023-10-16	AAOI	Stock	7.6	7.95	7.55	7.65	989200.0
2023-10-16	AAON	Stock	57.22	57.96	56.25	57.63	204000.0
2023-10-16	AAP	Stock	51.38	53.82	51.14	53.59	2041300.0
2023-10-16	AAT	Stock	18.52	18.8	18.38	18.73	217400.0
2023-10-16	AATC	Stock	5.57	5.6	5.47	5.5025	5798.0
2023-10-16	AAU-DELISTED	Stock	0.14	0.14	0.13	0.137	252634.0
2023-10-16	AAUAF-DELISTED	Stock	0.14	0.14	0.13	0.135	254880.0
2023-10-16	AAXJ	Stock	63.6	64.2	63.478	64.08	290766.0
2023-10-16	AB	Stock	29.5	30.0	29.41	29.67	111400.0
2023-10-16	ABAT	Stock	7.66	7.885	7.57	7.64	200645.0
2023-10-16	ABBNY-DELISTED	Stock	36.32	36.64	36.18	36.47	231006.0
2023-10-16	ABBV	Stock	148.22	149.5	146.92	147.23	3704400.0
2023-10-16	ABCB	Stock	38.3	38.82	38.12	38.49	225700.0
2023-10-16	ABCL	Stock	4.23	4.33	4.2	4.28	1132500.0
2023-10-16	ABCM-DELISTED	Stock	22.66	22.96	22.66	22.96	2840928.0
2023-10-16	ABEO	Stock	4.14	4.35	4.14	4.26	31500.0
2023-10-16	ABEV	Stock	2.55	2.57	2.53	2.56	8242200.0
2023-10-16	ABG	Stock	215.79	219.0	214.95	216.18	80900.0
2023-10-16	ABLLW	Stock	0.34	0.34	0.32	0.34	6550.0
2023-10-16	ABLV	Stock	3.12	3.12	2.98	2.98	6700.0
2023-10-16	ABLVW	Stock	0.0374	0.0374	0.0374	0.0374	116.0
2023-10-16	ABM	Stock	44.04	44.35	43.35	43.76	309800.0
2023-10-16	ABNB	Stock	125.19	126.76	124.186	125.19	2706100.0
2023-10-16	ABOS	Stock	3.7	3.87	3.62	3.75	313600.0
2023-10-16	ABR	Stock	14.42	14.71	14.32	14.6	2084200.0
2023-10-16	ABR.D	Stock	17.18	17.18	16.919	16.98	17285.0
2023-10-16	ABR.E	Stock	16.99	16.99	16.6932	16.76	5322.0
2023-10-16	ABR.F	Stock	17.99	18.27	17.85	17.9334	11788.0

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

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