PREVIEW / etf_daily / 2022-09-02

all etf daily files

  file:    by_date/etf_daily/2022/2022-09-02.parquet
  size:    103 KB
  rows:    2,777

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-09-02	SPY	ETF	400.28	401.56	390.33	392.24	99632100.0
2022-09-02	QQQ	ETF	302.34	303.75	293.52	295.17	64666839.0
2022-09-02	IWM	ETF	183.6	183.95	179.14	180.09	27468200.0
2022-09-02	DIA	ETF	319.77	320.75	312.31	313.76	3826200.0
2022-09-02	GLD	ETF	159.35	160.06	159.14	159.26	5196900.0
2022-09-02	TLT	ETF	109.68	110.56	109.47	110.22	13024400.0
2022-09-02	AAA	ETF	24.41	24.41	24.365	24.365	465.0
2022-09-02	AAAU	ETF	16.98	17.06	16.96	16.97	6593800.0
2022-09-02	AADR	ETF	49.34	49.34	49.06	49.06	1000.0
2022-09-02	AAPB	ETF	23.31	23.55	22.47	22.5	9473.0
2022-09-02	AAPD	ETF	25.76	26.51	25.64	26.4116	31823.0
2022-09-02	AAPU	ETF	23.78	23.83	22.66	22.85	29625.0
2022-09-02	AAXJ	ETF	66.05	66.35	65.49	65.59	796700.0
2022-09-02	ABEQ	ETF	26.76	26.767	26.35	26.376	8800.0
2022-09-02	ACES	ETF	62.55	62.55	60.555	60.92	34500.0
2022-09-02	ACIO	ETF	29.917	30.05	29.71	29.74	31300.0
2022-09-02	ACSI	ETF	44.847	44.847	44.847	44.847	63.0
2022-09-02	ACT	ETF	24.99	25.51	24.69	24.83	124539.0
2022-09-02	ACTV	ETF	29.96	29.96	29.3547	29.3547	2472.0
2022-09-02	ACTX	ETF	0.495	0.5	0.495	0.5	554.0
2022-09-02	ACVF	ETF	29.91	30.07	29.372	29.376	16200.0
2022-09-02	ACWF	ETF	32.09	32.18	31.6512	31.6512	2531.0
2022-09-02	ACWI	ETF	86.43	86.72	84.59	84.95	5335900.0
2022-09-02	ACWV	ETF	95.78	95.83	94.01	94.23	160400.0
2022-09-02	ACWX	ETF	44.05	44.315	43.385	43.5	2732491.0
2022-09-02	ADFI	ETF	8.52	8.52	8.49	8.495	17600.0
2022-09-02	ADIV	ETF	13.18	13.23	13.18	13.23	500.0
2022-09-02	ADME	ETF	35.4	35.51	34.97	35.028	8800.0
2022-09-02	ADRE	ETF	38.9	39.19	38.7601	38.78	2054.0
2022-09-02	AEMB	ETF	37.84	38.07	37.71	37.872	6700.0
2022-09-02	AESR	ETF	11.71	11.76	11.47	11.52	18100.0
2022-09-02	AFIF	ETF	8.86	8.94	8.86	8.915	35174.0
2022-09-02	AFK	ETF	16.38	16.55	16.34	16.3692	8988.0
2022-09-02	AFLG	ETF	23.67	23.79	23.26	23.306	1400.0
2022-09-02	AFSM	ETF	22.97	22.97	22.49	22.521	11300.0
2022-09-02	AFTY	ETF	16.51	16.51	16.448	16.448	600.0
2022-09-02	AGG	ETF	100.37	100.67	100.13	100.36	5966800.0
2022-09-02	AGGH	ETF	23.2601	23.45	23.26	23.3814	3019.0
2022-09-02	AGGY	ETF	44.26	44.38	44.22	44.27	96600.0
2022-09-02	AGIH	ETF	25.2341	25.3	25.2341	25.26	200.0
2022-09-02	AGNG	ETF	24.89	24.89	24.36	24.45	1800.0
2022-09-02	AGOV	ETF	81.4461	81.4461	81.4461	81.4461	1.0
2022-09-02	AGOX	ETF	20.96	21.22	20.72	20.8	13300.0
2022-09-02	AGQ	ETF	18.57	19.11	18.26	18.47	1065200.0
2022-09-02	AGZ	ETF	108.87	109.025	108.78	108.78	27238.0
2022-09-02	AGZD	ETF	22.915	22.945	22.825	22.88	72600.0
2022-09-02	AHHX	ETF	8.56	8.6	8.48	8.5385	41753.0
2022-09-02	AHYB	ETF	43.62	43.62	43.191	43.191	100.0
2022-09-02	AIA	ETF	58.03	58.2475	57.34	57.43	30770.0
2022-09-02	AIEQ	ETF	32.88	32.904	32.29	32.384	3700.0

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

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