PREVIEW / etf_daily / 2021-04-28

all etf daily files

  file:    by_date/etf_daily/2021/2021-04-28.parquet
  size:    88 KB
  rows:    2,330

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-04-28	SPY	ETF	417.81	419.01	416.9	417.4	51238900.0
2021-04-28	QQQ	ETF	339.81	340.85	338.3301	339.0	33615696.0
2021-04-28	IWM	ETF	228.08	229.49	227.1	228.84	16222700.0
2021-04-28	DIA	ETF	339.23	339.49	338.06	338.37	3025100.0
2021-04-28	GLD	ETF	165.75	166.96	165.49	166.91	6932200.0
2021-04-28	TLT	ETF	138.65	138.89	137.96	138.73	15263700.0
2021-04-28	AAA	ETF	25.03	25.125	25.02	25.04	8595.0
2021-04-28	AAAU	ETF	17.62	17.74	17.59	17.74	419300.0
2021-04-28	AADR	ETF	66.46	66.92	66.46	66.74	1700.0
2021-04-28	AAXJ	ETF	95.1	95.68	94.81	95.28	860600.0
2021-04-28	ABEQ	ETF	27.304	27.331	27.304	27.325	800.0
2021-04-28	ACES	ETF	76.0	76.088	75.014	75.71	54100.0
2021-04-28	ACIO	ETF	29.56	29.72	29.56	29.64	19500.0
2021-04-28	ACSI	ETF	48.65	48.65	48.5034	48.5034	702.0
2021-04-28	ACTV	ETF	37.47	37.85	37.45	37.4681	9361.0
2021-04-28	ACTX	ETF	4.0	4.0	4.0	4.0	891.0
2021-04-28	ACVF	ETF	31.0	31.1	31.0	31.037	7100.0
2021-04-28	ACWF	ETF	38.04	38.06	37.921	37.9792	3665.0
2021-04-28	ACWI	ETF	99.74	100.18	99.59	99.88	1898300.0
2021-04-28	ACWV	ETF	101.47	101.56	101.15	101.32	481600.0
2021-04-28	ACWX	ETF	57.2	57.55	57.15	57.43	540372.0
2021-04-28	ADFI	ETF	9.68	9.69	9.68	9.689	900.0
2021-04-28	ADIV	ETF	20.54	20.59	19.025	19.025	700.0
2021-04-28	ADME	ETF	38.69	38.9	38.69	38.779	71200.0
2021-04-28	ADRE	ETF	58.31	58.75	58.17	58.6	36826.0
2021-04-28	AESR	ETF	13.25	13.27	13.236	13.236	2800.0
2021-04-28	AFIF	ETF	9.705	9.72	9.67	9.6801	18810.0
2021-04-28	AFK	ETF	22.07	22.11	21.99	22.09	10604.0
2021-04-28	AFLG	ETF	24.99	25.024	24.971	24.971	5200.0
2021-04-28	AFMC	ETF	25.56	25.57	25.508	25.508	2700.0
2021-04-28	AFSM	ETF	26.268	26.28	26.23	26.23	2500.0
2021-04-28	AFTY	ETF	22.85	22.91	22.845	22.845	1400.0
2021-04-28	AGG	ETF	114.45	114.47	114.2	114.43	7078600.0
2021-04-28	AGGY	ETF	51.6	51.68	51.53	51.63	103000.0
2021-04-28	AGNG	ETF	29.01	29.285	29.01	29.255	4700.0
2021-04-28	AGQ	ETF	46.3	47.41	45.76	47.41	797200.0
2021-04-28	AGZ	ETF	118.09	118.39	117.96	118.15	131188.0
2021-04-28	AGZD	ETF	23.59	23.59	23.525	23.54	76600.0
2021-04-28	AIA	ETF	93.94	94.41	93.7	94.31	161485.0
2021-04-28	AIEQ	ETF	39.87	40.08	39.65	39.78	14400.0
2021-04-28	AIQ	ETF	29.93	30.05	29.84	29.86	20546.0
2021-04-28	AIRR	ETF	41.93	41.99	41.6	41.84	280600.0
2021-04-28	AIVI	ETF	43.59	43.65	43.53	43.58	4600.0
2021-04-28	ALTL	ETF	40.7717	41.03	40.71	40.9012	14396.0
2021-04-28	ALTY	ETF	13.33	13.34	13.277	13.33	15100.0
2021-04-28	AMJ	ETF	17.5	17.95	17.5	17.95	456314.0
2021-04-28	AMLP	ETF	32.48	33.24	32.48	33.24	3529200.0
2021-04-28	AMNA	ETF	31.1606	31.1606	31.1606	31.1606	1.0
2021-04-28	AMND	ETF	33.2077	33.2077	33.2077	33.2077	7.0
2021-04-28	AMOM	ETF	35.66	35.68	35.52	35.54	26300.0

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

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