PREVIEW / etf_daily / 2021-07-07

all etf daily files

  file:    by_date/etf_daily/2021/2021-07-07.parquet
  size:    91 KB
  rows:    2,408

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-07	SPY	ETF	433.66	434.76	431.51	434.46	63549500.0
2021-07-07	QQQ	ETF	362.45	362.76	358.94	360.95	35265242.0
2021-07-07	IWM	ETF	225.54	226.67	221.8	223.76	28521500.0
2021-07-07	DIA	ETF	345.65	347.14	344.43	346.92	3347000.0
2021-07-07	GLD	ETF	168.72	169.23	168.19	168.76	7108900.0
2021-07-07	TLT	ETF	147.57	148.56	147.22	148.04	20964400.0
2021-07-07	AAA	ETF	25.0	25.005	25.0	25.005	115.0
2021-07-07	AAAU	ETF	17.93	17.99	17.89	17.95	289100.0
2021-07-07	AADR	ETF	65.23	65.29	65.23	65.29	900.0
2021-07-07	AAXJ	ETF	92.81	92.83	91.84	92.13	782700.0
2021-07-07	ABEQ	ETF	27.46	27.53	27.46	27.478	16000.0
2021-07-07	ACES	ETF	75.42	75.61	72.93	73.36	34300.0
2021-07-07	ACIO	ETF	30.585	30.69	30.585	30.68	49600.0
2021-07-07	ACSI	ETF	50.57	50.578	50.57	50.578	366.0
2021-07-07	ACTV	ETF	38.095	38.51	38.095	38.4	4884.0
2021-07-07	ACVF	ETF	32.2	32.2	32.1	32.19	27600.0
2021-07-07	ACWF	ETF	37.895	38.1103	37.895	38.1103	1919.0
2021-07-07	ACWI	ETF	101.98	102.05	101.33	101.87	4506600.0
2021-07-07	ACWV	ETF	103.66	104.18	103.66	104.08	65800.0
2021-07-07	ACWX	ETF	57.36	57.4	56.955	57.25	1234195.0
2021-07-07	ADFI	ETF	9.77	9.79	9.69	9.775	3800.0
2021-07-07	ADIV	ETF	18.6	18.6	18.543	18.543	1100.0
2021-07-07	ADME	ETF	40.38	40.508	40.38	40.48	19900.0
2021-07-07	ADRE	ETF	56.07	56.07	55.1	55.225	6550.0
2021-07-07	AEMB	ETF	50.185	50.185	50.185	50.185	100.0
2021-07-07	AESR	ETF	13.78	13.81	13.754	13.786	13100.0
2021-07-07	AFIF	ETF	9.744	9.7699	9.74	9.75	10698.0
2021-07-07	AFK	ETF	22.05	22.05	21.785	21.82	9694.0
2021-07-07	AFLG	ETF	25.694	25.694	25.694	25.694	100.0
2021-07-07	AFMC	ETF	25.248	25.248	25.248	25.248	100.0
2021-07-07	AFSM	ETF	26.02	26.026	26.02	26.026	100.0
2021-07-07	AFTY	ETF	22.49	22.832	22.49	22.77	3200.0
2021-07-07	AGG	ETF	115.83	116.02	115.75	115.93	7786400.0
2021-07-07	AGGY	ETF	52.55	52.68	52.54	52.65	120300.0
2021-07-07	AGNG	ETF	30.608	30.78	30.608	30.78	2400.0
2021-07-07	AGOX	ETF	26.17	26.17	25.86	26.051	12000.0
2021-07-07	AGQ	ETF	46.78	46.93	45.5	46.08	652300.0
2021-07-07	AGZ	ETF	118.64	118.8399	118.62	118.7928	34910.0
2021-07-07	AGZD	ETF	23.535	23.55	23.505	23.535	17400.0
2021-07-07	AIA	ETF	89.17	89.265	88.385	88.71	191006.0
2021-07-07	AIEQ	ETF	41.65	41.814	40.87	41.14	17200.0
2021-07-07	AIQ	ETF	30.99	31.0	30.64	30.74	24616.0
2021-07-07	AIRR	ETF	39.96	40.19	39.67	40.09	59600.0
2021-07-07	AIVI	ETF	43.24	43.43	43.24	43.35	2800.0
2021-07-07	ALTL	ETF	41.73	42.06	41.73	41.99	24908.0
2021-07-07	ALTY	ETF	13.59	13.615	13.49	13.56	20700.0
2021-07-07	AMJ	ETF	19.64	19.76	19.19	19.23	941273.0
2021-07-07	AMLP	ETF	36.43	36.67	35.57	35.67	2763700.0
2021-07-07	AMNA	ETF	33.8465	33.8465	33.8465	33.8465	0.0
2021-07-07	AMND	ETF	35.8119	35.8119	35.8119	35.8119	1.0

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

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