PREVIEW / etf_daily / 2022-01-03

all etf daily files

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

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-03	SPY	ETF	476.3	477.85	473.85	477.71	72668200.0
2022-01-03	QQQ	ETF	399.05	401.94	396.88	401.68	40575854.0
2022-01-03	IWM	ETF	223.71	226.69	222.73	225.32	30618800.0
2022-01-03	DIA	ETF	364.34	365.85	362.3	365.68	5624100.0
2022-01-03	GLD	ETF	168.86	169.01	168.0	168.33	9014400.0
2022-01-03	TLT	ETF	146.41	146.94	144.28	144.3	33860400.0
2022-01-03	AAA	ETF	25.0	25.0	25.0	25.0	1311.0
2022-01-03	AAAU	ETF	17.97	17.98	17.88	17.91	195000.0
2022-01-03	AADR	ETF	64.45	64.57	64.39	64.41	3900.0
2022-01-03	AAXJ	ETF	83.13	83.36	82.53	83.29	629900.0
2022-01-03	ABEQ	ETF	28.452	28.452	28.417	28.417	2200.0
2022-01-03	ACES	ETF	65.05	65.6	64.675	65.5	35700.0
2022-01-03	ACIO	ETF	32.68	32.76	32.55	32.7	23900.0
2022-01-03	ACSI	ETF	53.56	53.6854	53.56	53.6854	392.0
2022-01-03	ACT	ETF	20.73	21.42	20.73	21.23	108468.0
2022-01-03	ACTV	ETF	36.677	36.96	36.66	36.8836	44090.0
2022-01-03	ACVF	ETF	35.63	35.7	35.52	35.7	4700.0
2022-01-03	ACWF	ETF	39.32	39.37	39.08	39.23	51269.0
2022-01-03	ACWI	ETF	106.12	106.36	105.55	106.34	12987500.0
2022-01-03	ACWV	ETF	108.35	108.35	107.21	107.85	207900.0
2022-01-03	ACWX	ETF	55.88	55.96	55.61	55.92	3154242.0
2022-01-03	ADFI	ETF	9.531	9.545	9.531	9.545	300.0
2022-01-03	ADIV	ETF	16.47	16.509	16.47	16.509	200.0
2022-01-03	ADME	ETF	43.33	43.33	43.054	43.25	17100.0
2022-01-03	ADRE	ETF	46.12	46.6299	45.8557	46.45	10541.0
2022-01-03	AESR	ETF	14.06	14.1	14.01	14.084	6700.0
2022-01-03	AFIF	ETF	9.52	9.52	9.5	9.5	6658.0
2022-01-03	AFK	ETF	20.45	20.45	20.155	20.23	7506.0
2022-01-03	AFLG	ETF	27.88	27.98	27.88	27.953	900.0
2022-01-03	AFMC	ETF	26.69	26.75	26.532	26.59	2200.0
2022-01-03	AFSM	ETF	28.16	28.2	27.845	27.887	3500.0
2022-01-03	AFTY	ETF	20.88	20.88	20.851	20.851	500.0
2022-01-03	AGG	ETF	113.67	113.68	113.3	113.3	9399200.0
2022-01-03	AGGY	ETF	51.51	51.51	51.29	51.33	197200.0
2022-01-03	AGNG	ETF	28.64	28.85	28.64	28.85	3400.0
2022-01-03	AGOV	ETF	97.84	97.88	97.65	97.65	1450.0
2022-01-03	AGOX	ETF	25.29	25.47	25.28	25.38	112600.0
2022-01-03	AGQ	ETF	33.08	33.8	32.86	33.55	957600.0
2022-01-03	AGZ	ETF	117.02	117.02	116.82	116.87	58948.0
2022-01-03	AGZD	ETF	23.31	23.405	23.31	23.385	291600.0
2022-01-03	AHHX	ETF	10.47	10.47	10.2	10.3346	271532.0
2022-01-03	AHYB	ETF	50.115	50.115	50.115	50.115	300.0
2022-01-03	AIA	ETF	76.63	77.11	76.2301	76.94	53619.0
2022-01-03	AIEQ	ETF	41.87	41.87	41.05	41.28	26300.0
2022-01-03	AIQ	ETF	31.85	31.91	31.62	31.89	28976.0
2022-01-03	AIRR	ETF	45.29	45.74	44.976	45.23	43400.0
2022-01-03	AIVI	ETF	42.0	42.14	41.97	42.06	23600.0
2022-01-03	ALTL	ETF	46.18	46.7411	46.096	46.49	135380.0
2022-01-03	ALTY	ETF	13.55	13.55	13.39	13.44	29200.0
2022-01-03	AMAX	ETF	9.7	9.71	9.68	9.68	95500.0

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

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