PREVIEW / etf_daily / 2021-05-26

all etf daily files

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

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-05-26	SPY	ETF	418.87	419.61	417.76	419.07	43088600.0
2021-05-26	QQQ	ETF	333.66	334.61	332.95	334.13	25444932.0
2021-05-26	IWM	ETF	220.13	223.69	220.12	223.35	20388200.0
2021-05-26	DIA	ETF	343.56	344.12	342.67	343.27	2064500.0
2021-05-26	GLD	ETF	178.37	178.61	177.04	177.64	8495400.0
2021-05-26	TLT	ETF	139.59	139.91	138.88	139.22	9793700.0
2021-05-26	AAA	ETF	25.015	25.015	25.015	25.015	38.0
2021-05-26	AAAU	ETF	18.96	18.98	18.82	18.87	382900.0
2021-05-26	AADR	ETF	64.88	64.98	64.87	64.96	800.0
2021-05-26	AAXJ	ETF	93.71	93.99	93.58	93.9	572100.0
2021-05-26	ABEQ	ETF	28.3	28.3	28.227	28.227	2500.0
2021-05-26	ACES	ETF	67.31	68.83	67.082	68.76	39700.0
2021-05-26	ACIO	ETF	29.79	29.83	29.76	29.79	89300.0
2021-05-26	ACSI	ETF	49.06	49.06	49.0176	49.0176	783.0
2021-05-26	ACTV	ETF	38.21	38.39	38.15	38.3321	7200.0
2021-05-26	ACTX	ETF	3.4	3.4	3.4	3.4	653.0
2021-05-26	ACVF	ETF	31.18	31.3	31.18	31.226	8500.0
2021-05-26	ACWF	ETF	38.13	38.17	38.08	38.0974	21193.0
2021-05-26	ACWI	ETF	100.11	100.35	99.99	100.24	1606700.0
2021-05-26	ACWV	ETF	103.15	103.3	103.06	103.19	75300.0
2021-05-26	ACWX	ETF	57.99	58.09	57.91	58.07	690821.0
2021-05-26	ADFI	ETF	9.71	9.71	9.67	9.687	1100.0
2021-05-26	ADIV	ETF	18.88	18.88	18.88	18.88	100.0
2021-05-26	ADME	ETF	38.78	38.8	38.716	38.74	75800.0
2021-05-26	ADRE	ETF	55.63	55.754	55.41	55.6694	3558.0
2021-05-26	AESR	ETF	13.24	13.29	13.24	13.261	6200.0
2021-05-26	AFIF	ETF	9.72	9.72	9.7	9.708	13865.0
2021-05-26	AFK	ETF	22.24	22.47	22.1805	22.39	20601.0
2021-05-26	AFLG	ETF	25.037	25.037	25.037	25.037	100.0
2021-05-26	AFMC	ETF	25.289	25.289	25.289	25.289	600.0
2021-05-26	AFSM	ETF	25.947	25.947	25.947	25.947	100.0
2021-05-26	AFTY	ETF	24.31	24.53	24.31	24.513	24100.0
2021-05-26	AGG	ETF	114.13	114.8	114.13	114.69	3969400.0
2021-05-26	AGGY	ETF	51.79	51.85	51.753	51.77	149400.0
2021-05-26	AGNG	ETF	29.095	29.12	29.04	29.12	1100.0
2021-05-26	AGOX	ETF	25.44	25.58	25.44	25.568	14200.0
2021-05-26	AGQ	ETF	53.07	53.4	51.95	52.29	738900.0
2021-05-26	AGZ	ETF	118.32	118.4	118.32	118.32	30799.0
2021-05-26	AGZD	ETF	23.525	23.525	23.47	23.495	37800.0
2021-05-26	AIA	ETF	91.06	91.19	90.85	91.17	53176.0
2021-05-26	AIEQ	ETF	37.56	37.75	37.37	37.72	14900.0
2021-05-26	AIQ	ETF	28.88	28.89	28.79	28.88	10137.0
2021-05-26	AIRR	ETF	40.66	41.05	40.556	41.0	18100.0
2021-05-26	AIVI	ETF	44.1	44.19	44.08	44.1	3700.0
2021-05-26	ALTL	ETF	41.49	41.49	41.21	41.23	39266.0
2021-05-26	ALTY	ETF	13.46	13.46	13.41	13.45	9000.0
2021-05-26	AMJ	ETF	18.96	19.215	18.93	19.11	273117.0
2021-05-26	AMLP	ETF	34.38	34.76	34.26	34.63	1307700.0
2021-05-26	AMNA	ETF	33.0235	33.0235	33.0235	33.0235	0.0
2021-05-26	AMND	ETF	35.0892	35.0892	35.0892	35.0892	22.0

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

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