PREVIEW / stock_daily / 2023-10-25

all stock daily files

  file:    by_date/stock_daily/2023/2023-10-25.parquet
  size:    233 KB
  rows:    7,341
  symbols: 1,344

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-25	AAPL	Stock	171.88	173.06	170.65	171.1	57157000.0
2023-10-25	MSFT	Stock	345.02	346.2	337.62	340.67	55053800.0
2023-10-25	NVDA	Stock	43.398	43.65	41.555	41.779	398379000.0
2023-10-25	AMZN	Stock	126.04	126.34	120.79	121.39	74577500.0
2023-10-25	GOOGL	Stock	128.16	128.31	125.07	125.61	84366208.0
2023-10-25	META	Stock	310.0	310.88	298.84	299.53	42192500.0
2023-10-25	TSLA	Stock	215.88	220.1	212.2	212.42	107065100.0
2023-10-25	TLT	Stock	84.02	84.13	83.13	83.45	60737170.0
2023-10-25	ES	Stock	53.22	54.36	53.16	54.22	2372200.0
2023-10-25	CL	Stock	72.83	73.46	72.58	73.41	5355300.0
2023-10-25	A	Stock	102.9	104.17	100.08	103.4	2699600.0
2023-10-25	AA	Stock	23.335	24.03	23.14	23.84	5510200.0
2023-10-25	AAC-DELISTED	Stock	10.78	10.78	10.75	10.77	59065.0
2023-10-25	AACG	Stock	1.02	1.07	1.02	1.02	2200.0
2023-10-25	AACIW-DELISTED	Stock	0.064	0.0869	0.0639	0.0869	1100.0
2023-10-25	AACT	Stock	10.29	10.3	10.29	10.29	1200.0
2023-10-25	AAIC-DELISTED	Stock	4.2	4.2	4.05	4.06	142901.0
2023-10-25	AAIC.C-DELISTED	Stock	23.7451	23.98	23.7451	23.98	6217.0
2023-10-25	AAL	Stock	11.12	11.24	11.04	11.04	40461800.0
2023-10-25	AAMC-DELISTED	Stock	3.7376	3.8118	3.7353	3.7765	6290.0
2023-10-25	AAME	Stock	1.87	1.87	1.75	1.8	11800.0
2023-10-25	AAMI	Stock	15.99	16.08	15.72	15.78	82100.0
2023-10-25	AAN-DELISTED	Stock	7.03	7.29	7.01	7.28	800500.0
2023-10-25	AAOI	Stock	7.5	7.51	7.05	7.12	728200.0
2023-10-25	AAON	Stock	53.25	53.72	52.24	53.34	575000.0
2023-10-25	AAP	Stock	48.01	49.87	47.73	49.84	1889600.0
2023-10-25	AAT	Stock	17.39	17.68	17.24	17.5	367200.0
2023-10-25	AATC	Stock	5.725	5.725	5.7	5.7	7513.0
2023-10-25	AAU-DELISTED	Stock	0.14	0.1401	0.135	0.135	208214.0
2023-10-25	AAUAF-DELISTED	Stock	0.14	0.1401	0.135	0.135	192628.0
2023-10-25	AAXJ	Stock	61.89	62.08	61.58	61.67	729142.0
2023-10-25	AB	Stock	28.91	29.24	28.04	28.4	417500.0
2023-10-25	ABAT	Stock	5.73	5.75	4.6	4.64	484880.0
2023-10-25	ABBNY-DELISTED	Stock	33.11	33.35	33.02	33.02	175766.0
2023-10-25	ABBV	Stock	146.11	146.9	144.82	145.26	5461500.0
2023-10-25	ABCB	Stock	35.03	35.43	34.26	35.17	432400.0
2023-10-25	ABCL	Stock	4.39	4.39	4.06	4.06	1340400.0
2023-10-25	ABCM-DELISTED	Stock	22.93	22.965	22.855	22.86	4012728.0
2023-10-25	ABEO	Stock	3.95	4.13	3.84	3.84	263200.0
2023-10-25	ABEV	Stock	2.48	2.5	2.46	2.46	10474500.0
2023-10-25	ABG	Stock	183.49	185.71	178.4	184.92	221400.0
2023-10-25	ABLLW	Stock	0.3394	0.3395	0.26	0.33	104629.0
2023-10-25	ABLV	Stock	2.55	2.56	2.5	2.52	13400.0
2023-10-25	ABM	Stock	39.72	39.88	39.4	39.5	315700.0
2023-10-25	ABNB	Stock	120.75	120.75	118.32	118.5	4844500.0
2023-10-25	ABOS	Stock	3.41	3.416	3.25	3.285	283600.0
2023-10-25	ABR	Stock	13.6	13.77	13.01	13.01	7493200.0
2023-10-25	ABR.D	Stock	16.56	16.67	16.33	16.45	12183.0
2023-10-25	ABR.E	Stock	16.3101	16.4	16.3101	16.4	421.0
2023-10-25	ABR.F	Stock	17.56	17.72	17.56	17.56	6544.0

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

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