PREVIEW / stock_daily / 2023-04-03

all stock daily files

  file:    by_date/stock_daily/2023/2023-04-03.parquet
  size:    245 KB
  rows:    7,603
  symbols: 1,744

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-04-03	AAPL	Stock	164.27	166.29	164.22	166.17	56976200.0
2023-04-03	MSFT	Stock	286.52	288.27	283.95	287.23	24883300.0
2023-04-03	NVDA	Stock	27.509	28.0	27.336	27.965	398716000.0
2023-04-03	AMZN	Stock	102.3	103.29	101.43	102.41	41135700.0
2023-04-03	GOOGL	Stock	102.39	104.53	101.93	104.36	25035399.0
2023-04-03	META	Stock	208.84	213.49	208.2	213.07	17924600.0
2023-04-03	TSLA	Stock	199.91	202.69	192.2	194.77	169545900.0
2023-04-03	TLT	Stock	105.88	107.095	105.7	106.6	18234843.0
2023-04-03	ES	Stock	77.55	78.05	76.72	77.41	1676000.0
2023-04-03	CL	Stock	75.24	75.75	74.87	75.36	3188700.0
2023-04-03	A	Stock	137.42	138.09	136.01	137.86	1551800.0
2023-04-03	AA	Stock	42.56	42.95	41.13	41.77	3272100.0
2023-04-03	AAC-DELISTED	Stock	10.32	10.34	10.32	10.33	7387.0
2023-04-03	AACG	Stock	1.98	1.98	1.85	1.91	23000.0
2023-04-03	AACIW-DELISTED	Stock	0.1085	0.1085	0.0795	0.1079	3600.0
2023-04-03	AAIC-DELISTED	Stock	2.82	2.85	2.79	2.8	44153.0
2023-04-03	AAIC.C-DELISTED	Stock	20.75	20.75	20.75	20.75	100.0
2023-04-03	AAL	Stock	14.52	14.62	14.28	14.42	14317400.0
2023-04-03	AAM.A-DELISTED	Stock	21.35	21.815	21.07	21.69	66940.0
2023-04-03	AAM.B-DELISTED	Stock	22.3558	22.81	22.0	22.67	4938.0
2023-04-03	AAMC-DELISTED	Stock	19.55	20.3706	19.55	19.9265	44356.0
2023-04-03	AAME	Stock	2.41	2.5	2.4	2.4	2400.0
2023-04-03	AAMI	Stock	23.6	23.77	22.65	23.05	151400.0
2023-04-03	AAN-DELISTED	Stock	9.63	9.79	9.42	9.68	378000.0
2023-04-03	AAOI	Stock	2.14	2.31	2.14	2.29	190600.0
2023-04-03	AAON	Stock	64.46	64.8333	63.5467	64.6733	722250.0
2023-04-03	AAP	Stock	121.88	123.36	121.48	122.69	1476200.0
2023-04-03	AAT	Stock	18.69	18.78	18.11	18.3	407600.0
2023-04-03	AATC	Stock	3.95	4.01	3.94	4.01	5206.0
2023-04-03	AAU-DELISTED	Stock	0.19	0.1985	0.19	0.1929	157148.0
2023-04-03	AAUAF-DELISTED	Stock	0.19	0.1985	0.19	0.1929	159796.0
2023-04-03	AAXJ	Stock	67.76	68.135	67.7	68.1	393559.0
2023-04-03	AB	Stock	36.32	36.51	35.57	35.7	259100.0
2023-04-03	ABB-DELISTED	Stock	34.4	34.5552	34.27	34.42	1369789.0
2023-04-03	ABBNY-DELISTED	Stock	34.4	34.5552	34.27	34.42	1524015.0
2023-04-03	ABBV	Stock	158.25	160.47	157.79	160.42	4389400.0
2023-04-03	ABC-DELISTED	Stock	161.0	163.22	160.5069	162.33	732822.0
2023-04-03	ABCB	Stock	36.62	36.97	35.67	35.99	297600.0
2023-04-03	ABCL	Stock	7.59	7.59	7.125	7.48	1671200.0
2023-04-03	ABCM-DELISTED	Stock	13.43	13.49	12.76	12.84	735261.0
2023-04-03	ABEO	Stock	2.82	2.92	2.76	2.83	168200.0
2023-04-03	ABEV	Stock	2.76	2.82	2.76	2.81	15132600.0
2023-04-03	ABG	Stock	209.99	211.69	206.01	209.98	187100.0
2023-04-03	ABLV	Stock	10.38	10.38	10.38	10.38	300.0
2023-04-03	ABM	Stock	44.95	45.21	44.55	44.94	341000.0
2023-04-03	ABNB	Stock	123.0	123.09	119.711	121.46	4230600.0
2023-04-03	ABOS	Stock	4.13	4.45	4.05	4.31	82000.0
2023-04-03	ABR	Stock	11.5	11.7	11.38	11.46	3357300.0
2023-04-03	ABR.D	Stock	17.45	18.1	17.3625	18.05	32423.0
2023-04-03	ABR.E	Stock	17.39	17.836	16.91	17.75	17140.0

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

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