PREVIEW / etf_daily / 2021-11-08

all etf daily files

  file:    by_date/etf_daily/2021/2021-11-08.parquet
  size:    96 KB
  rows:    2,561

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-11-08	SPY	ETF	469.7	470.23	468.2	468.93	50405200.0
2021-11-08	QQQ	ETF	398.57	399.62	397.4	398.06	29256270.0
2021-11-08	IWM	ETF	243.74	244.46	241.93	242.56	31324500.0
2021-11-08	DIA	ETF	365.06	365.64	363.33	364.32	3056000.0
2021-11-08	GLD	ETF	170.43	170.7	170.06	170.45	4966100.0
2021-11-08	TLT	ETF	148.96	149.28	148.51	149.02	12083800.0
2021-11-08	AAA	ETF	25.0499	25.0499	25.045	25.045	172.0
2021-11-08	AAAU	ETF	18.13	18.16	18.1	18.14	163300.0
2021-11-08	AADR	ETF	65.85	66.29	65.85	66.22	2000.0
2021-11-08	AAXJ	ETF	86.54	86.86	86.53	86.86	503000.0
2021-11-08	ABEQ	ETF	28.352	28.352	28.21	28.21	6400.0
2021-11-08	ACES	ETF	81.3	81.692	80.8	81.14	59300.0
2021-11-08	ACIO	ETF	31.95	32.71	31.95	32.1	20200.0
2021-11-08	ACSI	ETF	53.55	53.55	53.4905	53.4905	331.0
2021-11-08	ACT	ETF	23.27	23.75	23.07	23.17	69133.0
2021-11-08	ACTV	ETF	39.525	39.56	39.29	39.3746	9330.0
2021-11-08	ACTX	ETF	1.0	1.01	1.0	1.01	1746.0
2021-11-08	ACVF	ETF	35.45	35.45	35.217	35.256	8100.0
2021-11-08	ACWF	ETF	38.81	38.87	38.7288	38.82	6362.0
2021-11-08	ACWI	ETF	107.36	107.39	107.1	107.22	2516600.0
2021-11-08	ACWV	ETF	106.64	106.7	106.21	106.52	89700.0
2021-11-08	ACWX	ETF	57.94	57.97	57.85	57.92	1027370.0
2021-11-08	ADFI	ETF	9.73	9.73	9.715	9.715	700.0
2021-11-08	ADIV	ETF	17.845	17.845	17.845	17.845	100.0
2021-11-08	ADME	ETF	42.45	42.75	42.45	42.66	15100.0
2021-11-08	ADRE	ETF	49.93	50.38	49.88	50.36	6901.0
2021-11-08	AEMB	ETF	49.23	49.23	49.23	49.23	100.0
2021-11-08	AESR	ETF	14.88	14.9	14.86	14.86	5000.0
2021-11-08	AFIF	ETF	9.66	9.67	9.65	9.65	27422.0
2021-11-08	AFK	ETF	21.46	21.66	21.46	21.66	10283.0
2021-11-08	AFLG	ETF	27.306	27.306	27.306	27.306	100.0
2021-11-08	AFSM	ETF	29.04	29.07	28.833	28.833	3700.0
2021-11-08	AFTY	ETF	21.09	21.144	21.09	21.144	2100.0
2021-11-08	AGG	ETF	115.14	115.15	114.95	115.01	4922800.0
2021-11-08	AGGY	ETF	52.24	52.277	52.18	52.18	82800.0
2021-11-08	AGNG	ETF	30.42	30.7	30.17	30.27	10900.0
2021-11-08	AGOV	ETF	99.085	99.085	99.085	99.085	21.0
2021-11-08	AGOX	ETF	26.31	26.44	26.31	26.43	89700.0
2021-11-08	AGQ	ETF	38.75	39.18	38.38	39.05	791400.0
2021-11-08	AGZ	ETF	118.31	118.41	118.2	118.26	26923.0
2021-11-08	AGZD	ETF	23.415	23.455	23.395	23.44	72000.0
2021-11-08	AIA	ETF	80.04	80.45	79.9386	80.33	57181.0
2021-11-08	AIEQ	ETF	44.58	44.73	44.49	44.637	29100.0
2021-11-08	AIQ	ETF	32.92	33.05	32.891	33.0	25205.0
2021-11-08	AIRR	ETF	47.68	47.995	47.44	47.46	42100.0
2021-11-08	AIVI	ETF	41.8	41.8	41.78	41.8	700.0
2021-11-08	ALTL	ETF	44.79	44.79	44.2093	44.43	93183.0
2021-11-08	ALTY	ETF	13.62	13.67	13.59	13.62	20400.0
2021-11-08	AMJ	ETF	19.2	19.41	19.17	19.41	338132.0
2021-11-08	AMLP	ETF	35.31	35.73	35.31	35.66	1323400.0

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

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