PREVIEW / stock_daily / 2023-08-17

all stock daily files

  file:    by_date/stock_daily/2023/2023-08-17.parquet
  size:    238 KB
  rows:    7,406
  symbols: 1,450

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-17	AAPL	Stock	177.14	177.51	173.48	174.0	66062900.0
2023-08-17	MSFT	Stock	320.54	321.87	316.21	316.88	21257200.0
2023-08-17	NVDA	Stock	43.97	44.062	43.001	43.344	452395000.0
2023-08-17	AMZN	Stock	135.46	136.09	133.53	133.98	48354100.0
2023-08-17	GOOGL	Stock	129.8	131.99	129.29	129.92	33446280.0
2023-08-17	META	Stock	293.05	296.05	284.95	285.09	23950100.0
2023-08-17	TSLA	Stock	226.06	226.74	218.83	219.22	120718400.0
2023-08-17	TLT	Stock	93.5	93.605	93.02	93.44	32244852.0
2023-08-17	ES	Stock	64.39	65.22	64.27	64.38	1503600.0
2023-08-17	CL	Stock	74.44	74.86	73.95	74.0	2873100.0
2023-08-17	A	Stock	122.0	122.65	120.66	120.85	2180800.0
2023-08-17	AA	Stock	29.92	30.04	28.91	29.11	6527400.0
2023-08-17	AAC-DELISTED	Stock	10.65	10.65	10.64	10.65	46172.0
2023-08-17	AACG	Stock	1.24	1.3	1.21	1.27	8200.0
2023-08-17	AACIU	Stock	11.55	11.55	10.65	10.65	216.0
2023-08-17	AACT	Stock	10.23	10.24	10.2	10.2	600.0
2023-08-17	AAIC-DELISTED	Stock	4.42	4.46	4.39	4.4	34909.0
2023-08-17	AAL	Stock	15.44	15.46	15.01	15.05	22240800.0
2023-08-17	AAM.A-DELISTED	Stock	25.17	25.26	25.17	25.22	48377.0
2023-08-17	AAM.B-DELISTED	Stock	25.2	25.24	25.18	25.22	46099.0
2023-08-17	AAMC-DELISTED	Stock	5.7765	6.0176	5.7412	5.9	84830.0
2023-08-17	AAME	Stock	1.86	2.02	1.8	1.87	6400.0
2023-08-17	AAMI	Stock	19.88	20.67	19.86	20.63	212400.0
2023-08-17	AAN-DELISTED	Stock	12.68	12.75	12.38	12.42	155800.0
2023-08-17	AAOI	Stock	13.18	13.838	12.31	12.93	2930200.0
2023-08-17	AAON	Stock	62.92	63.49	60.82	60.82	404100.0
2023-08-17	AAP	Stock	70.25	70.93	69.39	69.46	1459200.0
2023-08-17	AAT	Stock	20.94	21.17	20.83	20.85	191700.0
2023-08-17	AATC	Stock	5.48	5.71	5.48	5.65	11755.0
2023-08-17	AAU-DELISTED	Stock	0.12	0.124	0.1181	0.1202	218990.0
2023-08-17	AAUAF-DELISTED	Stock	0.12	0.124	0.1181	0.1202	220308.0
2023-08-17	AAXJ	Stock	65.19	65.326	64.61	64.68	1401366.0
2023-08-17	AB	Stock	29.89	30.56	29.76	30.11	394000.0
2023-08-17	ABBNY-DELISTED	Stock	37.2	37.24	36.645	36.73	1095699.0
2023-08-17	ABBV	Stock	151.16	151.91	149.92	150.02	5285700.0
2023-08-17	ABC-DELISTED	Stock	183.15	184.22	179.105	180.0	1577538.0
2023-08-17	ABCB	Stock	41.43	41.76	40.85	41.23	264000.0
2023-08-17	ABCL	Stock	5.54	5.63	5.485	5.5	2502400.0
2023-08-17	ABCM-DELISTED	Stock	21.66	22.08	21.51	21.59	1059726.0
2023-08-17	ABEO	Stock	3.73	3.73	3.45	3.54	110800.0
2023-08-17	ABEV	Stock	2.85	2.87	2.8	2.83	16876600.0
2023-08-17	ABG	Stock	220.25	222.99	218.47	218.61	123200.0
2023-08-17	ABLLW	Stock	0.28	0.29	0.28	0.285	11581.0
2023-08-17	ABLV	Stock	8.69	8.69	5.18	5.85	436495.0
2023-08-17	ABM	Stock	45.15	45.39	44.65	44.89	403400.0
2023-08-17	ABNB	Stock	129.22	129.6	127.371	127.99	3908500.0
2023-08-17	ABOS	Stock	6.72	6.72	6.3	6.4	861400.0
2023-08-17	ABR	Stock	15.45	15.49	15.02	15.03	3432900.0
2023-08-17	ABR.D	Stock	18.57	18.57	18.28	18.48	7439.0
2023-08-17	ABR.E	Stock	18.3	18.32	18.3	18.32	1407.0

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

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