PREVIEW / etf_daily / 2021-09-09

all etf daily files

  file:    by_date/etf_daily/2021/2021-09-09.parquet
  size:    93 KB
  rows:    2,457

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-09-09	SPY	ETF	450.7	452.57	448.72	448.98	57970400.0
2021-09-09	QQQ	ETF	381.01	382.15	379.22	379.47	29398978.0
2021-09-09	IWM	ETF	223.54	226.29	222.96	223.81	27180500.0
2021-09-09	DIA	ETF	350.56	352.51	348.92	349.31	3484700.0
2021-09-09	GLD	ETF	168.17	168.28	166.83	168.03	6641400.0
2021-09-09	TLT	ETF	148.17	149.89	147.85	149.72	20324600.0
2021-09-09	AAA	ETF	25.0088	25.0088	25.005	25.005	127.0
2021-09-09	AAAU	ETF	17.89	17.89	17.75	17.87	218700.0
2021-09-09	AAXJ	ETF	89.21	89.44	88.91	89.19	640800.0
2021-09-09	ABEQ	ETF	27.705	27.705	27.577	27.577	1500.0
2021-09-09	ACES	ETF	69.5	70.168	69.069	69.5	33900.0
2021-09-09	ACIO	ETF	31.09	31.17	30.93	30.93	85700.0
2021-09-09	ACSI	ETF	51.3071	51.3071	51.3071	51.3071	6.0
2021-09-09	ACTV	ETF	38.26	38.26	38.03	38.0487	9244.0
2021-09-09	ACTX	ETF	1.15	1.15	1.13	1.13	1260.0
2021-09-09	ACVF	ETF	33.38	33.38	33.12	33.12	7100.0
2021-09-09	ACWF	ETF	38.99	39.14	38.9381	38.9381	4752.0
2021-09-09	ACWI	ETF	104.46	104.9	104.15	104.29	2336800.0
2021-09-09	ACWV	ETF	107.7	107.72	107.05	107.09	166200.0
2021-09-09	ACWX	ETF	57.73	57.975	57.65	57.75	578955.0
2021-09-09	ADFI	ETF	9.775	9.775	9.775	9.775	200.0
2021-09-09	ADIV	ETF	17.94	17.94	17.94	17.94	100.0
2021-09-09	ADME	ETF	41.39	41.483	41.17	41.2	26700.0
2021-09-09	ADRE	ETF	51.86	52.2999	51.86	52.1972	7384.0
2021-09-09	AEMB	ETF	50.28	50.28	50.28	50.28	100.0
2021-09-09	AESR	ETF	14.19	14.23	14.18	14.18	1500.0
2021-09-09	AFIF	ETF	9.71	9.74	9.71	9.735	11608.0
2021-09-09	AFK	ETF	21.4	21.654	21.4	21.41	5698.0
2021-09-09	AFLG	ETF	26.66	26.66	26.525	26.525	200.0
2021-09-09	AFSM	ETF	26.409	26.409	26.409	26.409	100.0
2021-09-09	AFTY	ETF	20.54	20.549	20.521	20.549	600.0
2021-09-09	AGG	ETF	115.84	116.15	115.76	116.1	3332600.0
2021-09-09	AGGY	ETF	52.54	52.72	52.54	52.685	79700.0
2021-09-09	AGNG	ETF	30.8	30.98	30.457	30.62	5200.0
2021-09-09	AGOX	ETF	26.74	26.74	26.42	26.55	14500.0
2021-09-09	AGQ	ETF	38.78	38.78	37.81	38.18	603500.0
2021-09-09	AGZ	ETF	119.15	119.27	119.06	119.2	16180.0
2021-09-09	AGZD	ETF	23.42	23.445	23.4	23.415	45400.0
2021-09-09	AIA	ETF	82.78	83.35	82.67	83.14	75836.0
2021-09-09	AIEQ	ETF	43.06	43.486	43.06	43.204	11300.0
2021-09-09	AIQ	ETF	31.67	31.945	31.55	31.79	15536.0
2021-09-09	AIRR	ETF	41.99	42.045	41.555	41.652	12400.0
2021-09-09	AIVI	ETF	43.48	43.54	43.32	43.38	6800.0
2021-09-09	ALTL	ETF	43.65	43.65	43.205	43.22	147006.0
2021-09-09	ALTY	ETF	13.65	13.73	13.65	13.65	33600.0
2021-09-09	AMJ	ETF	17.75	18.015	17.69	17.91	511055.0
2021-09-09	AMLP	ETF	32.68	33.12	32.44	32.84	1444600.0
2021-09-09	AMNA	ETF	31.973	31.973	31.973	31.973	0.0
2021-09-09	AMND	ETF	33.6437	33.6437	33.6437	33.6437	3.0
2021-09-09	AMOM	ETF	36.96	37.08	36.93	36.93	20400.0

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

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