PREVIEW / etf_daily / 2021-10-21

all etf daily files

  file:    by_date/etf_daily/2021/2021-10-21.parquet
  size:    95 KB
  rows:    2,535

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-10-21	SPY	ETF	451.77	453.83	451.31	453.59	41305400.0
2021-10-21	QQQ	ETF	374.16	377.47	373.85	377.27	25469277.0
2021-10-21	IWM	ETF	227.19	229.01	226.62	227.95	17851600.0
2021-10-21	DIA	ETF	355.39	356.09	354.3	355.96	2243800.0
2021-10-21	GLD	ETF	166.7	166.94	166.24	166.75	4412400.0
2021-10-21	TLT	ETF	143.0	143.15	142.23	142.56	13660000.0
2021-10-21	AAA	ETF	25.0	25.0	25.0	25.0	77.0
2021-10-21	AAAU	ETF	17.74	17.75	17.68	17.74	122100.0
2021-10-21	AADR	ETF	66.2	66.2	65.68	65.86	2000.0
2021-10-21	AAXJ	ETF	88.01	88.41	87.93	88.27	604500.0
2021-10-21	ABEQ	ETF	27.9	27.92	27.77	27.882	9900.0
2021-10-21	ACES	ETF	71.5	73.122	71.5	72.53	35300.0
2021-10-21	ACIO	ETF	31.24	31.45	31.23	31.45	60500.0
2021-10-21	ACSI	ETF	52.05	52.087	52.05	52.087	247.0
2021-10-21	ACT	ETF	23.04	23.25	22.55	22.99	132295.0
2021-10-21	ACTV	ETF	39.12	39.3	39.105	39.2454	21688.0
2021-10-21	ACTX	ETF	1.2	1.2	1.2	1.2	1404.0
2021-10-21	ACVF	ETF	33.85	33.85	33.676	33.82	6700.0
2021-10-21	ACWF	ETF	38.18	38.22	38.08	38.21	39783.0
2021-10-21	ACWI	ETF	104.54	104.91	104.47	104.9	1157100.0
2021-10-21	ACWV	ETF	105.35	105.69	105.28	105.59	321900.0
2021-10-21	ACWX	ETF	57.2	57.36	57.16	57.25	1018038.0
2021-10-21	ADFI	ETF	9.64	9.64	9.62	9.62	1300.0
2021-10-21	ADIV	ETF	17.545	17.545	17.545	17.545	100.0
2021-10-21	ADME	ETF	41.2	41.47	41.2	41.47	77700.0
2021-10-21	ADRE	ETF	51.51	51.7797	51.435	51.59	8218.0
2021-10-21	AEMB	ETF	48.84	48.84	48.735	48.735	51200.0
2021-10-21	AESR	ETF	14.34	14.42	14.33	14.42	3400.0
2021-10-21	AFIF	ETF	9.5967	9.6	9.58	9.585	4918.0
2021-10-21	AFK	ETF	22.14	22.14	21.7912	21.855	3205.0
2021-10-21	AFLG	ETF	26.696	26.696	26.696	26.696	100.0
2021-10-21	AFTY	ETF	21.564	21.564	21.564	21.564	1100.0
2021-10-21	AGG	ETF	114.01	114.04	113.84	113.84	5228300.0
2021-10-21	AGGY	ETF	51.6	51.65	51.546	51.57	540300.0
2021-10-21	AGNG	ETF	29.52	29.59	29.52	29.578	1000.0
2021-10-21	AGOV	ETF	99.05	99.21	99.05	99.21	451.0
2021-10-21	AGOX	ETF	27.0	27.07	26.888	27.07	33700.0
2021-10-21	AGQ	ETF	38.19	38.39	37.67	38.18	507600.0
2021-10-21	AGZ	ETF	117.76	117.83	117.6701	117.705	34109.0
2021-10-21	AGZD	ETF	23.455	23.5	23.435	23.455	34800.0
2021-10-21	AIA	ETF	82.2	82.479	82.05	82.42	56798.0
2021-10-21	AIEQ	ETF	43.09	43.4	43.09	43.374	27500.0
2021-10-21	AIQ	ETF	31.85	32.09	31.85	32.04	25819.0
2021-10-21	AIRR	ETF	42.79	43.08	42.79	43.08	14500.0
2021-10-21	AIVI	ETF	41.55	41.61	41.47	41.49	2400.0
2021-10-21	ALTL	ETF	43.02	43.13	42.79	43.08	24572.0
2021-10-21	ALTY	ETF	13.62	13.69	13.62	13.66	10600.0
2021-10-21	AMJ	ETF	20.12	20.2	19.65	19.9	464761.0
2021-10-21	AMLP	ETF	37.04	37.24	36.19	36.62	1481200.0
2021-10-21	AMNA	ETF	35.4757	35.4757	35.4757	35.4757	2.0

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

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