PREVIEW / etf_daily / 2022-06-23

all etf daily files

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

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-23	SPY	ETF	376.64	378.83	372.89	378.06	79292100.0
2022-06-23	QQQ	ETF	283.21	285.72	280.31	284.85	57457796.0
2022-06-23	IWM	ETF	168.19	170.23	166.55	169.83	27089800.0
2022-06-23	DIA	ETF	305.67	307.06	302.78	306.74	3582600.0
2022-06-23	GLD	ETF	171.39	172.13	169.9	170.26	6535300.0
2022-06-23	TLT	ETF	113.9	115.17	113.49	114.14	20669200.0
2022-06-23	AAA	ETF	24.395	24.395	24.39	24.39	365.0
2022-06-23	AAAU	ETF	18.25	18.33	18.1	18.14	605700.0
2022-06-23	AADR	ETF	48.48	48.48	47.68	47.83	1500.0
2022-06-23	AAXJ	ETF	68.29	68.66	67.75	68.43	1396400.0
2022-06-23	ABEQ	ETF	26.98	26.98	26.67	26.809	20200.0
2022-06-23	ACES	ETF	49.98	51.42	49.21	51.26	1543500.0
2022-06-23	ACIO	ETF	28.59	28.78	28.46	28.78	38800.0
2022-06-23	ACSI	ETF	42.3475	42.3475	42.3475	42.3475	96.0
2022-06-23	ACT	ETF	20.9	21.4425	20.75	21.01	268022.0
2022-06-23	ACTV	ETF	30.036	30.1295	29.81	30.1295	5657.0
2022-06-23	ACTX	ETF	0.6617	0.7222	0.6617	0.7222	10537.0
2022-06-23	ACVF	ETF	28.46	28.613	28.46	28.613	1300.0
2022-06-23	ACWF	ETF	30.82	30.96	30.725	30.8545	1878.0
2022-06-23	ACWI	ETF	83.62	83.91	82.77	83.76	3691000.0
2022-06-23	ACWV	ETF	93.29	93.97	92.71	93.92	555600.0
2022-06-23	ACWX	ETF	44.56	44.7	44.11	44.54	2855360.0
2022-06-23	ADFI	ETF	8.51	8.51	8.47	8.486	7500.0
2022-06-23	ADIV	ETF	14.1	14.1	14.0	14.07	3200.0
2022-06-23	ADME	ETF	34.48	34.61	34.3	34.58	14600.0
2022-06-23	ADRE	ETF	39.04	39.04	38.5346	38.99	2420.0
2022-06-23	AEMB	ETF	38.46	38.46	38.46	38.46	100.0
2022-06-23	AESR	ETF	11.03	11.04	10.9	11.04	18400.0
2022-06-23	AFIF	ETF	8.895	8.93	8.88	8.9	22956.0
2022-06-23	AFK	ETF	17.04	17.0901	16.79	16.9507	5236.0
2022-06-23	AFLG	ETF	22.578	22.578	22.578	22.578	100.0
2022-06-23	AFMC	ETF	20.752	20.752	20.752	20.752	100.0
2022-06-23	AFSM	ETF	21.611	21.611	21.611	21.611	100.0
2022-06-23	AFTY	ETF	18.353	18.353	18.353	18.353	100.0
2022-06-23	AGG	ETF	101.25	101.76	101.13	101.21	7773900.0
2022-06-23	AGGY	ETF	44.59	44.86	44.49	44.66	88000.0
2022-06-23	AGNG	ETF	24.98	25.2	24.91	25.2	2300.0
2022-06-23	AGOV	ETF	78.78	78.91	78.56	78.91	629.0
2022-06-23	AGOX	ETF	20.42	20.473	20.205	20.388	11500.0
2022-06-23	AGQ	ETF	27.57	27.88	26.29	26.47	948900.0
2022-06-23	AGZ	ETF	109.88	110.1	109.33	109.47	32018.0
2022-06-23	AGZD	ETF	22.84	22.985	22.75	22.9	126400.0
2022-06-23	AHHX	ETF	8.502	8.511	8.41	8.511	10027.0
2022-06-23	AHYB	ETF	43.195	43.195	43.195	43.195	200.0
2022-06-23	AIA	ETF	62.15	62.63	61.68	62.28	21017.0
2022-06-23	AIEQ	ETF	31.04	31.44	30.71	31.359	5900.0
2022-06-23	AIQ	ETF	21.06	21.3	20.91	21.2775	179930.0
2022-06-23	AIRR	ETF	37.07	37.07	36.411	36.807	14700.0
2022-06-23	AIVI	ETF	36.13	36.18	35.88	36.18	7000.0
2022-06-23	AIVL	ETF	87.92	88.52	87.64	88.52	17700.0

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

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