PREVIEW / stock_daily / 2023-09-25

all stock daily files

  file:    by_date/stock_daily/2023/2023-09-25.parquet
  size:    236 KB
  rows:    7,371
  symbols: 1,394

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-09-25	AAPL	Stock	174.2	176.97	174.15	176.08	46172700.0
2023-09-25	MSFT	Stock	316.59	317.67	315.0	317.54	17836000.0
2023-09-25	NVDA	Stock	41.591	42.536	41.177	42.222	419091000.0
2023-09-25	AMZN	Stock	129.36	131.78	128.77	131.27	46017800.0
2023-09-25	GOOGL	Stock	129.83	131.17	128.96	131.11	20094643.0
2023-09-25	META	Stock	295.64	300.95	293.7	300.83	18987000.0
2023-09-25	TSLA	Stock	243.38	247.1	238.31	246.99	104636600.0
2023-09-25	TLT	Stock	89.66	90.04	89.15	89.18	45587914.0
2023-09-25	ES	Stock	62.07	62.36	61.42	61.81	2681100.0
2023-09-25	CL	Stock	72.25	72.67	71.86	72.22	3296400.0
2023-09-25	A	Stock	110.76	112.03	110.53	111.94	987400.0
2023-09-25	AA	Stock	27.75	27.77	26.34	26.63	9304200.0
2023-09-25	AAC-DELISTED	Stock	10.71	10.79	10.71	10.76	282167.0
2023-09-25	AACG	Stock	1.13	1.15	1.13	1.15	3300.0
2023-09-25	AACT	Stock	10.26	10.27	10.26	10.27	144000.0
2023-09-25	AAIC-DELISTED	Stock	4.31	4.43	4.31	4.39	55572.0
2023-09-25	AAIC.C-DELISTED	Stock	24.0381	24.0381	23.7601	23.7601	550.0
2023-09-25	AAL	Stock	12.81	12.98	12.71	12.91	24618800.0
2023-09-25	AAMC-DELISTED	Stock	4.0353	4.3882	4.0	4.1235	68680.0
2023-09-25	AAME	Stock	1.95	1.97	1.94	1.94	900.0
2023-09-25	AAMI	Stock	19.9	19.98	19.59	19.77	122900.0
2023-09-25	AAN-DELISTED	Stock	10.34	10.56	10.245	10.46	322100.0
2023-09-25	AAOI	Stock	9.37	9.69	9.24	9.39	994200.0
2023-09-25	AAON	Stock	56.61	57.65	56.61	57.09	340200.0
2023-09-25	AAP	Stock	57.34	57.41	56.37	56.92	1622300.0
2023-09-25	AAT	Stock	18.85	19.0	18.81	18.96	577600.0
2023-09-25	AATC	Stock	6.02	6.25	6.014	6.12	15356.0
2023-09-25	AAU-DELISTED	Stock	0.1332	0.1339	0.126	0.1301	125428.0
2023-09-25	AAUAF-DELISTED	Stock	0.1332	0.1339	0.126	0.13	135586.0
2023-09-25	AAXJ	Stock	63.78	64.155	63.78	64.13	498971.0
2023-09-25	AB	Stock	31.1	31.6	31.03	31.37	186700.0
2023-09-25	ABAT	Stock	10.85	10.88	9.8	9.95	245751.0
2023-09-25	ABBNY-DELISTED	Stock	35.35	35.59	35.29	35.59	216201.0
2023-09-25	ABBV	Stock	152.44	154.74	151.66	154.65	3740000.0
2023-09-25	ABCB	Stock	37.1	37.87	36.97	37.84	504900.0
2023-09-25	ABCL	Stock	4.96	4.96	4.75	4.77	1493600.0
2023-09-25	ABCM-DELISTED	Stock	22.56	22.75	22.51	22.691	1472708.0
2023-09-25	ABEO	Stock	3.9	3.9	3.65	3.66	87100.0
2023-09-25	ABEV	Stock	2.63	2.66	2.61	2.62	14225500.0
2023-09-25	ABG	Stock	221.83	227.47	221.83	223.69	134300.0
2023-09-25	ABLLW	Stock	0.3	0.3	0.28	0.299	23543.0
2023-09-25	ABLV	Stock	3.21	3.35	3.21	3.22	1400.0
2023-09-25	ABM	Stock	39.37	39.66	39.33	39.44	500200.0
2023-09-25	ABNB	Stock	130.8	134.25	130.8	134.14	4154500.0
2023-09-25	ABOS	Stock	4.42	4.45	4.11	4.24	307300.0
2023-09-25	ABR	Stock	14.8	14.89	14.72	14.79	2020500.0
2023-09-25	ABR.D	Stock	18.39	18.5	18.25	18.25	6238.0
2023-09-25	ABR.E	Stock	18.31	18.9	18.1987	18.2	1571.0
2023-09-25	ABR.F	Stock	19.73	20.2497	19.73	19.75	11728.0
2023-09-25	ABSI	Stock	1.45	1.48	1.35	1.35	431100.0

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

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