PREVIEW / stock_daily / 2023-10-03

all stock daily files

  file:    by_date/stock_daily/2023/2023-10-03.parquet
  size:    236 KB
  rows:    7,402
  symbols: 1,394

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-10-03	AAPL	Stock	172.26	173.63	170.82	172.4	49594600.0
2023-10-03	MSFT	Stock	320.83	321.39	311.21	313.39	21033500.0
2023-10-03	NVDA	Stock	44.808	45.13	43.246	43.517	470850000.0
2023-10-03	AMZN	Stock	128.06	128.52	124.25	124.72	51565000.0
2023-10-03	GOOGL	Stock	133.94	134.26	131.84	132.43	22989401.0
2023-10-03	META	Stock	304.26	306.77	299.64	300.94	17362300.0
2023-10-03	TSLA	Stock	248.61	250.02	244.45	246.53	101985300.0
2023-10-03	TLT	Stock	86.31	86.65	84.885	85.06	71362641.0
2023-10-03	ES	Stock	55.19	56.27	54.21	56.05	3123800.0
2023-10-03	CL	Stock	70.84	71.14	70.36	70.47	3174300.0
2023-10-03	A	Stock	110.23	111.76	110.05	110.26	1543400.0
2023-10-03	AA	Stock	28.11	28.85	27.27	27.65	5457900.0
2023-10-03	AAC-DELISTED	Stock	10.76	10.76	10.74	10.74	8176.0
2023-10-03	AACG	Stock	1.14	1.14	1.12	1.13	4900.0
2023-10-03	AACT	Stock	10.28	10.28	10.27	10.27	11700.0
2023-10-03	AAIC-DELISTED	Stock	4.2	4.2	4.0928	4.17	84142.0
2023-10-03	AAIC.C-DELISTED	Stock	24.21	24.21	23.38	23.6	5295.0
2023-10-03	AAL	Stock	12.65	12.71	12.25	12.29	40692300.0
2023-10-03	AAMC-DELISTED	Stock	3.9353	3.9706	3.8471	3.9353	15640.0
2023-10-03	AAME	Stock	1.78	1.88	1.78	1.88	500.0
2023-10-03	AAMI	Stock	19.05	19.05	18.4	18.54	110600.0
2023-10-03	AAN-DELISTED	Stock	10.0	10.0	9.72	9.83	287500.0
2023-10-03	AAOI	Stock	11.06	11.32	9.95	10.32	2155900.0
2023-10-03	AAON	Stock	56.47	56.94	55.0	55.45	192500.0
2023-10-03	AAP	Stock	53.58	54.46	52.92	53.4	2390800.0
2023-10-03	AAT	Stock	18.85	18.88	17.94	18.12	481800.0
2023-10-03	AATC	Stock	5.7	5.7	5.62	5.62	4414.0
2023-10-03	AAU-DELISTED	Stock	0.138	0.138	0.135	0.1358	196705.0
2023-10-03	AAUAF-DELISTED	Stock	0.138	0.138	0.135	0.1358	201041.0
2023-10-03	AAXJ	Stock	62.57	62.84	62.36	62.49	2828949.0
2023-10-03	AB	Stock	30.68	30.72	30.03	30.13	366100.0
2023-10-03	ABAT	Stock	7.9	8.0504	7.4101	7.44	135380.0
2023-10-03	ABBNY-DELISTED	Stock	35.3901	35.6625	35.25	35.35	176343.0
2023-10-03	ABBV	Stock	147.83	147.99	145.35	147.43	4580900.0
2023-10-03	ABCB	Stock	37.43	37.72	36.74	36.98	258600.0
2023-10-03	ABCL	Stock	4.44	4.5	4.34	4.38	1781700.0
2023-10-03	ABCM-DELISTED	Stock	22.62	22.69	22.62	22.68	2865468.0
2023-10-03	ABEO	Stock	4.02	4.3	3.93	4.25	119800.0
2023-10-03	ABEV	Stock	2.56	2.59	2.5	2.5	12136800.0
2023-10-03	ABG	Stock	217.73	218.86	213.84	214.07	111300.0
2023-10-03	ABLLW	Stock	0.35	0.3995	0.35	0.36	52766.0
2023-10-03	ABLV	Stock	3.36	3.38	3.34	3.38	9000.0
2023-10-03	ABM	Stock	39.85	39.93	39.34	39.37	511900.0
2023-10-03	ABNB	Stock	132.17	133.41	126.49	127.73	9019700.0
2023-10-03	ABOS	Stock	4.13	4.215	4.03	4.2	351500.0
2023-10-03	ABR	Stock	14.26	14.39	13.67	13.85	7042900.0
2023-10-03	ABR.D	Stock	17.45	17.675	17.07	17.4	25566.0
2023-10-03	ABR.E	Stock	17.4	17.4	16.95	17.03	16741.0
2023-10-03	ABR.F	Stock	18.2	18.35	17.7	18.11	40447.0
2023-10-03	ABSI	Stock	1.27	1.445	1.25	1.41	686900.0

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

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