PREVIEW / etf_daily / 2021-08-11

all etf daily files

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

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-08-11	SPY	ETF	443.82	443.88	442.62	443.78	44034300.0
2021-08-11	QQQ	ETF	368.14	368.65	364.84	366.21	34249812.0
2021-08-11	IWM	ETF	223.02	223.73	220.47	223.69	25691300.0
2021-08-11	DIA	ETF	353.94	355.12	353.7	354.94	3422500.0
2021-08-11	GLD	ETF	163.15	164.17	162.68	164.0	7382400.0
2021-08-11	TLT	ETF	146.41	147.23	145.71	146.48	17227600.0
2021-08-11	AAA	ETF	25.015	25.015	25.015	25.015	11.0
2021-08-11	AAAU	ETF	17.36	17.45	17.3	17.43	282100.0
2021-08-11	AADR	ETF	69.36	69.36	69.36	69.36	500.0
2021-08-11	AAXJ	ETF	88.98	89.05	88.42	88.75	631000.0
2021-08-11	ABEQ	ETF	27.945	27.975	27.945	27.975	1200.0
2021-08-11	ACES	ETF	72.56	72.56	70.43	71.29	90800.0
2021-08-11	ACIO	ETF	30.75	30.85	30.75	30.8	30200.0
2021-08-11	ACSI	ETF	51.58	51.61	51.5699	51.61	1421.0
2021-08-11	ACTV	ETF	38.38	38.74	38.38	38.74	8834.0
2021-08-11	ACTX	ETF	1.92	1.92	1.41	1.42	1768.0
2021-08-11	ACVF	ETF	32.75	32.94	32.75	32.929	3100.0
2021-08-11	ACWF	ETF	38.73	38.845	38.635	38.7704	5031.0
2021-08-11	ACWI	ETF	103.49	103.53	103.16	103.45	4213500.0
2021-08-11	ACWV	ETF	105.66	105.71	105.44	105.56	143800.0
2021-08-11	ACWX	ETF	57.64	57.64	57.38	57.55	2208810.0
2021-08-11	ADFI	ETF	9.72	9.75	9.67	9.715	18100.0
2021-08-11	ADIV	ETF	18.382	18.382	18.382	18.382	100.0
2021-08-11	ADME	ETF	40.84	40.84	40.57	40.68	89000.0
2021-08-11	ADRE	ETF	53.4	53.4	52.8931	52.98	6807.0
2021-08-11	AEMB	ETF	49.775	49.775	49.775	49.775	100.0
2021-08-11	AESR	ETF	14.05	14.1	14.03	14.085	69500.0
2021-08-11	AFIF	ETF	9.61	9.705	9.61	9.69	7503.0
2021-08-11	AFK	ETF	21.9	21.9	21.87	21.9	2143.0
2021-08-11	AFLG	ETF	26.428	26.428	26.428	26.428	1100.0
2021-08-11	AFMC	ETF	26.001	26.001	26.001	26.001	1100.0
2021-08-11	AFSM	ETF	26.36	26.582	26.36	26.582	1900.0
2021-08-11	AFTY	ETF	21.22	21.22	21.22	21.22	200.0
2021-08-11	AGG	ETF	115.46	115.7	115.34	115.54	6674600.0
2021-08-11	AGGY	ETF	52.34	52.47	52.31	52.44	74400.0
2021-08-11	AGNG	ETF	30.17	30.17	30.001	30.001	2100.0
2021-08-11	AGOV	ETF	100.005	100.005	100.005	100.005	82.0
2021-08-11	AGOX	ETF	26.37	26.52	26.37	26.496	19300.0
2021-08-11	AGQ	ETF	36.58	36.85	36.1	36.8	754800.0
2021-08-11	AGZ	ETF	118.83	118.96	118.79	118.8652	28525.0
2021-08-11	AGZD	ETF	23.46	23.5	23.435	23.435	13600.0
2021-08-11	AIA	ETF	85.0	85.08	84.38	84.77	70405.0
2021-08-11	AIEQ	ETF	41.82	41.88	41.35	41.705	9200.0
2021-08-11	AIQ	ETF	30.91	30.915	30.7001	30.74	8543.0
2021-08-11	AIRR	ETF	42.58	42.86	42.18	42.86	21600.0
2021-08-11	AIVI	ETF	43.88	43.98	43.83	43.98	53600.0
2021-08-11	ALTL	ETF	43.11	43.1844	43.0551	43.1	10112.0
2021-08-11	ALTY	ETF	13.61	13.71	13.61	13.71	9700.0
2021-08-11	AMJ	ETF	17.97	18.23	17.825	18.23	406080.0
2021-08-11	AMLP	ETF	33.12	33.58	32.84	33.53	1665700.0

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

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