PREVIEW / etf_daily / 2021-06-08

all etf daily files

  file:    by_date/etf_daily/2021/2021-06-08.parquet
  size:    89 KB
  rows:    2,349

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-06-08	SPY	ETF	423.11	423.21	420.32	422.28	47134300.0
2021-06-08	QQQ	ETF	338.395	339.29	335.03	336.76	27282819.0
2021-06-08	IWM	ETF	231.21	233.48	229.98	232.89	27770300.0
2021-06-08	DIA	ETF	346.69	346.91	344.75	346.34	2748700.0
2021-06-08	GLD	ETF	177.23	177.54	176.37	177.32	5905800.0
2021-06-08	TLT	ETF	140.66	140.66	140.21	140.45	11230900.0
2021-06-08	AAA	ETF	25.01	25.01	24.995	24.995	113.0
2021-06-08	AAAU	ETF	18.84	18.87	18.75	18.85	687800.0
2021-06-08	AADR	ETF	67.4	67.52	67.4	67.52	1200.0
2021-06-08	AAXJ	ETF	94.71	94.76	94.21	94.54	809300.0
2021-06-08	ABEQ	ETF	28.15	28.266	28.15	28.232	500.0
2021-06-08	ACES	ETF	70.92	71.45	69.89	71.26	49100.0
2021-06-08	ACIO	ETF	30.06	30.06	29.71	29.77	41300.0
2021-06-08	ACSI	ETF	49.07	49.1998	49.07	49.1998	390.0
2021-06-08	ACTV	ETF	38.29	39.7499	38.29	39.6794	7574.0
2021-06-08	ACVF	ETF	31.87	31.87	31.405	31.55	4200.0
2021-06-08	ACWF	ETF	38.76	38.76	38.62	38.6859	5133.0
2021-06-08	ACWI	ETF	101.68	101.69	101.07	101.47	1453300.0
2021-06-08	ACWV	ETF	104.3	104.3	103.65	103.84	43100.0
2021-06-08	ACWX	ETF	59.17	59.17	58.91	59.04	439255.0
2021-06-08	ADFI	ETF	9.72	9.72	9.64	9.715	72000.0
2021-06-08	ADIV	ETF	19.04	19.05	19.01	19.01	600.0
2021-06-08	ADME	ETF	38.9	38.97	38.82	38.915	29100.0
2021-06-08	ADRE	ETF	57.24	57.24	56.4501	56.72	21391.0
2021-06-08	AESR	ETF	13.345	13.38	13.29	13.361	23600.0
2021-06-08	AFIF	ETF	9.7602	9.77	9.74	9.755	100557.0
2021-06-08	AFK	ETF	22.83	22.89	22.65	22.72	63694.0
2021-06-08	AFLG	ETF	25.296	25.296	25.296	25.296	100.0
2021-06-08	AFMC	ETF	25.6	25.889	25.6	25.889	1400.0
2021-06-08	AFSM	ETF	26.8	26.8	26.748	26.748	300.0
2021-06-08	AFTY	ETF	23.97	23.97	23.899	23.9	1800.0
2021-06-08	AGG	ETF	114.84	114.87	114.78	114.81	4395100.0
2021-06-08	AGGY	ETF	51.9	51.97	51.89	51.93	72500.0
2021-06-08	AGNG	ETF	30.08	30.08	29.54	29.819	6200.0
2021-06-08	AGOX	ETF	26.05	26.17	26.02	26.04	18800.0
2021-06-08	AGQ	ETF	52.43	52.75	51.56	52.0	677600.0
2021-06-08	AGZ	ETF	118.4	118.4547	118.39	118.39	41691.0
2021-06-08	AGZD	ETF	23.49	23.54	23.46	23.485	24200.0
2021-06-08	AIA	ETF	91.6	91.63	91.15	91.32	55382.0
2021-06-08	AIEQ	ETF	39.24	39.63	38.84	39.45	14800.0
2021-06-08	AIQ	ETF	29.35	29.5	29.19	29.21	23512.0
2021-06-08	AIRR	ETF	42.29	42.709	42.1	42.65	79200.0
2021-06-08	AIVI	ETF	44.95	45.07	44.94	45.03	10200.0
2021-06-08	ALTL	ETF	41.38	41.42	41.16	41.26	9824.0
2021-06-08	ALTY	ETF	13.74	13.74	13.66	13.71	19800.0
2021-06-08	AMJ	ETF	19.97	20.09	19.71	19.99	306591.0
2021-06-08	AMLP	ETF	36.72	37.09	36.32	37.09	2639200.0
2021-06-08	AMNA	ETF	34.9977	34.9977	34.9977	34.9977	9.0
2021-06-08	AMND	ETF	36.7924	36.7924	36.7924	36.7924	12.0
2021-06-08	AMOM	ETF	35.63	35.63	35.406	35.53	12700.0

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

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