PREVIEW / stock_daily / 2023-06-26

all stock daily files

  file:    by_date/stock_daily/2023/2023-06-26.parquet
  size:    241 KB
  rows:    7,506
  symbols: 1,594

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-26	AAPL	Stock	186.83	188.05	185.23	185.27	48088700.0
2023-06-26	MSFT	Stock	333.72	336.11	328.49	328.6	21520600.0
2023-06-26	NVDA	Stock	42.461	42.764	40.1	40.632	594322000.0
2023-06-26	AMZN	Stock	129.33	131.49	127.1	127.33	59989300.0
2023-06-26	GOOGL	Stock	120.76	122.0	118.265	118.34	33969897.0
2023-06-26	META	Stock	288.7	289.79	277.6	278.47	24232700.0
2023-06-26	TSLA	Stock	250.07	258.37	240.7	241.05	179990600.0
2023-06-26	TLT	Stock	103.62	103.8	103.16	103.44	12894937.0
2023-06-26	ES	Stock	70.05	70.93	69.69	70.82	1475600.0
2023-06-26	CL	Stock	76.65	76.91	75.61	76.64	4236600.0
2023-06-26	A	Stock	118.96	119.8	117.34	118.37	1673400.0
2023-06-26	AA	Stock	32.78	33.53	32.78	32.99	3311300.0
2023-06-26	AAC-DELISTED	Stock	10.51	10.52	10.51	10.52	8721.0
2023-06-26	AACG	Stock	1.35	1.39	1.35	1.37	3000.0
2023-06-26	AACIW-DELISTED	Stock	0.112	0.112	0.1022	0.1022	402.0
2023-06-26	AACT	Stock	10.14	10.1703	10.13	10.1401	15478.0
2023-06-26	AAIC-DELISTED	Stock	4.28	4.43	4.28	4.395	116063.0
2023-06-26	AAIC.C-DELISTED	Stock	22.76	22.76	22.72	22.72	500.0
2023-06-26	AAL	Stock	16.15	16.49	16.11	16.44	19715400.0
2023-06-26	AAM.A-DELISTED	Stock	22.71	23.08	22.71	22.86	6963.0
2023-06-26	AAM.B-DELISTED	Stock	22.41	22.99	22.41	22.67	9115.0
2023-06-26	AAMC-DELISTED	Stock	16.7118	17.1029	16.2735	16.2735	25208.0
2023-06-26	AAME	Stock	2.03	2.06	2.03	2.05	4100.0
2023-06-26	AAMI	Stock	20.34	20.745	20.3	20.31	126300.0
2023-06-26	AAN-DELISTED	Stock	12.55	12.83	12.55	12.78	147200.0
2023-06-26	AAOI	Stock	4.14	4.78	3.9	4.65	1823200.0
2023-06-26	AAON	Stock	63.3067	64.5467	63.1733	63.7267	252900.0
2023-06-26	AAP	Stock	65.99	67.34	65.95	67.29	1991100.0
2023-06-26	AAT	Stock	18.08	18.97	18.05	18.79	538600.0
2023-06-26	AATC	Stock	4.395	4.5	4.35	4.5	15729.0
2023-06-26	AAU-DELISTED	Stock	0.1286	0.13	0.128	0.128	97640.0
2023-06-26	AAUAF-DELISTED	Stock	0.1286	0.13	0.128	0.128	95611.0
2023-06-26	AAXJ	Stock	66.35	66.35	65.98	66.01	249504.0
2023-06-26	AB	Stock	31.6	32.26	31.6	31.94	213900.0
2023-06-26	ABBNY-DELISTED	Stock	38.31	38.55	38.18	38.39	177227.0
2023-06-26	ABBV	Stock	136.15	136.15	133.69	134.95	6468100.0
2023-06-26	ABC-DELISTED	Stock	187.4	188.28	186.44	187.82	865065.0
2023-06-26	ABCB	Stock	33.45	34.29	33.45	33.95	498200.0
2023-06-26	ABCL	Stock	7.28	7.345	6.9	6.91	3184400.0
2023-06-26	ABCM-DELISTED	Stock	22.5	23.75	22.45	22.5	2796287.0
2023-06-26	ABEO	Stock	4.88	4.97	4.56	4.75	129700.0
2023-06-26	ABEV	Stock	3.22	3.22	3.15	3.19	12337100.0
2023-06-26	ABG	Stock	228.17	234.98	228.17	229.0	146700.0
2023-06-26	ABM	Stock	40.48	41.72	40.46	41.36	380800.0
2023-06-26	ABNB	Stock	122.9	126.7	122.8	123.13	3645800.0
2023-06-26	ABOS	Stock	5.44	5.44	4.755	4.85	178700.0
2023-06-26	ABR	Stock	13.6	14.18	13.36	13.94	4352200.0
2023-06-26	ABR.D	Stock	18.2	18.26	18.18	18.18	11586.0
2023-06-26	ABR.F	Stock	19.16	19.24	19.14	19.21	10217.0
2023-06-26	ABSI	Stock	1.84	1.93	1.7	1.7	811200.0

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

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