PREVIEW / etf_daily / 2022-01-13

all etf daily files

  file:    by_date/etf_daily/2022/2022-01-13.parquet
  size:    99 KB
  rows:    2,641

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-01-13	SPY	ETF	472.19	472.88	463.44	464.53	91173100.0
2022-01-13	QQQ	ETF	388.77	389.47	376.7	377.66	77993962.0
2022-01-13	IWM	ETF	216.81	218.19	213.38	214.01	34489600.0
2022-01-13	DIA	ETF	364.21	365.13	360.45	361.2	6418100.0
2022-01-13	GLD	ETF	170.09	170.22	169.27	170.16	7034200.0
2022-01-13	TLT	ETF	143.39	144.42	143.03	144.28	15166000.0
2022-01-13	AAA	ETF	25.0	25.0	24.9901	25.0	2406.0
2022-01-13	AAAU	ETF	18.09	18.11	18.02	18.11	124800.0
2022-01-13	AADR	ETF	64.73	64.73	64.1	64.21	1200.0
2022-01-13	AAXJ	ETF	85.33	85.37	84.4	84.48	3294200.0
2022-01-13	ABEQ	ETF	29.03	29.08	28.91	28.923	11500.0
2022-01-13	ACES	ETF	60.13	60.578	58.13	58.23	36900.0
2022-01-13	ACIO	ETF	32.386	32.386	31.925	31.95	28100.0
2022-01-13	ACSI	ETF	52.3	52.3	51.7086	51.7086	106.0
2022-01-13	ACT	ETF	22.57	22.69	22.075	22.28	148165.0
2022-01-13	ACTV	ETF	37.36	37.37	36.9697	37.0	13996.0
2022-01-13	ACTX	ETF	1.4	1.4	1.39	1.39	696.0
2022-01-13	ACVF	ETF	35.2	35.2	34.69	34.69	3400.0
2022-01-13	ACWF	ETF	39.36	39.45	38.96	38.97	8624.0
2022-01-13	ACWI	ETF	106.04	106.12	104.29	104.44	5320100.0
2022-01-13	ACWV	ETF	106.31	106.43	105.6	105.76	119800.0
2022-01-13	ACWX	ETF	56.75	56.79	56.115	56.17	1819590.0
2022-01-13	ADFI	ETF	9.46	9.46	9.46	9.46	100.0
2022-01-13	ADIV	ETF	16.69	16.69	16.55	16.55	600.0
2022-01-13	ADME	ETF	42.94	42.94	42.16	42.18	34700.0
2022-01-13	ADRE	ETF	49.28	49.8552	48.79	49.0	8776.0
2022-01-13	AEMB	ETF	47.375	47.375	47.366	47.366	200.0
2022-01-13	AESR	ETF	13.91	13.97	13.67	13.67	7900.0
2022-01-13	AFIF	ETF	9.5	9.525	9.5	9.525	9759.0
2022-01-13	AFK	ETF	21.0	21.0	20.46	20.67	10848.0
2022-01-13	AFSM	ETF	27.03	27.11	26.663	26.663	200.0
2022-01-13	AFTY	ETF	20.2	20.23	20.18	20.18	1500.0
2022-01-13	AGG	ETF	112.6	112.8	112.51	112.8	8454300.0
2022-01-13	AGGY	ETF	50.8	50.9	50.79	50.9	52900.0
2022-01-13	AGNG	ETF	27.88	27.89	27.638	27.638	2100.0
2022-01-13	AGOV	ETF	97.29	97.29	97.156	97.156	60524.0
2022-01-13	AGOX	ETF	25.59	25.59	24.899	24.899	21900.0
2022-01-13	AGQ	ETF	34.32	34.43	33.75	33.99	577400.0
2022-01-13	AGZ	ETF	116.35	116.49	116.33	116.49	28451.0
2022-01-13	AGZD	ETF	23.325	23.345	23.305	23.305	36000.0
2022-01-13	AHHX	ETF	10.13	10.22	10.13	10.185	63170.0
2022-01-13	AHYB	ETF	49.86	49.86	49.775	49.775	200.0
2022-01-13	AIA	ETF	80.21	80.26	79.12	79.17	71385.0
2022-01-13	AIEQ	ETF	39.49	39.5	38.506	38.506	88900.0
2022-01-13	AIQ	ETF	30.92	30.92	29.9	29.9	31881.0
2022-01-13	AIRR	ETF	44.42	44.75	44.17	44.17	29100.0
2022-01-13	AIVI	ETF	43.43	43.52	43.18	43.23	21800.0
2022-01-13	ALTL	ETF	46.08	46.08	45.7233	45.86	96127.0
2022-01-13	ALTY	ETF	13.53	13.53	13.42	13.44	53500.0
2022-01-13	AMAX	ETF	9.61	9.625	9.579	9.585	21500.0

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

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