PREVIEW / etf_daily / 2022-06-17

all etf daily files

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

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-06-17	SPY	ETF	365.51	369.38	362.17	365.86	111113900.0
2022-06-17	QQQ	ETF	272.18	277.19	270.5119	274.69	82703402.0
2022-06-17	IWM	ETF	164.48	167.52	163.7	165.18	40327300.0
2022-06-17	DIA	ETF	298.27	301.58	296.39	298.72	4738000.0
2022-06-17	GLD	ETF	172.15	172.3	170.97	171.27	7407200.0
2022-06-17	TLT	ETF	112.01	112.83	110.96	112.08	21614300.0
2022-06-17	AAA	ETF	24.45	24.45	24.4301	24.45	200.0
2022-06-17	AAAU	ETF	18.34	18.36	18.21	18.25	1530900.0
2022-06-17	AADR	ETF	50.04	50.04	49.37	49.69	1800.0
2022-06-17	AAXJ	ETF	68.27	68.52	67.46	67.96	2793300.0
2022-06-17	ABEQ	ETF	26.99	26.99	26.62	26.745	9000.0
2022-06-17	ACES	ETF	46.68	48.95	46.68	48.64	379400.0
2022-06-17	ACIO	ETF	28.28	28.35	28.0	28.12	72300.0
2022-06-17	ACSI	ETF	41.1047	41.1047	41.1047	41.1047	39.0
2022-06-17	ACT	ETF	21.55	22.01	20.9	21.53	1332470.0
2022-06-17	ACTV	ETF	29.2	29.385	29.105	29.2426	3404.0
2022-06-17	ACVF	ETF	27.82	27.83	27.543	27.8	9400.0
2022-06-17	ACWF	ETF	30.77	30.83	30.4	30.6134	10033.0
2022-06-17	ACWI	ETF	82.1	82.69	81.26	81.93	4877700.0
2022-06-17	ACWV	ETF	90.81	91.41	90.41	90.98	649000.0
2022-06-17	ACWX	ETF	44.55	44.73	44.07	44.36	5664782.0
2022-06-17	ADFI	ETF	8.42	8.46	8.42	8.445	8400.0
2022-06-17	ADIV	ETF	13.942	13.942	13.942	13.942	100.0
2022-06-17	ADME	ETF	33.99	33.99	33.73	33.76	34300.0
2022-06-17	ADRE	ETF	39.6933	39.6933	39.18	39.21	4221.0
2022-06-17	AEMB	ETF	38.57	38.591	38.43	38.591	18800.0
2022-06-17	AESR	ETF	10.78	10.91	10.69	10.79	64300.0
2022-06-17	AFIF	ETF	8.85	8.91	8.85	8.885	66660.0
2022-06-17	AFK	ETF	17.61	17.61	17.28	17.56	5822.0
2022-06-17	AFLG	ETF	21.95	22.14	21.95	22.069	400.0
2022-06-17	AFMC	ETF	20.53	20.53	20.526	20.526	100.0
2022-06-17	AFSM	ETF	21.32	21.427	21.32	21.427	100.0
2022-06-17	AFTY	ETF	18.108	18.108	18.108	18.108	100.0
2022-06-17	AGG	ETF	100.42	100.57	99.98	100.34	9892200.0
2022-06-17	AGGY	ETF	44.27	44.349	44.11	44.19	102100.0
2022-06-17	AGNG	ETF	24.07	24.07	23.86	23.95	2000.0
2022-06-17	AGOV	ETF	77.9999	78.01	77.86	77.86	2926.0
2022-06-17	AGOX	ETF	20.34	20.34	20.07	20.15	21600.0
2022-06-17	AGQ	ETF	28.74	28.84	28.13	28.29	676200.0
2022-06-17	AGZ	ETF	108.74	108.84	108.52	108.7	17573.0
2022-06-17	AGZD	ETF	23.045	23.065	22.955	22.96	126000.0
2022-06-17	AHHX	ETF	8.455	8.5	8.43	8.4662	15566.0
2022-06-17	AHYB	ETF	42.88	43.042	42.88	43.042	500.0
2022-06-17	AIA	ETF	63.14	63.27	62.01	62.34	64417.0
2022-06-17	AIEQ	ETF	29.9	30.15	29.795	29.998	6500.0
2022-06-17	AIQ	ETF	20.56	20.771	20.431	20.65	10406.0
2022-06-17	AIRR	ETF	36.17	36.841	36.17	36.61	19100.0
2022-06-17	AIVI	ETF	36.38	36.47	36.11	36.19	1900.0
2022-06-17	AIVL	ETF	86.19	86.63	85.65	86.18	9800.0
2022-06-17	ALTL	ETF	38.76	38.97	38.4898	38.68	138289.0

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

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