PREVIEW / etf_daily / 2021-01-28

all etf daily files

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

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-28	SPY	ETF	376.36	381.93	375.89	377.63	94198100.0
2021-01-28	QQQ	ETF	320.67	326.42	320.03	321.32	42836324.0
2021-01-28	IWM	ETF	210.84	212.37	207.63	208.72	32202500.0
2021-01-28	DIA	ETF	304.98	309.42	304.83	306.07	6392100.0
2021-01-28	GLD	ETF	174.28	174.73	172.04	172.68	9392400.0
2021-01-28	TLT	ETF	153.4	153.46	152.16	152.92	10667800.0
2021-01-28	AAA	ETF	25.15	25.15	25.15	25.15	218.0
2021-01-28	AAAU	ETF	18.5	18.55	18.27	18.33	614100.0
2021-01-28	AADR	ETF	61.0	61.6	61.0	61.22	2500.0
2021-01-28	AAXJ	ETF	94.64	96.25	94.5	95.89	1309500.0
2021-01-28	ABEQ	ETF	25.47	25.63	25.441	25.62	5500.0
2021-01-28	ACES	ETF	93.25	94.72	91.9	93.9	114900.0
2021-01-28	ACIO	ETF	27.66	27.72	27.48	27.48	8300.0
2021-01-28	ACSI	ETF	43.7089	43.7089	43.6355	43.6355	587.0
2021-01-28	ACTV	ETF	33.38	33.47	33.22	33.22	1948.0
2021-01-28	ACTX	ETF	4.5	4.6	4.5	4.6	821.0
2021-01-28	ACVF	ETF	27.91	28.099	27.91	28.005	1400.0
2021-01-28	ACWF	ETF	34.495	34.8096	34.43	34.603	9222.0
2021-01-28	ACWI	ETF	91.87	93.08	91.75	92.25	5900200.0
2021-01-28	ACWV	ETF	96.79	97.54	96.68	96.71	205500.0
2021-01-28	ACWX	ETF	54.12	54.68	54.06	54.43	1272177.0
2021-01-28	ADFI	ETF	9.895	9.895	9.89	9.89	2700.0
2021-01-28	ADME	ETF	36.19	36.44	36.095	36.095	7300.0
2021-01-28	ADRE	ETF	60.0	61.0	59.965	60.62	24400.0
2021-01-28	AESR	ETF	12.05	12.05	11.968	11.968	5700.0
2021-01-28	AFIF	ETF	9.745	9.76	9.74	9.75	18730.0
2021-01-28	AFK	ETF	21.14	21.14	21.0	21.01	16922.0
2021-01-28	AFLG	ETF	22.8	22.94	22.775	22.775	1200.0
2021-01-28	AFMC	ETF	22.27	22.46	22.27	22.3	2100.0
2021-01-28	AFSM	ETF	23.69	23.95	23.68	23.7	5200.0
2021-01-28	AFTY	ETF	24.0	24.23	23.97	24.17	8400.0
2021-01-28	AGG	ETF	117.48	117.49	117.29	117.44	6176500.0
2021-01-28	AGGY	ETF	53.32	53.32	53.195	53.27	116800.0
2021-01-28	AGNG	ETF	28.47	28.755	28.429	28.66	7200.0
2021-01-28	AGQ	ETF	50.16	52.23	47.2	50.75	4499900.0
2021-01-28	AGZ	ETF	119.55	119.55	119.41	119.5	21195.0
2021-01-28	AGZD	ETF	23.56	23.645	23.56	23.61	5200.0
2021-01-28	AIA	ETF	95.0	96.4	94.61	96.15	221822.0
2021-01-28	AIEQ	ETF	38.9	39.27	38.53	38.95	76100.0
2021-01-28	AIQ	ETF	27.97	28.39	27.89	28.09	71006.0
2021-01-28	AIRR	ETF	35.11	35.79	35.11	35.401	29700.0
2021-01-28	AIVI	ETF	41.65	41.8	41.65	41.69	4600.0
2021-01-28	ALTL	ETF	32.81	32.91	32.77	32.7713	1218.0
2021-01-28	ALTY	ETF	11.87	11.95	11.81	11.93	11200.0
2021-01-28	AMJ	ETF	14.67	14.88	14.61	14.86	604553.0
2021-01-28	AMLP	ETF	26.88	27.46	26.88	27.4	2468900.0
2021-01-28	AMNA	ETF	26.4998	26.4998	26.4998	26.4998	12.0
2021-01-28	AMND	ETF	28.2277	28.2277	28.2277	28.2277	0.0
2021-01-28	AMOM	ETF	32.19	32.5	32.17	32.259	2000.0
2021-01-28	AMTR	ETF	30.4454	30.4454	30.4454	30.4454	0.0

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

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