PREVIEW / stock_daily / 2023-09-18

all stock daily files

  file:    by_date/stock_daily/2023/2023-09-18.parquet
  size:    237 KB
  rows:    7,408
  symbols: 1,436

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-09-18	AAPL	Stock	176.48	179.38	176.17	177.97	67257600.0
2023-09-18	MSFT	Stock	327.8	330.4	326.36	329.06	16834200.0
2023-09-18	NVDA	Stock	42.748	44.242	42.0	43.966	500271000.0
2023-09-18	AMZN	Stock	140.48	141.75	139.22	139.98	42823500.0
2023-09-18	GOOGL	Stock	136.61	139.16	136.61	138.21	21861346.0
2023-09-18	META	Stock	298.19	303.6	297.8	302.55	14234200.0
2023-09-18	TSLA	Stock	271.16	271.44	263.76	265.28	101543300.0
2023-09-18	TLT	Stock	92.85	93.53	92.82	93.49	17963376.0
2023-09-18	ES	Stock	64.25	64.48	63.36	64.29	1852200.0
2023-09-18	CL	Stock	73.4	74.11	72.85	73.85	4042700.0
2023-09-18	A	Stock	115.0	115.0	112.66	112.69	1818000.0
2023-09-18	AA	Stock	29.19	29.24	28.485	28.85	4524800.0
2023-09-18	AAC-DELISTED	Stock	10.71	10.73	10.71	10.73	7752.0
2023-09-18	AACG	Stock	1.14	1.16	1.13	1.13	4300.0
2023-09-18	AACIW-DELISTED	Stock	0.0755	0.0755	0.0754	0.0754	200.0
2023-09-18	AACT	Stock	10.25	10.37	10.25	10.27	23000.0
2023-09-18	AAIC-DELISTED	Stock	4.59	4.62	4.5	4.5	224400.0
2023-09-18	AAL	Stock	13.24	13.27	13.08	13.11	21613900.0
2023-09-18	AAM.A-DELISTED	Stock	25.05	25.05	25.0	25.01	24255.0
2023-09-18	AAM.B-DELISTED	Stock	25.01	25.0599	25.0	25.0195	18445.0
2023-09-18	AAMC-DELISTED	Stock	4.0882	4.2353	4.0412	4.1471	55590.0
2023-09-18	AAME	Stock	2.0	2.0	1.92	1.94	5100.0
2023-09-18	AAMI	Stock	20.37	20.395	20.21	20.23	102800.0
2023-09-18	AAN-DELISTED	Stock	9.8	9.82	9.38	9.62	1059000.0
2023-09-18	AAOI	Stock	9.67	10.24	9.63	9.88	3166200.0
2023-09-18	AAON	Stock	61.0	61.93	60.34	60.87	431800.0
2023-09-18	AAP	Stock	59.48	59.48	57.52	58.16	2043500.0
2023-09-18	AAT	Stock	20.49	20.67	20.26	20.4	210700.0
2023-09-18	AATC	Stock	6.08	6.08	6.0	6.0	4085.0
2023-09-18	AAU-DELISTED	Stock	0.131	0.1386	0.1259	0.13	299846.0
2023-09-18	AAUAF-DELISTED	Stock	0.131	0.1386	0.126	0.13	301119.0
2023-09-18	AAXJ	Stock	65.13	65.445	65.08	65.43	223598.0
2023-09-18	AB	Stock	32.74	33.03	31.9	32.31	360200.0
2023-09-18	ABBNY-DELISTED	Stock	36.43	36.81	36.43	36.55	261080.0
2023-09-18	ABBV	Stock	153.08	153.97	152.1	153.94	2967600.0
2023-09-18	ABCB	Stock	39.47	39.67	38.72	38.84	361300.0
2023-09-18	ABCL	Stock	5.33	5.33	5.12	5.13	1464700.0
2023-09-18	ABCM-DELISTED	Stock	22.73	22.74	22.635	22.645	3721698.0
2023-09-18	ABEO	Stock	3.92	3.98	3.67	3.67	220900.0
2023-09-18	ABEV	Stock	2.73	2.75	2.72	2.73	13955900.0
2023-09-18	ABG	Stock	226.19	230.4	225.49	225.92	140600.0
2023-09-18	ABLLW	Stock	0.396	0.396	0.372	0.372	997.0
2023-09-18	ABLV	Stock	3.13	3.65	3.01	3.425	93700.0
2023-09-18	ABLVW	Stock	0.0599	0.0599	0.0599	0.0599	20100.0
2023-09-18	ABM	Stock	40.73	41.04	40.69	40.74	410700.0
2023-09-18	ABNB	Stock	141.93	144.4	141.19	142.55	7351400.0
2023-09-18	ABOS	Stock	5.45	5.455	5.102	5.12	389900.0
2023-09-18	ABR	Stock	16.03	16.04	15.74	15.76	2079000.0
2023-09-18	ABR.D	Stock	18.87	18.87	18.5	18.74	11700.0
2023-09-18	ABR.E	Stock	18.8238	18.8238	18.676	18.69	3688.0

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

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