PREVIEW / etf_daily / 2022-07-22

all etf daily files

  file:    by_date/etf_daily/2022/2022-07-22.parquet
  size:    101 KB
  rows:    2,735

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
2022-07-22	SPY	ETF	398.92	400.18	392.75	395.09	72197300.0
2022-07-22	QQQ	ETF	306.43	308.55	300.115	301.99	57127715.0
2022-07-22	IWM	ETF	182.88	183.25	178.05	179.51	25116100.0
2022-07-22	DIA	ETF	321.76	322.2	317.34	319.06	3264100.0
2022-07-22	GLD	ETF	160.55	162.13	160.35	160.67	5733800.0
2022-07-22	TLT	ETF	118.29	119.27	117.97	118.55	17715300.0
2022-07-22	AAA	ETF	24.22	24.22	24.22	24.22	2.0
2022-07-22	AAAU	ETF	17.1	17.27	17.09	17.12	1166300.0
2022-07-22	AADR	ETF	48.93	48.93	48.3	48.39	1800.0
2022-07-22	AAXJ	ETF	68.28	68.32	67.39	67.61	468300.0
2022-07-22	ABEQ	ETF	26.8	26.8	26.505	26.62	18100.0
2022-07-22	ACES	ETF	53.56	53.94	51.68	52.06	15600.0
2022-07-22	ACIO	ETF	29.81	29.81	29.555	29.67	11800.0
2022-07-22	ACSI	ETF	44.3039	44.3039	44.3039	44.3039	23.0
2022-07-22	ACT	ETF	22.01	22.065	21.68	21.81	92492.0
2022-07-22	ACTV	ETF	31.8999	31.8999	31.42	31.5458	8382.0
2022-07-22	ACTX	ETF	0.7	0.7	0.7	0.7	1283.0
2022-07-22	ACVF	ETF	30.12	30.12	29.816	29.816	900.0
2022-07-22	ACWF	ETF	32.25	32.4	31.94	32.03	50322.0
2022-07-22	ACWI	ETF	87.36	87.71	86.11	86.53	1732700.0
2022-07-22	ACWV	ETF	95.8	96.18	95.18	95.61	181600.0
2022-07-22	ACWX	ETF	45.46	45.67	44.945	45.11	2342340.0
2022-07-22	ADFI	ETF	8.66	8.66	8.62	8.645	7400.0
2022-07-22	ADIV	ETF	13.755	13.755	13.681	13.681	500.0
2022-07-22	ADME	ETF	35.728	35.76	35.28	35.362	112600.0
2022-07-22	ADRE	ETF	39.02	39.02	38.25	38.44	4402.0
2022-07-22	AEMB	ETF	37.47	37.795	37.44	37.795	14500.0
2022-07-22	AESR	ETF	11.54	11.54	11.43	11.48	10500.0
2022-07-22	AFIF	ETF	8.9	8.91	8.88	8.895	40037.0
2022-07-22	AFK	ETF	17.01	17.12	16.92	16.94	9378.0
2022-07-22	AFLG	ETF	23.28	23.336	23.28	23.336	100.0
2022-07-22	AFMC	ETF	21.89	22.02	21.89	22.02	200.0
2022-07-22	AFSM	ETF	22.913	22.993	22.87	22.993	200.0
2022-07-22	AFTY	ETF	17.84	17.851	17.78	17.78	500.0
2022-07-22	AGG	ETF	103.26	103.6	103.12	103.36	7323100.0
2022-07-22	AGGY	ETF	45.56	45.76	45.55	45.67	122300.0
2022-07-22	AGNG	ETF	26.21	26.21	25.98	26.007	1900.0
2022-07-22	AGOV	ETF	78.63	81.39	78.63	80.25	1452.0
2022-07-22	AGOX	ETF	21.2	21.2	20.77	20.83	273300.0
2022-07-22	AGQ	ETF	20.72	21.21	20.2	20.36	1024100.0
2022-07-22	AGZ	ETF	110.32	110.765	110.32	110.71	9948.0
2022-07-22	AGZD	ETF	22.905	22.905	22.86	22.89	35200.0
2022-07-22	AHHX	ETF	8.67	8.67	8.55	8.585	3043.0
2022-07-22	AHYB	ETF	44.57	44.689	44.427	44.427	600.0
2022-07-22	AIA	ETF	61.66	61.68	60.745	60.93	28342.0
2022-07-22	AIEQ	ETF	33.09	33.23	32.34	32.39	4100.0
2022-07-22	AIQ	ETF	22.4	22.4376	21.96	22.05	52196.0
2022-07-22	AIRR	ETF	40.0	40.099	39.36	39.608	8500.0
2022-07-22	AIVI	ETF	35.48	35.62	35.22	35.31	2100.0
2022-07-22	AIVL	ETF	92.62	92.67	91.69	92.1	2700.0

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

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