PREVIEW / etf_daily / 2020-12-23

all etf daily files

  file:    by_date/etf_daily/2020/2020-12-23.parquet
  size:    83 KB
  rows:    2,194

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
2020-12-23	SPY	ETF	368.28	369.62	367.22	367.57	46201400.0
2020-12-23	QQQ	ETF	309.81	310.18	308.035	308.2	21201280.0
2020-12-23	IWM	ETF	198.57	199.65	197.9	199.14	18392000.0
2020-12-23	DIA	ETF	301.2	302.79	301.14	301.28	2714400.0
2020-12-23	GLD	ETF	175.1	176.21	175.06	175.65	6542800.0
2020-12-23	TLT	ETF	156.62	156.69	155.46	156.67	9266600.0
2020-12-23	AAA	ETF	25.08	25.09	25.08	25.09	1881.0
2020-12-23	AAAU	ETF	18.6	18.7	18.58	18.64	305800.0
2020-12-23	AADR	ETF	60.38	60.89	60.38	60.46	4000.0
2020-12-23	AAXJ	ETF	87.17	87.23	86.82	87.17	2184700.0
2020-12-23	ABEQ	ETF	25.29	25.41	25.267	25.41	3700.0
2020-12-23	ACES	ETF	80.53	80.91	79.125	80.11	165100.0
2020-12-23	ACIO	ETF	27.34	28.0	27.34	27.42	19400.0
2020-12-23	ACSI	ETF	43.3898	43.3898	43.3898	43.3898	132.0
2020-12-23	ACTV	ETF	31.39	31.48	31.3499	31.4489	3272.0
2020-12-23	ACTX	ETF	2.595	2.595	1.6	2.44	11906.0
2020-12-23	ACVF	ETF	27.5	27.6	27.461	27.461	3200.0
2020-12-23	ACWF	ETF	33.14	33.2276	33.14	33.17	30927.0
2020-12-23	ACWI	ETF	89.57	89.8	89.43	89.48	4822800.0
2020-12-23	ACWV	ETF	95.5	95.7	95.32	95.36	232300.0
2020-12-23	ACWX	ETF	52.27	52.42	52.235	52.36	668244.0
2020-12-23	ADME	ETF	35.68	35.76	35.59	35.59	15600.0
2020-12-23	ADRE	ETF	55.62	55.62	55.16	55.53	17158.0
2020-12-23	AESR	ETF	11.81	11.81	11.774	11.774	2700.0
2020-12-23	AFIF	ETF	9.73	9.77	9.73	9.76	23601.0
2020-12-23	AFK	ETF	20.48	20.695	20.445	20.55	18394.0
2020-12-23	AFLG	ETF	22.27	22.27	22.208	22.208	2900.0
2020-12-23	AFTY	ETF	21.95	21.95	21.903	21.903	700.0
2020-12-23	AGG	ETF	117.81	117.88	117.63	117.88	4157700.0
2020-12-23	AGGY	ETF	53.41	53.461	53.38	53.42	98900.0
2020-12-23	AGNG	ETF	27.95	27.95	27.877	27.9	42100.0
2020-12-23	AGQ	ETF	47.94	49.03	47.83	48.36	883900.0
2020-12-23	AGZ	ETF	119.54	119.61	119.47	119.61	140570.0
2020-12-23	AGZD	ETF	23.605	23.605	23.5	23.54	14800.0
2020-12-23	AIA	ETF	83.75	83.85	83.55	83.67	86358.0
2020-12-23	AIEQ	ETF	36.43	36.6	36.07	36.492	12100.0
2020-12-23	AIQ	ETF	27.38	27.39	27.12	27.12	145242.0
2020-12-23	AIRR	ETF	33.71	34.11	33.71	33.91	40500.0
2020-12-23	AIVI	ETF	40.01	40.19	40.01	40.12	39900.0
2020-12-23	ALTL	ETF	31.86	31.86	31.58	31.66	14859.0
2020-12-23	ALTY	ETF	11.62	11.75	11.62	11.67	18300.0
2020-12-23	AMJ	ETF	14.36	14.48	14.195	14.23	813493.0
2020-12-23	AMLP	ETF	26.37	26.84	26.26	26.42	2295200.0
2020-12-23	AMNA	ETF	25.7	25.75	25.7	25.7127	202.0
2020-12-23	AMND	ETF	27.4919	27.4919	27.4919	27.4919	9.0
2020-12-23	AMOM	ETF	39.69	39.69	39.602	39.602	600.0
2020-12-23	AMTR	ETF	28.94	29.03	28.94	29.0085	5100.0
2020-12-23	AMUB	ETF	9.0599	9.11	8.95	8.9773	16340.0
2020-12-23	AMZA	ETF	19.62	20.08	19.56	19.71	172900.0
2020-12-23	ANEW	ETF	42.113	42.239	42.05	42.112	4500.0

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

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