PREVIEW / stock_daily / 2023-06-16

all stock daily files

  file:    by_date/stock_daily/2023/2023-06-16.parquet
  size:    243 KB
  rows:    7,481
  symbols: 1,569

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-06-16	AAPL	Stock	186.73	186.99	184.27	184.92	101235600.0
2023-06-16	MSFT	Stock	351.32	351.47	341.95	342.33	46533600.0
2023-06-16	NVDA	Stock	43.45	43.721	42.661	42.692	655709000.0
2023-06-16	AMZN	Stock	127.71	127.9	125.3	125.49	84188100.0
2023-06-16	GOOGL	Stock	125.93	126.108	123.28	123.53	45535553.0
2023-06-16	META	Stock	284.75	287.85	280.13	281.0	43102500.0
2023-06-16	TSLA	Stock	258.92	263.6	257.21	260.54	167563700.0
2023-06-16	TLT	Stock	102.44	102.8269	102.03	102.6	16759084.0
2023-06-16	ES	Stock	71.33	72.34	71.33	72.08	4269900.0
2023-06-16	CL	Stock	77.09	78.04	77.09	77.78	7368900.0
2023-06-16	A	Stock	122.1	123.18	120.63	121.13	3941300.0
2023-06-16	AA	Stock	35.97	36.04	34.79	35.62	5811700.0
2023-06-16	AAC-DELISTED	Stock	10.5	10.52	10.49	10.5	31585.0
2023-06-16	AACG	Stock	1.42	1.44	1.37	1.41	7500.0
2023-06-16	AACT	Stock	10.12	10.12	10.11	10.11	250958.0
2023-06-16	AAIC-DELISTED	Stock	4.44	4.46	4.16	4.23	1425360.0
2023-06-16	AAL	Stock	16.67	16.72	16.43	16.48	22635600.0
2023-06-16	AAM.A-DELISTED	Stock	22.77	23.34	21.84	21.96	143496.0
2023-06-16	AAM.B-DELISTED	Stock	22.43	23.0184	21.95	21.95	105377.0
2023-06-16	AAMC-DELISTED	Stock	18.5	18.9765	17.6588	17.9735	67670.0
2023-06-16	AAME	Stock	2.2	2.24	2.2	2.24	600.0
2023-06-16	AAMI	Stock	22.98	22.98	22.077	22.21	595800.0
2023-06-16	AAN-DELISTED	Stock	13.74	13.74	13.09	13.32	2026100.0
2023-06-16	AAOI	Stock	4.7	4.99	4.55	4.85	3897500.0
2023-06-16	AAON	Stock	63.1867	63.98	62.4733	63.8667	852750.0
2023-06-16	AAP	Stock	70.55	71.6	68.7	69.22	4971200.0
2023-06-16	AAT	Stock	19.92	19.92	19.52	19.7	763600.0
2023-06-16	AATC	Stock	4.29	4.29	4.25	4.29	2467.0
2023-06-16	AAU-DELISTED	Stock	0.129	0.1323	0.128	0.1286	165498.0
2023-06-16	AAUAF-DELISTED	Stock	0.129	0.1323	0.128	0.1286	158370.0
2023-06-16	AAXJ	Stock	69.18	69.22	68.76	68.96	530153.0
2023-06-16	AB	Stock	34.2	34.22	33.32	33.46	309200.0
2023-06-16	ABBNY-DELISTED	Stock	39.77	39.77	39.46	39.46	226001.0
2023-06-16	ABBV	Stock	136.7	138.92	136.49	138.64	14615000.0
2023-06-16	ABC-DELISTED	Stock	181.2	183.435	180.525	183.01	1551902.0
2023-06-16	ABCB	Stock	35.7	35.7	34.71	35.32	1023200.0
2023-06-16	ABCL	Stock	7.59	7.593	7.405	7.58	3995500.0
2023-06-16	ABCM-DELISTED	Stock	20.07	22.54	19.72	22.34	4277162.0
2023-06-16	ABEO	Stock	4.49	4.53	4.24	4.5	215200.0
2023-06-16	ABEV	Stock	3.09	3.15	3.08	3.09	20356900.0
2023-06-16	ABG	Stock	230.2	230.2	219.38	221.79	791600.0
2023-06-16	ABM	Stock	42.96	43.05	42.09	42.35	1041600.0
2023-06-16	ABNB	Stock	128.68	129.2	126.79	128.68	6892400.0
2023-06-16	ABOS	Stock	5.64	5.97	5.42	5.84	129800.0
2023-06-16	ABR	Stock	14.27	14.3	13.84	13.87	3951300.0
2023-06-16	ABR.D	Stock	18.07	18.2499	18.03	18.085	9966.0
2023-06-16	ABR.E	Stock	18.01	18.01	17.81	17.98	2152.0
2023-06-16	ABR.F	Stock	19.12	19.12	18.995	19.12	4348.0
2023-06-16	ABSI	Stock	1.76	1.77	1.71	1.75	766300.0
2023-06-16	ABST-DELISTED	Stock	11.35	11.39	11.33	11.36	1320006.0

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

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