PREVIEW / stock_daily / 2023-05-08

all stock daily files

  file:    by_date/stock_daily/2023/2023-05-08.parquet
  size:    241 KB
  rows:    7,513
  symbols: 1,634

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-08	AAPL	Stock	172.48	173.85	172.11	173.5	55962800.0
2023-05-08	MSFT	Stock	310.13	310.2	306.09	308.65	21318600.0
2023-05-08	NVDA	Stock	28.522	29.22	28.35	29.151	344979000.0
2023-05-08	AMZN	Stock	105.04	106.1	104.7	105.83	49430900.0
2023-05-08	GOOGL	Stock	105.18	107.96	105.16	107.77	26511445.0
2023-05-08	META	Stock	231.42	235.62	230.27	233.27	16400500.0
2023-05-08	TSLA	Stock	173.72	173.8	169.19	171.79	112249400.0
2023-05-08	TLT	Stock	103.515	103.87	103.32	103.42	20587042.0
2023-05-08	ES	Stock	77.13	77.92	76.37	76.75	1364900.0
2023-05-08	CL	Stock	80.49	80.97	80.17	80.75	6564700.0
2023-05-08	A	Stock	134.01	134.21	131.75	132.45	1005300.0
2023-05-08	AA	Stock	37.96	38.2	36.69	36.82	3750400.0
2023-05-08	AAC-DELISTED	Stock	10.39	10.39	10.38	10.39	198271.0
2023-05-08	AACG	Stock	1.76	1.82	1.76	1.82	8600.0
2023-05-08	AAIC-DELISTED	Stock	2.58	2.61	2.55	2.59	33251.0
2023-05-08	AAIC.C-DELISTED	Stock	21.48	22.46	21.48	22.46	1021.0
2023-05-08	AAL	Stock	14.34	14.66	14.23	14.36	34586900.0
2023-05-08	AAM.A-DELISTED	Stock	24.52	24.75	24.23	24.35	10106.0
2023-05-08	AAM.B-DELISTED	Stock	24.28	24.93	23.5	24.93	8650.0
2023-05-08	AAMC-DELISTED	Stock	25.2353	26.0294	24.7792	25.55	31426.0
2023-05-08	AAME	Stock	2.24	2.27	2.15	2.22	8200.0
2023-05-08	AAMI	Stock	22.7	22.86	22.13	22.41	90800.0
2023-05-08	AAN-DELISTED	Stock	12.36	12.39	12.19	12.35	176200.0
2023-05-08	AAOI	Stock	1.76	1.84	1.74	1.77	223000.0
2023-05-08	AAON	Stock	68.9933	69.3133	63.7333	64.6333	677550.0
2023-05-08	AAP	Stock	123.95	125.91	122.85	125.75	868500.0
2023-05-08	AAT	Stock	19.1	19.18	18.79	18.88	539900.0
2023-05-08	AATC	Stock	3.95	4.0	3.95	4.0	5026.0
2023-05-08	AAU-DELISTED	Stock	0.1281	0.1281	0.12	0.1222	333479.0
2023-05-08	AAUAF-DELISTED	Stock	0.1281	0.1281	0.12	0.1222	337319.0
2023-05-08	AAXJ	Stock	67.32	67.32	66.97	67.09	285638.0
2023-05-08	AB	Stock	33.79	34.66	33.6	34.41	264700.0
2023-05-08	ABB-DELISTED	Stock	36.22	36.405	36.045	36.13	926814.0
2023-05-08	ABBNY-DELISTED	Stock	36.22	36.405	36.045	36.14	1022105.0
2023-05-08	ABBV	Stock	148.15	148.2	146.74	147.45	3689500.0
2023-05-08	ABC-DELISTED	Stock	167.55	168.88	166.775	168.23	504759.0
2023-05-08	ABCB	Stock	31.08	31.49	29.55	29.58	388100.0
2023-05-08	ABCL	Stock	6.09	6.11	5.64	5.71	3258600.0
2023-05-08	ABCM-DELISTED	Stock	17.51	17.95	17.04	17.93	967592.0
2023-05-08	ABEO	Stock	3.32	3.34	3.07	3.13	103400.0
2023-05-08	ABEV	Stock	2.89	2.91	2.86	2.87	12173900.0
2023-05-08	ABG	Stock	198.0	204.76	196.49	201.88	265600.0
2023-05-08	ABLV	Stock	10.4	10.42	10.4	10.42	9111.0
2023-05-08	ABM	Stock	42.91	43.0	42.15	42.32	144000.0
2023-05-08	ABNB	Stock	123.16	127.555	122.98	125.65	10142900.0
2023-05-08	ABOS	Stock	5.31	5.31	4.39	4.85	503500.0
2023-05-08	ABR	Stock	12.1	12.5	11.92	12.21	11087500.0
2023-05-08	ABR.D	Stock	17.65	17.7364	17.535	17.7	21203.0
2023-05-08	ABR.E	Stock	17.36	17.77	17.3515	17.45	11686.0
2023-05-08	ABR.F	Stock	17.75	18.43	17.55	18.42	95402.0

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

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