PREVIEW / etf_daily / 2021-01-25

all etf daily files

  file:    by_date/etf_daily/2021/2021-01-25.parquet
  size:    85 KB
  rows:    2,244

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-01-25	SPY	ETF	383.67	384.77	378.46	384.39	70402000.0
2021-01-25	QQQ	ETF	328.91	330.32	321.41	328.11	39080644.0
2021-01-25	IWM	ETF	214.93	217.91	211.6	214.79	33985000.0
2021-01-25	DIA	ETF	308.99	309.78	305.62	309.65	4546400.0
2021-01-25	GLD	ETF	174.82	174.96	173.19	174.05	5936800.0
2021-01-25	TLT	ETF	152.76	153.69	152.64	153.67	8712600.0
2021-01-25	AAA	ETF	25.155	25.155	25.155	25.155	47.0
2021-01-25	AAAU	ETF	18.55	18.58	18.4	18.47	632000.0
2021-01-25	AADR	ETF	63.79	63.79	62.77	63.09	3100.0
2021-01-25	AAXJ	ETF	99.29	99.59	98.22	99.19	674000.0
2021-01-25	ABEQ	ETF	25.59	25.72	25.51	25.695	7700.0
2021-01-25	ACES	ETF	98.99	101.24	95.3	96.84	225100.0
2021-01-25	ACIO	ETF	27.87	27.95	27.752	27.95	9400.0
2021-01-25	ACSI	ETF	44.45	44.88	44.45	44.62	1389.0
2021-01-25	ACTV	ETF	32.845	33.14	32.83	33.14	3891.0
2021-01-25	ACTX	ETF	3.515	20.0	3.41	4.91	6803.0
2021-01-25	ACVF	ETF	28.52	28.52	28.13	28.429	4000.0
2021-01-25	ACWF	ETF	35.46	35.48	35.1437	35.4	17226.0
2021-01-25	ACWI	ETF	93.96	94.14	92.79	94.08	5147600.0
2021-01-25	ACWV	ETF	97.45	98.17	97.45	98.15	321700.0
2021-01-25	ACWX	ETF	55.35	55.5	54.875	55.48	983931.0
2021-01-25	ADFI	ETF	9.911	9.911	9.911	9.911	4000.0
2021-01-25	ADME	ETF	36.86	36.86	36.32	36.6	18900.0
2021-01-25	ADRE	ETF	63.05	63.1075	61.5	62.33	46762.0
2021-01-25	AESR	ETF	12.21	12.21	12.131	12.179	4100.0
2021-01-25	AFIF	ETF	9.74	9.78	9.74	9.765	52908.0
2021-01-25	AFK	ETF	22.0	22.0	21.3101	21.4486	34491.0
2021-01-25	AFLG	ETF	23.25	23.28	23.1	23.182	9300.0
2021-01-25	AFSM	ETF	24.3	24.378	24.3	24.378	2900.0
2021-01-25	AFTY	ETF	24.84	24.89	24.777	24.838	4300.0
2021-01-25	AGG	ETF	117.39	117.56	117.36	117.55	4049000.0
2021-01-25	AGGY	ETF	53.25	53.28	53.206	53.28	83000.0
2021-01-25	AGNG	ETF	29.44	29.444	29.27	29.444	21900.0
2021-01-25	AGQ	ETF	47.18	47.4	45.36	46.09	963800.0
2021-01-25	AGZ	ETF	119.43	119.6	119.43	119.6	32562.0
2021-01-25	AGZD	ETF	23.59	23.62	23.53	23.61	53400.0
2021-01-25	AIA	ETF	101.09	101.09	99.62	100.48	237685.0
2021-01-25	AIEQ	ETF	39.94	40.41	38.79	39.83	65100.0
2021-01-25	AIQ	ETF	29.06	29.1499	28.3681	28.9	221112.0
2021-01-25	AIRR	ETF	37.55	37.55	36.32	36.81	44600.0
2021-01-25	AIVI	ETF	41.75	42.09	41.64	42.09	6800.0
2021-01-25	ALTL	ETF	33.5915	33.6	33.1975	33.4411	6031.0
2021-01-25	ALTY	ETF	12.01	12.05	11.947	12.03	21700.0
2021-01-25	AMJ	ETF	15.0	15.0699	14.72	14.98	740437.0
2021-01-25	AMLP	ETF	27.67	27.81	27.12	27.67	2346900.0
2021-01-25	AMNA	ETF	26.9643	26.9643	26.9643	26.9643	3.0
2021-01-25	AMND	ETF	28.631	28.631	28.631	28.631	4.0
2021-01-25	AMOM	ETF	33.508	33.508	33.08	33.201	800.0
2021-01-25	AMTR	ETF	30.8	30.99	30.78	30.9798	808.0
2021-01-25	AMUB	ETF	9.36	9.45	9.28	9.45	19328.0

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

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