PREVIEW / stock_daily / 2023-07-03

all stock daily files

  file:    by_date/stock_daily/2023/2023-07-03.parquet
  size:    234 KB
  rows:    7,318
  symbols: 1,474

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-07-03	AAPL	Stock	193.78	193.88	191.76	192.46	31458200.0
2023-07-03	MSFT	Stock	339.19	340.9	336.57	337.99	12508700.0
2023-07-03	NVDA	Stock	42.517	42.898	42.202	42.413	198209000.0
2023-07-03	AMZN	Stock	130.82	131.85	130.07	130.22	28264800.0
2023-07-03	GOOGL	Stock	119.24	120.19	118.8182	119.9	14467850.0
2023-07-03	META	Stock	286.7	289.4	284.85	286.02	8629300.0
2023-07-03	TSLA	Stock	276.49	284.25	275.11	279.82	119685900.0
2023-07-03	TLT	Stock	102.84	103.255	102.06	102.08	16011810.0
2023-07-03	ES	Stock	70.55	71.49	70.41	71.05	1027700.0
2023-07-03	CL	Stock	76.65	77.44	76.52	77.14	2092200.0
2023-07-03	A	Stock	120.02	120.85	119.22	119.32	996200.0
2023-07-03	AA	Stock	34.5	34.93	34.14	34.27	2460900.0
2023-07-03	AAC-DELISTED	Stock	10.56	10.57	10.56	10.56	64086.0
2023-07-03	AACG	Stock	1.41	1.48	1.41	1.41	2200.0
2023-07-03	AACT	Stock	10.16	10.16	10.15	10.15	2100.0
2023-07-03	AAIC-DELISTED	Stock	4.58	4.6127	4.51	4.54	164600.0
2023-07-03	AAIC.C-DELISTED	Stock	22.84	23.0	22.84	23.0	4220.0
2023-07-03	AAL	Stock	17.86	18.18	17.82	18.1	12883700.0
2023-07-03	AAM.A-DELISTED	Stock	23.39	23.45	23.17	23.45	2333.0
2023-07-03	AAM.B-DELISTED	Stock	23.24	23.24	23.0	23.0	1400.0
2023-07-03	AAMC-DELISTED	Stock	32.6471	33.2294	30.2176	30.2176	26010.0
2023-07-03	AAME	Stock	2.02	2.02	1.93	1.93	1000.0
2023-07-03	AAMI	Stock	20.83	21.15	20.83	20.98	60100.0
2023-07-03	AAN-DELISTED	Stock	14.02	14.57	14.02	14.56	123800.0
2023-07-03	AAOI	Stock	6.255	6.63	5.71	6.07	2705600.0
2023-07-03	AAON	Stock	62.88	64.14	62.7	63.88	130350.0
2023-07-03	AAP	Stock	70.23	71.64	69.86	70.95	1234700.0
2023-07-03	AAT	Stock	19.1	19.78	19.1	19.68	226100.0
2023-07-03	AATC	Stock	4.44	4.44	4.43	4.43	12870.0
2023-07-03	AAU-DELISTED	Stock	0.13	0.1325	0.1259	0.1259	63391.0
2023-07-03	AAUAF-DELISTED	Stock	0.13	0.13	0.128	0.1281	65273.0
2023-07-03	AAXJ	Stock	67.22	67.575	67.14	67.23	280391.0
2023-07-03	AB	Stock	32.03	32.74	31.98	32.64	160600.0
2023-07-03	ABBNY-DELISTED	Stock	38.65	38.71	38.45	38.61	94514.0
2023-07-03	ABBV	Stock	134.0	135.43	133.15	135.01	2674600.0
2023-07-03	ABC-DELISTED	Stock	191.29	191.29	189.17	190.92	485408.0
2023-07-03	ABCB	Stock	34.25	35.41	34.25	35.0	138700.0
2023-07-03	ABCL	Stock	6.46	6.68	6.43	6.59	1126200.0
2023-07-03	ABCM-DELISTED	Stock	24.46	24.76	23.975	24.2	850506.0
2023-07-03	ABEO	Stock	4.12	4.7	4.04	4.31	297200.0
2023-07-03	ABEV	Stock	3.18	3.2	3.17	3.18	4319900.0
2023-07-03	ABG	Stock	238.56	245.52	236.59	239.09	103000.0
2023-07-03	ABM	Stock	42.29	42.93	42.29	42.57	176800.0
2023-07-03	ABNB	Stock	129.28	134.27	129.23	132.35	5001800.0
2023-07-03	ABOS	Stock	4.9	5.113	4.7	4.96	123300.0
2023-07-03	ABR	Stock	14.95	15.05	14.78	15.05	1918700.0
2023-07-03	ABR.D	Stock	18.39	18.55	18.31	18.55	15464.0
2023-07-03	ABR.E	Stock	18.15	18.19	18.08	18.15	6639.0
2023-07-03	ABR.F	Stock	20.6	20.62	20.1142	20.41	15592.0
2023-07-03	ABSI	Stock	1.51	1.57	1.51	1.53	287400.0

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

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