PREVIEW / stock_daily / 2023-06-06

all stock daily files

  file:    by_date/stock_daily/2023/2023-06-06.parquet
  size:    241 KB
  rows:    7,482
  symbols: 1,595

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-06	AAPL	Stock	179.97	180.12	177.43	179.21	64848400.0
2023-06-06	MSFT	Stock	335.33	335.37	332.17	333.68	20396200.0
2023-06-06	NVDA	Stock	38.83	39.16	38.148	38.654	388729000.0
2023-06-06	AMZN	Stock	125.07	127.4	125.0	126.61	45695200.0
2023-06-06	GOOGL	Stock	126.01	128.29	125.36	127.31	26641095.0
2023-06-06	META	Stock	270.14	276.57	269.69	271.12	19419000.0
2023-06-06	TSLA	Stock	216.14	221.91	212.53	221.31	146911600.0
2023-06-06	TLT	Stock	101.84	102.47	101.39	102.4	14332121.0
2023-06-06	ES	Stock	70.97	71.05	69.79	70.0	2007700.0
2023-06-06	CL	Stock	76.36	76.53	75.29	75.57	5154500.0
2023-06-06	A	Stock	118.78	119.22	116.64	117.44	1758800.0
2023-06-06	AA	Stock	33.5	34.98	33.44	34.55	4132600.0
2023-06-06	AAC-DELISTED	Stock	10.5	10.5	10.49	10.5	434620.0
2023-06-06	AACG	Stock	1.45	1.46	1.4	1.4	12900.0
2023-06-06	AACIW-DELISTED	Stock	0.07	0.09	0.06	0.06	84274.0
2023-06-06	AAIC-DELISTED	Stock	4.13	4.27	4.13	4.2347	465557.0
2023-06-06	AAIC.C-DELISTED	Stock	22.6799	23.15	22.6799	22.9	2958.0
2023-06-06	AAL	Stock	14.81	15.02	14.7	14.93	15840000.0
2023-06-06	AAM.A-DELISTED	Stock	24.15	24.6	24.03	24.09	21178.0
2023-06-06	AAM.B-DELISTED	Stock	24.4606	24.85	24.44	24.5	2863.0
2023-06-06	AAMC-DELISTED	Stock	26.2353	26.9604	25.1529	26.5265	41983.0
2023-06-06	AAME	Stock	2.14	2.15	2.13	2.15	6900.0
2023-06-06	AAMI	Stock	22.06	22.57	22.06	22.41	300900.0
2023-06-06	AAN-DELISTED	Stock	12.98	14.03	12.98	13.96	260100.0
2023-06-06	AAOI	Stock	2.36	2.82	2.36	2.72	916000.0
2023-06-06	AAON	Stock	60.5467	62.4667	60.4667	62.0333	389850.0
2023-06-06	AAP	Stock	65.55	67.2	65.19	66.07	3296200.0
2023-06-06	AAT	Stock	19.33	19.98	19.28	19.75	466800.0
2023-06-06	AATC	Stock	4.35	4.35	4.2	4.33	4132.0
2023-06-06	AAU-DELISTED	Stock	0.12	0.1269	0.12	0.1258	163213.0
2023-06-06	AAUAF-DELISTED	Stock	0.12	0.1269	0.12	0.1243	166156.0
2023-06-06	AAXJ	Stock	66.64	67.475	66.62	67.36	559217.0
2023-06-06	AB	Stock	34.76	35.34	34.7	34.98	194700.0
2023-06-06	ABBNY-DELISTED	Stock	37.31	37.4	37.17	37.37	657526.0
2023-06-06	ABBV	Stock	137.47	137.54	134.63	135.43	4359900.0
2023-06-06	ABC-DELISTED	Stock	175.03	175.64	173.02	174.33	520151.0
2023-06-06	ABCB	Stock	33.5	36.21	32.05	35.64	650200.0
2023-06-06	ABCL	Stock	6.82	6.95	6.675	6.91	2521000.0
2023-06-06	ABCM-DELISTED	Stock	16.9	17.4	16.415	17.19	1434939.0
2023-06-06	ABEO	Stock	4.0	4.2	3.72	4.0	202900.0
2023-06-06	ABEV	Stock	2.89	3.0	2.89	2.98	22366400.0
2023-06-06	ABG	Stock	211.68	221.58	211.68	220.16	225300.0
2023-06-06	ABM	Stock	45.92	48.8	45.82	48.51	764500.0
2023-06-06	ABNB	Stock	115.92	119.09	115.41	117.3	5025700.0
2023-06-06	ABOS	Stock	4.95	5.305	4.95	5.2	73800.0
2023-06-06	ABR	Stock	13.55	14.08	13.47	13.91	2954200.0
2023-06-06	ABR.D	Stock	18.27	18.49	18.27	18.4	6751.0
2023-06-06	ABR.E	Stock	17.98	17.98	17.8	17.95	5453.0
2023-06-06	ABR.F	Stock	18.89	19.0	18.87	18.87	31227.0
2023-06-06	ABSI	Stock	1.8	1.835	1.7	1.78	650100.0

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

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