PREVIEW / etf_daily / 2022-06-28

all etf daily files

  file:    by_date/etf_daily/2022/2022-06-28.parquet
  size:    103 KB
  rows:    2,747

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-28	SPY	ETF	390.23	393.16	380.53	380.65	86548900.0
2022-06-28	QQQ	ETF	293.0	295.65	283.35	283.54	61867060.0
2022-06-28	IWM	ETF	176.93	178.15	172.35	172.44	25909200.0
2022-06-28	DIA	ETF	316.0	318.75	309.23	309.34	3025900.0
2022-06-28	GLD	ETF	170.07	170.21	169.51	169.62	2982700.0
2022-06-28	TLT	ETF	111.29	112.18	110.87	112.12	13706600.0
2022-06-28	AAA	ETF	24.39	24.39	24.36	24.385	9101.0
2022-06-28	AAAU	ETF	18.12	18.12	18.06	18.08	629200.0
2022-06-28	AADR	ETF	50.07	50.4	49.08	49.17	4300.0
2022-06-28	AAXJ	ETF	70.55	70.89	69.62	69.62	1104400.0
2022-06-28	ABEQ	ETF	27.569	27.569	27.211	27.211	10700.0
2022-06-28	ACES	ETF	51.74	52.1	49.52	49.62	61300.0
2022-06-28	ACIO	ETF	29.65	29.65	29.0	29.06	21500.0
2022-06-28	ACSI	ETF	42.6704	42.6704	42.6704	42.6704	23.0
2022-06-28	ACT	ETF	22.09	22.64	21.46	21.48	228572.0
2022-06-28	ACTV	ETF	31.6193	31.6193	30.94	30.9402	8872.0
2022-06-28	ACTX	ETF	0.8	0.8	0.7611	0.7611	750.0
2022-06-28	ACVF	ETF	29.52	29.52	28.836	28.836	10800.0
2022-06-28	ACWF	ETF	31.9689	31.9689	31.4297	31.4297	4322.0
2022-06-28	ACWI	ETF	86.58	87.04	84.76	84.79	3202000.0
2022-06-28	ACWV	ETF	96.03	96.18	94.59	94.62	676400.0
2022-06-28	ACWX	ETF	46.05	46.19	45.38	45.42	2943076.0
2022-06-28	ADFI	ETF	7.88	8.48	7.88	8.46	85600.0
2022-06-28	ADIV	ETF	14.31	14.31	14.218	14.218	400.0
2022-06-28	ADME	ETF	35.55	35.75	34.75	34.779	17000.0
2022-06-28	ADRE	ETF	40.49	40.52	39.577	39.6	4192.0
2022-06-28	AEMB	ETF	37.83	37.83	37.71	37.74	3500.0
2022-06-28	AESR	ETF	11.45	11.47	11.07	11.14	167100.0
2022-06-28	AFIF	ETF	8.89	8.89	8.8701	8.8845	3545.0
2022-06-28	AFK	ETF	17.41	17.48	17.17	17.22	3151.0
2022-06-28	AFLG	ETF	22.95	22.95	22.829	22.829	1100.0
2022-06-28	AFMC	ETF	21.46	21.46	21.223	21.223	500.0
2022-06-28	AFSM	ETF	22.134	22.134	22.134	22.134	100.0
2022-06-28	AFTY	ETF	18.804	18.804	18.804	18.804	100.0
2022-06-28	AGG	ETF	100.53	100.66	100.4	100.64	6540000.0
2022-06-28	AGGY	ETF	44.19	44.286	44.179	44.27	149200.0
2022-06-28	AGNG	ETF	25.93	25.93	25.413	25.413	1100.0
2022-06-28	AGOV	ETF	79.2	79.31	78.0	78.7	6909.0
2022-06-28	AGOX	ETF	21.13	21.14	20.68	20.687	9400.0
2022-06-28	AGQ	ETF	26.88	26.91	25.94	26.0	859500.0
2022-06-28	AGZ	ETF	109.24	109.4011	109.01	109.12	44374.0
2022-06-28	AGZD	ETF	22.875	22.895	22.81	22.87	62000.0
2022-06-28	AHHX	ETF	8.5	8.5	8.46	8.4802	294856.0
2022-06-28	AHYB	ETF	42.778	42.778	42.778	42.778	200.0
2022-06-28	AIA	ETF	64.57	64.89	63.6	63.6	57786.0
2022-06-28	AIEQ	ETF	32.12	32.176	31.014	31.08	7800.0
2022-06-28	AIQ	ETF	22.02	22.17	21.31	21.32	37185.0
2022-06-28	AIRR	ETF	38.59	38.821	37.64	37.74	25400.0
2022-06-28	AIVI	ETF	36.32	36.56	36.02	36.02	31700.0
2022-06-28	AIVL	ETF	91.02	91.49	89.32	89.32	4500.0

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

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