PREVIEW / etf_daily / 2021-03-26

all etf daily files

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

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-03-26	SPY	ETF	390.93	396.41	390.29	395.98	114409100.0
2021-03-26	QQQ	ETF	311.11	316.33	309.67	316.0	63519634.0
2021-03-26	IWM	ETF	218.96	220.68	215.96	220.61	34452600.0
2021-03-26	DIA	ETF	327.6	330.89	326.68	330.61	4956600.0
2021-03-26	GLD	ETF	161.71	162.73	161.65	162.24	6153900.0
2021-03-26	TLT	ETF	136.42	137.24	136.22	136.66	8433300.0
2021-03-26	AAA	ETF	25.06	25.06	25.06	25.06	8.0
2021-03-26	AAAU	ETF	17.17	17.28	17.17	17.24	387800.0
2021-03-26	AADR	ETF	61.09	62.05	60.97	62.05	5100.0
2021-03-26	AAXJ	ETF	91.17	92.75	90.87	92.56	1124700.0
2021-03-26	ABEQ	ETF	26.29	26.459	26.287	26.459	21900.0
2021-03-26	ACES	ETF	73.0	74.739	72.62	74.65	135900.0
2021-03-26	ACIO	ETF	28.0	28.38	28.0	28.38	5700.0
2021-03-26	ACSI	ETF	46.0103	46.0103	46.0103	46.0103	237.0
2021-03-26	ACTV	ETF	36.0	36.039	35.575	36.039	2444.0
2021-03-26	ACTX	ETF	3.85	3.85	3.72	3.72	342.0
2021-03-26	ACVF	ETF	29.32	29.645	29.285	29.645	3500.0
2021-03-26	ACWF	ETF	35.82	36.45	35.72	36.45	19494.0
2021-03-26	ACWI	ETF	94.2	95.43	94.05	95.33	2965100.0
2021-03-26	ACWV	ETF	98.2	99.25	97.98	99.22	665300.0
2021-03-26	ACWX	ETF	54.88	55.525	54.83	55.52	1318077.0
2021-03-26	ADFI	ETF	9.65	9.7	9.643	9.649	5500.0
2021-03-26	ADME	ETF	35.98	36.5	35.98	36.5	3900.0
2021-03-26	ADRE	ETF	54.49	55.5587	53.62	55.53	33728.0
2021-03-26	AESR	ETF	12.48	12.58	12.379	12.58	24300.0
2021-03-26	AFIF	ETF	9.71	9.73	9.69	9.72	89765.0
2021-03-26	AFK	ETF	20.92	21.06	20.8012	21.06	7653.0
2021-03-26	AFLG	ETF	23.52	23.775	23.52	23.775	2000.0
2021-03-26	AFMC	ETF	24.245	24.245	24.245	24.245	1200.0
2021-03-26	AFSM	ETF	24.994	24.994	24.994	24.994	100.0
2021-03-26	AFTY	ETF	22.315	22.597	22.28	22.597	5900.0
2021-03-26	AGG	ETF	113.91	114.08	113.86	113.91	4333900.0
2021-03-26	AGGY	ETF	51.3	51.37	51.249	51.28	79500.0
2021-03-26	AGNG	ETF	27.295	27.572	27.23	27.572	3100.0
2021-03-26	AGQ	ETF	43.2	43.56	42.73	43.25	552600.0
2021-03-26	AGZ	ETF	118.04	118.06	117.9301	117.96	24028.0
2021-03-26	AGZD	ETF	23.47	23.48	23.445	23.465	24800.0
2021-03-26	AIA	ETF	90.67	92.31	90.46	92.3	271413.0
2021-03-26	AIEQ	ETF	37.58	37.88	37.02	37.7	12600.0
2021-03-26	AIQ	ETF	27.7	28.2	27.64	28.2	13363.0
2021-03-26	AIRR	ETF	39.51	40.4	39.51	40.4	55200.0
2021-03-26	AIVI	ETF	42.47	42.77	42.47	42.77	3700.0
2021-03-26	ALTL	ETF	38.6	39.118	38.4638	39.1046	8591.0
2021-03-26	ALTY	ETF	12.603	12.671	12.603	12.671	6500.0
2021-03-26	AMJ	ETF	16.56	16.72	16.26	16.72	483552.0
2021-03-26	AMLP	ETF	30.18	30.84	29.96	30.8	2447100.0
2021-03-26	AMNA	ETF	30.3668	30.3668	30.3668	30.3668	0.0
2021-03-26	AMND	ETF	32.2566	32.2566	32.2566	32.2566	1.0
2021-03-26	AMOM	ETF	32.39	33.122	32.39	33.122	6300.0
2021-03-26	AMPS	ETF	9.81	10.06	9.73	9.99	240335.0

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

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