PREVIEW / etf_daily / 2020-06-25

all etf daily files

  file:    by_date/etf_daily/2020/2020-06-25.parquet
  size:    77 KB
  rows:    2,037

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-06-25	SPY	ETF	303.47	307.64	301.28	307.35	89468000.0
2020-06-25	QQQ	ETF	243.91	246.34	241.14	246.03	36940811.0
2020-06-25	IWM	ETF	137.71	140.58	136.29	140.45	37191200.0
2020-06-25	DIA	ETF	253.34	257.71	252.06	257.44	4312300.0
2020-06-25	GLD	ETF	165.89	165.91	165.16	165.8	7093800.0
2020-06-25	TLT	ETF	164.21	164.35	163.4	163.5	10968000.0
2020-06-25	AAAU	ETF	17.6	17.6	17.52	17.59	246800.0
2020-06-25	AADR	ETF	52.08	52.94	52.06	52.94	5000.0
2020-06-25	AAXJ	ETF	69.36	69.79	69.1	69.79	455700.0
2020-06-25	ABEQ	ETF	22.011	22.188	21.969	22.187	5500.0
2020-06-25	ACES	ETF	37.56	37.98	36.93	37.98	27600.0
2020-06-25	ACIO	ETF	25.0	25.082	24.958	25.082	2000.0
2020-06-25	ACSI	ETF	32.75	33.1116	32.75	33.1116	208.0
2020-06-25	ACTX	ETF	4.0651	4.0651	3.304	3.363	1544.0
2020-06-25	ACWF	ETF	27.185	27.64	27.185	27.6393	120735.0
2020-06-25	ACWI	ETF	72.96	73.87	72.51	73.84	1579100.0
2020-06-25	ACWV	ETF	86.87	87.44	86.28	87.43	179700.0
2020-06-25	ACWX	ETF	43.09	43.58	42.89	43.54	1935417.0
2020-06-25	ADME	ETF	31.815	32.08	31.801	32.05	4100.0
2020-06-25	ADRE	ETF	39.79	40.0142	39.705	40.0142	3028.0
2020-06-25	AESR	ETF	9.81	9.871	9.775	9.871	28500.0
2020-06-25	AFIF	ETF	9.81	9.84	9.8	9.825	60389.0
2020-06-25	AFK	ETF	16.25	16.32	16.24	16.24	4165.0
2020-06-25	AFLG	ETF	18.49	18.642	18.49	18.642	300.0
2020-06-25	AFMC	ETF	16.39	16.62	16.39	16.62	300.0
2020-06-25	AFSM	ETF	16.21	16.418	16.21	16.418	200.0
2020-06-25	AFTY	ETF	16.62	16.64	16.59	16.63	4300.0
2020-06-25	AGG	ETF	117.94	117.95	117.8	117.87	4723300.0
2020-06-25	AGGY	ETF	53.71	53.71	53.59	53.625	146400.0
2020-06-25	AGNG	ETF	24.125	24.354	24.09	24.354	1400.0
2020-06-25	AGQ	ETF	27.43	27.83	27.2	27.79	445400.0
2020-06-25	AGZ	ETF	121.0	121.08	120.85	120.9735	42143.0
2020-06-25	AGZD	ETF	23.49	23.535	23.43	23.485	11200.0
2020-06-25	AIA	ETF	64.74	65.11	64.58	65.02	36954.0
2020-06-25	AIEQ	ETF	27.58	27.963	27.517	27.9	11100.0
2020-06-25	AIQ	ETF	20.39	20.61	20.3112	20.5985	6403.0
2020-06-25	AIRR	ETF	23.065	23.283	22.731	23.283	12700.0
2020-06-25	AIVI	ETF	35.38	35.77	35.24	35.72	87300.0
2020-06-25	ALTL	ETF	23.78	24.0732	23.72	24.0732	112665.0
2020-06-25	ALTY	ETF	10.66	10.8	10.58	10.752	13500.0
2020-06-25	AMJ	ETF	13.6	13.97	13.39	13.69	865809.0
2020-06-25	AMLP	ETF	25.08	25.98	24.9	25.49	2129300.0
2020-06-25	AMNA	ETF	23.9503	23.9503	23.9503	23.9503	2.0
2020-06-25	AMOM	ETF	29.04	29.327	29.04	29.327	700.0
2020-06-25	AMUB	ETF	8.63	8.775	8.47	8.61	39965.0
2020-06-25	AMZA	ETF	18.05	18.929	17.92	18.31	107000.0
2020-06-25	ANGL	ETF	28.78	28.88	28.59	28.87	1219700.0
2020-06-25	AOA	ETF	54.21	54.79	54.03	54.75	37000.0
2020-06-25	AOK	ETF	36.17	36.36	36.11	36.36	78384.0
2020-06-25	AOM	ETF	39.59	39.87	39.51	39.87	228256.0

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

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