PREVIEW / etf_daily / 2020-04-16

all etf daily files

  file:    by_date/etf_daily/2020/2020-04-16.parquet
  size:    74 KB
  rows:    1,957

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-04-16	SPY	ETF	279.15	280.03	275.76	279.1	131798300.0
2020-04-16	QQQ	ETF	211.78	214.369	209.69	213.25	64657362.0
2020-04-16	IWM	ETF	118.09	118.42	114.56	116.91	49501300.0
2020-04-16	DIA	ETF	235.7	236.06	232.18	235.34	6126400.0
2020-04-16	GLD	ETF	161.88	163.15	160.65	161.71	9233200.0
2020-04-16	TLT	ETF	169.26	170.32	169.02	170.09	8265400.0
2020-04-16	AAAU	ETF	17.24	17.3	17.05	17.14	395700.0
2020-04-16	AADR	ETF	44.02	44.2	43.51	44.04	4600.0
2020-04-16	AAXJ	ETF	62.5	62.59	62.07	62.33	1030900.0
2020-04-16	ABEQ	ETF	20.987	21.21	20.987	21.21	12800.0
2020-04-16	ACES	ETF	31.07	31.44	30.705	31.06	73000.0
2020-04-16	ACIO	ETF	23.8	23.87	23.686	23.87	5200.0
2020-04-16	ACSI	ETF	29.9407	30.0979	29.9407	30.0979	283.0
2020-04-16	ACTX	ETF	5.428	5.428	4.7908	5.2292	101.0
2020-04-16	ACWF	ETF	25.3752	25.3752	25.1806	25.33	3449.0
2020-04-16	ACWI	ETF	66.06	66.23	65.33	66.01	2940900.0
2020-04-16	ACWV	ETF	85.86	85.93	85.04	85.71	414800.0
2020-04-16	ACWX	ETF	38.59	38.73	38.17	38.45	3666283.0
2020-04-16	ADME	ETF	29.97	30.0	29.75	29.914	6900.0
2020-04-16	ADRE	ETF	35.4723	35.6907	35.39	35.545	6183.0
2020-04-16	AESR	ETF	8.91	9.05	8.91	9.044	15200.0
2020-04-16	AFIF	ETF	9.8	9.86	9.79	9.83	28693.0
2020-04-16	AFK	ETF	13.89	13.9	13.53	13.53	12605.0
2020-04-16	AFLG	ETF	16.8	17.004	16.8	17.004	6500.0
2020-04-16	AFMC	ETF	14.51	14.704	14.51	14.704	6900.0
2020-04-16	AFSM	ETF	13.8	14.071	13.8	14.071	7200.0
2020-04-16	AFTY	ETF	15.24	15.33	15.24	15.255	4200.0
2020-04-16	AGG	ETF	117.19	117.53	117.19	117.39	4744700.0
2020-04-16	AGGY	ETF	53.38	54.352	52.2	53.34	322600.0
2020-04-16	AGNG	ETF	21.91	21.98	21.72	21.93	12300.0
2020-04-16	AGQ	ETF	22.21	22.58	21.62	22.36	185600.0
2020-04-16	AGZ	ETF	120.76	120.76	120.36	120.56	107756.0
2020-04-16	AGZD	ETF	23.4	23.515	23.4	23.415	3600.0
2020-04-16	AIA	ETF	58.38	58.47	58.0	58.29	68259.0
2020-04-16	AIEQ	ETF	24.72	24.9	24.55	24.9	18700.0
2020-04-16	AIQ	ETF	16.94	17.2	16.94	17.1085	10571.0
2020-04-16	AIRR	ETF	19.78	19.935	19.22	19.62	24100.0
2020-04-16	AIVI	ETF	32.13	32.2	31.78	31.94	48700.0
2020-04-16	ALTY	ETF	9.56	9.56	9.21	9.224	8200.0
2020-04-16	AMJ	ETF	10.41	10.68	10.39	10.46	3489155.0
2020-04-16	AMLP	ETF	20.0	20.15	19.45	19.6	6763520.0
2020-04-16	AMOM	ETF	24.76	24.954	24.76	24.954	500.0
2020-04-16	AMUB	ETF	6.71	6.72	6.6005	6.6005	15208.0
2020-04-16	AMZA	ETF	13.35	13.35	12.82	12.92	85600.0
2020-04-16	ANGL	ETF	27.27	27.29	26.97	27.14	1041800.0
2020-04-16	AOA	ETF	49.57	49.78	49.29	49.61	80600.0
2020-04-16	AOK	ETF	34.79	34.87	34.7	34.78	362446.0
2020-04-16	AOM	ETF	37.64	37.74	37.45	37.71	353448.0
2020-04-16	AOR	ETF	42.86	42.945	42.631	42.94	193920.0
2020-04-16	ARCM	ETF	100.323	100.323	100.27	100.27	200.0

> showing 50 of 1,957 rows — these rows as CSV

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