PREVIEW / stock_daily / 2023-08-16

all stock daily files

  file:    by_date/stock_daily/2023/2023-08-16.parquet
  size:    238 KB
  rows:    7,421
  symbols: 1,471

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-08-16	AAPL	Stock	177.13	178.54	176.5	176.57	46964900.0
2023-08-16	MSFT	Stock	320.8	324.42	319.8	320.4	20698900.0
2023-08-16	NVDA	Stock	44.52	44.675	43.406	43.486	527451000.0
2023-08-16	AMZN	Stock	137.19	137.27	135.01	135.07	41675900.0
2023-08-16	GOOGL	Stock	128.7	130.2809	127.865	128.7	25216068.0
2023-08-16	META	Stock	300.2	301.08	294.28	294.29	18547700.0
2023-08-16	TSLA	Stock	228.02	233.97	225.38	225.6	112484500.0
2023-08-16	TLT	Stock	94.28	94.79	93.72	93.84	23076663.0
2023-08-16	ES	Stock	64.5	64.75	64.19	64.42	1346700.0
2023-08-16	CL	Stock	74.77	74.97	74.21	74.42	3639900.0
2023-08-16	A	Stock	121.99	123.65	120.37	121.36	3388800.0
2023-08-16	AA	Stock	30.08	30.52	29.095	29.31	7915900.0
2023-08-16	AAC-DELISTED	Stock	10.61	10.66	10.61	10.65	12924.0
2023-08-16	AACG	Stock	1.18	1.22	1.18	1.21	6500.0
2023-08-16	AACT	Stock	10.23	10.23	10.21	10.21	200.0
2023-08-16	AAIC-DELISTED	Stock	4.47	4.49	4.41	4.42	81641.0
2023-08-16	AAIC.C-DELISTED	Stock	23.9501	24.0	23.95	23.95	4215.0
2023-08-16	AAL	Stock	15.58	15.84	15.39	15.44	20012000.0
2023-08-16	AAM.A-DELISTED	Stock	25.32	25.5114	25.13	25.17	186728.0
2023-08-16	AAM.B-DELISTED	Stock	25.25	25.395	25.15	25.17	60613.0
2023-08-16	AAMC-DELISTED	Stock	5.7353	6.2506	5.6953	5.8706	267070.0
2023-08-16	AAME	Stock	1.81	1.82	1.73	1.73	1800.0
2023-08-16	AAMI	Stock	19.67	19.89	19.625	19.83	119100.0
2023-08-16	AAN-DELISTED	Stock	12.62	12.91	12.61	12.61	209500.0
2023-08-16	AAOI	Stock	14.2	14.37	12.8	13.03	3755700.0
2023-08-16	AAON	Stock	63.0333	63.8067	62.46	63.0467	216000.0
2023-08-16	AAP	Stock	70.0	70.68	69.83	69.87	1432200.0
2023-08-16	AAT	Stock	21.29	21.32	20.94	20.97	325800.0
2023-08-16	AATC	Stock	5.45	5.59	5.45	5.59	14685.0
2023-08-16	AAU-DELISTED	Stock	0.1203	0.1303	0.1151	0.12	359138.0
2023-08-16	AAUAF-DELISTED	Stock	0.1203	0.1303	0.1151	0.12	364016.0
2023-08-16	AAXJ	Stock	64.62	64.93	64.455	64.5	808612.0
2023-08-16	AB	Stock	29.11	29.84	29.11	29.6	231100.0
2023-08-16	ABBNY-DELISTED	Stock	38.0	38.15	37.71	37.77	468163.0
2023-08-16	ABBV	Stock	152.59	153.6	151.38	151.55	3214900.0
2023-08-16	ABC-DELISTED	Stock	185.89	186.38	183.28	183.99	1167022.0
2023-08-16	ABCB	Stock	41.72	42.19	41.15	41.18	163800.0
2023-08-16	ABCL	Stock	5.5	5.595	5.46	5.5	2048300.0
2023-08-16	ABCM-DELISTED	Stock	22.5	22.5	20.79	21.53	5058180.0
2023-08-16	ABEO	Stock	3.45	3.72	3.31	3.56	89100.0
2023-08-16	ABEV	Stock	2.83	2.86	2.82	2.84	8817000.0
2023-08-16	ABG	Stock	222.41	225.95	218.64	219.32	119900.0
2023-08-16	ABLLW	Stock	0.29	0.29	0.254	0.266	49249.0
2023-08-16	ABLV	Stock	8.22	9.2	8.22	8.67	18120.0
2023-08-16	ABM	Stock	45.32	45.86	45.12	45.13	207700.0
2023-08-16	ABNB	Stock	129.0	130.15	128.4	128.83	3336900.0
2023-08-16	ABOS	Stock	7.12	7.12	6.51	6.79	706100.0
2023-08-16	ABR	Stock	15.7	15.89	15.45	15.47	2044400.0
2023-08-16	ABR.D	Stock	18.66	18.66	18.45	18.48	10505.0
2023-08-16	ABR.E	Stock	18.6	18.6	18.29	18.3	4609.0

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

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