PREVIEW / etf_daily / 2022-07-06

all etf daily files

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

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-06	SPY	ETF	382.11	385.87	379.6	383.25	70426200.0
2022-07-06	QQQ	ETF	287.35	290.95	285.59	288.8	63194715.0
2022-07-06	IWM	ETF	172.45	173.71	169.75	171.55	25697600.0
2022-07-06	DIA	ETF	310.0	312.29	307.94	310.41	2493300.0
2022-07-06	GLD	ETF	164.32	164.57	161.47	162.14	11861100.0
2022-07-06	TLT	ETF	117.39	117.54	114.77	114.77	20205400.0
2022-07-06	AAA	ETF	24.21	24.255	24.2	24.2	606.0
2022-07-06	AAAU	ETF	17.5	17.53	17.2	17.27	675500.0
2022-07-06	AADR	ETF	47.6	47.6	46.25	47.0	4200.0
2022-07-06	AAXJ	ETF	67.96	68.09	67.34	67.86	1290000.0
2022-07-06	ABEQ	ETF	26.6	26.89	26.6	26.804	15700.0
2022-07-06	ACES	ETF	48.99	50.0	48.51	48.99	25800.0
2022-07-06	ACIO	ETF	28.98	29.21	28.92	29.11	27900.0
2022-07-06	ACSI	ETF	43.0204	43.0204	43.0204	43.0204	69.0
2022-07-06	ACT	ETF	21.35	21.56	20.86	21.2	183359.0
2022-07-06	ACTV	ETF	30.785	30.89	30.7	30.7187	4405.0
2022-07-06	ACTX	ETF	0.6402	0.85	0.6402	0.85	305.0
2022-07-06	ACVF	ETF	28.785	29.09	28.75	28.914	3900.0
2022-07-06	ACWF	ETF	30.79	31.04	30.671	30.9514	7261.0
2022-07-06	ACWI	ETF	83.99	84.59	83.42	84.17	3530200.0
2022-07-06	ACWV	ETF	95.07	95.91	95.03	95.46	589400.0
2022-07-06	ACWX	ETF	44.05	44.2201	43.76	44.11	3170373.0
2022-07-06	ADFI	ETF	8.51	8.51	8.49	8.505	2500.0
2022-07-06	ADIV	ETF	13.708	13.77	13.708	13.761	400.0
2022-07-06	ADME	ETF	34.78	35.01	34.59	34.84	14900.0
2022-07-06	ADRE	ETF	38.21	38.2301	37.58	38.12	20520.0
2022-07-06	AEMB	ETF	37.62	37.62	37.318	37.318	500.0
2022-07-06	AESR	ETF	11.06	11.21	11.06	11.14	9700.0
2022-07-06	AFIF	ETF	8.849	8.85	8.82	8.825	25383.0
2022-07-06	AFK	ETF	16.79	16.79	16.485	16.68	4935.0
2022-07-06	AFLG	ETF	22.722	22.817	22.6	22.817	3000.0
2022-07-06	AFMC	ETF	20.74	20.988	20.74	20.988	200.0
2022-07-06	AFSM	ETF	21.735	21.735	21.45	21.698	200.0
2022-07-06	AFTY	ETF	18.668	18.68	18.662	18.662	600.0
2022-07-06	AGG	ETF	102.78	102.8	101.84	101.84	6647700.0
2022-07-06	AGGY	ETF	45.28	45.34	44.92	44.95	150300.0
2022-07-06	AGNG	ETF	25.78	25.85	25.78	25.83	800.0
2022-07-06	AGOV	ETF	78.62	80.37	78.51	79.5805	1671.0
2022-07-06	AGOX	ETF	20.08	20.24	19.955	20.17	14000.0
2022-07-06	AGQ	ETF	22.13	22.26	21.34	21.93	899100.0
2022-07-06	AGZ	ETF	110.74	110.74	110.22	110.53	46936.0
2022-07-06	AGZD	ETF	22.75	22.805	22.73	22.755	77600.0
2022-07-06	AHHX	ETF	8.4	8.46	8.4	8.4253	5150.0
2022-07-06	AHYB	ETF	42.635	42.635	42.56	42.6	400.0
2022-07-06	AIA	ETF	61.23	61.4091	60.58	61.14	75514.0
2022-07-06	AIEQ	ETF	31.8	32.0	31.48	31.62	11400.0
2022-07-06	AIQ	ETF	21.16	21.32	21.01	21.21	7437.0
2022-07-06	AIRR	ETF	37.18	37.18	36.508	37.045	12400.0
2022-07-06	AIVI	ETF	34.43	34.56	34.4	34.54	36200.0
2022-07-06	AIVL	ETF	89.15	89.81	88.83	89.45	16500.0

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

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