PREVIEW / etf_daily / 2022-07-25

all etf daily files

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

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-25	SPY	ETF	395.75	396.47	393.21	395.57	53631500.0
2022-07-25	QQQ	ETF	302.02	302.5	298.22	300.27	40582381.0
2022-07-25	IWM	ETF	180.05	180.92	178.43	180.44	19267200.0
2022-07-25	DIA	ETF	320.07	320.39	318.25	319.96	4002500.0
2022-07-25	GLD	ETF	160.64	160.7	159.81	160.23	3713400.0
2022-07-25	TLT	ETF	116.71	117.54	116.47	117.39	24868100.0
2022-07-25	AAA	ETF	24.3	24.3	24.24	24.26	11296.0
2022-07-25	AAAU	ETF	17.12	17.13	17.02	17.07	550500.0
2022-07-25	AADR	ETF	48.97	49.29	48.97	49.21	900.0
2022-07-25	AAXJ	ETF	67.85	68.0	67.6	67.91	533800.0
2022-07-25	ABEQ	ETF	26.702	26.78	26.65	26.746	7400.0
2022-07-25	ACES	ETF	52.3	52.3	51.16	52.2	16000.0
2022-07-25	ACIO	ETF	29.641	29.72	29.54	29.71	17100.0
2022-07-25	ACSI	ETF	44.3243	44.3243	44.3243	44.3243	10.0
2022-07-25	ACT	ETF	21.98	22.405	21.95	22.34	135328.0
2022-07-25	ACTV	ETF	31.52	31.54	31.27	31.4537	2968.0
2022-07-25	ACVF	ETF	29.96	29.96	29.89	29.919	3100.0
2022-07-25	ACWF	ETF	32.14	32.2361	32.1	32.2219	26580.0
2022-07-25	ACWI	ETF	86.87	86.96	86.39	86.8	7341200.0
2022-07-25	ACWV	ETF	95.82	95.82	95.32	95.67	120800.0
2022-07-25	ACWX	ETF	45.39	45.46	45.21	45.43	2290225.0
2022-07-25	ADFI	ETF	8.61	8.64	8.61	8.625	1900.0
2022-07-25	ADIV	ETF	13.813	13.813	13.813	13.813	100.0
2022-07-25	ADME	ETF	35.374	35.45	35.24	35.409	12300.0
2022-07-25	ADRE	ETF	38.66	38.85	38.66	38.83	3256.0
2022-07-25	AEMB	ETF	37.911	37.911	37.911	37.911	100.0
2022-07-25	AESR	ETF	11.43	11.513	11.43	11.513	3800.0
2022-07-25	AFIF	ETF	8.8614	8.8614	8.84	8.845	21340.0
2022-07-25	AFK	ETF	17.07	17.07	16.885	17.03	3558.0
2022-07-25	AFLG	ETF	23.439	23.439	23.439	23.439	100.0
2022-07-25	AFMC	ETF	22.18	22.18	22.18	22.18	200.0
2022-07-25	AFSM	ETF	23.211	23.211	23.211	23.211	100.0
2022-07-25	AFTY	ETF	17.84	17.84	17.84	17.84	100.0
2022-07-25	AGG	ETF	102.9	103.09	102.87	102.98	3729500.0
2022-07-25	AGGY	ETF	45.4	45.464	45.39	45.44	57100.0
2022-07-25	AGNG	ETF	26.05	26.11	26.05	26.077	4400.0
2022-07-25	AGOV	ETF	80.036	80.42	79.64	80.42	1885.0
2022-07-25	AGOX	ETF	20.965	21.01	20.84	21.01	99200.0
2022-07-25	AGQ	ETF	20.13	20.16	19.71	19.95	670800.0
2022-07-25	AGZ	ETF	110.39	110.559	110.39	110.51	12849.0
2022-07-25	AGZD	ETF	22.885	22.905	22.82	22.89	150400.0
2022-07-25	AHHX	ETF	8.61	8.6703	8.6	8.656	6399.0
2022-07-25	AHYB	ETF	44.409	44.409	44.409	44.409	400.0
2022-07-25	AIA	ETF	61.17	61.2894	60.9	61.14	33378.0
2022-07-25	AIEQ	ETF	32.52	32.696	32.468	32.696	4100.0
2022-07-25	AIQ	ETF	22.04	22.04	21.78	21.89	8501.0
2022-07-25	AIRR	ETF	39.943	40.028	39.8	39.975	7400.0
2022-07-25	AIVI	ETF	35.66	35.66	35.52	35.64	2000.0
2022-07-25	AIVL	ETF	92.17	92.61	91.97	92.41	3100.0
2022-07-25	ALTL	ETF	41.07	41.29	40.9821	41.25	72867.0

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

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