PREVIEW / etf_daily / 2022-01-04

all etf daily files

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

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-04	SPY	ETF	479.22	479.98	475.58	477.55	71178700.0
2022-01-04	QQQ	ETF	402.24	402.28	393.288	396.47	58027206.0
2022-01-04	IWM	ETF	226.0	227.13	223.38	224.98	22013100.0
2022-01-04	DIA	ETF	367.34	369.21	367.21	367.87	5462200.0
2022-01-04	GLD	ETF	168.9	169.72	168.73	169.57	6965600.0
2022-01-04	TLT	ETF	143.61	144.13	142.74	143.7	21996400.0
2022-01-04	AAA	ETF	25.0001	25.0001	25.0001	25.0001	3.0
2022-01-04	AAAU	ETF	17.97	18.05	17.96	18.05	79200.0
2022-01-04	AADR	ETF	64.29	64.39	64.12	64.39	1700.0
2022-01-04	AAXJ	ETF	83.32	83.43	82.77	82.95	1060600.0
2022-01-04	ABEQ	ETF	28.52	28.64	28.52	28.601	3000.0
2022-01-04	ACES	ETF	65.73	65.903	63.4	64.13	31200.0
2022-01-04	ACIO	ETF	32.76	32.79	32.585	32.65	105900.0
2022-01-04	ACSI	ETF	53.5948	53.5948	53.5948	53.5948	106.0
2022-01-04	ACT	ETF	21.27	21.8	21.23	21.68	116964.0
2022-01-04	ACTV	ETF	37.315	37.42	37.25	37.3366	9111.0
2022-01-04	ACTX	ETF	1.4	1.4	1.4	1.4	255.0
2022-01-04	ACVF	ETF	35.81	35.858	35.543	35.735	11300.0
2022-01-04	ACWF	ETF	39.33	39.45	39.2056	39.3696	20318.0
2022-01-04	ACWI	ETF	106.73	106.78	105.89	106.25	9016100.0
2022-01-04	ACWV	ETF	107.66	107.89	107.49	107.59	163000.0
2022-01-04	ACWX	ETF	56.1879	56.245	55.92	56.02	1313417.0
2022-01-04	ADFI	ETF	9.54	9.54	9.52	9.54	11000.0
2022-01-04	ADIV	ETF	16.611	16.635	16.6	16.635	700.0
2022-01-04	ADME	ETF	43.4	43.4	43.099	43.16	19800.0
2022-01-04	ADRE	ETF	46.52	46.5501	45.9297	46.33	16024.0
2022-01-04	AEMB	ETF	48.07	48.07	48.01	48.056	4300.0
2022-01-04	AESR	ETF	14.1	14.13	14.02	14.076	73100.0
2022-01-04	AFIF	ETF	9.55	9.56	9.54	9.5501	138910.0
2022-01-04	AFK	ETF	20.12	20.275	20.11	20.17	7908.0
2022-01-04	AFLG	ETF	28.09	28.09	28.039	28.039	100.0
2022-01-04	AFMC	ETF	26.71	26.761	26.71	26.761	300.0
2022-01-04	AFSM	ETF	27.96	27.96	27.948	27.948	100.0
2022-01-04	AFTY	ETF	20.78	20.78	20.677	20.677	200.0
2022-01-04	AGG	ETF	113.22	113.3	113.08	113.29	7772100.0
2022-01-04	AGGY	ETF	51.17	51.23	51.03	51.2	212200.0
2022-01-04	AGNG	ETF	28.84	28.84	28.56	28.72	4400.0
2022-01-04	AGOV	ETF	97.45	97.665	97.34	97.37	1866.0
2022-01-04	AGOX	ETF	25.42	25.69	25.397	25.52	33000.0
2022-01-04	AGQ	ETF	33.73	34.17	33.61	34.03	587500.0
2022-01-04	AGZ	ETF	116.81	116.88	116.71	116.88	20496.0
2022-01-04	AGZD	ETF	23.425	23.425	23.35	23.36	46200.0
2022-01-04	AHHX	ETF	10.34	10.36	10.26	10.3047	2920.0
2022-01-04	AHYB	ETF	50.05	50.06	50.05	50.06	300.0
2022-01-04	AIA	ETF	77.2	77.2899	76.62	76.96	60352.0
2022-01-04	AIEQ	ETF	41.34	41.42	40.51	40.74	76900.0
2022-01-04	AIQ	ETF	31.89	31.915	31.065	31.39	34916.0
2022-01-04	AIRR	ETF	45.54	46.08	45.54	45.99	171400.0
2022-01-04	AIVI	ETF	42.17	42.58	42.17	42.47	12000.0
2022-01-04	ALTL	ETF	46.74	46.83	46.49	46.65	181196.0

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

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