PREVIEW / etf_daily / 2021-01-04

all etf daily files

  file:    by_date/etf_daily/2021/2021-01-04.parquet
  size:    84 KB
  rows:    2,226

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-04	SPY	ETF	375.31	375.45	364.82	368.79	110210800.0
2021-01-04	QQQ	ETF	315.11	315.29	305.18	309.31	45305898.0
2021-01-04	IWM	ETF	197.54	197.89	190.94	193.5	33664200.0
2021-01-04	DIA	ETF	306.59	306.66	298.74	302.32	5106600.0
2021-01-04	GLD	ETF	181.97	182.4	180.96	182.33	14331400.0
2021-01-04	TLT	ETF	156.67	158.18	156.54	157.54	13152900.0
2021-01-04	AAA	ETF	25.065	25.07	25.065	25.0654	3752.0
2021-01-04	AAAU	ETF	19.33	19.36	19.22	19.35	767800.0
2021-01-04	AADR	ETF	61.95	62.12	61.12	61.44	47800.0
2021-01-04	AAXJ	ETF	91.24	91.55	90.06	90.43	1163500.0
2021-01-04	ABEQ	ETF	25.605	25.605	25.3	25.417	6900.0
2021-01-04	ACES	ETF	81.17	81.986	78.86	79.97	171900.0
2021-01-04	ACIO	ETF	27.807	27.807	27.407	27.578	41400.0
2021-01-04	ACSI	ETF	45.0	45.0	42.23	42.6054	795.0
2021-01-04	ACTV	ETF	31.28	31.28	30.99	31.0342	3962.0
2021-01-04	ACTX	ETF	2.26	2.26	2.26	2.26	349.0
2021-01-04	ACVF	ETF	28.06	28.06	27.2	27.351	3800.0
2021-01-04	ACWF	ETF	34.0	34.14	33.45	33.6272	9489.0
2021-01-04	ACWI	ETF	91.6	91.63	89.44	90.22	5006200.0
2021-01-04	ACWV	ETF	97.52	97.52	96.01	96.4	275300.0
2021-01-04	ACWX	ETF	54.01	54.075	53.09	53.32	2957953.0
2021-01-04	ADFI	ETF	9.96	9.96	9.96	9.96	100.0
2021-01-04	ADME	ETF	35.98	35.98	35.277	35.565	28300.0
2021-01-04	ADRE	ETF	56.76	57.0858	55.82	56.08	27290.0
2021-01-04	AESR	ETF	11.82	11.82	11.67	11.748	1500.0
2021-01-04	AFIF	ETF	9.79	9.81	9.74	9.75	105507.0
2021-01-04	AFK	ETF	21.01	21.3	20.501	20.6845	24477.0
2021-01-04	AFLG	ETF	21.86	22.001	21.86	22.001	900.0
2021-01-04	AFMC	ETF	20.9	21.045	20.9	21.045	200.0
2021-01-04	AFSM	ETF	21.881	21.881	21.881	21.881	100.0
2021-01-04	AFTY	ETF	23.44	23.44	23.135	23.191	7300.0
2021-01-04	AGG	ETF	118.08	118.14	117.99	118.04	6414100.0
2021-01-04	AGGY	ETF	53.55	53.68	53.55	53.61	133300.0
2021-01-04	AGNG	ETF	28.14	28.17	27.67	27.72	4200.0
2021-01-04	AGQ	ETF	55.45	55.78	52.6	54.55	1938900.0
2021-01-04	AGZ	ETF	119.51	119.6163	119.51	119.59	65019.0
2021-01-04	AGZD	ETF	23.57	23.62	23.525	23.575	34200.0
2021-01-04	AIA	ETF	89.33	89.53	88.2386	88.45	622928.0
2021-01-04	AIEQ	ETF	35.84	35.98	34.95	35.34	30400.0
2021-01-04	AIQ	ETF	27.39	27.41	26.65	26.94	79467.0
2021-01-04	AIRR	ETF	33.89	34.2	32.989	33.28	25100.0
2021-01-04	AIVI	ETF	41.28	41.28	40.64	40.66	5500.0
2021-01-04	ALTL	ETF	32.0	32.0	31.27	31.41	4474.0
2021-01-04	ALTY	ETF	11.69	11.71	11.5	11.55	34900.0
2021-01-04	AMJ	ETF	14.03	14.15	13.66	13.77	3420781.0
2021-01-04	AMLP	ETF	26.12	26.19	25.23	25.44	7087100.0
2021-01-04	AMNA	ETF	25.1066	25.1066	25.1066	25.1066	0.0
2021-01-04	AMND	ETF	26.7285	26.7285	26.7285	26.7285	58.0
2021-01-04	AMOM	ETF	32.1	32.25	31.7	31.768	5600.0
2021-01-04	AMTR	ETF	28.301	28.301	28.301	28.301	0.0

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

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