PREVIEW / etf_daily / 2023-01-31

all etf daily files

  file:    by_date/etf_daily/2023/2023-01-31.parquet
  size:    108 KB
  rows:    2,903

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-31	SPY	ETF	401.13	406.53	400.77	406.48	86811800.0
2023-01-31	QQQ	ETF	290.31	294.72	290.2	294.62	46705106.0
2023-01-31	IWM	ETF	187.42	191.58	187.38	191.48	21567900.0
2023-01-31	DIA	ETF	337.6	340.86	336.51	340.83	2593500.0
2023-01-31	GLD	ETF	178.82	179.7	178.54	179.41	5976900.0
2023-01-31	TLT	ETF	106.98	107.28	105.87	107.17	13705300.0
2023-01-31	AAA	ETF	24.61	24.61	24.61	24.61	112.0
2023-01-31	AAAU	ETF	19.08	19.16	19.05	19.13	674500.0
2023-01-31	AADR	ETF	49.72	50.33	49.72	50.33	1700.0
2023-01-31	AAPB	ETF	17.94	18.3	17.94	18.3	2322.0
2023-01-31	AAPD	ETF	27.57	27.58	27.22	27.23	100197.0
2023-01-31	AAPU	ETF	19.06	19.37	18.98	19.37	64988.0
2023-01-31	AAXJ	ETF	70.67	70.92	70.4	70.9	592900.0
2023-01-31	ABEQ	ETF	28.8	28.94	28.67	28.94	9000.0
2023-01-31	ACES	ETF	51.24	52.88	51.24	52.88	96400.0
2023-01-31	ACIO	ETF	29.54	29.81	29.5	29.81	20900.0
2023-01-31	ACSI	ETF	45.4468	45.4468	45.4468	45.4468	29.0
2023-01-31	ACT	ETF	24.83	25.21	24.82	25.15	313758.0
2023-01-31	ACTV	ETF	31.65	32.02	31.6	32.02	6129.0
2023-01-31	ACVF	ETF	31.0	31.4	31.0	31.34	8900.0
2023-01-31	ACWF	ETF	33.61	33.94	33.57	33.94	19817.0
2023-01-31	ACWI	ETF	90.16	91.26	90.09	91.25	8372000.0
2023-01-31	ACWV	ETF	96.23	97.2	96.15	96.91	370800.0
2023-01-31	ACWX	ETF	49.15	49.57	49.06	49.56	1768080.0
2023-01-31	ADFI	ETF	8.59	8.6	8.58	8.598	10300.0
2023-01-31	ADIV	ETF	14.39	14.493	14.381	14.493	300.0
2023-01-31	ADME	ETF	34.2	34.46	34.2	34.46	20300.0
2023-01-31	ADPV	ETF	25.16	25.44	25.09	25.43	38643.0
2023-01-31	ADRE	ETF	42.23	42.5529	42.04	42.55	7728.0
2023-01-31	AESR	ETF	11.73	11.84	11.73	11.84	14400.0
2023-01-31	AFIF	ETF	8.88	8.9	8.88	8.9	15507.0
2023-01-31	AFK	ETF	17.22	17.22	17.01	17.05	7106.0
2023-01-31	AFLG	ETF	24.25	24.403	24.25	24.403	100.0
2023-01-31	AFMC	ETF	23.87	24.079	23.87	24.079	200.0
2023-01-31	AFSM	ETF	24.312	24.312	24.312	24.312	100.0
2023-01-31	AFTY	ETF	17.47	17.47	17.47	17.47	2700.0
2023-01-31	AGG	ETF	100.16	100.34	99.83	100.22	12083600.0
2023-01-31	AGGH	ETF	23.45	23.45	22.58	22.6744	1960.0
2023-01-31	AGGY	ETF	44.05	44.13	43.92	44.13	296000.0
2023-01-31	AGIH	ETF	24.67	24.67	24.67	24.67	100.0
2023-01-31	AGNG	ETF	26.74	26.94	26.73	26.902	4600.0
2023-01-31	AGOV	ETF	80.7495	80.7495	80.7495	80.7495	98.0
2023-01-31	AGOX	ETF	21.864	22.05	21.864	22.037	17500.0
2023-01-31	AGQ	ETF	30.46	31.23	30.34	31.13	414800.0
2023-01-31	AGZ	ETF	108.18	108.28	108.1152	108.28	25055.0
2023-01-31	AGZD	ETF	21.85	21.88	21.83	21.86	223800.0
2023-01-31	AHHX	ETF	8.65	8.72	8.64	8.71	5718.0
2023-01-31	AHYB	ETF	44.26	44.443	44.26	44.443	700.0
2023-01-31	AIA	ETF	64.64	64.93	64.36	64.85	48847.0
2023-01-31	AIEQ	ETF	31.56	32.168	31.52	32.161	103800.0

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

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