PREVIEW / stock_daily / 2023-04-26

all stock daily files

  file:    by_date/stock_daily/2023/2023-04-26.parquet
  size:    242 KB
  rows:    7,555
  symbols: 1,693

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-26	AAPL	Stock	163.06	165.28	162.8	163.76	45498800.0
2023-04-26	MSFT	Stock	296.7	299.57	292.73	295.37	64599200.0
2023-04-26	NVDA	Stock	27.002	27.33	26.705	26.956	406337000.0
2023-04-26	AMZN	Stock	105.04	106.62	104.1	104.98	73803800.0
2023-04-26	GOOGL	Stock	104.92	106.35	102.63	103.71	53347560.0
2023-04-26	META	Stock	212.5	214.11	208.88	209.4	41992700.0
2023-04-26	TSLA	Stock	160.29	160.67	153.14	153.75	153364100.0
2023-04-26	TLT	Stock	106.79	107.24	105.67	105.82	19610403.0
2023-04-26	ES	Stock	78.83	79.43	77.46	77.51	1501500.0
2023-04-26	CL	Stock	77.16	77.65	76.61	76.68	4592000.0
2023-04-26	A	Stock	128.15	133.84	128.11	133.12	3003800.0
2023-04-26	AA	Stock	36.08	36.2	35.02	35.45	4799500.0
2023-04-26	AAC-DELISTED	Stock	10.36	10.38	10.36	10.375	47998.0
2023-04-26	AACG	Stock	1.84	1.87	1.8	1.83	4600.0
2023-04-26	AACIW-DELISTED	Stock	0.095	0.0984	0.0892	0.0892	747.0
2023-04-26	AAIC-DELISTED	Stock	2.6	2.63	2.5799	2.6	52482.0
2023-04-26	AAIC.C-DELISTED	Stock	21.26	21.26	21.059	21.059	4050.0
2023-04-26	AAL	Stock	12.9	13.08	12.65	12.74	33435200.0
2023-04-26	AAM.A-DELISTED	Stock	24.37	24.65	24.25	24.56	31762.0
2023-04-26	AAM.B-DELISTED	Stock	23.7361	24.69	23.7361	24.65	13752.0
2023-04-26	AAMC-DELISTED	Stock	24.0971	25.4706	23.7765	24.5471	42891.0
2023-04-26	AAME	Stock	2.22	2.25	2.19	2.22	9100.0
2023-04-26	AAMI	Stock	22.17	22.55	21.97	22.08	65100.0
2023-04-26	AAN-DELISTED	Stock	12.78	13.72	12.6	13.13	994200.0
2023-04-26	AAOI	Stock	2.01	2.07	2.01	2.06	64700.0
2023-04-26	AAON	Stock	64.62	64.64	62.4	62.6133	661200.0
2023-04-26	AAP	Stock	122.9	124.41	121.71	122.33	1170700.0
2023-04-26	AAT	Stock	17.53	18.3	17.53	17.89	683700.0
2023-04-26	AATC	Stock	4.02	4.06	4.02	4.06	1886.0
2023-04-26	AAU-DELISTED	Stock	0.1271	0.1373	0.1201	0.1247	595472.0
2023-04-26	AAUAF-DELISTED	Stock	0.1271	0.1373	0.1201	0.1248	595369.0
2023-04-26	AAXJ	Stock	65.83	66.06	65.49	65.53	347970.0
2023-04-26	AB	Stock	34.4	34.74	33.55	34.1	340800.0
2023-04-26	ABB-DELISTED	Stock	35.97	36.06	35.51	35.58	2930429.0
2023-04-26	ABBNY-DELISTED	Stock	35.97	36.06	35.51	35.59	3308441.0
2023-04-26	ABBV	Stock	162.68	163.26	160.5	161.8	5192000.0
2023-04-26	ABC-DELISTED	Stock	167.04	167.93	165.23	165.48	592647.0
2023-04-26	ABCB	Stock	32.23	32.87	31.89	32.64	479800.0
2023-04-26	ABCL	Stock	6.74	6.85	6.6	6.74	1570100.0
2023-04-26	ABCM-DELISTED	Stock	15.52	15.8	15.3011	15.78	308181.0
2023-04-26	ABEO	Stock	3.23	3.26	3.06	3.2	58000.0
2023-04-26	ABEV	Stock	2.78	2.81	2.77	2.77	17581900.0
2023-04-26	ABG	Stock	186.12	193.92	184.79	186.03	380100.0
2023-04-26	ABLV	Stock	10.38	10.38	10.38	10.38	659.0
2023-04-26	ABM	Stock	41.03	41.49	40.77	40.88	240800.0
2023-04-26	ABNB	Stock	113.5	114.6	113.2	113.68	3615500.0
2023-04-26	ABOS	Stock	3.67	3.78	3.6	3.76	46200.0
2023-04-26	ABR	Stock	10.41	10.75	10.35	10.48	3129900.0
2023-04-26	ABR.D	Stock	17.72	17.79	17.68	17.68	4182.0
2023-04-26	ABR.E	Stock	17.55	17.565	17.42	17.4307	3602.0

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

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