PREVIEW / etf_daily / 2022-06-02

all etf daily files

  file:    by_date/etf_daily/2022/2022-06-02.parquet
  size:    102 KB
  rows:    2,736

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-06-02	SPY	ETF	409.42	417.44	407.04	417.39	79609600.0
2022-06-02	QQQ	ETF	304.85	314.56	303.4001	314.38	59291333.0
2022-06-02	IWM	ETF	184.59	188.76	184.17	188.76	24876000.0
2022-06-02	DIA	ETF	328.55	332.78	325.36	332.77	3718800.0
2022-06-02	GLD	ETF	173.66	174.45	173.49	174.35	5623100.0
2022-06-02	TLT	ETF	116.63	116.71	115.46	116.28	9832000.0
2022-06-02	AAA	ETF	24.405	24.405	24.405	24.405	25.0
2022-06-02	AAAU	ETF	18.49	18.58	18.48	18.57	743700.0
2022-06-02	AADR	ETF	56.96	57.03	56.68	57.03	1800.0
2022-06-02	AAXJ	ETF	71.33	72.49	71.29	72.49	2624200.0
2022-06-02	ABEQ	ETF	28.9	29.18	28.9	29.18	8000.0
2022-06-02	ACES	ETF	52.03	54.73	51.84	54.52	98500.0
2022-06-02	ACIO	ETF	29.88	30.27	29.82	30.27	29100.0
2022-06-02	ACSI	ETF	45.9373	45.9373	45.9373	45.9373	90.0
2022-06-02	ACT	ETF	24.26	24.72	23.97	24.68	341614.0
2022-06-02	ACTV	ETF	32.72	33.312	32.72	33.312	4724.0
2022-06-02	ACTX	ETF	0.72	0.75	0.72	0.75	1338.0
2022-06-02	ACVF	ETF	30.78	31.478	30.72	31.478	6100.0
2022-06-02	ACWF	ETF	34.4	34.9282	34.31	34.9282	10238.0
2022-06-02	ACWI	ETF	91.69	93.31	91.3	93.3	2553600.0
2022-06-02	ACWV	ETF	98.99	99.45	97.9	99.37	195000.0
2022-06-02	ACWX	ETF	49.43	50.185	49.37	50.17	1556759.0
2022-06-02	ADFI	ETF	8.735	8.75	8.72	8.745	20100.0
2022-06-02	ADIV	ETF	14.999	14.999	14.999	14.999	200.0
2022-06-02	ADME	ETF	37.22	37.945	37.11	37.92	49300.0
2022-06-02	ADRE	ETF	41.88	42.08	41.88	42.08	2553.0
2022-06-02	AEMB	ETF	40.52	40.888	40.52	40.888	1500.0
2022-06-02	AESR	ETF	12.13	12.34	12.13	12.34	39500.0
2022-06-02	AFIF	ETF	9.05	9.07	9.05	9.07	44912.0
2022-06-02	AFK	ETF	19.16	19.33	19.0948	19.33	10511.0
2022-06-02	AFLG	ETF	24.8	24.956	24.8	24.956	100.0
2022-06-02	AFMC	ETF	23.706	23.706	23.706	23.706	100.0
2022-06-02	AFSM	ETF	24.603	24.603	24.603	24.603	100.0
2022-06-02	AFTY	ETF	17.4	17.434	17.39	17.434	700.0
2022-06-02	AGG	ETF	103.06	103.09	102.73	102.99	7456800.0
2022-06-02	AGGH	ETF	23.6701	23.8	23.6701	23.7897	657.0
2022-06-02	AGGY	ETF	45.71	45.71	45.52	45.6	83700.0
2022-06-02	AGNG	ETF	25.66	26.04	25.5	26.04	3500.0
2022-06-02	AGOV	ETF	80.5	81.5	79.8667	80.3662	3237.0
2022-06-02	AGOX	ETF	22.28	22.66	22.275	22.66	13200.0
2022-06-02	AGQ	ETF	29.66	30.37	29.63	30.33	566000.0
2022-06-02	AGZ	ETF	110.51	110.5483	110.44	110.53	11684.0
2022-06-02	AGZD	ETF	23.045	23.08	23.035	23.065	50000.0
2022-06-02	AHHX	ETF	9.1954	9.26	9.1954	9.2587	1312.0
2022-06-02	AHYB	ETF	45.685	45.785	45.68	45.785	900.0
2022-06-02	AIA	ETF	65.35	66.56	65.28	66.53	115734.0
2022-06-02	AIEQ	ETF	34.18	34.887	34.18	34.85	3700.0
2022-06-02	AIQ	ETF	22.57	23.42	22.57	23.42	57014.0
2022-06-02	AIRR	ETF	40.52	41.23	40.52	41.16	5500.0
2022-06-02	AIVI	ETF	39.55	39.97	39.46	39.97	7900.0

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

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