PREVIEW / etf_daily / 2022-08-31

all etf daily files

  file:    by_date/etf_daily/2022/2022-08-31.parquet
  size:    104 KB
  rows:    2,784

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-08-31	SPY	ETF	399.93	401.24	395.04	395.18	76029700.0
2022-08-31	QQQ	ETF	303.99	304.91	299.16	299.27	50044041.0
2022-08-31	IWM	ETF	184.94	185.74	183.19	183.5	22412500.0
2022-08-31	DIA	ETF	318.46	320.17	315.6	315.65	2981600.0
2022-08-31	GLD	ETF	159.5	160.57	159.26	159.27	5438600.0
2022-08-31	TLT	ETF	112.69	113.34	111.58	111.88	13623500.0
2022-08-31	AAA	ETF	24.41	24.41	24.41	24.41	1.0
2022-08-31	AAAU	ETF	17.0	17.11	16.97	16.97	1709400.0
2022-08-31	AADR	ETF	49.79	49.79	49.5	49.62	1900.0
2022-08-31	AAPB	ETF	23.48	23.48	22.85	22.85	2223.0
2022-08-31	AAPD	ETF	25.77	26.12	25.6009	26.0972	28146.0
2022-08-31	AAPU	ETF	23.6215	23.87	23.15	23.17	111913.0
2022-08-31	AAXJ	ETF	67.3	67.56	66.91	66.96	680200.0
2022-08-31	ABEQ	ETF	26.41	26.657	26.41	26.45	15100.0
2022-08-31	ACES	ETF	62.87	63.71	62.35	63.11	163800.0
2022-08-31	ACIO	ETF	29.965	29.98	29.84	29.88	70800.0
2022-08-31	ACSI	ETF	45.46	45.477	45.1721	45.1721	657.0
2022-08-31	ACT	ETF	25.46	25.745	25.21	25.4	224310.0
2022-08-31	ACTV	ETF	30.18	30.29	29.84	29.84	8430.0
2022-08-31	ACTX	ETF	0.495	0.5	0.495	0.5	889.0
2022-08-31	ACVF	ETF	29.94	29.94	29.7	29.73	1300.0
2022-08-31	ACWF	ETF	32.111	32.2178	32.0158	32.0158	5383.0
2022-08-31	ACWI	ETF	86.93	87.1	85.9	85.9	2580900.0
2022-08-31	ACWV	ETF	95.5	95.88	94.82	94.82	170300.0
2022-08-31	ACWX	ETF	44.56	44.73	44.27	44.27	3783304.0
2022-08-31	ADFI	ETF	8.53	8.54	8.48	8.485	44700.0
2022-08-31	ADIV	ETF	13.42	13.428	13.42	13.428	500.0
2022-08-31	ADME	ETF	35.51	35.585	35.355	35.36	25000.0
2022-08-31	ADRE	ETF	39.475	39.7	39.19	39.34	21575.0
2022-08-31	AEMB	ETF	38.06	38.06	37.954	37.954	300.0
2022-08-31	AESR	ETF	11.67	11.68	11.6	11.6	16100.0
2022-08-31	AFIF	ETF	8.9	8.91	8.87	8.87	31769.0
2022-08-31	AFK	ETF	16.72	16.8	16.58	16.6426	4186.0
2022-08-31	AFLG	ETF	23.66	23.66	23.506	23.506	900.0
2022-08-31	AFMC	ETF	22.3	22.3	22.216	22.216	100.0
2022-08-31	AFSM	ETF	23.08	23.08	22.949	22.949	100.0
2022-08-31	AFTY	ETF	16.804	16.804	16.804	16.804	100.0
2022-08-31	AGG	ETF	101.04	101.23	100.64	100.71	6116500.0
2022-08-31	AGGH	ETF	23.4456	23.45	23.3499	23.3499	34858.0
2022-08-31	AGGY	ETF	44.59	44.648	44.405	44.45	139500.0
2022-08-31	AGNG	ETF	24.83	24.84	24.51	24.51	3200.0
2022-08-31	AGOV	ETF	81.0918	81.0918	81.0918	81.0918	75.0
2022-08-31	AGOX	ETF	21.23	21.256	21.078	21.131	19300.0
2022-08-31	AGQ	ETF	18.76	19.02	18.49	18.5	1304200.0
2022-08-31	AGZ	ETF	109.25	109.37	109.09	109.21	25167.0
2022-08-31	AGZD	ETF	22.875	23.0	22.875	22.93	20400.0
2022-08-31	AHHX	ETF	8.575	8.575	8.51	8.54	25037.0
2022-08-31	AHYB	ETF	43.31	43.319	43.11	43.319	2500.0
2022-08-31	AIA	ETF	59.54	59.75	59.03	59.2	1027284.0
2022-08-31	AIEQ	ETF	33.53	33.61	33.375	33.381	5100.0

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

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