PREVIEW / stock_daily / 2023-05-15

all stock daily files

  file:    by_date/stock_daily/2023/2023-05-15.parquet
  size:    241 KB
  rows:    7,535
  symbols: 1,657

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-05-15	AAPL	Stock	173.16	173.21	171.47	172.07	37266700.0
2023-05-15	MSFT	Stock	309.1	309.9	307.59	309.46	16336500.0
2023-05-15	NVDA	Stock	28.508	28.969	28.152	28.953	293926000.0
2023-05-15	AMZN	Stock	111.15	112.29	109.25	111.2	53011100.0
2023-05-15	GOOGL	Stock	116.11	118.48	116.01	116.51	36266765.0
2023-05-15	META	Stock	236.92	240.26	235.33	238.86	20653200.0
2023-05-15	TSLA	Stock	167.66	169.76	164.55	166.35	105592500.0
2023-05-15	TLT	Stock	103.39	103.47	103.12	103.19	20085302.0
2023-05-15	ES	Stock	77.43	77.53	75.96	76.84	2119700.0
2023-05-15	CL	Stock	81.89	82.09	80.82	81.08	4477100.0
2023-05-15	A	Stock	127.94	128.19	126.75	127.99	1262800.0
2023-05-15	AA	Stock	35.505	37.08	35.37	36.99	3438900.0
2023-05-15	AAC-DELISTED	Stock	10.47	10.47	10.44	10.46	24536.0
2023-05-15	AACG	Stock	1.56	1.61	1.52	1.52	10300.0
2023-05-15	AACIW-DELISTED	Stock	0.11	0.11	0.11	0.11	125.0
2023-05-15	AAIC-DELISTED	Stock	2.57	2.5747	2.54	2.55	56500.0
2023-05-15	AAIC.C-DELISTED	Stock	21.2	21.925	21.1999	21.48	1120.0
2023-05-15	AAL	Stock	14.04	14.32	13.92	14.28	14994100.0
2023-05-15	AAM.A-DELISTED	Stock	24.09	24.09	23.08	23.08	3681.0
2023-05-15	AAM.B-DELISTED	Stock	23.145	23.26	23.0	23.08	25369.0
2023-05-15	AAMC-DELISTED	Stock	22.6794	23.6029	22.3382	23.0853	53645.0
2023-05-15	AAME	Stock	2.25	2.25	2.22	2.25	4700.0
2023-05-15	AAMI	Stock	21.79	21.96	21.56	21.6	54400.0
2023-05-15	AAN-DELISTED	Stock	12.47	12.65	12.395	12.62	162100.0
2023-05-15	AAOI	Stock	1.68	1.71	1.64	1.64	98300.0
2023-05-15	AAON	Stock	63.2267	63.8867	62.6	62.9867	422100.0
2023-05-15	AAP	Stock	122.73	122.73	120.5	121.95	970700.0
2023-05-15	AAT	Stock	18.96	19.12	18.75	18.94	475200.0
2023-05-15	AATC	Stock	3.95	4.07	3.95	4.07	5044.0
2023-05-15	AAU-DELISTED	Stock	0.1105	0.1135	0.107	0.1127	208860.0
2023-05-15	AAUAF-DELISTED	Stock	0.1105	0.1135	0.107	0.1127	212279.0
2023-05-15	AAXJ	Stock	65.94	66.72	65.92	66.72	1110303.0
2023-05-15	AB	Stock	34.16	34.69	33.91	34.07	210900.0
2023-05-15	ABB-DELISTED	Stock	36.77	37.1055	36.7	37.06	1084535.0
2023-05-15	ABBNY-DELISTED	Stock	36.77	37.1055	36.7	37.05	1226108.0
2023-05-15	ABBV	Stock	147.67	148.9	145.66	146.59	4391800.0
2023-05-15	ABC-DELISTED	Stock	170.95	173.585	170.59	173.34	1287898.0
2023-05-15	ABCB	Stock	29.15	30.49	28.96	30.19	478500.0
2023-05-15	ABCL	Stock	5.77	6.01	5.745	5.98	2408200.0
2023-05-15	ABCM-DELISTED	Stock	17.25	17.68	17.25	17.46	467328.0
2023-05-15	ABEO	Stock	2.99	3.1	2.98	3.08	38800.0
2023-05-15	ABEV	Stock	2.94	2.97	2.92	2.96	9221100.0
2023-05-15	ABG	Stock	199.91	204.47	196.41	202.06	249900.0
2023-05-15	ABM	Stock	43.4	43.78	43.12	43.51	201900.0
2023-05-15	ABNB	Stock	105.06	106.15	103.55	105.78	5422500.0
2023-05-15	ABOS	Stock	5.54	6.2	5.15	6.2	256900.0
2023-05-15	ABR	Stock	12.53	12.86	12.5	12.78	3785000.0
2023-05-15	ABR.D	Stock	17.5	17.7399	17.3101	17.34	18831.0
2023-05-15	ABR.E	Stock	17.27	17.27	17.22	17.23	1128.0
2023-05-15	ABR.F	Stock	17.9	18.0999	17.9	18.01	4375.0

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

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