PREVIEW / stock_daily / 2023-10-05

all stock daily files

  file:    by_date/stock_daily/2023/2023-10-05.parquet
  size:    235 KB
  rows:    7,353
  symbols: 1,381

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-05	AAPL	Stock	173.79	175.45	172.68	174.91	48527900.0
2023-10-05	MSFT	Stock	319.09	319.98	314.9	319.36	16965600.0
2023-10-05	NVDA	Stock	44.05	44.9	43.888	44.688	393483000.0
2023-10-05	AMZN	Stock	126.71	126.73	124.33	125.96	39660600.0
2023-10-05	GOOGL	Stock	135.07	135.49	133.45	135.07	19832615.0
2023-10-05	META	Stock	304.63	306.21	299.5	304.79	19130000.0
2023-10-05	TSLA	Stock	260.0	263.6	256.25	260.05	119159200.0
2023-10-05	TLT	Stock	86.105	86.19	85.635	85.83	35758761.0
2023-10-05	ES	Stock	56.03	56.03	54.87	55.21	2366900.0
2023-10-05	CL	Stock	70.12	70.27	69.16	69.27	3565300.0
2023-10-05	A	Stock	112.09	112.24	108.77	110.35	1295700.0
2023-10-05	AA	Stock	27.13	27.3	26.45	26.53	4425100.0
2023-10-05	AAC-DELISTED	Stock	10.73	10.75	10.73	10.745	4442.0
2023-10-05	AACG	Stock	1.1	1.14	1.1	1.1	2200.0
2023-10-05	AACIW-DELISTED	Stock	0.0575	0.0587	0.0575	0.0587	826.0
2023-10-05	AACT	Stock	10.28	10.281	10.28	10.28	11500.0
2023-10-05	AAIC-DELISTED	Stock	4.17	4.295	4.17	4.28	68599.0
2023-10-05	AAIC.C-DELISTED	Stock	23.76	23.77	23.76	23.77	1568.0
2023-10-05	AAL	Stock	12.91	13.01	12.72	12.85	36272900.0
2023-10-05	AAMC-DELISTED	Stock	3.8824	4.1647	3.8824	4.0941	57460.0
2023-10-05	AAME	Stock	1.83	1.83	1.83	1.83	1400.0
2023-10-05	AAMI	Stock	18.25	18.36	18.06	18.28	134100.0
2023-10-05	AAN-DELISTED	Stock	9.68	9.83	9.61	9.82	418600.0
2023-10-05	AAOI	Stock	8.96	9.21	8.51	9.12	1841700.0
2023-10-05	AAON	Stock	56.07	56.49	55.68	56.01	241500.0
2023-10-05	AAP	Stock	51.81	53.61	51.03	52.96	2122300.0
2023-10-05	AAT	Stock	18.36	18.57	18.17	18.39	309600.0
2023-10-05	AATC	Stock	5.72	5.74	5.5	5.6	12960.0
2023-10-05	AAU-DELISTED	Stock	0.138	0.138	0.13	0.134	120205.0
2023-10-05	AAUAF-DELISTED	Stock	0.138	0.138	0.13	0.134	122370.0
2023-10-05	AAXJ	Stock	62.59	62.81	62.32	62.77	413385.0
2023-10-05	AB	Stock	30.46	31.05	30.46	30.95	234200.0
2023-10-05	ABAT	Stock	7.24	7.4492	7.01	7.16	110862.0
2023-10-05	ABBNY-DELISTED	Stock	35.75	35.86	35.63	35.805	383631.0
2023-10-05	ABBV	Stock	147.93	149.53	147.09	147.45	3599500.0
2023-10-05	ABCB	Stock	37.2	38.04	37.14	37.89	477500.0
2023-10-05	ABCL	Stock	4.43	4.51	4.34	4.42	1264300.0
2023-10-05	ABCM-DELISTED	Stock	22.75	22.895	22.74	22.75	8507800.0
2023-10-05	ABEO	Stock	4.16	4.35	4.01	4.3	153300.0
2023-10-05	ABEV	Stock	2.54	2.54	2.47	2.49	20539200.0
2023-10-05	ABG	Stock	212.63	214.85	207.96	207.99	129500.0
2023-10-05	ABLLW	Stock	0.36	0.39	0.27	0.38	12479.0
2023-10-05	ABLV	Stock	3.36	3.36	3.35	3.35	2200.0
2023-10-05	ABM	Stock	40.25	40.93	40.08	40.73	547900.0
2023-10-05	ABNB	Stock	126.54	126.62	121.67	124.99	7630200.0
2023-10-05	ABOS	Stock	4.16	4.48	4.14	4.48	443100.0
2023-10-05	ABR	Stock	13.45	13.97	13.31	13.87	3844900.0
2023-10-05	ABR.D	Stock	17.7	17.7	17.21	17.25	19775.0
2023-10-05	ABR.E	Stock	18.07	18.07	17.115	17.115	745.0
2023-10-05	ABR.F	Stock	17.95	18.41	17.95	18.34	16962.0

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

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