PREVIEW / etf_daily / 2023-01-19

all etf daily files

  file:    by_date/etf_daily/2023/2023-01-19.parquet
  size:    107 KB
  rows:    2,899

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-01-19	SPY	ETF	389.36	391.08	387.26	388.64	86958900.0
2023-01-19	QQQ	ETF	276.22	277.375	273.89	275.15	44150436.0
2023-01-19	IWM	ETF	182.73	183.1	180.78	182.04	24624500.0
2023-01-19	DIA	ETF	331.06	332.46	329.97	330.63	3454200.0
2023-01-19	GLD	ETF	178.37	180.03	178.09	179.89	6678700.0
2023-01-19	TLT	ETF	108.1	108.37	107.44	107.95	17194700.0
2023-01-19	AAA	ETF	24.505	24.505	24.505	24.505	88.0
2023-01-19	AAAU	ETF	19.02	19.2	19.0	19.18	716900.0
2023-01-19	AADR	ETF	49.5	49.88	49.5	49.88	27500.0
2023-01-19	AAPB	ETF	16.25	16.425	16.25	16.425	1293.0
2023-01-19	AAPD	ETF	29.32	29.34	28.85	29.0172	208575.0
2023-01-19	AAPU	ETF	17.4	17.8	17.36	17.63	77233.0
2023-01-19	AAXJ	ETF	70.37	70.76	70.3	70.57	562900.0
2023-01-19	ABEQ	ETF	28.36	28.49	28.36	28.432	8000.0
2023-01-19	ACES	ETF	50.34	50.34	48.37	48.62	41800.0
2023-01-19	ACIO	ETF	29.01	29.1	28.98	29.02	18200.0
2023-01-19	ACSI	ETF	42.48	42.772	42.48	42.772	216.0
2023-01-19	ACT	ETF	23.96	24.1	23.895	24.0	379087.0
2023-01-19	ACTV	ETF	30.61	30.8599	30.61	30.72	28939.0
2023-01-19	ACVF	ETF	30.25	30.25	30.0	30.072	5900.0
2023-01-19	ACWF	ETF	32.89	33.02	32.74	32.9	6780.0
2023-01-19	ACWI	ETF	88.3	88.68	87.88	88.3	3860000.0
2023-01-19	ACWV	ETF	95.86	96.2	95.79	95.92	343200.0
2023-01-19	ACWX	ETF	48.79	48.99	48.62	48.89	1598481.0
2023-01-19	ADFI	ETF	8.6	8.62	8.56	8.62	28700.0
2023-01-19	ADIV	ETF	14.302	14.302	14.302	14.302	100.0
2023-01-19	ADME	ETF	33.56	33.619	33.44	33.44	5500.0
2023-01-19	ADPV	ETF	25.3	25.3	25.1	25.1	17542.0
2023-01-19	ADRE	ETF	42.09	42.51	42.09	42.4102	51271.0
2023-01-19	AEMB	ETF	39.28	39.29	39.28	39.29	100.0
2023-01-19	AESR	ETF	11.47	11.53	11.47	11.47	17800.0
2023-01-19	AFIF	ETF	8.85	8.85	8.83	8.85	6740.0
2023-01-19	AFK	ETF	16.92	17.19	16.92	17.03	18802.0
2023-01-19	AFLG	ETF	23.27	23.42	23.27	23.342	300.0
2023-01-19	AFMC	ETF	22.79	22.834	22.79	22.834	100.0
2023-01-19	AFSM	ETF	23.3	23.342	23.3	23.342	100.0
2023-01-19	AFTY	ETF	17.37	17.434	17.35	17.434	1300.0
2023-01-19	AGG	ETF	100.73	100.73	100.33	100.5	8633700.0
2023-01-19	AGGH	ETF	22.85	22.85	22.85	22.85	100.0
2023-01-19	AGGY	ETF	44.31	44.375	44.23	44.3	137400.0
2023-01-19	AGIH	ETF	24.6471	24.73	24.6471	24.73	1318.0
2023-01-19	AGNG	ETF	26.86	26.992	26.85	26.894	1600.0
2023-01-19	AGOV	ETF	81.3	81.3	81.3	81.3	55.0
2023-01-19	AGOX	ETF	21.15	21.264	21.1	21.137	8400.0
2023-01-19	AGQ	ETF	30.67	31.8	30.5	31.57	583300.0
2023-01-19	AGZ	ETF	108.45	108.5	108.3512	108.42	29703.0
2023-01-19	AGZD	ETF	21.775	21.885	21.76	21.825	252000.0
2023-01-19	AHHX	ETF	8.6595	8.6601	8.635	8.6601	985.0
2023-01-19	AHYB	ETF	44.292	44.292	44.292	44.292	300.0
2023-01-19	AIA	ETF	63.72	64.215	63.6952	64.06	135741.0

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

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