PREVIEW / etf_daily / 2022-07-05

all etf daily files

  file:    by_date/etf_daily/2022/2022-07-05.parquet
  size:    102 KB
  rows:    2,753

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-05	SPY	ETF	375.88	381.98	372.9	381.96	81438000.0
2022-07-05	QQQ	ETF	278.31	287.08	276.7501	286.96	61829272.0
2022-07-05	IWM	ETF	168.68	172.9	166.73	172.83	25151100.0
2022-07-05	DIA	ETF	306.6	309.76	303.58	309.71	3767700.0
2022-07-05	GLD	ETF	167.18	167.33	164.41	164.75	14035400.0
2022-07-05	TLT	ETF	116.89	117.75	116.17	116.73	16689700.0
2022-07-05	AAA	ETF	24.335	24.335	24.335	24.335	5.0
2022-07-05	AAAU	ETF	17.82	17.83	17.51	17.55	1494600.0
2022-07-05	AADR	ETF	46.71	47.1	46.41	47.1	800.0
2022-07-05	AAXJ	ETF	67.32	68.37	67.09	68.37	1738600.0
2022-07-05	ABEQ	ETF	26.58	26.835	26.566	26.835	1700.0
2022-07-05	ACES	ETF	47.86	48.97	46.57	48.86	77300.0
2022-07-05	ACIO	ETF	28.77	29.01	28.684	28.969	22900.0
2022-07-05	ACSI	ETF	41.9601	42.9693	41.9601	42.9693	329.0
2022-07-05	ACT	ETF	21.25	21.5	20.98	21.5	192908.0
2022-07-05	ACTV	ETF	30.04	31.03	30.04	31.029	1155.0
2022-07-05	ACTX	ETF	0.87	0.87	0.85	0.85	288.0
2022-07-05	ACVF	ETF	28.51	28.811	28.24	28.811	2800.0
2022-07-05	ACWF	ETF	30.68	30.9354	30.4399	30.9354	6087.0
2022-07-05	ACWI	ETF	82.95	84.07	82.4	84.05	5108900.0
2022-07-05	ACWV	ETF	94.92	95.25	93.88	95.09	537900.0
2022-07-05	ACWX	ETF	43.82	44.21	43.54	44.2	2442455.0
2022-07-05	ADFI	ETF	8.51	8.55	8.51	8.543	4600.0
2022-07-05	ADIV	ETF	13.73	13.85	13.73	13.85	300.0
2022-07-05	ADME	ETF	34.22	34.71	34.2	34.71	14000.0
2022-07-05	ADRE	ETF	37.94	38.59	37.7083	38.59	2583.0
2022-07-05	AEMB	ETF	37.78	37.78	37.74	37.74	100.0
2022-07-05	AESR	ETF	11.04	11.16	10.94	11.16	23300.0
2022-07-05	AFIF	ETF	8.87	8.88	8.85	8.88	10431.0
2022-07-05	AFK	ETF	16.97	16.97	16.67	16.67	5757.0
2022-07-05	AFLG	ETF	22.7	22.717	22.7	22.717	100.0
2022-07-05	AFMC	ETF	20.937	21.07	20.937	21.07	1200.0
2022-07-05	AFSM	ETF	21.445	21.824	21.42	21.824	200.0
2022-07-05	AFTY	ETF	18.928	19.006	18.928	19.006	900.0
2022-07-05	AGG	ETF	102.54	102.7	102.35	102.53	6813100.0
2022-07-05	AGGY	ETF	45.16	45.37	45.11	45.2	631300.0
2022-07-05	AGNG	ETF	25.289	25.755	25.289	25.755	1200.0
2022-07-05	AGOV	ETF	79.02	80.32	79.02	79.4419	1151.0
2022-07-05	AGOX	ETF	19.88	20.19	19.77	20.19	12500.0
2022-07-05	AGQ	ETF	22.71	22.82	21.53	21.94	1795100.0
2022-07-05	AGRH	ETF	25.22	25.22	25.195	25.195	101.0
2022-07-05	AGZ	ETF	110.53	110.8	110.4	110.4	22613.0
2022-07-05	AGZD	ETF	22.77	22.8	22.705	22.73	150600.0
2022-07-05	AHHX	ETF	8.355	8.4476	8.16	8.4476	5022.0
2022-07-05	AHYB	ETF	42.71	42.71	42.71	42.71	100.0
2022-07-05	AIA	ETF	60.95	61.74	60.61	61.68	351903.0
2022-07-05	AIEQ	ETF	30.49	31.679	30.49	31.678	6500.0
2022-07-05	AIQ	ETF	20.55	21.2	20.4401	21.19	22235.0
2022-07-05	AIRR	ETF	36.93	37.267	36.195	37.267	18400.0
2022-07-05	AIVI	ETF	34.34	34.62	34.34	34.62	13300.0

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

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