PREVIEW / etf_daily / 2021-05-24

all etf daily files

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

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-24	SPY	ETF	417.34	420.32	417.08	419.17	51376700.0
2021-05-24	QQQ	ETF	329.37	333.67	326.9032	332.51	32475771.0
2021-05-24	IWM	ETF	221.18	222.45	220.0	221.4	18324200.0
2021-05-24	DIA	ETF	343.37	344.69	343.05	343.96	2531800.0
2021-05-24	GLD	ETF	176.15	176.59	175.87	176.35	5557300.0
2021-05-24	TLT	ETF	137.99	138.58	137.89	138.18	6868700.0
2021-05-24	AAA	ETF	25.001	25.0179	24.91	25.0134	3376.0
2021-05-24	AAAU	ETF	18.72	18.77	18.68	18.75	296800.0
2021-05-24	AADR	ETF	64.99	65.19	64.77	65.19	4300.0
2021-05-24	AAXJ	ETF	91.76	92.25	91.55	92.02	631600.0
2021-05-24	ABEQ	ETF	28.4	28.41	28.37	28.371	1100.0
2021-05-24	ACES	ETF	68.35	68.35	67.11	67.66	53100.0
2021-05-24	ACIO	ETF	29.88	30.18	29.78	29.78	41700.0
2021-05-24	ACSI	ETF	49.1354	49.1354	49.1354	49.1354	228.0
2021-05-24	ACTV	ETF	38.3348	38.52	38.22	38.4303	9523.0
2021-05-24	ACVF	ETF	31.4	31.4	31.23	31.297	9100.0
2021-05-24	ACWF	ETF	37.94	38.129	37.94	38.06	4920.0
2021-05-24	ACWI	ETF	99.61	100.28	99.59	100.0	1764200.0
2021-05-24	ACWV	ETF	103.08	103.42	103.07	103.07	139400.0
2021-05-24	ACWX	ETF	57.59	57.855	57.51	57.78	793733.0
2021-05-24	ADFI	ETF	9.67	9.7	9.67	9.684	2800.0
2021-05-24	ADIV	ETF	18.55	18.55	18.49	18.535	30000.0
2021-05-24	ADME	ETF	38.82	38.9	38.73	38.73	37700.0
2021-05-24	ADRE	ETF	55.06	55.3699	54.9866	55.11	29146.0
2021-05-24	AESR	ETF	13.21	13.31	13.21	13.259	16000.0
2021-05-24	AFIF	ETF	9.73	9.73	9.7	9.7103	31611.0
2021-05-24	AFK	ETF	22.19	22.3599	22.07	22.18	25751.0
2021-05-24	AFLG	ETF	25.01	25.1	25.01	25.055	2400.0
2021-05-24	AFMC	ETF	25.207	25.207	25.207	25.207	600.0
2021-05-24	AFSM	ETF	25.719	25.719	25.719	25.719	100.0
2021-05-24	AFTY	ETF	23.46	23.46	23.27	23.39	10700.0
2021-05-24	AGG	ETF	114.5	114.51	114.38	114.45	3867700.0
2021-05-24	AGGY	ETF	51.55	51.66	51.55	51.66	91900.0
2021-05-24	AGNG	ETF	29.38	29.38	29.25	29.281	4700.0
2021-05-24	AGOX	ETF	25.16	25.46	25.16	25.418	21300.0
2021-05-24	AGQ	ETF	52.54	53.16	52.22	52.63	508700.0
2021-05-24	AGZ	ETF	118.15	118.26	118.15	118.26	19635.0
2021-05-24	AGZD	ETF	23.46	23.525	23.46	23.49	67600.0
2021-05-24	AIA	ETF	88.83	89.41	88.72	89.17	94661.0
2021-05-24	AIEQ	ETF	36.78	37.17	36.78	37.14	8300.0
2021-05-24	AIQ	ETF	28.36	28.69	28.36	28.67	20311.0
2021-05-24	AIRR	ETF	41.44	41.44	41.113	41.15	87900.0
2021-05-24	AIVI	ETF	44.19	44.29	44.19	44.24	36300.0
2021-05-24	ALTL	ETF	41.61	41.61	41.43	41.49	29699.0
2021-05-24	ALTY	ETF	13.51	13.51	13.44	13.51	7200.0
2021-05-24	AMJ	ETF	19.29	19.39	19.12	19.25	259105.0
2021-05-24	AMLP	ETF	34.8	35.08	34.55	35.01	1878300.0
2021-05-24	AMNA	ETF	33.4411	33.4411	33.4411	33.4411	0.0
2021-05-24	AMND	ETF	35.4903	35.4903	35.4903	35.4903	22.0
2021-05-24	AMOM	ETF	34.3	34.8	34.3	34.62	33100.0

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

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