PREVIEW / etf_daily / 2021-04-26

all etf daily files

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

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-26	SPY	ETF	417.44	418.22	416.81	417.61	52182400.0
2021-04-26	QQQ	ETF	339.67	341.92	338.9	341.63	30811968.0
2021-04-26	IWM	ETF	227.0	228.69	226.75	228.11	19069200.0
2021-04-26	DIA	ETF	341.15	341.48	339.39	339.87	2090900.0
2021-04-26	GLD	ETF	166.63	166.87	166.05	166.84	4786600.0
2021-04-26	TLT	ETF	140.15	140.51	139.85	139.86	9103500.0
2021-04-26	AAA	ETF	25.04	25.04	25.035	25.035	194.0
2021-04-26	AAAU	ETF	17.72	17.73	17.65	17.73	515600.0
2021-04-26	AADR	ETF	65.81	66.48	65.81	66.48	2200.0
2021-04-26	AAXJ	ETF	94.38	94.81	94.32	94.78	2443700.0
2021-04-26	ABEQ	ETF	27.435	27.435	27.3	27.303	15400.0
2021-04-26	ACES	ETF	76.75	77.238	75.5	77.23	53900.0
2021-04-26	ACIO	ETF	29.7	29.71	29.648	29.68	18200.0
2021-04-26	ACSI	ETF	48.4243	48.4243	48.4243	48.4243	303.0
2021-04-26	ACTV	ETF	37.19	37.23	37.1007	37.1652	6497.0
2021-04-26	ACTX	ETF	4.03	4.03	4.03	4.03	173.0
2021-04-26	ACVF	ETF	31.22	31.22	31.05	31.073	7500.0
2021-04-26	ACWF	ETF	38.02	38.14	38.02	38.086	8820.0
2021-04-26	ACWI	ETF	99.62	99.88	99.57	99.76	2320700.0
2021-04-26	ACWV	ETF	102.11	102.21	101.78	101.92	216900.0
2021-04-26	ACWX	ETF	57.12	57.275	57.1	57.24	431290.0
2021-04-26	ADFI	ETF	9.72	9.72	9.695	9.695	1000.0
2021-04-26	ADIV	ETF	19.07	19.103	19.053	19.103	1000.0
2021-04-26	ADME	ETF	38.73	38.79	38.714	38.75	12700.0
2021-04-26	ADRE	ETF	57.35	58.0	57.35	58.0	16580.0
2021-04-26	AESR	ETF	13.23	13.29	13.23	13.252	7900.0
2021-04-26	AFIF	ETF	9.73	9.73	9.71	9.7101	30634.0
2021-04-26	AFK	ETF	21.96	22.07	21.9146	22.04	28267.0
2021-04-26	AFLG	ETF	25.04	25.07	25.04	25.04	49700.0
2021-04-26	AFMC	ETF	25.53	25.53	25.489	25.489	1000.0
2021-04-26	AFSM	ETF	26.274	26.274	26.274	26.274	100.0
2021-04-26	AFTY	ETF	22.59	22.61	22.535	22.61	6200.0
2021-04-26	AGG	ETF	114.74	114.8	114.65	114.65	3480300.0
2021-04-26	AGGY	ETF	51.8	51.85	51.77	51.8	82500.0
2021-04-26	AGNG	ETF	29.42	29.49	29.28	29.41	2800.0
2021-04-26	AGQ	ETF	47.18	47.18	46.62	47.11	509300.0
2021-04-26	AGZ	ETF	118.22	118.318	118.2	118.26	186705.0
2021-04-26	AGZD	ETF	23.585	23.585	23.5	23.54	31400.0
2021-04-26	AIA	ETF	93.68	94.03	93.55	93.86	82380.0
2021-04-26	AIEQ	ETF	39.52	40.22	39.52	40.22	50300.0
2021-04-26	AIQ	ETF	29.64	29.87	29.63	29.85	43969.0
2021-04-26	AIRR	ETF	42.04	42.22	41.76	41.84	94100.0
2021-04-26	AIVI	ETF	43.65	43.75	43.65	43.71	3900.0
2021-04-26	ALTL	ETF	40.42	41.0	40.1826	40.1826	31188.0
2021-04-26	ALTY	ETF	13.25	13.25	13.18	13.23	22200.0
2021-04-26	AMJ	ETF	17.4	17.545	17.27	17.31	322369.0
2021-04-26	AMLP	ETF	32.14	32.49	32.12	32.38	1651600.0
2021-04-26	AMNA	ETF	30.4	30.4	30.367	30.367	496.0
2021-04-26	AMND	ETF	32.3544	32.3544	32.3544	32.3544	0.0
2021-04-26	AMOM	ETF	35.72	35.72	35.49	35.67	18900.0

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

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