PREVIEW / etf_daily / 2022-07-01

all etf daily files

  file:    by_date/etf_daily/2022/2022-07-01.parquet
  size:    102 KB
  rows:    2,753

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-07-01	SPY	ETF	376.56	381.7	373.8	381.24	74839700.0
2022-07-01	QQQ	ETF	278.95	282.53	277.03	282.13	56675107.0
2022-07-01	IWM	ETF	169.05	171.84	167.66	171.41	24598600.0
2022-07-01	DIA	ETF	307.4	311.31	304.77	310.85	3315000.0
2022-07-01	GLD	ETF	167.14	168.68	166.96	168.32	11380300.0
2022-07-01	TLT	ETF	115.9	117.59	115.22	115.82	21858800.0
2022-07-01	AAA	ETF	24.29	24.3	24.29	24.3	104.0
2022-07-01	AAAU	ETF	17.8	17.97	17.79	17.93	816000.0
2022-07-01	AADR	ETF	48.12	48.57	47.36	48.57	4300.0
2022-07-01	AAXJ	ETF	68.37	68.74	67.96	68.69	855100.0
2022-07-01	ABEQ	ETF	26.84	27.25	26.84	27.25	12400.0
2022-07-01	ACES	ETF	48.46	49.18	48.07	48.84	107000.0
2022-07-01	ACIO	ETF	28.61	29.0	28.61	28.956	14500.0
2022-07-01	ACSI	ETF	42.673	42.673	42.673	42.673	32.0
2022-07-01	ACT	ETF	21.37	21.725	20.71	21.72	161142.0
2022-07-01	ACTV	ETF	30.69	30.83	30.45	30.8263	4315.0
2022-07-01	ACTX	ETF	0.9	0.9	0.9	0.9	202.0
2022-07-01	ACVF	ETF	28.44	28.863	28.44	28.863	900.0
2022-07-01	ACWF	ETF	30.97	31.2052	30.75	31.2052	4962.0
2022-07-01	ACWI	ETF	83.5	84.55	82.93	84.48	3230800.0
2022-07-01	ACWV	ETF	94.56	95.83	94.56	95.77	187500.0
2022-07-01	ACWX	ETF	44.45	44.97	44.23	44.97	1634757.0
2022-07-01	ADFI	ETF	8.83	8.83	8.5	8.577	14300.0
2022-07-01	ADIV	ETF	14.053	14.053	14.053	14.053	100.0
2022-07-01	ADME	ETF	34.47	34.72	34.32	34.7	7400.0
2022-07-01	ADRE	ETF	38.52	38.75	38.1	38.75	7858.0
2022-07-01	AEMB	ETF	38.14	38.14	38.06	38.135	600.0
2022-07-01	AESR	ETF	11.07	11.19	11.01	11.18	24500.0
2022-07-01	AFIF	ETF	8.861	8.8752	8.86	8.8752	9868.0
2022-07-01	AFK	ETF	17.1	17.1	16.77	17.0	4277.0
2022-07-01	AFLG	ETF	22.57	22.787	22.57	22.787	100.0
2022-07-01	AFMC	ETF	21.18	21.181	21.18	21.181	100.0
2022-07-01	AFSM	ETF	21.951	21.951	21.951	21.951	100.0
2022-07-01	AFTY	ETF	19.01	19.11	18.98	19.064	1600.0
2022-07-01	AGG	ETF	102.21	102.79	102.09	102.34	7393100.0
2022-07-01	AGGY	ETF	45.02	45.36	45.02	45.09	178300.0
2022-07-01	AGIH	ETF	25.47	25.47	25.385	25.385	3090.0
2022-07-01	AGNG	ETF	25.25	25.715	25.25	25.704	1100.0
2022-07-01	AGOV	ETF	79.72	80.452	79.72	80.452	776.0
2022-07-01	AGOX	ETF	20.24	20.34	20.0	20.34	68800.0
2022-07-01	AGQ	ETF	22.78	23.6	22.56	23.5	1346200.0
2022-07-01	AGRH	ETF	25.24	25.24	25.2148	25.2148	3569.0
2022-07-01	AGZ	ETF	110.45	110.81	110.34	110.34	17799.0
2022-07-01	AGZD	ETF	22.79	22.865	22.735	22.84	184600.0
2022-07-01	AHHX	ETF	8.45	8.72	8.45	8.5176	10654.0
2022-07-01	AHYB	ETF	42.769	42.769	42.769	42.769	100.0
2022-07-01	AIA	ETF	61.86	62.26	61.39	62.1	112359.0
2022-07-01	AIEQ	ETF	30.19	30.97	30.19	30.907	17200.0
2022-07-01	AIQ	ETF	20.73	20.918	20.54	20.88	11016.0
2022-07-01	AIRR	ETF	37.07	37.6	36.86	37.55	6800.0

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

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