PREVIEW / stock_daily / 2023-05-24

all stock daily files

  file:    by_date/stock_daily/2023/2023-05-24.parquet
  size:    241 KB
  rows:    7,513
  symbols: 1,627

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-05-24	AAPL	Stock	171.09	172.42	170.52	171.84	45143500.0
2023-05-24	MSFT	Stock	314.73	316.5	312.61	313.85	23384900.0
2023-05-24	NVDA	Stock	30.21	30.607	29.806	30.538	721419000.0
2023-05-24	AMZN	Stock	115.35	117.34	115.02	116.75	63487900.0
2023-05-24	GOOGL	Stock	121.12	121.91	119.86	120.9	34182635.0
2023-05-24	META	Stock	245.28	249.59	244.95	249.21	17724300.0
2023-05-24	TSLA	Stock	182.23	184.22	178.22	182.9	137605100.0
2023-05-24	TLT	Stock	101.28	101.36	100.53	100.53	18473351.0
2023-05-24	ES	Stock	72.75	73.0	71.77	71.8	1871500.0
2023-05-24	CL	Stock	77.24	77.43	76.47	76.48	7584200.0
2023-05-24	A	Stock	115.2	121.09	113.28	120.99	6850400.0
2023-05-24	AA	Stock	35.26	35.36	34.205	34.35	3450700.0
2023-05-24	AAC-DELISTED	Stock	10.49	10.49	10.481	10.49	22242.0
2023-05-24	AACG	Stock	1.55	1.55	1.49	1.49	39400.0
2023-05-24	AACIW-DELISTED	Stock	0.0919	0.0919	0.0919	0.0919	180.0
2023-05-24	AAIC-DELISTED	Stock	2.75	2.7503	2.7	2.71	132453.0
2023-05-24	AAIC.C-DELISTED	Stock	21.2056	21.225	21.08	21.2	6127.0
2023-05-24	AAL	Stock	13.98	13.98	13.55	13.8	30501800.0
2023-05-24	AAM.A-DELISTED	Stock	23.59	24.16	23.59	23.92	10149.0
2023-05-24	AAM.B-DELISTED	Stock	24.02	24.81	23.88	24.6	9921.0
2023-05-24	AAMC-DELISTED	Stock	28.6765	28.6765	28.2353	28.3824	8031.0
2023-05-24	AAME	Stock	2.21	2.21	2.16	2.16	1600.0
2023-05-24	AAMI	Stock	22.35	22.35	21.72	21.75	87600.0
2023-05-24	AAN-DELISTED	Stock	12.77	12.8	12.37	12.64	176200.0
2023-05-24	AAOI	Stock	1.72	1.78	1.715	1.76	160400.0
2023-05-24	AAON	Stock	59.7	59.9933	58.2933	58.7133	334800.0
2023-05-24	AAP	Stock	117.51	117.51	114.96	115.23	866400.0
2023-05-24	AAT	Stock	19.51	19.62	18.99	19.1	480700.0
2023-05-24	AATC	Stock	4.4	4.515	4.4	4.515	19961.0
2023-05-24	AAU-DELISTED	Stock	0.13	0.13	0.1176	0.1216	413169.0
2023-05-24	AAUAF-DELISTED	Stock	0.13	0.13	0.1176	0.1216	416388.0
2023-05-24	AAXJ	Stock	65.39	65.46	65.0	65.05	588463.0
2023-05-24	AB	Stock	33.61	34.25	33.46	33.89	249800.0
2023-05-24	ABBNY-DELISTED	Stock	36.2	36.31	35.87	36.07	1217162.0
2023-05-24	ABBV	Stock	142.59	142.94	140.94	141.15	4143500.0
2023-05-24	ABC-DELISTED	Stock	171.51	172.14	170.67	171.07	834946.0
2023-05-24	ABCB	Stock	32.51	32.62	31.82	32.35	314400.0
2023-05-24	ABCL	Stock	7.05	7.16	6.75	7.02	2973300.0
2023-05-24	ABCM-DELISTED	Stock	16.34	16.94	16.055	16.795	687462.0
2023-05-24	ABEO	Stock	3.17	3.41	3.08	3.22	165000.0
2023-05-24	ABEV	Stock	2.92	2.96	2.91	2.94	14061500.0
2023-05-24	ABG	Stock	206.69	206.69	201.77	203.05	114000.0
2023-05-24	ABM	Stock	43.63	43.63	42.76	42.79	265100.0
2023-05-24	ABNB	Stock	105.46	106.59	103.82	105.71	5371700.0
2023-05-24	ABOS	Stock	5.17	5.453	5.05	5.25	127300.0
2023-05-24	ABR	Stock	12.45	12.49	12.16	12.22	3100100.0
2023-05-24	ABR.D	Stock	17.02	17.5214	17.02	17.52	16491.0
2023-05-24	ABR.E	Stock	16.7	16.895	16.7	16.89	3049.0
2023-05-24	ABR.F	Stock	18.1	18.25	17.8	17.98	21076.0
2023-05-24	ABSI	Stock	1.73	1.742	1.51	1.62	771200.0

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

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