PREVIEW / etf_daily / 2021-12-22

all etf daily files

  file:    by_date/etf_daily/2021/2021-12-22.parquet
  size:    98 KB
  rows:    2,606

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-12-22	SPY	ETF	462.79	467.81	462.58	467.69	58890200.0
2021-12-22	QQQ	ETF	388.91	394.16	388.23	393.95	37042200.0
2021-12-22	IWM	ETF	217.87	220.35	217.13	220.28	32442000.0
2021-12-22	DIA	ETF	354.95	357.56	354.17	357.39	2999500.0
2021-12-22	GLD	ETF	167.58	168.64	167.11	168.59	4672900.0
2021-12-22	TLT	ETF	149.73	149.86	149.02	149.82	12253900.0
2021-12-22	AAA	ETF	25.03	25.03	25.015	25.015	1323.0
2021-12-22	AAAU	ETF	17.84	17.94	17.79	17.93	57200.0
2021-12-22	AADR	ETF	63.04	63.38	62.72	63.38	8700.0
2021-12-22	AAXJ	ETF	81.59	82.1	81.35	82.08	1102000.0
2021-12-22	ABEQ	ETF	27.996	28.1	27.996	28.09	8400.0
2021-12-22	ACES	ETF	63.55	64.26	63.11	64.1	246500.0
2021-12-22	ACIO	ETF	32.04	32.27	31.975	32.27	45100.0
2021-12-22	ACSI	ETF	52.4066	52.4066	52.4066	52.4066	276.0
2021-12-22	ACT	ETF	19.61	19.92	19.565	19.78	101835.0
2021-12-22	ACTV	ETF	35.54	35.88	35.45	35.7971	10399.0
2021-12-22	ACTX	ETF	1.4	1.4	1.4	1.4	2039.0
2021-12-22	ACVF	ETF	34.59	35.11	34.59	35.11	15700.0
2021-12-22	ACWF	ETF	38.015	38.39	38.015	38.39	3852.0
2021-12-22	ACWI	ETF	103.36	104.47	103.34	104.43	5294100.0
2021-12-22	ACWV	ETF	105.88	106.77	105.88	106.73	442800.0
2021-12-22	ACWX	ETF	54.58	55.16	54.54	55.15	2684778.0
2021-12-22	ADFI	ETF	9.58	9.61	9.58	9.595	2300.0
2021-12-22	ADIV	ETF	16.14	16.23	16.09	16.23	300.0
2021-12-22	ADME	ETF	42.37	42.76	42.33	42.76	21000.0
2021-12-22	ADRE	ETF	44.55	45.22	44.55	45.22	15047.0
2021-12-22	AEMB	ETF	48.251	48.251	48.251	48.251	100.0
2021-12-22	AESR	ETF	13.61	13.775	13.61	13.775	48100.0
2021-12-22	AFIF	ETF	9.54	9.56	9.54	9.56	39551.0
2021-12-22	AFK	ETF	19.48	19.97	19.48	19.9086	15263.0
2021-12-22	AFLG	ETF	27.626	27.681	27.626	27.681	400.0
2021-12-22	AFMC	ETF	26.097	26.146	26.048	26.146	500.0
2021-12-22	AFSM	ETF	27.172	27.231	27.172	27.231	300.0
2021-12-22	AFTY	ETF	21.365	21.37	21.365	21.37	400.0
2021-12-22	AGG	ETF	114.33	114.35	114.17	114.34	6171700.0
2021-12-22	AGGY	ETF	51.77	51.85	51.754	51.8	70200.0
2021-12-22	AGNG	ETF	28.36	28.755	28.36	28.755	6200.0
2021-12-22	AGOV	ETF	98.8063	98.8063	98.8063	98.8063	60.0
2021-12-22	AGOX	ETF	25.14	25.21	24.19	25.07	205400.0
2021-12-22	AGQ	ETF	32.94	33.41	32.57	33.34	541500.0
2021-12-22	AGZ	ETF	117.32	117.4052	117.2702	117.31	32815.0
2021-12-22	AGZD	ETF	23.36	23.375	23.315	23.335	79400.0
2021-12-22	AHHX	ETF	10.45	10.46	10.3445	10.3445	1091.0
2021-12-22	AHYB	ETF	50.02	50.035	50.02	50.035	100.0
2021-12-22	AIA	ETF	75.56	76.27	75.39	76.27	164455.0
2021-12-22	AIEQ	ETF	41.35	41.82	41.34	41.815	11400.0
2021-12-22	AIQ	ETF	31.28	31.65	31.2795	31.64	23174.0
2021-12-22	AIRR	ETF	43.64	44.045	43.394	44.0	63700.0
2021-12-22	AIVI	ETF	41.46	41.88	41.37	41.88	7900.0
2021-12-22	ALTL	ETF	44.9	45.305	44.73	45.26	166436.0

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

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