PREVIEW / etf_daily / 2023-04-18

all etf daily files

  file:    by_date/etf_daily/2023/2023-04-18.parquet
  size:    109 KB
  rows:    2,938

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-18	SPY	ETF	415.58	415.72	412.78	414.21	63560000.0
2023-04-18	QQQ	ETF	320.99	321.42	317.64	318.86	46746940.0
2023-04-18	IWM	ETF	179.59	179.63	176.94	178.02	22873100.0
2023-04-18	DIA	ETF	339.94	340.22	337.9	339.8	2191100.0
2023-04-18	GLD	ETF	185.24	186.99	185.04	186.25	8056900.0
2023-04-18	TLT	ETF	103.81	104.59	103.8	104.2	15922600.0
2023-04-18	AAA	ETF	24.535	24.535	24.535	24.535	25.0
2023-04-18	AAAU	ETF	19.77	19.95	19.75	19.88	2330800.0
2023-04-18	AADR	ETF	49.53	49.53	49.3	49.36	40800.0
2023-04-18	AAPB	ETF	22.8936	23.0852	22.76	22.9547	8297.0
2023-04-18	AAPD	ETF	23.48	23.5599	23.3204	23.4338	182472.0
2023-04-18	AAPU	ETF	23.51	23.76	23.4	23.58	74569.0
2023-04-18	AAXJ	ETF	68.45	68.47	68.04	68.16	452100.0
2023-04-18	ABEQ	ETF	28.67	28.713	28.665	28.698	2700.0
2023-04-18	ACES	ETF	45.55	45.55	44.455	44.81	94800.0
2023-04-18	ACIO	ETF	30.27	30.478	30.27	30.4	34700.0
2023-04-18	ACSI	ETF	44.5374	44.5374	44.5374	44.5374	113.0
2023-04-18	ACT	ETF	24.52	24.77	24.25	24.35	156773.0
2023-04-18	ACTV	ETF	29.76	29.76	29.26	29.4314	10318.0
2023-04-18	ACTX	ETF	0.32	0.32	0.32	0.32	251.0
2023-04-18	ACVF	ETF	31.75	31.75	31.675	31.71	4600.0
2023-04-18	ACWF	ETF	34.241	34.241	34.17	34.2137	1683.0
2023-04-18	ACWI	ETF	92.88	92.92	92.36	92.64	1634700.0
2023-04-18	ACWV	ETF	99.15	99.22	98.8	98.97	48900.0
2023-04-18	ACWX	ETF	49.96	50.03	49.83	49.95	954161.0
2023-04-18	ADFI	ETF	8.5	8.52	8.49	8.52	17000.0
2023-04-18	ADIV	ETF	13.945	13.945	13.945	13.945	100.0
2023-04-18	ADME	ETF	34.99	35.166	34.99	35.08	28100.0
2023-04-18	ADPV	ETF	23.4363	23.4799	23.4363	23.4799	836.0
2023-04-18	AEMB	ETF	37.715	37.715	37.715	37.715	100.0
2023-04-18	AESR	ETF	12.11	12.17	12.11	12.16	24900.0
2023-04-18	AFIF	ETF	8.79	8.82	8.78	8.8	8279.0
2023-04-18	AFK	ETF	16.0	16.195	15.825	15.9446	112023.0
2023-04-18	AFLG	ETF	24.24	24.252	24.234	24.234	300.0
2023-04-18	AFMC	ETF	23.13	23.18	23.13	23.177	300.0
2023-04-18	AFSM	ETF	23.24	23.372	23.24	23.372	1000.0
2023-04-18	AFTY	ETF	16.499	16.499	16.499	16.499	100.0
2023-04-18	AGG	ETF	98.91	99.16	98.91	99.04	4753000.0
2023-04-18	AGGY	ETF	43.53	43.62	43.53	43.59	130000.0
2023-04-18	AGNG	ETF	28.05	28.05	28.05	28.05	100.0
2023-04-18	AGOV	ETF	76.5	79.4	76.5	77.695	503.0
2023-04-18	AGOX	ETF	21.62	21.92	21.62	21.875	11500.0
2023-04-18	AGQ	ETF	33.39	34.38	33.33	34.0	474300.0
2023-04-18	AGZ	ETF	107.85	107.94	107.79	107.85	131521.0
2023-04-18	AGZD	ETF	21.925	21.925	21.76	21.82	34800.0
2023-04-18	AHYB	ETF	44.13	44.13	43.98	44.062	2900.0
2023-04-18	AIA	ETF	61.22	61.22	60.7	60.85	42485.0
2023-04-18	AIEQ	ETF	28.83	28.83	28.394	28.574	14100.0
2023-04-18	AIQ	ETF	24.31	24.4	24.04	24.16	65553.0
2023-04-18	AIRR	ETF	46.61	46.62	45.828	46.02	150200.0

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

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