PREVIEW / stock_daily / 2023-07-07

all stock daily files

  file:    by_date/stock_daily/2023/2023-07-07.parquet
  size:    238 KB
  rows:    7,412
  symbols: 1,519

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-07-07	AAPL	Stock	191.41	192.67	190.24	190.68	46778000.0
2023-07-07	MSFT	Stock	339.32	341.79	337.0	337.22	21185300.0
2023-07-07	NVDA	Stock	42.322	43.214	42.18	42.503	355881000.0
2023-07-07	AMZN	Stock	128.59	130.97	128.13	129.78	41928700.0
2023-07-07	GOOGL	Stock	120.1	121.05	119.4	119.48	21709549.0
2023-07-07	META	Stock	292.18	296.2	288.66	290.53	25546200.0
2023-07-07	TSLA	Stock	278.43	280.78	273.77	274.43	113602000.0
2023-07-07	TLT	Stock	99.18	99.6	98.985	99.08	28996478.0
2023-07-07	ES	Stock	70.73	71.56	70.58	70.83	1702700.0
2023-07-07	CL	Stock	76.71	76.75	75.53	75.59	4420200.0
2023-07-07	A	Stock	117.67	119.08	116.89	117.0	1493300.0
2023-07-07	AA	Stock	32.8	34.6	32.68	34.09	6297100.0
2023-07-07	AAC-DELISTED	Stock	10.57	10.57	10.56	10.57	4791.0
2023-07-07	AACG	Stock	1.37	1.44	1.34	1.38	8300.0
2023-07-07	AACIW-DELISTED	Stock	0.0998	0.0998	0.0442	0.0987	6358.0
2023-07-07	AACT	Stock	10.17	10.175	10.17	10.17	18000.0
2023-07-07	AAIC-DELISTED	Stock	4.34	4.51	4.34	4.51	300279.0
2023-07-07	AAIC.C-DELISTED	Stock	22.95	23.0	22.84	22.9195	1275.0
2023-07-07	AAL	Stock	17.93	18.55	17.93	18.35	21936300.0
2023-07-07	AAM.A-DELISTED	Stock	22.54	22.9	22.54	22.71	3512.0
2023-07-07	AAM.B-DELISTED	Stock	22.47	22.83	22.47	22.52	10786.0
2023-07-07	AAMC-DELISTED	Stock	34.4118	34.4118	30.2941	30.7941	36720.0
2023-07-07	AAME	Stock	2.04	2.05	1.91	1.96	6600.0
2023-07-07	AAMI	Stock	20.41	20.58	19.98	19.99	131300.0
2023-07-07	AAN-DELISTED	Stock	14.6	15.53	14.6	15.28	518800.0
2023-07-07	AAOI	Stock	6.59	8.1	6.59	7.19	5750000.0
2023-07-07	AAON	Stock	62.9733	63.3933	62.1333	62.96	523200.0
2023-07-07	AAP	Stock	69.8	70.3	68.78	69.38	2779300.0
2023-07-07	AAT	Stock	19.31	20.04	19.3	19.74	320800.0
2023-07-07	AATC	Stock	4.41	4.41	4.41	4.41	358.0
2023-07-07	AAU-DELISTED	Stock	0.128	0.133	0.128	0.133	177927.0
2023-07-07	AAUAF-DELISTED	Stock	0.128	0.133	0.128	0.133	175506.0
2023-07-07	AAXJ	Stock	65.57	66.38	65.545	66.05	851659.0
2023-07-07	AB	Stock	31.41	31.9	31.41	31.54	206300.0
2023-07-07	ABBNY-DELISTED	Stock	37.43	37.9	37.3948	37.74	147781.0
2023-07-07	ABBV	Stock	137.15	137.65	135.35	135.5	6872700.0
2023-07-07	ABC-DELISTED	Stock	191.45	192.94	190.45	190.84	1024881.0
2023-07-07	ABCB	Stock	33.68	34.77	33.68	34.41	424300.0
2023-07-07	ABCL	Stock	6.38	6.59	6.38	6.51	1612900.0
2023-07-07	ABCM-DELISTED	Stock	23.93	24.46	23.81	24.42	1609581.0
2023-07-07	ABEO	Stock	4.08	4.21	4.05	4.09	370400.0
2023-07-07	ABEV	Stock	3.04	3.05	3.01	3.03	7821000.0
2023-07-07	ABG	Stock	238.97	245.25	238.97	243.68	173100.0
2023-07-07	ABLLW	Stock	0.2625	0.3199	0.2625	0.289	88457.0
2023-07-07	ABLV	Stock	10.61	10.61	10.6	10.6	1047.0
2023-07-07	ABM	Stock	41.76	42.13	40.58	41.58	799700.0
2023-07-07	ABNB	Stock	128.16	131.62	128.06	130.32	3148100.0
2023-07-07	ABOS	Stock	5.06	5.12	4.95	5.06	95800.0
2023-07-07	ABR	Stock	14.59	14.85	14.56	14.68	5721800.0
2023-07-07	ABR.D	Stock	18.5	18.6	18.25	18.56	9669.0

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

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