PREVIEW / stock_daily / 2023-09-19

all stock daily files

  file:    by_date/stock_daily/2023/2023-09-19.parquet
  size:    234 KB
  rows:    7,345
  symbols: 1,355

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-19	AAPL	Stock	177.52	179.63	177.13	179.07	51826900.0
2023-09-19	MSFT	Stock	326.17	329.39	324.51	328.65	16505900.0
2023-09-19	NVDA	Stock	43.833	43.966	43.002	43.52	373064000.0
2023-09-19	AMZN	Stock	138.7	138.84	135.56	137.63	61482500.0
2023-09-19	GOOGL	Stock	137.42	138.41	136.62	138.04	20353653.0
2023-09-19	META	Stock	302.48	306.17	299.81	305.07	15924400.0
2023-09-19	TSLA	Stock	264.35	267.85	261.2	266.5	103704000.0
2023-09-19	TLT	Stock	93.08	93.43	92.8	92.8	24947684.0
2023-09-19	ES	Stock	64.33	64.53	63.73	63.79	1777000.0
2023-09-19	CL	Stock	73.66	73.69	72.6	73.22	3016000.0
2023-09-19	A	Stock	112.37	113.23	111.72	112.31	2222400.0
2023-09-19	AA	Stock	28.83	28.989	27.835	28.34	5151500.0
2023-09-19	AAC-DELISTED	Stock	10.71	10.73	10.71	10.73	16947.0
2023-09-19	AACG	Stock	1.18	1.18	1.13	1.13	1000.0
2023-09-19	AACT	Stock	10.28	10.28	10.26	10.26	240400.0
2023-09-19	AAIC-DELISTED	Stock	4.48	4.59	4.48	4.59	59283.0
2023-09-19	AAIC.C-DELISTED	Stock	23.92	23.92	23.8	23.8967	3605.0
2023-09-19	AAL	Stock	13.08	13.35	13.05	13.19	25325000.0
2023-09-19	AAM.A-DELISTED	Stock	25.04	25.04	25.01	25.01	13648.0
2023-09-19	AAM.B-DELISTED	Stock	25.0105	25.04	25.01	25.02	13771.0
2023-09-19	AAMC-DELISTED	Stock	4.1529	4.1529	3.8588	3.8588	71570.0
2023-09-19	AAME	Stock	1.89	1.92	1.8	1.92	11300.0
2023-09-19	AAMI	Stock	20.22	20.29	20.085	20.24	81000.0
2023-09-19	AAN-DELISTED	Stock	9.64	9.795	9.605	9.77	430800.0
2023-09-19	AAOI	Stock	9.9	10.13	9.36	9.64	2451800.0
2023-09-19	AAON	Stock	60.55	61.83	59.62	61.77	432400.0
2023-09-19	AAP	Stock	58.01	60.04	57.97	59.66	1900200.0
2023-09-19	AAT	Stock	20.45	20.67	20.38	20.55	280000.0
2023-09-19	AATC	Stock	6.05	6.08	6.04	6.04	3104.0
2023-09-19	AAU-DELISTED	Stock	0.1369	0.1369	0.1208	0.1301	249663.0
2023-09-19	AAUAF-DELISTED	Stock	0.1369	0.1369	0.1208	0.1301	251870.0
2023-09-19	AAXJ	Stock	64.99	65.2	64.83	64.92	171700.0
2023-09-19	AB	Stock	32.47	32.79	32.17	32.17	223300.0
2023-09-19	ABBNY-DELISTED	Stock	36.2701	36.42	36.16	36.37	179330.0
2023-09-19	ABBV	Stock	153.89	154.64	151.6	153.49	3509700.0
2023-09-19	ABCB	Stock	38.99	39.22	38.38	38.71	238400.0
2023-09-19	ABCL	Stock	5.13	5.18	5.06	5.08	1249200.0
2023-09-19	ABCM-DELISTED	Stock	22.65	22.7	22.58	22.645	3915130.0
2023-09-19	ABEO	Stock	3.66	3.89	3.66	3.79	170100.0
2023-09-19	ABEV	Stock	2.75	2.76	2.73	2.73	12436000.0
2023-09-19	ABG	Stock	227.0	228.02	224.21	224.97	139000.0
2023-09-19	ABLLW	Stock	0.3975	0.3988	0.333	0.37	122664.0
2023-09-19	ABLV	Stock	3.42	3.6	3.42	3.44	28500.0
2023-09-19	ABLVW	Stock	0.0367	0.0367	0.0306	0.0306	1536.0
2023-09-19	ABM	Stock	40.81	40.96	40.63	40.68	450800.0
2023-09-19	ABNB	Stock	141.86	142.57	139.77	141.85	6674100.0
2023-09-19	ABOS	Stock	5.1	5.23	5.02	5.1	254600.0
2023-09-19	ABR	Stock	15.77	15.89	15.59	15.77	1622500.0
2023-09-19	ABR.D	Stock	18.58	18.63	18.55	18.55	9771.0
2023-09-19	ABR.E	Stock	18.44	18.667	18.44	18.6	4019.0

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

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