PREVIEW / stock_daily / 2023-06-01

all stock daily files

  file:    by_date/stock_daily/2023/2023-06-01.parquet
  size:    242 KB
  rows:    7,524
  symbols: 1,626

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-01	AAPL	Stock	177.7	180.12	176.93	180.09	68901800.0
2023-06-01	MSFT	Stock	325.93	333.53	324.72	332.58	26773900.0
2023-06-01	NVDA	Stock	38.489	40.05	38.34	39.77	635873000.0
2023-06-01	AMZN	Stock	120.69	123.49	119.93	122.77	54375100.0
2023-06-01	GOOGL	Stock	122.815	124.42	122.62	123.72	30772683.0
2023-06-01	META	Stock	265.9	274.0	265.89	272.61	25609500.0
2023-06-01	TSLA	Stock	202.59	209.8	199.37	207.52	148029900.0
2023-06-01	TLT	Stock	103.28	103.63	102.63	103.12	21040382.0
2023-06-01	ES	Stock	69.44	69.46	68.19	68.83	2355100.0
2023-06-01	CL	Stock	74.91	75.27	74.64	74.9	4704100.0
2023-06-01	A	Stock	116.97	117.64	115.0	116.26	3966100.0
2023-06-01	AA	Stock	32.0	33.04	31.52	32.7	4830600.0
2023-06-01	AAC-DELISTED	Stock	10.5	10.5	10.48	10.49	60798.0
2023-06-01	AACG	Stock	1.54	1.55	1.5	1.5	4300.0
2023-06-01	AACIW-DELISTED	Stock	0.061	0.0899	0.061	0.0859	871.0
2023-06-01	AAIC-DELISTED	Stock	4.06	4.17	4.06	4.14	1158493.0
2023-06-01	AAIC.C-DELISTED	Stock	22.7176	22.7176	22.3	22.4793	2653.0
2023-06-01	AAL	Stock	14.87	14.88	14.61	14.7	21239100.0
2023-06-01	AAM.A-DELISTED	Stock	23.46	24.03	23.46	23.67	10135.0
2023-06-01	AAM.B-DELISTED	Stock	23.9	23.9	22.9	23.7459	8196.0
2023-06-01	AAMC-DELISTED	Stock	29.7118	29.7118	27.286	27.8235	43041.0
2023-06-01	AAME	Stock	2.13	2.14	2.12	2.14	1500.0
2023-06-01	AAMI	Stock	21.6	22.68	21.33	22.31	225600.0
2023-06-01	AAN-DELISTED	Stock	12.26	12.415	12.073	12.25	202600.0
2023-06-01	AAOI	Stock	2.19	2.25	2.08	2.21	239300.0
2023-06-01	AAON	Stock	57.68	58.9267	57.0667	58.4467	686100.0
2023-06-01	AAP	Stock	71.77	71.96	67.8	68.03	9523500.0
2023-06-01	AAT	Stock	19.13	19.13	18.64	18.82	326600.0
2023-06-01	AATC	Stock	4.17	4.33	4.17	4.3	2493.0
2023-06-01	AAU-DELISTED	Stock	0.12	0.1223	0.12	0.1201	115554.0
2023-06-01	AAUAF-DELISTED	Stock	0.12	0.1223	0.12	0.1201	121476.0
2023-06-01	AAXJ	Stock	64.75	65.86	64.75	65.83	686460.0
2023-06-01	AB	Stock	34.77	35.35	34.7	35.21	145100.0
2023-06-01	ABBNY-DELISTED	Stock	36.78	37.0	36.73	36.89	832838.0
2023-06-01	ABBV	Stock	135.26	135.26	131.1	133.44	11895600.0
2023-06-01	ABC-DELISTED	Stock	170.57	173.27	170.18	172.6	1026198.0
2023-06-01	ABCB	Stock	31.82	33.07	31.37	32.49	424400.0
2023-06-01	ABCL	Stock	6.98	6.99	6.69	6.79	2102000.0
2023-06-01	ABCM-DELISTED	Stock	16.11	16.51	15.7	16.27	2156557.0
2023-06-01	ABEO	Stock	3.08	3.11	3.0	3.06	49200.0
2023-06-01	ABEV	Stock	2.81	2.84	2.79	2.82	14191300.0
2023-06-01	ABG	Stock	208.62	208.69	204.88	204.89	189600.0
2023-06-01	ABM	Stock	43.9	44.51	43.59	44.13	276200.0
2023-06-01	ABNB	Stock	109.84	113.54	109.11	112.16	6644100.0
2023-06-01	ABOS	Stock	4.94	5.25	4.81	5.0	151300.0
2023-06-01	ABR	Stock	12.63	12.88	12.55	12.85	2071200.0
2023-06-01	ABR.D	Stock	18.05	18.3117	17.91	17.91	21876.0
2023-06-01	ABR.E	Stock	17.67	17.99	17.43	17.75	19882.0
2023-06-01	ABR.F	Stock	18.61	18.82	18.42	18.64	40920.0
2023-06-01	ABSI	Stock	1.92	1.92	1.83	1.84	536700.0

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

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