PREVIEW / etf_daily / 2022-06-29

all etf daily files

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

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-29	SPY	ETF	381.23	382.27	378.42	380.34	65676000.0
2022-06-29	QQQ	ETF	283.4	285.34	280.84	283.8	57302726.0
2022-06-29	IWM	ETF	172.55	172.7	168.97	170.69	21292500.0
2022-06-29	DIA	ETF	310.4	311.48	308.83	310.05	2462800.0
2022-06-29	GLD	ETF	170.58	170.7	169.17	169.49	4785600.0
2022-06-29	TLT	ETF	112.38	113.9	112.17	113.87	12925400.0
2022-06-29	AAA	ETF	24.38	24.4	24.38	24.38	617.0
2022-06-29	AAAU	ETF	18.17	18.19	18.02	18.07	1273000.0
2022-06-29	AADR	ETF	49.36	49.36	48.94	48.94	1600.0
2022-06-29	AAXJ	ETF	69.3	69.56	69.1	69.37	633800.0
2022-06-29	ABEQ	ETF	27.13	27.19	27.02	27.028	82700.0
2022-06-29	ACES	ETF	49.16	49.18	47.48	48.21	291400.0
2022-06-29	ACIO	ETF	28.89	29.09	28.89	29.03	59400.0
2022-06-29	ACSI	ETF	42.6834	42.6834	42.6834	42.6834	27.0
2022-06-29	ACT	ETF	21.44	21.44	20.81	20.93	206110.0
2022-06-29	ACTV	ETF	30.54	30.6314	30.4045	30.6314	7817.0
2022-06-29	ACTX	ETF	0.8	0.8	0.8	0.8	739.0
2022-06-29	ACVF	ETF	28.69	28.767	28.65	28.767	1000.0
2022-06-29	ACWF	ETF	31.47	31.47	31.23	31.32	6223.0
2022-06-29	ACWI	ETF	84.87	85.03	84.26	84.56	3589900.0
2022-06-29	ACWV	ETF	94.45	95.2	94.45	94.9	238800.0
2022-06-29	ACWX	ETF	45.47	45.5	45.16	45.2	2658715.0
2022-06-29	ADFI	ETF	8.46	8.48	8.46	8.474	38000.0
2022-06-29	ADIV	ETF	14.19	14.2	14.19	14.2	800.0
2022-06-29	ADME	ETF	34.85	34.85	34.67	34.74	28800.0
2022-06-29	ADRE	ETF	39.56	39.56	39.24	39.5	6368.0
2022-06-29	AEMB	ETF	37.65	37.893	37.65	37.893	200.0
2022-06-29	AESR	ETF	11.15	11.21	11.051	11.14	78900.0
2022-06-29	AFIF	ETF	8.87	8.89	8.87	8.885	6667.0
2022-06-29	AFK	ETF	17.23	17.34	17.07	17.08	4061.0
2022-06-29	AFLG	ETF	22.71	22.765	22.71	22.765	100.0
2022-06-29	AFMC	ETF	20.94	21.069	20.94	21.069	3900.0
2022-06-29	AFSM	ETF	21.73	21.875	21.73	21.875	7500.0
2022-06-29	AFTY	ETF	18.7	18.72	18.69	18.709	900.0
2022-06-29	AGG	ETF	100.8	101.24	100.68	101.22	7326500.0
2022-06-29	AGGY	ETF	44.32	44.53	44.281	44.5	355300.0
2022-06-29	AGNG	ETF	25.43	25.448	25.144	25.448	7500.0
2022-06-29	AGOV	ETF	78.12	78.7	78.12	78.7	1192.0
2022-06-29	AGOX	ETF	20.87	20.87	20.37	20.41	131700.0
2022-06-29	AGQ	ETF	26.14	26.19	25.45	25.81	696500.0
2022-06-29	AGZ	ETF	109.12	109.7	109.12	109.63	18332.0
2022-06-29	AGZD	ETF	22.92	22.99	22.785	22.835	56400.0
2022-06-29	AHHX	ETF	8.46	8.46	8.35	8.401	36466.0
2022-06-29	AHYB	ETF	42.53	42.628	42.53	42.57	1000.0
2022-06-29	AIA	ETF	63.27	63.45	62.95	63.29	51353.0
2022-06-29	AIEQ	ETF	30.98	30.98	30.46	30.73	13100.0
2022-06-29	AIQ	ETF	21.21	21.29	20.63	21.13	18309.0
2022-06-29	AIRR	ETF	37.03	37.185	36.67	36.81	15600.0
2022-06-29	AIVI	ETF	36.24	36.24	35.8	35.8	38000.0
2022-06-29	AIVL	ETF	89.67	89.67	88.71	89.21	6500.0

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

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