PREVIEW / etf_daily / 2022-01-07

all etf daily files

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

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-07	SPY	ETF	467.95	469.2	464.65	466.09	85111600.0
2022-01-07	QQQ	ETF	384.03	385.76	378.04	379.86	72652304.0
2022-01-07	IWM	ETF	218.6	220.38	215.93	216.07	31583900.0
2022-01-07	DIA	ETF	361.89	363.87	361.13	362.31	5806300.0
2022-01-07	GLD	ETF	167.37	168.01	166.86	167.75	8191900.0
2022-01-07	TLT	ETF	143.13	143.24	141.56	142.26	18756800.0
2022-01-07	AAA	ETF	24.99	25.0	24.99	25.0	1562.0
2022-01-07	AAAU	ETF	17.8	17.88	17.77	17.86	84100.0
2022-01-07	AADR	ETF	63.66	63.66	63.66	63.66	200.0
2022-01-07	AAXJ	ETF	82.44	82.84	82.06	82.73	950300.0
2022-01-07	ABEQ	ETF	28.55	28.8	28.55	28.771	7300.0
2022-01-07	ACES	ETF	59.83	60.835	59.1	59.62	56300.0
2022-01-07	ACIO	ETF	32.04	32.19	31.95	32.07	41800.0
2022-01-07	ACSI	ETF	52.13	52.13	51.9973	51.9973	132.0
2022-01-07	ACT	ETF	21.83	22.3575	21.83	22.24	132694.0
2022-01-07	ACTV	ETF	36.83	36.94	36.675	36.7761	3327.0
2022-01-07	ACTX	ETF	1.42	1.42	1.2	1.2	2901.0
2022-01-07	ACVF	ETF	35.28	35.28	34.78	34.83	19200.0
2022-01-07	ACWF	ETF	38.87	38.901	38.6	38.76	23518.0
2022-01-07	ACWI	ETF	104.44	104.72	103.77	104.28	4589400.0
2022-01-07	ACWV	ETF	105.86	106.33	105.82	106.05	294500.0
2022-01-07	ACWX	ETF	55.38	55.68	55.21	55.6	1694075.0
2022-01-07	ADFI	ETF	9.465	9.47	9.43	9.455	1600.0
2022-01-07	ADIV	ETF	16.5	16.604	16.5	16.604	1800.0
2022-01-07	ADME	ETF	42.2	42.441	42.2	42.22	27100.0
2022-01-07	ADRE	ETF	46.61	47.0251	46.379	46.6633	38262.0
2022-01-07	AEMB	ETF	47.661	47.661	47.661	47.661	100.0
2022-01-07	AESR	ETF	13.83	13.87	13.72	13.761	7600.0
2022-01-07	AFIF	ETF	9.51	9.52	9.5	9.51	20650.0
2022-01-07	AFK	ETF	20.29	20.36	20.24	20.32	4112.0
2022-01-07	AFLG	ETF	27.46	27.46	27.378	27.378	200.0
2022-01-07	AFMC	ETF	26.024	26.03	25.973	25.973	300.0
2022-01-07	AFSM	ETF	27.09	27.11	26.856	26.856	2900.0
2022-01-07	AFTY	ETF	20.466	20.466	20.466	20.466	100.0
2022-01-07	AGG	ETF	112.69	112.71	112.34	112.49	9018900.0
2022-01-07	AGGY	ETF	50.89	50.93	50.76	50.81	230400.0
2022-01-07	AGNG	ETF	27.7	27.815	27.68	27.742	33700.0
2022-01-07	AGOV	ETF	96.95	96.95	96.81	96.81	610.0
2022-01-07	AGOX	ETF	25.2	25.2	24.907	24.91	24800.0
2022-01-07	AGQ	ETF	31.4	32.11	30.94	31.74	1140000.0
2022-01-07	AGZ	ETF	116.08	116.4	116.08	116.35	29119.0
2022-01-07	AGZD	ETF	23.43	23.43	23.355	23.355	102200.0
2022-01-07	AHHX	ETF	10.17	10.21	10.11	10.1704	7155.0
2022-01-07	AHYB	ETF	49.71	49.71	49.675	49.675	300.0
2022-01-07	AIA	ETF	76.66	77.02	76.29	76.82	77259.0
2022-01-07	AIEQ	ETF	39.325	39.69	39.011	39.07	16200.0
2022-01-07	AIQ	ETF	30.37	30.629	30.0102	30.18	86115.0
2022-01-07	AIRR	ETF	45.15	45.348	44.33	44.427	52900.0
2022-01-07	AIVI	ETF	42.3	42.58	42.3	42.57	7100.0
2022-01-07	ALTL	ETF	46.47	46.47	46.09	46.18	339975.0

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

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