PREVIEW / etf_daily / 2022-01-05

all etf daily files

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

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-05	SPY	ETF	477.16	477.98	468.28	468.38	104538900.0
2022-01-05	QQQ	ETF	394.74	395.89	384.03	384.29	75739847.0
2022-01-05	IWM	ETF	224.87	225.91	217.32	217.36	40582100.0
2022-01-05	DIA	ETF	367.71	369.5	363.98	364.09	7638000.0
2022-01-05	GLD	ETF	170.62	170.93	168.9	169.06	8715600.0
2022-01-05	TLT	ETF	144.14	144.16	142.71	142.92	20911700.0
2022-01-05	AAA	ETF	25.0	25.0	24.999	25.0	12292.0
2022-01-05	AAAU	ETF	18.16	18.18	17.98	18.0	165400.0
2022-01-05	AADR	ETF	64.5	64.53	63.35	63.35	5900.0
2022-01-05	AAXJ	ETF	82.29	82.93	81.55	81.57	1613200.0
2022-01-05	ABEQ	ETF	28.795	28.795	28.52	28.52	800.0
2022-01-05	ACES	ETF	63.99	63.99	60.63	60.69	77600.0
2022-01-05	ACIO	ETF	32.44	32.599	32.24	32.24	60000.0
2022-01-05	ACSI	ETF	53.56	53.56	52.6652	52.6652	191.0
2022-01-05	ACT	ETF	21.68	22.07	21.56	21.71	141633.0
2022-01-05	ACTV	ETF	37.3309	37.45	36.685	36.6878	8320.0
2022-01-05	ACVF	ETF	35.75	35.75	35.05	35.05	25600.0
2022-01-05	ACWF	ETF	39.45	39.58	38.8476	38.8476	7552.0
2022-01-05	ACWI	ETF	106.31	106.44	104.47	104.52	6835700.0
2022-01-05	ACWV	ETF	107.55	107.95	106.58	106.58	153100.0
2022-01-05	ACWX	ETF	56.13	56.26	55.41	55.41	3377874.0
2022-01-05	ADFI	ETF	9.495	9.51	9.495	9.5	6100.0
2022-01-05	ADIV	ETF	16.68	16.68	16.55	16.553	1400.0
2022-01-05	ADME	ETF	43.27	43.27	42.43	42.44	51500.0
2022-01-05	ADRE	ETF	46.0	46.69	45.45	45.48	30475.0
2022-01-05	AEMB	ETF	47.639	47.639	47.639	47.639	100.0
2022-01-05	AESR	ETF	14.06	14.07	13.807	13.807	11700.0
2022-01-05	AFIF	ETF	9.56	9.56	9.52	9.53	20268.0
2022-01-05	AFK	ETF	20.3	20.4502	20.08	20.13	10511.0
2022-01-05	AFLG	ETF	28.03	28.03	27.558	27.558	1100.0
2022-01-05	AFMC	ETF	26.16	26.16	26.144	26.144	200.0
2022-01-05	AFSM	ETF	27.9	27.9	27.124	27.124	100.0
2022-01-05	AFTY	ETF	20.8	20.8	20.548	20.548	500.0
2022-01-05	AGG	ETF	113.34	113.36	112.9	112.94	8530900.0
2022-01-05	AGGY	ETF	51.26	51.26	51.05	51.05	80800.0
2022-01-05	AGNG	ETF	28.61	28.61	28.176	28.176	2100.0
2022-01-05	AGOV	ETF	97.1	97.1	96.95	96.95	1010.0
2022-01-05	AGOX	ETF	25.74	25.74	25.0	25.06	45600.0
2022-01-05	AGQ	ETF	34.3	34.62	33.03	33.03	845100.0
2022-01-05	AGZ	ETF	116.73	116.8253	116.58	116.63	26359.0
2022-01-05	AGZD	ETF	23.44	23.44	23.335	23.38	97600.0
2022-01-05	AHHX	ETF	10.35	10.35	10.25	10.285	5855.0
2022-01-05	AHYB	ETF	50.04	50.04	49.865	49.865	400.0
2022-01-05	AIA	ETF	75.9	76.62	75.26	75.42	95305.0
2022-01-05	AIEQ	ETF	40.57	40.57	39.32	39.32	31600.0
2022-01-05	AIQ	ETF	31.1	31.219	30.29	30.31	23618.0
2022-01-05	AIRR	ETF	46.09	46.35	44.85	44.85	35800.0
2022-01-05	AIVI	ETF	42.67	42.79	42.32	42.32	6900.0
2022-01-05	ALTL	ETF	46.76	46.83	46.28	46.33	288807.0
2022-01-05	ALTY	ETF	13.43	13.48	13.36	13.36	16100.0

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

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