PREVIEW / stock_daily / 2023-01-25

all stock daily files

  file:    by_date/stock_daily/2023/2023-01-25.parquet
  size:    248 KB
  rows:    7,685
  symbols: 1,898

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-01-25	AAPL	Stock	140.89	142.43	138.81	141.86	65799300.0
2023-01-25	MSFT	Stock	234.48	243.3	230.9	240.61	66526600.0
2023-01-25	NVDA	Stock	18.913	19.37	18.58	19.323	449537000.0
2023-01-25	AMZN	Stock	92.56	97.24	91.52	97.18	94261600.0
2023-01-25	GOOGL	Stock	95.57	96.162	93.76	95.22	42329952.0
2023-01-25	META	Stock	141.22	143.17	140.31	141.5	26622000.0
2023-01-25	TSLA	Stock	141.91	146.41	138.07	144.43	192734300.0
2023-01-25	TLT	Stock	107.37	107.905	106.64	107.48	11906502.0
2023-01-25	ES	Stock	79.6	79.98	78.89	79.71	1934700.0
2023-01-25	CL	Stock	75.48	75.99	74.63	75.77	3142700.0
2023-01-25	A	Stock	154.0	156.54	152.83	155.76	736200.0
2023-01-25	AA	Stock	51.87	52.705	51.07	52.19	4584100.0
2023-01-25	AAC-DELISTED	Stock	10.13	10.14	10.12	10.12	42940.0
2023-01-25	AACG	Stock	1.38	1.44	1.35	1.44	6900.0
2023-01-25	AACIW-DELISTED	Stock	0.0997	0.1	0.0997	0.1	3000.0
2023-01-25	AAIC-DELISTED	Stock	3.0	3.05	3.0	3.02	60986.0
2023-01-25	AAIC.C-DELISTED	Stock	22.2112	22.72	22.2112	22.67	3411.0
2023-01-25	AAL	Stock	15.97	16.48	15.9	16.26	34131000.0
2023-01-25	AAM.A-DELISTED	Stock	24.705	24.83	24.645	24.7563	4623.0
2023-01-25	AAM.B-DELISTED	Stock	24.7	24.912	24.53	24.6212	3896.0
2023-01-25	AAMC-DELISTED	Stock	9.1176	9.5088	9.0529	9.2941	56284.0
2023-01-25	AAME	Stock	2.5	2.55	2.46	2.55	3900.0
2023-01-25	AAMI	Stock	22.24	22.48	22.13	22.34	84500.0
2023-01-25	AAN-DELISTED	Stock	13.71	13.99	13.66	13.94	179800.0
2023-01-25	AAOI	Stock	2.21	2.26	2.13	2.2	57300.0
2023-01-25	AAON	Stock	49.5933	51.6667	49.3	49.5067	130500.0
2023-01-25	AAP	Stock	146.48	149.12	143.22	149.11	1074000.0
2023-01-25	AAT	Stock	26.9	27.2	26.72	27.09	187800.0
2023-01-25	AATC	Stock	4.1075	4.18	4.07	4.15	15826.0
2023-01-25	AAU-DELISTED	Stock	0.2438	0.2447	0.2361	0.2398	188612.0
2023-01-25	AAUAF-DELISTED	Stock	0.2438	0.2447	0.2361	0.2398	191151.0
2023-01-25	AAWW-DELISTED	Stock	102.0	102.1	101.98	101.99	178286.0
2023-01-25	AAXJ	Stock	71.99	72.29	71.44	72.29	710501.0
2023-01-25	AB	Stock	37.75	37.91	37.3	37.53	138700.0
2023-01-25	ABB-DELISTED	Stock	34.04	34.33	33.9185	34.26	1332808.0
2023-01-25	ABBNY-DELISTED	Stock	34.04	34.33	33.9185	34.27	1481571.0
2023-01-25	ABBV	Stock	147.38	147.98	146.5	147.79	5744300.0
2023-01-25	ABC-DELISTED	Stock	161.27	163.48	161.23	163.46	784594.0
2023-01-25	ABCB	Stock	47.52	47.66	46.89	47.54	517500.0
2023-01-25	ABCL	Stock	9.95	10.44	9.78	10.41	1370400.0
2023-01-25	ABCM-DELISTED	Stock	16.8	17.0	16.69	16.95	320169.0
2023-01-25	ABEO	Stock	2.59	2.6	2.55	2.58	127500.0
2023-01-25	ABEV	Stock	2.63	2.69	2.62	2.68	28129500.0
2023-01-25	ABG	Stock	187.15	194.48	186.56	193.64	158500.0
2023-01-25	ABM	Stock	45.01	45.54	44.49	45.19	207000.0
2023-01-25	ABNB	Stock	100.36	104.675	99.841	104.44	5169300.0
2023-01-25	ABOS	Stock	5.94	6.18	5.835	5.87	47800.0
2023-01-25	ABR	Stock	14.33	14.5	14.23	14.46	1173300.0
2023-01-25	ABR.D	Stock	19.73	20.2081	19.73	20.02	6700.0
2023-01-25	ABR.E	Stock	19.62	19.8598	19.62	19.8598	1755.0

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

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