PREVIEW / etf_daily / 2022-04-20

all etf daily files

  file:    by_date/etf_daily/2022/2022-04-20.parquet
  size:    101 KB
  rows:    2,713

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-04-20	SPY	ETF	446.92	447.57	443.48	444.71	65224400.0
2022-04-20	QQQ	ETF	347.09	347.56	339.96	341.21	65500022.0
2022-04-20	IWM	ETF	203.05	203.87	201.86	202.33	20516200.0
2022-04-20	DIA	ETF	351.06	353.07	350.28	351.53	5677000.0
2022-04-20	GLD	ETF	181.59	182.72	181.35	182.71	7038600.0
2022-04-20	TLT	ETF	120.22	121.97	119.92	121.65	31423200.0
2022-04-20	AAA	ETF	24.875	24.875	24.875	24.875	156.0
2022-04-20	AAAU	ETF	19.35	19.45	19.32	19.45	525400.0
2022-04-20	AADR	ETF	58.91	58.99	57.23	57.23	1400.0
2022-04-20	AAXJ	ETF	72.89	72.89	72.13	72.24	1227300.0
2022-04-20	ABEQ	ETF	30.24	30.27	30.23	30.267	8300.0
2022-04-20	ACES	ETF	58.16	58.16	56.13	56.21	31500.0
2022-04-20	ACIO	ETF	31.38	31.47	31.29	31.368	55100.0
2022-04-20	ACSI	ETF	50.22	50.22	50.0578	50.0578	222.0
2022-04-20	ACT	ETF	23.81	24.79	23.81	24.7	220832.0
2022-04-20	ACTV	ETF	35.91	35.92	35.7	35.7074	10790.0
2022-04-20	ACTX	ETF	0.97	0.97	0.95	0.95	2205.0
2022-04-20	ACVF	ETF	33.57	33.59	33.4	33.436	6000.0
2022-04-20	ACWF	ETF	36.68	36.79	36.58	36.6	20284.0
2022-04-20	ACWI	ETF	98.55	98.57	97.78	98.07	1896400.0
2022-04-20	ACWV	ETF	105.46	105.8	105.14	105.43	132800.0
2022-04-20	ACWX	ETF	51.33	51.355	51.06	51.19	1796527.0
2022-04-20	ADFI	ETF	8.83	8.83	8.79	8.807	18100.0
2022-04-20	ADIV	ETF	15.212	15.212	15.212	15.212	100.0
2022-04-20	ADME	ETF	40.38	40.38	40.19	40.19	34000.0
2022-04-20	ADRE	ETF	41.8	41.8	41.23	41.23	10847.0
2022-04-20	AEMB	ETF	41.947	41.947	41.947	41.947	100.0
2022-04-20	AESR	ETF	13.28	13.39	13.23	13.325	234900.0
2022-04-20	AFIF	ETF	9.26	9.28	9.26	9.27	197998.0
2022-04-20	AFK	ETF	21.2	21.2	20.88	20.97	11474.0
2022-04-20	AFLG	ETF	26.84	26.9	26.8	26.801	700.0
2022-04-20	AFMC	ETF	24.96	24.96	24.96	24.96	100.0
2022-04-20	AFSM	ETF	25.836	25.836	25.836	25.836	100.0
2022-04-20	AFTY	ETF	17.7	17.701	17.69	17.701	1100.0
2022-04-20	AGG	ETF	103.36	103.74	103.3	103.61	8460900.0
2022-04-20	AGGY	ETF	45.84	45.98	45.818	45.95	120500.0
2022-04-20	AGNG	ETF	29.04	29.04	28.86	28.927	3300.0
2022-04-20	AGOV	ETF	81.48	81.48	81.48	81.48	57.0
2022-04-20	AGOX	ETF	23.6	23.6	23.37	23.37	36100.0
2022-04-20	AGQ	ETF	38.94	39.56	38.83	39.53	475600.0
2022-04-20	AGZ	ETF	110.779	111.13	110.779	111.13	47234.0
2022-04-20	AGZD	ETF	23.1	23.14	23.065	23.09	82600.0
2022-04-20	AHHX	ETF	9.25	9.25	9.21	9.222	13843.0
2022-04-20	AHYB	ETF	46.559	46.559	46.46	46.46	500.0
2022-04-20	AIA	ETF	65.66	65.71	64.96	65.07	49430.0
2022-04-20	AIEQ	ETF	36.76	36.76	36.592	36.65	6600.0
2022-04-20	AIQ	ETF	25.31	25.31	24.76	24.83	17228.0
2022-04-20	AIRR	ETF	41.74	42.138	41.67	41.82	104800.0
2022-04-20	AIVI	ETF	40.04	40.14	40.02	40.06	5200.0
2022-04-20	AIVL	ETF	100.04	101.32	100.04	100.86	10400.0

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

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