PREVIEW / stock_daily / 2023-04-24

all stock daily files

  file:    by_date/stock_daily/2023/2023-04-24.parquet
  size:    243 KB
  rows:    7,535
  symbols: 1,658

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-04-24	AAPL	Stock	165.0	165.6	163.89	165.33	41949600.0
2023-04-24	MSFT	Stock	282.09	284.95	278.72	281.77	26611000.0
2023-04-24	NVDA	Stock	27.013	27.366	26.671	27.042	339282000.0
2023-04-24	AMZN	Stock	107.66	109.23	105.07	106.21	69575600.0
2023-04-24	GOOGL	Stock	105.49	106.63	104.7	105.97	23542829.0
2023-04-24	META	Stock	213.68	213.92	210.71	212.79	15750900.0
2023-04-24	TSLA	Stock	164.65	165.65	158.61	162.55	140006600.0
2023-04-24	TLT	Stock	104.96	105.4875	104.84	105.41	17034309.0
2023-04-24	ES	Stock	78.96	79.46	78.36	79.34	847600.0
2023-04-24	CL	Stock	76.78	77.94	76.78	77.88	5350900.0
2023-04-24	A	Stock	138.8	139.52	138.09	138.48	856700.0
2023-04-24	AA	Stock	37.98	38.54	37.56	38.04	5027800.0
2023-04-24	AAC-DELISTED	Stock	10.37	10.37	10.35	10.36	33520.0
2023-04-24	AACG	Stock	1.85	1.91	1.84	1.91	5900.0
2023-04-24	AACIW-DELISTED	Stock	0.0805	0.101	0.0611	0.0738	17697.0
2023-04-24	AAIC-DELISTED	Stock	2.55	2.62	2.55	2.62	23547.0
2023-04-24	AAIC.C-DELISTED	Stock	21.3221	21.38	21.2112	21.2112	1188.0
2023-04-24	AAL	Stock	13.42	13.56	13.05	13.32	25019800.0
2023-04-24	AAM.A-DELISTED	Stock	24.3633	24.43	24.0	24.2	18359.0
2023-04-24	AAM.B-DELISTED	Stock	24.2889	24.5999	24.0238	24.5999	3400.0
2023-04-24	AAMC-DELISTED	Stock	23.8147	24.2529	23.8147	23.9706	21352.0
2023-04-24	AAME	Stock	2.25	2.31	2.24	2.29	2200.0
2023-04-24	AAMI	Stock	23.56	23.63	23.13	23.33	72600.0
2023-04-24	AAN-DELISTED	Stock	10.13	10.36	10.12	10.22	292100.0
2023-04-24	AAOI	Stock	2.12	2.16	2.04	2.15	166100.0
2023-04-24	AAON	Stock	66.3	67.2	64.8333	65.7467	424500.0
2023-04-24	AAP	Stock	127.73	128.0	125.91	126.83	816200.0
2023-04-24	AAT	Stock	17.96	18.08	17.63	17.85	273800.0
2023-04-24	AATC	Stock	4.04	4.08	3.98	4.04	7689.0
2023-04-24	AAU-DELISTED	Stock	0.16	0.1634	0.119	0.1289	2282541.0
2023-04-24	AAUAF-DELISTED	Stock	0.16	0.1634	0.119	0.1305	2274695.0
2023-04-24	AAXJ	Stock	66.55	66.67	66.2	66.38	523239.0
2023-04-24	AB	Stock	35.88	36.13	35.41	35.55	165400.0
2023-04-24	ABB-DELISTED	Stock	35.59	35.76	35.54	35.65	1051222.0
2023-04-24	ABBNY-DELISTED	Stock	35.59	35.76	35.54	35.64	1209630.0
2023-04-24	ABBV	Stock	162.57	164.36	162.33	164.08	4728900.0
2023-04-24	ABC-DELISTED	Stock	166.78	168.21	166.37	167.72	304021.0
2023-04-24	ABCB	Stock	33.89	34.4	33.6	33.77	276500.0
2023-04-24	ABCL	Stock	7.22	7.24	7.01	7.17	1572800.0
2023-04-24	ABCM-DELISTED	Stock	15.79	16.07	15.56	16.06	431589.0
2023-04-24	ABEO	Stock	3.28	3.44	3.13	3.39	329100.0
2023-04-24	ABEV	Stock	2.88	2.88	2.82	2.82	24349900.0
2023-04-24	ABG	Stock	203.19	209.03	203.19	206.87	331000.0
2023-04-24	ABLV	Stock	10.37	10.37	10.37	10.37	2603.0
2023-04-24	ABM	Stock	42.33	42.62	42.05	42.14	208500.0
2023-04-24	ABNB	Stock	115.53	116.4	114.51	116.12	3239500.0
2023-04-24	ABOS	Stock	3.96	4.015	3.61	3.78	75400.0
2023-04-24	ABR	Stock	10.43	10.57	10.1	10.49	6900800.0
2023-04-24	ABR.D	Stock	17.26	17.5316	17.25	17.52	13245.0
2023-04-24	ABR.E	Stock	17.35	17.525	17.27	17.4	17166.0

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

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