PREVIEW / stock_daily / 2023-07-19

all stock daily files

  file:    by_date/stock_daily/2023/2023-07-19.parquet
  size:    242 KB
  rows:    7,512
  symbols: 1,550

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-19	AAPL	Stock	193.1	198.23	192.65	195.1	80507300.0
2023-07-19	MSFT	Stock	361.75	362.46	352.44	355.08	39732900.0
2023-07-19	NVDA	Stock	47.464	47.818	46.742	47.077	427502000.0
2023-07-19	AMZN	Stock	133.39	135.99	132.53	135.36	54531000.0
2023-07-19	GOOGL	Stock	124.6	125.18	121.8	122.03	37224033.0
2023-07-19	META	Stock	313.03	318.68	310.52	316.01	21763700.0
2023-07-19	TSLA	Stock	296.04	299.29	289.52	291.26	142355400.0
2023-07-19	TLT	Stock	102.0	102.98	101.725	102.95	27192463.0
2023-07-19	ES	Stock	71.96	72.96	71.77	72.15	1597800.0
2023-07-19	CL	Stock	76.05	76.56	75.65	76.42	5717700.0
2023-07-19	A	Stock	120.01	123.34	119.86	123.08	2425400.0
2023-07-19	AA	Stock	35.17	35.34	34.53	34.84	6127100.0
2023-07-19	AAC-DELISTED	Stock	10.58	10.59	10.56	10.57	71577.0
2023-07-19	AACG	Stock	1.41	1.45	1.41	1.44	8100.0
2023-07-19	AACT	Stock	10.16	10.16	10.16	10.16	10100.0
2023-07-19	AAIC-DELISTED	Stock	4.77	4.84	4.72	4.78	144569.0
2023-07-19	AAIC.C-DELISTED	Stock	23.3641	23.3641	23.15	23.15	775.0
2023-07-19	AAL	Stock	18.7	18.8	18.44	18.6	20416100.0
2023-07-19	AAM.A-DELISTED	Stock	22.8	23.0	22.7921	22.82	10202.0
2023-07-19	AAM.B-DELISTED	Stock	22.95	23.13	22.75	22.87	6403.0
2023-07-19	AAMC-DELISTED	Stock	30.5653	31.7647	30.0882	30.0941	57290.0
2023-07-19	AAME	Stock	1.88	1.89	1.85	1.89	13800.0
2023-07-19	AAMI	Stock	21.59	21.84	21.54	21.72	201100.0
2023-07-19	AAN-DELISTED	Stock	15.44	15.86	15.44	15.77	174900.0
2023-07-19	AAOI	Stock	7.75	9.38	7.75	8.67	4994700.0
2023-07-19	AAON	Stock	70.28	70.4267	68.2533	69.0133	271050.0
2023-07-19	AAP	Stock	70.26	72.52	69.99	72.44	2774500.0
2023-07-19	AAT	Stock	21.83	22.33	21.8	22.23	411600.0
2023-07-19	AATC	Stock	4.48	4.48	4.465	4.4686	4945.0
2023-07-19	AAU-DELISTED	Stock	0.165	0.165	0.155	0.1589	248652.0
2023-07-19	AAUAF-DELISTED	Stock	0.165	0.165	0.155	0.159	251017.0
2023-07-19	AAXJ	Stock	68.48	68.67	68.06	68.11	481736.0
2023-07-19	AB	Stock	34.3	34.64	33.7	33.92	252700.0
2023-07-19	ABBNY-DELISTED	Stock	39.02	39.05	38.77	39.0	155045.0
2023-07-19	ABBV	Stock	137.24	138.06	136.95	137.68	4784200.0
2023-07-19	ABC-DELISTED	Stock	192.41	192.79	189.11	191.89	752798.0
2023-07-19	ABCB	Stock	39.53	40.57	39.19	40.4	405000.0
2023-07-19	ABCL	Stock	7.64	8.05	7.6	7.95	3182500.0
2023-07-19	ABCM-DELISTED	Stock	23.64	24.0	23.28	23.5	928786.0
2023-07-19	ABEO	Stock	3.89	3.91	3.76	3.79	119300.0
2023-07-19	ABEV	Stock	3.02	3.04	2.99	3.02	13256000.0
2023-07-19	ABG	Stock	250.28	250.85	245.38	249.98	192700.0
2023-07-19	ABLLW	Stock	0.2767	0.2767	0.24	0.25	42829.0
2023-07-19	ABM	Stock	42.97	43.73	42.67	43.7	411400.0
2023-07-19	ABNB	Stock	145.75	147.675	144.19	145.535	4968600.0
2023-07-19	ABOS	Stock	7.7	7.98	7.27	7.41	5345000.0
2023-07-19	ABR	Stock	16.55	16.89	16.54	16.84	3548700.0
2023-07-19	ABR.D	Stock	18.8	18.8	18.49	18.77	10350.0
2023-07-19	ABR.E	Stock	18.36	18.37	18.3	18.35	2091.0
2023-07-19	ABR.F	Stock	20.35	20.4	20.22	20.35	18426.0

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

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