PREVIEW / etf_daily / 2021-06-22

all etf daily files

  file:    by_date/etf_daily/2021/2021-06-22.parquet
  size:    90 KB
  rows:    2,361

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
2021-06-22	SPY	ETF	420.85	424.0	420.08	423.11	57700300.0
2021-06-22	QQQ	ETF	344.15	348.03	343.84	347.57	28941626.0
2021-06-22	IWM	ETF	226.27	228.41	224.72	227.91	21188500.0
2021-06-22	DIA	ETF	338.73	340.41	337.45	339.45	4042100.0
2021-06-22	GLD	ETF	166.35	166.92	166.01	166.25	7223900.0
2021-06-22	TLT	ETF	142.17	143.68	142.12	143.64	14530200.0
2021-06-22	AAA	ETF	25.0101	25.03	25.0101	25.025	2517.0
2021-06-22	AAAU	ETF	17.69	17.74	17.65	17.68	290600.0
2021-06-22	AADR	ETF	65.29	65.83	65.29	65.83	900.0
2021-06-22	AAXJ	ETF	92.75	92.75	92.09	92.6	1025700.0
2021-06-22	ABEQ	ETF	27.44	27.5	27.405	27.48	3100.0
2021-06-22	ACES	ETF	71.16	72.72	71.16	72.71	59000.0
2021-06-22	ACIO	ETF	29.812	30.01	29.812	29.93	48600.0
2021-06-22	ACSI	ETF	49.3086	49.3086	49.3086	49.3086	166.0
2021-06-22	ACTV	ETF	38.58	38.8979	38.58	38.8979	1855.0
2021-06-22	ACTX	ETF	3.33	3.33	2.85	2.85	697.0
2021-06-22	ACVF	ETF	31.6	31.63	31.488	31.615	1400.0
2021-06-22	ACWF	ETF	37.55	37.719	37.52	37.59	36857.0
2021-06-22	ACWI	ETF	100.11	100.8	99.91	100.65	1620100.0
2021-06-22	ACWV	ETF	102.39	102.72	102.25	102.59	58800.0
2021-06-22	ACWX	ETF	57.31	57.65	57.2	57.55	1111456.0
2021-06-22	ADFI	ETF	9.72	9.73	9.72	9.73	5100.0
2021-06-22	ADIV	ETF	18.6	18.629	18.6	18.629	300.0
2021-06-22	ADME	ETF	39.176	39.44	39.176	39.399	38400.0
2021-06-22	ADRE	ETF	55.33	55.6514	55.33	55.63	6749.0
2021-06-22	AESR	ETF	13.33	13.42	13.33	13.415	4800.0
2021-06-22	AFIF	ETF	9.66	9.73	9.66	9.715	38502.0
2021-06-22	AFK	ETF	21.7	21.789	21.67	21.7281	14820.0
2021-06-22	AFLG	ETF	25.03	25.139	25.03	25.139	200.0
2021-06-22	AFMC	ETF	25.048	25.048	25.048	25.048	100.0
2021-06-22	AFSM	ETF	26.159	26.159	26.159	26.159	100.0
2021-06-22	AFTY	ETF	22.751	22.765	22.751	22.765	2300.0
2021-06-22	AGG	ETF	114.83	115.14	114.83	115.11	6485100.0
2021-06-22	AGGY	ETF	52.05	52.19	52.05	52.19	89400.0
2021-06-22	AGNG	ETF	30.59	30.696	30.579	30.696	2100.0
2021-06-22	AGOX	ETF	26.01	26.01	25.681	25.82	15200.0
2021-06-22	AGQ	ETF	45.04	45.23	44.67	44.78	548000.0
2021-06-22	AGZ	ETF	118.14	118.33	118.14	118.29	30303.0
2021-06-22	AGZD	ETF	23.52	23.535	23.51	23.515	36600.0
2021-06-22	AIA	ETF	88.66	89.2	88.635	89.2	62085.0
2021-06-22	AIEQ	ETF	40.69	41.067	40.52	41.023	32500.0
2021-06-22	AIQ	ETF	29.52	29.999	29.5	29.9748	508483.0
2021-06-22	AIRR	ETF	40.17	40.38	39.771	40.38	16900.0
2021-06-22	AIVI	ETF	43.91	44.1	43.87	44.06	10900.0
2021-06-22	ALTL	ETF	41.09	41.2284	41.04	41.08	16742.0
2021-06-22	ALTY	ETF	13.79	13.79	13.611	13.68	25400.0
2021-06-22	AMJ	ETF	20.12	20.12	19.75	19.93	440080.0
2021-06-22	AMLP	ETF	37.02	37.06	36.45	36.86	1765400.0
2021-06-22	AMNA	ETF	34.24	34.4536	34.24	34.4536	437.0
2021-06-22	AMND	ETF	36.32	36.4983	36.32	36.4983	411.0

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

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