PREVIEW / etf_daily / 2022-01-20

all etf daily files

  file:    by_date/etf_daily/2022/2022-01-20.parquet
  size:    100 KB
  rows:    2,649

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-20	SPY	ETF	453.75	458.74	444.5	446.75	122379700.0
2022-01-20	QQQ	ETF	369.79	373.87	361.17	361.72	88610680.0
2022-01-20	IWM	ETF	205.38	208.99	200.33	200.75	50466000.0
2022-01-20	DIA	ETF	351.48	355.05	346.81	347.33	8968700.0
2022-01-20	GLD	ETF	172.31	172.6	171.59	171.65	9570500.0
2022-01-20	TLT	ETF	141.37	141.99	141.09	141.94	13959000.0
2022-01-20	AAA	ETF	24.999	25.0	24.99	25.0	3024.0
2022-01-20	AAAU	ETF	18.34	18.37	18.26	18.28	110400.0
2022-01-20	AADR	ETF	63.5	63.5	62.34	62.34	3700.0
2022-01-20	AAXJ	ETF	84.84	85.3	83.82	84.0	2305300.0
2022-01-20	ABEQ	ETF	28.41	28.84	28.381	28.381	32300.0
2022-01-20	ACES	ETF	55.42	57.23	54.45	54.56	58600.0
2022-01-20	ACIO	ETF	31.69	31.79	31.216	31.32	45300.0
2022-01-20	ACSI	ETF	50.75	50.75	49.782	49.782	439.0
2022-01-20	ACT	ETF	21.76	21.94	21.02	21.19	204391.0
2022-01-20	ACTV	ETF	35.97	35.97	34.92	34.92	5203.0
2022-01-20	ACVF	ETF	33.9	34.33	33.477	33.477	2600.0
2022-01-20	ACWF	ETF	38.11	38.35	37.4603	37.4603	25422.0
2022-01-20	ACWI	ETF	102.64	103.58	101.19	101.24	10613600.0
2022-01-20	ACWV	ETF	104.7	105.39	103.79	103.84	252700.0
2022-01-20	ACWX	ETF	55.76	56.02	55.145	55.15	5680981.0
2022-01-20	ADFI	ETF	9.42	9.42	9.39	9.393	36400.0
2022-01-20	ADIV	ETF	16.6	16.6	16.537	16.537	300.0
2022-01-20	ADME	ETF	41.69	41.83	40.98	41.04	28500.0
2022-01-20	ADRE	ETF	49.22	49.3435	48.14	48.3044	8888.0
2022-01-20	AESR	ETF	13.45	13.54	13.155	13.155	66000.0
2022-01-20	AFIF	ETF	9.5	9.51	9.49	9.5	75804.0
2022-01-20	AFK	ETF	21.0	21.33	20.79	20.79	22505.0
2022-01-20	AFLG	ETF	26.855	26.855	26.176	26.176	1800.0
2022-01-20	AFMC	ETF	24.565	24.565	24.565	24.565	100.0
2022-01-20	AFSM	ETF	25.795	25.795	24.883	24.883	600.0
2022-01-20	AFTY	ETF	20.76	20.83	20.716	20.716	6300.0
2022-01-20	AGG	ETF	111.84	111.9	111.75	111.79	7186400.0
2022-01-20	AGGY	ETF	50.38	50.41	50.357	50.4	120200.0
2022-01-20	AGNG	ETF	27.34	27.56	27.1	27.1	4800.0
2022-01-20	AGOV	ETF	96.8483	96.8483	96.8483	96.8483	1.0
2022-01-20	AGOX	ETF	24.26	24.64	23.96	23.98	31900.0
2022-01-20	AGQ	ETF	38.34	38.91	38.0	38.14	1451200.0
2022-01-20	AGZ	ETF	115.76	116.06	115.76	116.06	42139.0
2022-01-20	AGZD	ETF	23.305	23.32	23.275	23.275	46400.0
2022-01-20	AHHX	ETF	10.07	10.12	10.01	10.085	28767.0
2022-01-20	AHYB	ETF	49.394	49.394	49.394	49.394	200.0
2022-01-20	AIA	ETF	80.08	80.695	79.1169	79.17	131682.0
2022-01-20	AIEQ	ETF	37.0	37.649	36.42	36.42	16600.0
2022-01-20	AIQ	ETF	29.37	29.6953	28.795	28.83	17326.0
2022-01-20	AIRR	ETF	42.17	42.819	41.19	41.2	31200.0
2022-01-20	AIVI	ETF	42.71	43.03	42.4	42.4	8300.0
2022-01-20	AIVL	ETF	99.66	100.92	98.87	98.95	58900.0
2022-01-20	ALTL	ETF	45.1	45.43	44.65	44.7	140753.0
2022-01-20	ALTY	ETF	13.28	13.33	13.16	13.18	64300.0

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

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