PREVIEW / etf_daily / 2021-10-19

all etf daily files

  file:    by_date/etf_daily/2021/2021-10-19.parquet
  size:    94 KB
  rows:    2,526

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-19	SPY	ETF	448.92	450.71	448.27	450.64	46996800.0
2021-10-19	QQQ	ETF	373.75	375.52	372.6974	375.47	29090963.0
2021-10-19	IWM	ETF	225.98	226.88	224.61	225.87	15498400.0
2021-10-19	DIA	ETF	353.67	354.51	352.8	354.46	2380900.0
2021-10-19	GLD	ETF	166.5	166.5	165.2	165.45	6588500.0
2021-10-19	TLT	ETF	144.66	144.73	143.65	143.7	12156300.0
2021-10-19	AAA	ETF	25.0	25.0	25.0	25.0	743.0
2021-10-19	AAAU	ETF	17.7	17.71	17.57	17.61	83500.0
2021-10-19	AADR	ETF	65.83	66.24	65.83	66.06	1300.0
2021-10-19	AAXJ	ETF	88.1	88.77	87.93	88.74	1147000.0
2021-10-19	ABEQ	ETF	27.9	27.9	27.65	27.71	8800.0
2021-10-19	ACES	ETF	70.73	72.659	70.73	72.39	65300.0
2021-10-19	ACIO	ETF	31.16	31.22	31.12	31.163	35400.0
2021-10-19	ACSI	ETF	51.29	51.32	51.24	51.3002	16295.0
2021-10-19	ACT	ETF	21.95	22.77	21.525	22.51	209721.0
2021-10-19	ACTV	ETF	39.03	39.14	38.88	38.985	6132.0
2021-10-19	ACTX	ETF	1.0	1.0	1.0	1.0	1000.0
2021-10-19	ACVF	ETF	33.46	33.58	33.419	33.53	14500.0
2021-10-19	ACWF	ETF	37.99	38.1391	37.98	38.1045	4622.0
2021-10-19	ACWI	ETF	104.15	104.57	104.08	104.57	2740100.0
2021-10-19	ACWV	ETF	104.63	105.17	104.63	105.14	360600.0
2021-10-19	ACWX	ETF	57.26	57.44	57.2	57.4	1564417.0
2021-10-19	ADFI	ETF	9.639	9.66	9.639	9.645	2100.0
2021-10-19	ADIV	ETF	17.56	17.56	17.522	17.522	700.0
2021-10-19	ADME	ETF	41.0	41.23	41.0	41.15	38500.0
2021-10-19	ADRE	ETF	51.59	52.0	51.59	52.0	7788.0
2021-10-19	AESR	ETF	14.21	14.29	14.21	14.27	11100.0
2021-10-19	AFIF	ETF	9.59	9.6	9.58	9.585	16627.0
2021-10-19	AFK	ETF	22.11	22.11	22.0	22.03	3182.0
2021-10-19	AFLG	ETF	26.43	26.47	26.38	26.442	2400.0
2021-10-19	AFSM	ETF	26.782	26.782	26.782	26.782	100.0
2021-10-19	AFTY	ETF	21.37	21.531	21.37	21.531	7200.0
2021-10-19	AGG	ETF	114.37	114.37	114.16	114.16	5041000.0
2021-10-19	AGGY	ETF	51.84	51.84	51.71	51.71	308700.0
2021-10-19	AGNG	ETF	29.13	29.38	29.13	29.37	3000.0
2021-10-19	AGOV	ETF	99.34	99.64	99.34	99.41	1360.0
2021-10-19	AGOX	ETF	26.815	26.98	26.815	26.96	85100.0
2021-10-19	AGQ	ETF	37.69	37.9	36.42	36.55	929300.0
2021-10-19	AGZ	ETF	117.94	118.0065	117.91	117.99	28142.0
2021-10-19	AGZD	ETF	23.48	23.48	23.455	23.475	31800.0
2021-10-19	AIA	ETF	81.83	82.94	81.825	82.93	87730.0
2021-10-19	AIEQ	ETF	42.97	43.25	42.857	42.96	13400.0
2021-10-19	AIQ	ETF	31.85	32.1	31.85	32.07	35092.0
2021-10-19	AIRR	ETF	42.39	42.496	42.0	42.39	9100.0
2021-10-19	AIVI	ETF	41.69	41.74	41.69	41.7	3100.0
2021-10-19	ALTL	ETF	42.77	43.09	42.7	42.97	50890.0
2021-10-19	ALTY	ETF	13.6	13.619	13.56	13.595	14700.0
2021-10-19	AMJ	ETF	19.88	19.96	19.72	19.96	504697.0
2021-10-19	AMLP	ETF	36.61	36.74	36.3	36.74	1786400.0
2021-10-19	AMNA	ETF	35.8769	35.8769	35.8769	35.8769	0.0

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

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