PREVIEW / etf_daily / 2021-06-02

all etf daily files

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

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-02	SPY	ETF	420.37	421.23	419.29	420.33	49097100.0
2021-06-02	QQQ	ETF	333.25	334.34	331.695	333.47	22047940.0
2021-06-02	IWM	ETF	228.91	228.92	226.83	228.33	18927500.0
2021-06-02	DIA	ETF	346.75	347.35	345.75	346.36	2576700.0
2021-06-02	GLD	ETF	178.34	178.78	177.97	178.77	6613100.0
2021-06-02	TLT	ETF	138.55	138.79	138.32	138.53	7347900.0
2021-06-02	AAA	ETF	24.997	24.997	24.997	24.997	108.0
2021-06-02	AAAU	ETF	18.95	19.0	18.92	19.0	321300.0
2021-06-02	AADR	ETF	67.43	67.93	67.43	67.93	1600.0
2021-06-02	AAXJ	ETF	95.82	95.94	95.58	95.84	368600.0
2021-06-02	ABEQ	ETF	28.3	28.35	28.291	28.291	3100.0
2021-06-02	ACES	ETF	69.51	69.56	68.82	69.34	63900.0
2021-06-02	ACIO	ETF	29.745	29.81	29.73	29.79	20500.0
2021-06-02	ACSI	ETF	49.1536	49.1536	49.1536	49.1536	188.0
2021-06-02	ACTV	ETF	39.52	39.52	39.35	39.4121	2866.0
2021-06-02	ACVF	ETF	31.4	31.4	31.32	31.331	2700.0
2021-06-02	ACWF	ETF	38.53	38.53	38.465	38.502	1810.0
2021-06-02	ACWI	ETF	101.0	101.28	100.9	101.09	1081700.0
2021-06-02	ACWV	ETF	102.95	103.35	102.9	103.27	489800.0
2021-06-02	ACWX	ETF	58.9483	59.1	58.85	59.03	1130820.0
2021-06-02	ADFI	ETF	9.69	9.75	9.69	9.7	75000.0
2021-06-02	ADIV	ETF	19.08	19.08	19.08	19.08	300.0
2021-06-02	ADME	ETF	38.83	38.83	38.713	38.77	14300.0
2021-06-02	ADRE	ETF	57.91	57.98	57.71	57.8908	27955.0
2021-06-02	AESR	ETF	13.3	13.35	13.26	13.299	276000.0
2021-06-02	AFIF	ETF	9.74	9.76	9.74	9.75	15658.0
2021-06-02	AFK	ETF	22.89	22.98	22.826	22.98	19073.0
2021-06-02	AFLG	ETF	25.12	25.12	25.087	25.087	10700.0
2021-06-02	AFMC	ETF	25.496	25.496	25.496	25.496	800.0
2021-06-02	AFTY	ETF	24.19	24.35	24.19	24.23	10300.0
2021-06-02	AGG	ETF	114.45	114.51	114.3	114.48	6103900.0
2021-06-02	AGGY	ETF	51.79	51.81	51.75	51.8	61000.0
2021-06-02	AGNG	ETF	29.12	29.24	28.966	28.966	5600.0
2021-06-02	AGOX	ETF	25.93	25.97	25.895	25.944	39000.0
2021-06-02	AGQ	ETF	53.42	54.31	53.22	54.31	711400.0
2021-06-02	AGZ	ETF	118.34	118.34	118.24	118.26	18067.0
2021-06-02	AGZD	ETF	23.55	23.55	23.48	23.51	155200.0
2021-06-02	AIA	ETF	93.01	93.21	92.71	93.05	180726.0
2021-06-02	AIEQ	ETF	38.33	38.427	38.19	38.26	13900.0
2021-06-02	AIQ	ETF	29.12	29.27	29.1	29.21	47159.0
2021-06-02	AIRR	ETF	42.43	42.43	41.535	41.674	32000.0
2021-06-02	AIVI	ETF	44.64	44.82	44.64	44.75	2800.0
2021-06-02	ALTL	ETF	40.0	41.36	40.0	41.25	60995.0
2021-06-02	ALTY	ETF	13.71	13.71	13.606	13.631	60500.0
2021-06-02	AMJ	ETF	19.19	19.55	19.105	19.38	627604.0
2021-06-02	AMLP	ETF	35.5	36.02	35.18	35.85	2290300.0
2021-06-02	AMNA	ETF	34.03	34.22	34.0248	34.0248	1000.0
2021-06-02	AMND	ETF	35.9898	35.9898	35.9898	35.9898	0.0
2021-06-02	AMOM	ETF	35.2	35.2	34.97	35.08	15500.0
2021-06-02	AMPS	ETF	9.85	9.85	9.8464	9.8464	100428.0

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

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