PREVIEW / etf_daily / 2022-08-01

all etf daily files

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

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-01	SPY	ETF	409.15	413.41	408.4	410.77	69997500.0
2022-08-01	QQQ	ETF	313.65	318.81	312.53	315.27	46358833.0
2022-08-01	IWM	ETF	185.79	188.32	184.22	187.18	23905600.0
2022-08-01	DIA	ETF	326.91	329.72	326.45	328.04	2745500.0
2022-08-01	GLD	ETF	164.98	165.41	164.41	165.03	4666900.0
2022-08-01	TLT	ETF	118.25	120.1	118.08	120.04	17974600.0
2022-08-01	AAA	ETF	24.25	24.25	24.25	24.25	1.0
2022-08-01	AAAU	ETF	17.58	17.63	17.52	17.58	1538500.0
2022-08-01	AADR	ETF	50.93	51.22	50.93	51.06	1200.0
2022-08-01	AAXJ	ETF	67.25	67.79	66.95	67.41	882500.0
2022-08-01	ABEQ	ETF	27.05	27.16	27.05	27.141	7400.0
2022-08-01	ACES	ETF	59.5	59.5	58.069	58.87	47500.0
2022-08-01	ACIO	ETF	30.58	30.61	30.46	30.59	32300.0
2022-08-01	ACSI	ETF	46.22	46.2684	46.22	46.2684	797.0
2022-08-01	ACT	ETF	22.91	23.4	22.54	23.24	329719.0
2022-08-01	ACTV	ETF	31.59	31.82	31.52	31.545	11689.0
2022-08-01	ACVF	ETF	30.75	30.946	30.75	30.946	500.0
2022-08-01	ACWF	ETF	33.06	33.1108	33.0485	33.1108	3445.0
2022-08-01	ACWI	ETF	89.23	90.06	89.05	89.53	3610700.0
2022-08-01	ACWV	ETF	97.3	97.9	97.3	97.57	563500.0
2022-08-01	ACWX	ETF	46.3	46.62	46.135	46.36	3057691.0
2022-08-01	ADFI	ETF	8.68	8.77	8.68	8.755	20000.0
2022-08-01	ADIV	ETF	13.67	13.695	13.67	13.695	500.0
2022-08-01	ADME	ETF	36.61	36.72	36.47	36.573	9100.0
2022-08-01	ADRE	ETF	38.62	38.94	38.615	38.84	10118.0
2022-08-01	AEMB	ETF	38.89	38.89	38.89	38.89	700.0
2022-08-01	AESR	ETF	12.41	12.41	11.82	11.93	46400.0
2022-08-01	AFIF	ETF	8.8998	8.91	8.89	8.91	25823.0
2022-08-01	AFK	ETF	17.5	17.5	17.16	17.27	5993.0
2022-08-01	AFLG	ETF	24.15	24.197	24.15	24.197	1800.0
2022-08-01	AFSM	ETF	24.072	24.072	24.072	24.072	100.0
2022-08-01	AFTY	ETF	17.34	17.34	17.287	17.287	1600.0
2022-08-01	AGG	ETF	103.99	104.31	103.91	104.23	7733700.0
2022-08-01	AGGH	ETF	24.07	24.09	24.0431	24.0431	854.0
2022-08-01	AGGY	ETF	46.02	46.22	46.01	46.15	202800.0
2022-08-01	AGNG	ETF	26.03	26.12	26.03	26.07	1100.0
2022-08-01	AGOV	ETF	83.005	83.005	82.9678	82.9678	195.0
2022-08-01	AGOX	ETF	21.53	21.69	21.51	21.607	22200.0
2022-08-01	AGQ	ETF	24.37	24.68	24.18	24.51	902000.0
2022-08-01	AGZ	ETF	111.13	111.35	111.05	111.15	38369.0
2022-08-01	AGZD	ETF	22.845	22.91	22.845	22.905	241400.0
2022-08-01	AHHX	ETF	8.79	8.83	8.7	8.769	6802.0
2022-08-01	AHYB	ETF	44.977	44.977	44.96	44.96	300.0
2022-08-01	AIA	ETF	59.37	59.75	59.02	59.41	217370.0
2022-08-01	AIEQ	ETF	33.77	34.025	33.598	33.85	4900.0
2022-08-01	AIQ	ETF	22.31	22.5832	22.185	22.49	32639.0
2022-08-01	AIRR	ETF	42.97	43.399	42.652	43.39	14000.0
2022-08-01	AIVI	ETF	36.55	36.55	36.5	36.51	1800.0
2022-08-01	AIVL	ETF	93.72	94.56	93.72	94.33	2600.0
2022-08-01	ALTL	ETF	42.55	42.62	42.41	42.54	110167.0

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

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