PREVIEW / etf_daily / 2020-12-21

all etf daily files

  file:    by_date/etf_daily/2020/2020-12-21.parquet
  size:    83 KB
  rows:    2,193

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
2020-12-21	SPY	ETF	364.97	378.46	362.03	367.86	96386700.0
2020-12-21	QQQ	ETF	306.46	309.47	303.6	308.92	37095480.0
2020-12-21	IWM	ETF	191.9	195.78	191.48	195.24	30873000.0
2020-12-21	DIA	ETF	298.79	302.97	297.42	302.14	6340800.0
2020-12-21	GLD	ETF	176.29	176.94	175.76	175.88	8168900.0
2020-12-21	TLT	ETF	157.2	157.34	156.45	156.95	8988200.0
2020-12-21	AAA	ETF	25.08	25.08	25.07	25.07	2939.0
2020-12-21	AAAU	ETF	18.7	18.78	18.66	18.67	634300.0
2020-12-21	AADR	ETF	60.03	60.2	59.92	60.05	2600.0
2020-12-21	AAXJ	ETF	86.39	87.19	86.13	86.91	1479100.0
2020-12-21	ABEQ	ETF	25.13	25.248	25.13	25.248	5100.0
2020-12-21	ACES	ETF	75.62	76.29	74.02	76.29	160300.0
2020-12-21	ACIO	ETF	27.364	27.56	27.31	27.56	22700.0
2020-12-21	ACSI	ETF	43.0047	43.0047	43.0047	43.0047	131.0
2020-12-21	ACTV	ETF	30.73	30.92	30.72	30.89	5932.0
2020-12-21	ACVF	ETF	27.3	27.45	27.015	27.45	9100.0
2020-12-21	ACWF	ETF	32.79	33.06	32.695	32.9717	22380.0
2020-12-21	ACWI	ETF	88.31	89.42	87.94	89.21	5624100.0
2020-12-21	ACWV	ETF	95.14	95.54	94.46	95.43	416100.0
2020-12-21	ACWX	ETF	51.5	52.12	51.38	52.01	1930438.0
2020-12-21	ADME	ETF	35.223	35.69	35.18	35.69	9500.0
2020-12-21	ADRE	ETF	55.14	55.76	55.122	55.61	13824.0
2020-12-21	AESR	ETF	11.73	11.79	11.65	11.765	5800.0
2020-12-21	AFIF	ETF	9.8	9.8	9.765	9.79	535695.0
2020-12-21	AFK	ETF	21.68	21.68	20.0539	20.56	51443.0
2020-12-21	AFLG	ETF	22.14	22.14	22.14	22.14	100.0
2020-12-21	AFMC	ETF	21.305	21.305	21.305	21.305	100.0
2020-12-21	AFSM	ETF	22.124	22.124	22.124	22.124	100.0
2020-12-21	AFTY	ETF	21.9	21.95	21.86	21.947	2800.0
2020-12-21	AGG	ETF	117.92	117.96	117.75	117.79	4818300.0
2020-12-21	AGGY	ETF	53.46	53.496	53.429	53.47	124700.0
2020-12-21	AGNG	ETF	27.61	27.83	27.444	27.82	4700.0
2020-12-21	AGQ	ETF	49.75	51.35	49.74	50.9	1772800.0
2020-12-21	AGZ	ETF	119.66	119.66	119.5	119.59	35858.0
2020-12-21	AGZD	ETF	23.47	23.575	23.47	23.52	7200.0
2020-12-21	AIA	ETF	82.9	83.57	82.721	83.41	187963.0
2020-12-21	AIEQ	ETF	35.98	36.25	35.679	36.25	31100.0
2020-12-21	AIQ	ETF	26.83	27.069	26.6001	27.04	306456.0
2020-12-21	AIRR	ETF	32.98	33.22	32.85	33.19	8100.0
2020-12-21	AIVI	ETF	39.56	40.02	39.47	39.92	47200.0
2020-12-21	ALTL	ETF	30.96	31.45	28.9525	31.2084	15666.0
2020-12-21	ALTY	ETF	11.85	11.85	11.64	11.72	22800.0
2020-12-21	AMJ	ETF	14.35	14.39	14.05	14.21	1393718.0
2020-12-21	AMLP	ETF	26.36	26.65	25.92	26.32	4851700.0
2020-12-21	AMNA	ETF	25.55	25.8	25.55	25.782	300.0
2020-12-21	AMND	ETF	27.5538	27.5538	27.5538	27.5538	11.0
2020-12-21	AMOM	ETF	39.77	39.77	39.331	39.682	1500.0
2020-12-21	AMTR	ETF	28.71	29.23	28.71	29.07	435721.0
2020-12-21	AMUB	ETF	8.8057	9.0499	8.8057	8.954	5606.0
2020-12-21	AMZA	ETF	19.77	19.95	19.11	19.69	169000.0

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

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