PREVIEW / stock_daily / 2023-10-23

all stock daily files

  file:    by_date/stock_daily/2023/2023-10-23.parquet
  size:    234 KB
  rows:    7,362
  symbols: 1,347

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-23	AAPL	Stock	170.91	174.01	169.93	173.0	55980100.0
2023-10-23	MSFT	Stock	325.47	332.73	324.39	329.32	24374700.0
2023-10-23	NVDA	Stock	41.229	43.248	40.945	42.975	478530000.0
2023-10-23	AMZN	Stock	124.63	127.88	123.98	126.56	48260000.0
2023-10-23	GOOGL	Stock	135.04	137.6599	133.95	136.5	26317930.0
2023-10-23	META	Stock	309.5	317.36	307.26	314.01	17796800.0
2023-10-23	TSLA	Stock	210.0	216.98	202.51	212.08	150683400.0
2023-10-23	TLT	Stock	82.81	84.86	82.42	84.24	70890435.0
2023-10-23	ES	Stock	52.86	53.39	52.21	52.46	3189700.0
2023-10-23	CL	Stock	73.0	73.13	71.87	71.96	4517600.0
2023-10-23	A	Stock	108.1	109.91	107.4	109.34	2886000.0
2023-10-23	AA	Stock	23.16	24.21	23.07	23.41	6780200.0
2023-10-23	AAC-DELISTED	Stock	10.75	10.77	10.74	10.76	50199.0
2023-10-23	AACG	Stock	1.02	1.08	1.02	1.06	1200.0
2023-10-23	AACT	Stock	10.295	10.31	10.28	10.31	178600.0
2023-10-23	AAIC-DELISTED	Stock	4.27	4.27	3.96	3.99	460914.0
2023-10-23	AAIC.C-DELISTED	Stock	23.65	23.66	23.5	23.545	3911.0
2023-10-23	AAL	Stock	11.02	11.41	10.94	11.29	45680300.0
2023-10-23	AAMC-DELISTED	Stock	3.8471	3.9159	3.8235	3.8412	12240.0
2023-10-23	AAME	Stock	1.89	1.94	1.89	1.94	300.0
2023-10-23	AAMI	Stock	16.5	16.625	16.26	16.38	99900.0
2023-10-23	AAN-DELISTED	Stock	9.25	9.35	8.83	8.89	540800.0
2023-10-23	AAOI	Stock	6.7	7.295	6.66	7.17	1207200.0
2023-10-23	AAON	Stock	53.26	54.36	53.03	53.54	399800.0
2023-10-23	AAP	Stock	50.67	50.83	48.23	48.45	2529500.0
2023-10-23	AAT	Stock	17.85	18.11	17.15	17.58	1124900.0
2023-10-23	AATC	Stock	5.5	5.725	5.5	5.7	9167.0
2023-10-23	AAU-DELISTED	Stock	0.143	0.15	0.135	0.1415	359648.0
2023-10-23	AAUAF-DELISTED	Stock	0.143	0.15	0.135	0.1415	363388.0
2023-10-23	AAXJ	Stock	61.3	61.94	61.06	61.74	287452.0
2023-10-23	AB	Stock	29.25	29.25	28.51	28.89	503100.0
2023-10-23	ABAT	Stock	6.05	6.1	5.43	5.55	373985.0
2023-10-23	ABBNY-DELISTED	Stock	33.19	33.61	33.13	33.44	509848.0
2023-10-23	ABBV	Stock	146.16	146.42	144.2	144.73	3903300.0
2023-10-23	ABCB	Stock	36.04	36.88	35.35	35.75	316900.0
2023-10-23	ABCL	Stock	4.27	4.309	4.2	4.27	1107400.0
2023-10-23	ABCM-DELISTED	Stock	22.75	22.995	22.725	22.905	9461890.0
2023-10-23	ABEO	Stock	4.13	4.29	3.94	3.99	88000.0
2023-10-23	ABEV	Stock	2.45	2.49	2.44	2.45	6495000.0
2023-10-23	ABG	Stock	203.61	205.0	198.88	199.16	168000.0
2023-10-23	ABLLW	Stock	0.3362	0.3396	0.2626	0.3394	7530.0
2023-10-23	ABLV	Stock	2.72	2.73	2.52	2.52	7000.0
2023-10-23	ABM	Stock	40.29	40.63	40.01	40.11	319200.0
2023-10-23	ABNB	Stock	116.48	122.525	115.55	120.39	5442500.0
2023-10-23	ABOS	Stock	3.43	3.438	3.31	3.31	290500.0
2023-10-23	ABR	Stock	13.92	14.03	13.59	13.63	4002700.0
2023-10-23	ABR.D	Stock	16.76	16.78	16.5	16.5	9187.0
2023-10-23	ABR.E	Stock	16.4739	16.4739	16.4	16.4	1805.0
2023-10-23	ABR.F	Stock	17.75	17.75	17.57	17.57	11708.0
2023-10-23	ABSI	Stock	1.25	1.27	1.21	1.22	217700.0

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

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