PREVIEW / stock_daily / 2023-07-18

all stock daily files

  file:    by_date/stock_daily/2023/2023-07-18.parquet
  size:    242 KB
  rows:    7,515
  symbols: 1,547

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-18	AAPL	Stock	193.35	194.33	192.42	193.73	48353800.0
2023-07-18	MSFT	Stock	345.83	366.78	342.17	359.49	64872700.0
2023-07-18	NVDA	Stock	46.701	47.896	45.734	47.494	569164000.0
2023-07-18	AMZN	Stock	132.71	133.86	131.35	132.83	54969100.0
2023-07-18	GOOGL	Stock	124.6	124.68	122.96	123.76	26226447.0
2023-07-18	META	Stock	310.88	314.2	307.62	312.05	20764600.0
2023-07-18	TSLA	Stock	290.15	295.26	286.01	293.34	112434700.0
2023-07-18	TLT	Stock	101.8	102.065	101.57	101.8	15412764.0
2023-07-18	ES	Stock	72.32	72.85	70.53	71.41	2004500.0
2023-07-18	CL	Stock	75.82	76.96	75.66	75.84	3916200.0
2023-07-18	A	Stock	118.38	119.79	118.0	119.56	1362700.0
2023-07-18	AA	Stock	35.31	35.72	34.62	35.04	4661700.0
2023-07-18	AAC-DELISTED	Stock	10.58	10.6	10.57	10.575	86861.0
2023-07-18	AACG	Stock	1.46	1.51	1.44	1.44	6900.0
2023-07-18	AACIU	Stock	10.6	10.6	10.53	10.53	395.0
2023-07-18	AAIC-DELISTED	Stock	4.6	4.77	4.6	4.75	238843.0
2023-07-18	AAIC.C-DELISTED	Stock	23.1	23.1002	23.05	23.05	2100.0
2023-07-18	AAL	Stock	18.2	18.72	18.2	18.68	16839500.0
2023-07-18	AAM.A-DELISTED	Stock	22.6	23.0	22.6	22.98	8624.0
2023-07-18	AAM.B-DELISTED	Stock	22.57	22.93	22.53	22.93	16559.0
2023-07-18	AAMC-DELISTED	Stock	31.1941	31.9529	30.0888	31.3529	53040.0
2023-07-18	AAME	Stock	1.85	1.89	1.85	1.86	3500.0
2023-07-18	AAMI	Stock	21.21	21.72	21.21	21.59	186900.0
2023-07-18	AAN-DELISTED	Stock	15.04	15.46	15.04	15.31	182900.0
2023-07-18	AAOI	Stock	8.79	9.12	7.56	7.67	5446900.0
2023-07-18	AAON	Stock	69.8933	70.7267	68.56	69.9333	397950.0
2023-07-18	AAP	Stock	69.88	71.2	68.96	69.31	1815400.0
2023-07-18	AAT	Stock	20.94	21.75	20.83	21.63	518700.0
2023-07-18	AATC	Stock	4.42	4.5	4.42	4.47	18775.0
2023-07-18	AAU-DELISTED	Stock	0.141	0.17	0.141	0.1625	787496.0
2023-07-18	AAUAF-DELISTED	Stock	0.141	0.17	0.141	0.1625	791090.0
2023-07-18	AAXJ	Stock	68.46	68.53	68.02	68.22	212645.0
2023-07-18	AB	Stock	33.79	34.33	33.79	34.09	177200.0
2023-07-18	ABBNY-DELISTED	Stock	39.4205	39.8	39.392	39.59	150392.0
2023-07-18	ABBV	Stock	134.8	137.9	134.71	136.58	5392800.0
2023-07-18	ABC-DELISTED	Stock	192.33	193.4	192.06	192.39	512673.0
2023-07-18	ABCB	Stock	37.48	39.38	37.48	39.28	393300.0
2023-07-18	ABCL	Stock	7.61	7.81	7.5	7.56	1768600.0
2023-07-18	ABCM-DELISTED	Stock	23.85	23.9575	23.402	23.63	951072.0
2023-07-18	ABEO	Stock	4.0	4.06	3.87	3.9	63400.0
2023-07-18	ABEV	Stock	3.04	3.08	3.01	3.02	20834400.0
2023-07-18	ABG	Stock	244.43	248.71	244.43	247.42	137500.0
2023-07-18	ABLLW	Stock	0.3	0.3267	0.22	0.2251	147643.0
2023-07-18	ABLV	Stock	10.6	10.64	10.6	10.64	34371.0
2023-07-18	ABM	Stock	42.39	43.33	42.39	42.81	452800.0
2023-07-18	ABNB	Stock	144.0	147.54	143.75	146.53	4124900.0
2023-07-18	ABOS	Stock	9.05	9.2	7.11	8.0	4119100.0
2023-07-18	ABR	Stock	16.08	16.52	16.07	16.32	2577100.0
2023-07-18	ABR.D	Stock	18.4	18.7	18.4	18.69	11656.0
2023-07-18	ABR.E	Stock	18.3	18.36	18.17	18.31	20640.0

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

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