PREVIEW / stock_daily / 2023-04-04

all stock daily files

  file:    by_date/stock_daily/2023/2023-04-04.parquet
  size:    244 KB
  rows:    7,573
  symbols: 1,728

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-04	AAPL	Stock	166.6	166.84	165.11	165.63	46278300.0
2023-04-04	MSFT	Stock	287.23	290.45	285.67	287.18	25824300.0
2023-04-04	NVDA	Stock	27.966	28.0	27.307	27.453	368592000.0
2023-04-04	AMZN	Stock	102.75	104.2	102.11	103.95	48662500.0
2023-04-04	GOOGL	Stock	104.33	105.58	104.04	104.72	24420079.0
2023-04-04	META	Stock	213.39	216.24	212.54	214.72	21026400.0
2023-04-04	TSLA	Stock	197.32	198.74	190.32	192.58	126463800.0
2023-04-04	TLT	Stock	105.78	107.8	105.75	107.13	18052419.0
2023-04-04	ES	Stock	77.57	78.22	77.31	78.05	1072400.0
2023-04-04	CL	Stock	75.55	75.9	74.7	74.73	3002600.0
2023-04-04	A	Stock	138.25	139.11	137.53	138.21	1778700.0
2023-04-04	AA	Stock	41.44	41.52	39.31	40.34	4587400.0
2023-04-04	AAC-DELISTED	Stock	10.34	10.34	10.32	10.32	11129.0
2023-04-04	AACG	Stock	1.93	1.94	1.87	1.89	7000.0
2023-04-04	AACIW-DELISTED	Stock	0.0959	0.10799	0.0805	0.1079	1180.0
2023-04-04	AAIC-DELISTED	Stock	2.84	2.84	2.75	2.76	40540.0
2023-04-04	AAIC.C-DELISTED	Stock	20.88	21.202	20.88	21.202	1021.0
2023-04-04	AAL	Stock	14.55	14.55	14.02	14.16	16124100.0
2023-04-04	AAM.A-DELISTED	Stock	21.31	21.9899	21.235	21.71	22507.0
2023-04-04	AAM.B-DELISTED	Stock	22.6	23.23	21.84	23.18	20457.0
2023-04-04	AAMC-DELISTED	Stock	20.0	20.0	19.9265	19.9265	3237.0
2023-04-04	AAME	Stock	2.45	2.5	2.44	2.45	5700.0
2023-04-04	AAMI	Stock	23.21	23.21	22.29	22.38	85100.0
2023-04-04	AAN-DELISTED	Stock	9.74	9.75	9.35	9.62	333500.0
2023-04-04	AAOI	Stock	2.32	2.32	2.2	2.21	80200.0
2023-04-04	AAON	Stock	64.7133	64.7733	61.86	62.6067	691950.0
2023-04-04	AAP	Stock	122.7	123.24	119.24	121.34	900600.0
2023-04-04	AAT	Stock	18.45	18.45	17.89	18.13	336400.0
2023-04-04	AATC	Stock	4.0	4.01	3.9	3.9	12926.0
2023-04-04	AAU-DELISTED	Stock	0.19	0.202	0.19	0.2004	202990.0
2023-04-04	AAUAF-DELISTED	Stock	0.19	0.202	0.19	0.2004	203882.0
2023-04-04	AAXJ	Stock	68.0	68.03	67.69	68.01	325182.0
2023-04-04	AB	Stock	35.58	35.85	34.39	34.81	240500.0
2023-04-04	ABB-DELISTED	Stock	34.43	34.49	33.755	33.91	1768202.0
2023-04-04	ABBNY-DELISTED	Stock	34.43	34.49	33.755	33.91	1975156.0
2023-04-04	ABBV	Stock	160.51	161.73	159.53	159.78	4224400.0
2023-04-04	ABC-DELISTED	Stock	162.1	163.12	161.02	162.99	546460.0
2023-04-04	ABCB	Stock	35.95	35.95	34.09	34.68	527700.0
2023-04-04	ABCL	Stock	7.47	7.47	7.18	7.21	1343100.0
2023-04-04	ABCM-DELISTED	Stock	12.83	12.99	12.68	12.75	941064.0
2023-04-04	ABEO	Stock	2.76	2.86	2.75	2.82	31100.0
2023-04-04	ABEV	Stock	2.84	2.86	2.78	2.82	19317600.0
2023-04-04	ABG	Stock	211.46	211.46	200.73	203.46	256700.0
2023-04-04	ABM	Stock	45.12	45.12	43.34	43.49	387100.0
2023-04-04	ABNB	Stock	121.68	122.06	118.21	118.46	3349300.0
2023-04-04	ABOS	Stock	4.31	4.31	3.69	3.84	439700.0
2023-04-04	ABR	Stock	11.51	11.54	11.19	11.25	3080800.0
2023-04-04	ABR.D	Stock	18.17	18.3399	17.7501	18.01	25249.0
2023-04-04	ABR.E	Stock	18.08	18.2	17.5999	17.5999	7763.0
2023-04-04	ABR.F	Stock	17.99	18.0	17.65	17.74	38044.0

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

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