PREVIEW / stock_daily / 2023-10-18

all stock daily files

  file:    by_date/stock_daily/2023/2023-10-18.parquet
  size:    233 KB
  rows:    7,347
  symbols: 1,344

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-18	AAPL	Stock	175.58	177.58	175.11	175.84	54764400.0
2023-10-18	MSFT	Stock	332.49	335.59	328.3	330.11	23153600.0
2023-10-18	NVDA	Stock	42.591	43.219	41.825	42.196	627294000.0
2023-10-18	AMZN	Stock	129.9	130.67	127.51	128.13	42699500.0
2023-10-18	GOOGL	Stock	139.445	140.72	137.38	137.96	23374998.0
2023-10-18	META	Stock	321.39	325.94	315.56	316.97	16851000.0
2023-10-18	TSLA	Stock	252.7	254.63	242.08	242.68	125147800.0
2023-10-18	TLT	Stock	84.38	84.72	83.85	84.5	63724616.0
2023-10-18	ES	Stock	55.36	55.71	54.29	54.49	3090000.0
2023-10-18	CL	Stock	72.45	73.43	72.29	73.07	6058300.0
2023-10-18	A	Stock	111.33	111.33	108.54	108.61	1803500.0
2023-10-18	AA	Stock	27.1	27.43	26.5	26.52	6489400.0
2023-10-18	AAC-DELISTED	Stock	10.78	10.78	10.76	10.76	39847.0
2023-10-18	AACG	Stock	1.09	1.09	1.04	1.04	3200.0
2023-10-18	AACT	Stock	10.3	10.3	10.29	10.29	17400.0
2023-10-18	AAIC-DELISTED	Stock	4.41	4.42	4.36	4.37	101894.0
2023-10-18	AAIC.C-DELISTED	Stock	23.9639	23.98	23.86	23.86	3992.0
2023-10-18	AAL	Stock	11.74	11.74	11.22	11.36	67141500.0
2023-10-18	AAMC-DELISTED	Stock	3.9824	4.0235	3.8235	3.8235	14790.0
2023-10-18	AAME	Stock	1.8	1.8	1.8	1.8	400.0
2023-10-18	AAMI	Stock	17.68	17.68	17.31	17.34	69300.0
2023-10-18	AAN-DELISTED	Stock	9.84	9.98	9.62	9.76	236900.0
2023-10-18	AAOI	Stock	7.51	7.96	7.36	7.55	1270200.0
2023-10-18	AAON	Stock	56.69	56.69	53.31	53.72	624200.0
2023-10-18	AAP	Stock	54.32	54.5	53.22	53.24	1213700.0
2023-10-18	AAT	Stock	18.84	18.84	18.56	18.6	138300.0
2023-10-18	AATC	Stock	5.55	5.55	5.55	5.55	341.0
2023-10-18	AAU-DELISTED	Stock	0.139	0.145	0.1331	0.14	373500.0
2023-10-18	AAUAF-DELISTED	Stock	0.139	0.145	0.1331	0.14	376802.0
2023-10-18	AAXJ	Stock	63.13	63.31	62.78	62.86	342286.0
2023-10-18	AB	Stock	29.85	29.85	29.35	29.38	124000.0
2023-10-18	ABAT	Stock	7.1	7.69	6.72	6.72	194609.0
2023-10-18	ABBNY-DELISTED	Stock	34.11	34.27	33.82	34.17	584774.0
2023-10-18	ABBV	Stock	149.27	149.61	148.34	149.28	4910500.0
2023-10-18	ABCB	Stock	38.32	38.42	37.49	37.58	302200.0
2023-10-18	ABCL	Stock	4.35	4.37	4.28	4.35	2817200.0
2023-10-18	ABCM-DELISTED	Stock	22.85	22.95	22.825	22.89	2122947.0
2023-10-18	ABEO	Stock	4.37	4.4	4.23	4.32	67500.0
2023-10-18	ABEV	Stock	2.51	2.51	2.44	2.45	9106000.0
2023-10-18	ABG	Stock	214.48	215.19	212.29	212.83	116800.0
2023-10-18	ABLLW	Stock	0.3389	0.3389	0.3389	0.3389	500.0
2023-10-18	ABLV	Stock	2.96	2.96	2.8	2.8	2600.0
2023-10-18	ABM	Stock	42.86	42.86	42.19	42.2	361200.0
2023-10-18	ABNB	Stock	123.02	124.35	121.72	122.17	4098400.0
2023-10-18	ABOS	Stock	3.82	3.82	3.56	3.575	290900.0
2023-10-18	ABR	Stock	14.42	14.45	14.17	14.3	2560500.0
2023-10-18	ABR.D	Stock	16.9	16.95	16.43	16.7	20064.0
2023-10-18	ABR.E	Stock	16.54	16.95	16.5	16.95	5049.0
2023-10-18	ABR.F	Stock	17.64	17.83	17.64	17.78	12984.0
2023-10-18	ABSI	Stock	1.45	1.46	1.37	1.37	150300.0

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

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