PREVIEW / stock_daily / 2023-01-10

all stock daily files

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

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-10	AAPL	Stock	130.26	131.26	128.12	130.73	63896200.0
2023-01-10	MSFT	Stock	227.76	231.31	227.33	228.85	27033900.0
2023-01-10	NVDA	Stock	15.507	15.962	15.472	15.909	384101000.0
2023-01-10	AMZN	Stock	87.57	90.19	87.29	89.87	67756600.0
2023-01-10	GOOGL	Stock	85.98	88.67	85.83	88.42	30467755.0
2023-01-10	META	Stock	127.27	133.44	127.15	132.99	28684400.0
2023-01-10	TSLA	Stock	121.07	122.76	114.92	118.85	167642500.0
2023-01-10	TLT	Stock	104.53	104.82	103.5	103.99	20545215.0
2023-01-10	ES	Stock	85.38	85.79	84.91	85.69	1072800.0
2023-01-10	CL	Stock	78.97	78.97	78.02	78.31	3397200.0
2023-01-10	A	Stock	150.18	155.55	148.75	155.23	1565700.0
2023-01-10	AA	Stock	50.6	53.125	49.91	52.98	5734300.0
2023-01-10	AAC-DELISTED	Stock	10.13	10.13	10.12	10.13	1043055.0
2023-01-10	AACG	Stock	1.39	1.39	1.38	1.39	1400.0
2023-01-10	AACIW-DELISTED	Stock	0.045	0.4149	0.02	0.1108	1110709.0
2023-01-10	AAIC-DELISTED	Stock	2.99	3.0	2.96	3.0	18130.0
2023-01-10	AAIC.C-DELISTED	Stock	21.3801	21.3801	21.3801	21.3801	110.0
2023-01-10	AAL	Stock	14.56	15.2	14.56	15.19	31109900.0
2023-01-10	AAM.A-DELISTED	Stock	23.77	24.0199	23.72	23.98	7294.0
2023-01-10	AAM.B-DELISTED	Stock	23.42	24.0	23.42	23.6	10272.0
2023-01-10	AAMC-DELISTED	Stock	7.5765	7.5765	7.1824	7.3529	17024.0
2023-01-10	AAME	Stock	2.58	2.58	2.46	2.57	2500.0
2023-01-10	AAMI	Stock	20.69	21.1	20.62	21.09	220400.0
2023-01-10	AAN-DELISTED	Stock	13.13	13.48	13.01	13.46	238700.0
2023-01-10	AAOI	Stock	2.15	2.25	2.12	2.12	166200.0
2023-01-10	AAON	Stock	49.2067	50.4467	49.2067	50.4067	277650.0
2023-01-10	AAP	Stock	152.0	153.63	151.28	151.97	642700.0
2023-01-10	AAT	Stock	26.63	26.64	26.35	26.63	161500.0
2023-01-10	AATC	Stock	3.75	3.77	3.69	3.74	14801.0
2023-01-10	AAU-DELISTED	Stock	0.2585	0.2665	0.2507	0.2529	102031.0
2023-01-10	AAUAF-DELISTED	Stock	0.2585	0.2665	0.2507	0.2529	104252.0
2023-01-10	AAWW-DELISTED	Stock	101.1	101.67	101.1	101.54	222080.0
2023-01-10	AAXJ	Stock	69.35	69.73	69.09	69.72	980210.0
2023-01-10	AB	Stock	36.32	38.03	36.28	37.94	272700.0
2023-01-10	ABB-DELISTED	Stock	32.68	32.93	32.68	32.92	734625.0
2023-01-10	ABBNY-DELISTED	Stock	32.68	32.93	32.68	32.92	837974.0
2023-01-10	ABBV	Stock	162.23	162.42	158.3	159.64	5936200.0
2023-01-10	ABC-DELISTED	Stock	165.82	167.95	164.9	167.3	775319.0
2023-01-10	ABCB	Stock	47.28	48.0	46.72	47.65	239200.0
2023-01-10	ABCL	Stock	9.5	9.63	9.33	9.38	1228500.0
2023-01-10	ABCM-DELISTED	Stock	16.18	16.65	16.1	16.52	280977.0
2023-01-10	ABEO	Stock	3.06	3.12	3.0	3.05	191800.0
2023-01-10	ABEV	Stock	2.75	2.78	2.71	2.76	19909900.0
2023-01-10	ABG	Stock	183.99	189.53	182.22	189.37	161500.0
2023-01-10	ABLV	Stock	10.17	10.17	10.17	10.17	200.0
2023-01-10	ABM	Stock	45.31	46.3	45.29	46.19	348700.0
2023-01-10	ABNB	Stock	88.86	89.62	86.75	88.54	4165600.0
2023-01-10	ABOS	Stock	5.47	5.62	5.43	5.58	53700.0
2023-01-10	ABR	Stock	13.75	13.98	13.68	13.96	899800.0
2023-01-10	ABR.D	Stock	19.32	19.62	19.12	19.4764	20559.0

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

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