PREVIEW / etf_daily / 2023-03-15

all etf daily files

  file:    by_date/etf_daily/2023/2023-03-15.parquet
  size:    110 KB
  rows:    2,977

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-03-15	SPY	ETF	385.89	389.49	383.71	389.28	172996900.0
2023-03-15	QQQ	ETF	294.71	299.27	293.24	298.93	83631535.0
2023-03-15	IWM	ETF	171.93	173.91	170.38	173.61	54405800.0
2023-03-15	DIA	ETF	316.9	319.81	314.97	319.54	6518000.0
2023-03-15	GLD	ETF	178.86	180.13	177.49	178.21	14546100.0
2023-03-15	TLT	ETF	106.78	107.71	105.35	106.1	45164100.0
2023-03-15	AAA	ETF	24.5006	24.54	24.5006	24.54	1408.0
2023-03-15	AAAU	ETF	19.08	19.21	18.93	19.01	2525800.0
2023-03-15	AADR	ETF	44.58	45.28	44.58	45.28	2100.0
2023-03-15	AAPB	ETF	19.47	19.979	19.43	19.9238	2244.0
2023-03-15	AAPD	ETF	25.92	26.14	25.6	25.6	152377.0
2023-03-15	AAPU	ETF	20.56	21.02	20.3577	20.97	95204.0
2023-03-15	AAXJ	ETF	63.85	64.09	63.43	64.05	873200.0
2023-03-15	ABEQ	ETF	26.9	26.94	26.79	26.93	17400.0
2023-03-15	ACES	ETF	44.17	44.39	43.14	44.03	99200.0
2023-03-15	ACIO	ETF	29.295	29.47	29.13	29.284	14800.0
2023-03-15	ACSI	ETF	42.3134	42.3134	42.3134	42.3134	6.0
2023-03-15	ACT	ETF	21.68	21.97	21.0801	21.96	169249.0
2023-03-15	ACTV	ETF	28.683	29.08	28.55	28.9712	9656.0
2023-03-15	ACVF	ETF	29.5	29.81	29.5	29.799	2400.0
2023-03-15	ACWF	ETF	31.76	31.902	31.54	31.8337	39798.0
2023-03-15	ACWI	ETF	85.48	86.13	84.95	86.12	3277200.0
2023-03-15	ACWV	ETF	92.11	93.06	92.11	93.0	188900.0
2023-03-15	ACWX	ETF	45.56	45.845	45.251	45.79	2802888.0
2023-03-15	ADFI	ETF	8.4	8.46	8.39	8.455	8100.0
2023-03-15	ADIV	ETF	13.22	13.306	13.22	13.306	400.0
2023-03-15	ADME	ETF	33.17	33.83	33.17	33.79	6400.0
2023-03-15	ADPV	ETF	22.84	22.85	22.645	22.8471	30382.0
2023-03-15	ADRE	ETF	37.59	37.68	37.0	37.68	3351.0
2023-03-15	AEMB	ETF	37.46	37.485	37.46	37.485	200.0
2023-03-15	AESR	ETF	11.26	11.41	11.26	11.41	11600.0
2023-03-15	AFIF	ETF	8.8199	8.8199	8.74	8.8	19086.0
2023-03-15	AFK	ETF	15.4	15.4	15.0311	15.1	8206.0
2023-03-15	AFLG	ETF	22.82	22.946	22.82	22.874	400.0
2023-03-15	AFMC	ETF	22.08	22.08	22.05	22.079	300.0
2023-03-15	AFSM	ETF	22.36	22.56	22.22	22.471	1800.0
2023-03-15	AFTY	ETF	15.859	15.859	15.859	15.859	100.0
2023-03-15	AGG	ETF	99.43	99.7	98.81	99.27	11133700.0
2023-03-15	AGGH	ETF	22.96	23.0485	22.96	23.0485	730.0
2023-03-15	AGGY	ETF	43.47	43.765	43.43	43.61	191600.0
2023-03-15	AGNG	ETF	25.718	25.84	25.697	25.84	1000.0
2023-03-15	AGOV	ETF	77.68	77.68	76.015	76.015	714.0
2023-03-15	AGOX	ETF	20.35	20.689	20.35	20.543	21200.0
2023-03-15	AGQ	ETF	26.6	26.71	25.33	25.67	1189300.0
2023-03-15	AGZ	ETF	108.73	108.73	108.05	108.23	82490.0
2023-03-15	AGZD	ETF	21.625	21.86	21.535	21.695	177600.0
2023-03-15	AHHX	ETF	8.3576	8.3576	8.3576	8.3576	98.0
2023-03-15	AHYB	ETF	42.9	42.934	42.9	42.934	500.0
2023-03-15	AIA	ETF	56.83	57.01	56.39	56.92	49500.0
2023-03-15	AIEQ	ETF	27.99	28.17	27.696	28.09	21400.0

> showing 50 of 2,977 rows — these rows as CSV

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