PREVIEW / etf_daily / 2021-07-02

all etf daily files

  file:    by_date/etf_daily/2021/2021-07-02.parquet
  size:    90 KB
  rows:    2,401

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-07-02	SPY	ETF	431.67	434.1	430.52	433.72	57697700.0
2021-07-02	QQQ	ETF	356.52	358.97	356.28	358.64	32727244.0
2021-07-02	IWM	ETF	232.0	232.08	228.56	229.19	21029700.0
2021-07-02	DIA	ETF	347.04	348.29	346.18	347.94	3013500.0
2021-07-02	GLD	ETF	167.35	167.72	166.4	167.29	7873600.0
2021-07-02	TLT	ETF	144.23	145.04	144.11	145.04	9650200.0
2021-07-02	AAA	ETF	24.98	25.0	24.98	25.0	694.0
2021-07-02	AAAU	ETF	17.8	17.83	17.69	17.78	258500.0
2021-07-02	AADR	ETF	66.29	66.63	66.23	66.63	2800.0
2021-07-02	AAXJ	ETF	93.22	93.64	93.07	93.61	3187800.0
2021-07-02	ABEQ	ETF	27.4	27.54	27.37	27.54	3000.0
2021-07-02	ACES	ETF	75.61	76.06	74.93	75.18	34700.0
2021-07-02	ACIO	ETF	30.31	30.58	30.31	30.58	55100.0
2021-07-02	ACSI	ETF	50.69	50.7141	50.69	50.7141	300.0
2021-07-02	ACTV	ETF	38.95	38.97	38.86	38.911	5029.0
2021-07-02	ACTX	ETF	2.55	2.56	2.5	2.55	1829.0
2021-07-02	ACVF	ETF	32.25	32.279	32.13	32.279	1800.0
2021-07-02	ACWF	ETF	38.18	38.24	38.085	38.2359	9844.0
2021-07-02	ACWI	ETF	101.76	102.14	101.58	102.08	2150500.0
2021-07-02	ACWV	ETF	103.39	103.7	103.21	103.64	83800.0
2021-07-02	ACWX	ETF	57.49	57.63	57.31	57.56	392062.0
2021-07-02	ADFI	ETF	9.74	9.75	9.74	9.75	800.0
2021-07-02	ADIV	ETF	18.63	18.64	18.63	18.64	500.0
2021-07-02	ADME	ETF	40.08	40.32	40.08	40.32	63700.0
2021-07-02	ADRE	ETF	56.99	56.99	56.655	56.83	11633.0
2021-07-02	AEMB	ETF	49.98	49.98	49.98	49.98	100.0
2021-07-02	AESR	ETF	13.79	13.791	13.69	13.791	2100.0
2021-07-02	AFIF	ETF	9.76	9.76	9.745	9.7451	7093.0
2021-07-02	AFK	ETF	22.05	22.05	21.72	21.85	6255.0
2021-07-02	AFLG	ETF	25.54	25.662	25.54	25.662	135300.0
2021-07-02	AFMC	ETF	25.486	25.486	25.486	25.486	600.0
2021-07-02	AFSM	ETF	26.478	26.478	26.478	26.478	100.0
2021-07-02	AFTY	ETF	22.47	22.543	22.47	22.543	1000.0
2021-07-02	AGG	ETF	115.23	115.37	115.17	115.36	4312800.0
2021-07-02	AGGY	ETF	52.19	52.3	52.18	52.3	94300.0
2021-07-02	AGNG	ETF	30.86	30.86	30.685	30.85	4300.0
2021-07-02	AGOX	ETF	26.59	26.59	26.23	26.327	32900.0
2021-07-02	AGQ	ETF	47.16	47.76	46.5	47.45	1273800.0
2021-07-02	AGZ	ETF	118.2	118.3689	118.2	118.305	48614.0
2021-07-02	AGZD	ETF	23.545	23.57	23.51	23.545	14800.0
2021-07-02	AIA	ETF	90.3	90.4395	90.035	90.37	111276.0
2021-07-02	AIEQ	ETF	41.66	41.764	41.35	41.51	15800.0
2021-07-02	AIQ	ETF	30.53	30.77	30.53	30.76	11797.0
2021-07-02	AIRR	ETF	41.26	41.26	40.54	40.63	164000.0
2021-07-02	AIVI	ETF	43.27	43.51	43.27	43.51	1600.0
2021-07-02	ALTL	ETF	42.03	42.03	41.46	41.66	19469.0
2021-07-02	ALTY	ETF	13.67	13.71	13.62	13.7	16000.0
2021-07-02	AMJ	ETF	19.94	19.94	19.62	19.87	219676.0
2021-07-02	AMLP	ETF	36.93	37.0	36.41	36.97	2202600.0
2021-07-02	AMNA	ETF	34.28	34.5563	34.24	34.5563	4600.0

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

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