PREVIEW / etf_daily / 2022-09-19

all etf daily files

  file:    by_date/etf_daily/2022/2022-09-19.parquet
  size:    104 KB
  rows:    2,805

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-19	SPY	ETF	382.26	388.55	382.18	388.55	73278500.0
2022-09-19	QQQ	ETF	286.1	291.21	286.04	291.05	52613831.0
2022-09-19	IWM	ETF	177.01	180.75	176.96	180.52	25412200.0
2022-09-19	DIA	ETF	305.37	310.19	305.29	310.15	2730000.0
2022-09-19	GLD	ETF	154.87	156.04	154.82	155.96	5582800.0
2022-09-19	TLT	ETF	106.96	107.82	106.8	107.32	11084400.0
2022-09-19	AAA	ETF	24.28	24.28	24.28	24.28	2.0
2022-09-19	AAAU	ETF	16.5	16.63	16.5	16.61	1064200.0
2022-09-19	AADR	ETF	47.67	48.04	47.67	48.04	900.0
2022-09-19	AAPB	ETF	21.2	21.9578	21.2	21.9578	5230.0
2022-09-19	AAPD	ETF	27.43	27.43	26.4469	26.4469	33949.0
2022-09-19	AAPU	ETF	21.26	22.44	21.26	22.44	38447.0
2022-09-19	AAXJ	ETF	63.53	64.16	63.53	64.12	837100.0
2022-09-19	ABEQ	ETF	26.31	26.489	26.29	26.489	11800.0
2022-09-19	ACES	ETF	64.43	65.31	64.174	65.06	101500.0
2022-09-19	ACIO	ETF	29.06	29.299	29.06	29.25	75200.0
2022-09-19	ACSI	ETF	44.5	45.1699	44.5	45.1699	554.0
2022-09-19	ACT	ETF	22.9	23.74	22.9	23.69	429827.0
2022-09-19	ACTV	ETF	29.135	29.34	29.07	29.33	5420.0
2022-09-19	ACVF	ETF	28.75	29.209	28.75	29.209	3300.0
2022-09-19	ACWF	ETF	31.43	31.57	31.281	31.57	14819.0
2022-09-19	ACWI	ETF	83.24	84.55	83.23	84.54	5578300.0
2022-09-19	ACWV	ETF	93.46	94.08	93.0	94.05	131600.0
2022-09-19	ACWX	ETF	42.71	43.38	42.71	43.35	3011735.0
2022-09-19	ADFI	ETF	8.31	8.45	8.31	8.42	13200.0
2022-09-19	ADIV	ETF	12.99	13.03	12.99	13.03	600.0
2022-09-19	ADME	ETF	34.28	34.43	34.23	34.43	19200.0
2022-09-19	ADRE	ETF	37.03	37.89	37.03	37.89	1976.0
2022-09-19	AEMB	ETF	37.39	37.49	37.36	37.49	400.0
2022-09-19	AESR	ETF	11.338	11.398	11.312	11.398	3600.0
2022-09-19	AFIF	ETF	8.81	8.83	8.8	8.8	23380.0
2022-09-19	AFK	ETF	16.21	16.24	16.16	16.24	5117.0
2022-09-19	AFLG	ETF	23.13	23.182	23.13	23.182	200.0
2022-09-19	AFMC	ETF	21.78	21.828	21.78	21.828	200.0
2022-09-19	AFSM	ETF	22.08	22.305	22.08	22.305	1900.0
2022-09-19	AFTY	ETF	16.145	16.17	16.145	16.17	1200.0
2022-09-19	AGG	ETF	98.53	98.84	98.48	98.68	5982200.0
2022-09-19	AGGH	ETF	22.98	22.9853	22.93	22.9853	1010.0
2022-09-19	AGGY	ETF	43.49	43.56	43.39	43.505	73800.0
2022-09-19	AGNG	ETF	24.494	24.61	24.494	24.587	500.0
2022-09-19	AGOV	ETF	80.83	80.88	80.2205	80.6142	3148.0
2022-09-19	AGOX	ETF	20.34	20.75	20.34	20.735	13300.0
2022-09-19	AGQ	ETF	21.37	22.06	21.35	22.03	666900.0
2022-09-19	AGZ	ETF	107.72	107.81	107.57	107.57	21586.0
2022-09-19	AGZD	ETF	22.995	22.995	22.9	22.935	49000.0
2022-09-19	AHHX	ETF	8.45	8.4953	8.45	8.4953	3589.0
2022-09-19	AHYB	ETF	43.334	43.334	43.334	43.334	100.0
2022-09-19	AIA	ETF	54.56	55.19	54.56	55.15	22444.0
2022-09-19	AIEQ	ETF	31.61	32.45	31.61	32.369	7200.0
2022-09-19	AIQ	ETF	20.46	20.85	20.46	20.85	12203.0

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

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