PREVIEW / etf_daily / 2020-02-26

all etf daily files

  file:    by_date/etf_daily/2020/2020-02-26.parquet
  size:    76 KB
  rows:    1,967

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-02-26	SPY	ETF	314.18	318.11	310.7	311.5	194773800.0
2020-02-26	QQQ	ETF	216.67	220.28	214.9	216.48	80400053.0
2020-02-26	IWM	ETF	157.05	158.49	154.22	154.5	39465000.0
2020-02-26	DIA	ETF	271.99	275.31	268.83	269.74	7477600.0
2020-02-26	GLD	ETF	153.82	155.28	152.9	153.97	17912500.0
2020-02-26	TLT	ETF	149.95	151.72	149.58	150.25	22589500.0
2020-02-26	AAAU	ETF	16.31	16.45	16.21	16.32	97800.0
2020-02-26	AADR	ETF	53.16	53.43	52.39	52.45	7700.0
2020-02-26	AAXJ	ETF	69.64	70.13	69.31	69.35	1562600.0
2020-02-26	ABEQ	ETF	24.178	24.178	23.914	23.914	400.0
2020-02-26	ACES	ETF	39.34	40.394	39.221	39.255	99600.0
2020-02-26	ACIO	ETF	24.52	24.53	24.399	24.399	12200.0
2020-02-26	ACSI	ETF	35.4423	35.65	34.83	34.83	1951.0
2020-02-26	ACTX	ETF	6.8264	7.9651	6.8264	7.1113	162.0
2020-02-26	ACWF	ETF	30.1	30.1	29.57	29.5848	7872.0
2020-02-26	ACWI	ETF	76.26	77.02	75.55	75.68	7015500.0
2020-02-26	ACWV	ETF	95.35	96.21	94.91	94.98	824000.0
2020-02-26	ACWX	ETF	46.18	46.47	45.83	45.88	2491181.0
2020-02-26	ADME	ETF	30.86	30.91	30.611	30.611	6200.0
2020-02-26	ADRE	ETF	41.05	41.532	40.8	40.94	7651.0
2020-02-26	AESR	ETF	9.797	9.797	9.78	9.783	1600.0
2020-02-26	AFIF	ETF	9.7849	9.82	9.78	9.78	13808.0
2020-02-26	AFK	ETF	18.26	18.5763	18.26	18.5	36420.0
2020-02-26	AFMC	ETF	19.496	19.496	19.127	19.127	100.0
2020-02-26	AFSM	ETF	19.218	19.218	18.861	18.861	100.0
2020-02-26	AFTY	ETF	16.422	16.462	16.33	16.332	5100.0
2020-02-26	AGG	ETF	115.32	115.61	115.26	115.35	4763000.0
2020-02-26	AGGY	ETF	53.52	53.624	53.48	53.51	285100.0
2020-02-26	AGNG	ETF	23.67	23.93	23.5	23.63	5800.0
2020-02-26	AGQ	ETF	31.2	31.6	30.86	31.18	348000.0
2020-02-26	AGZ	ETF	118.02	118.2862	117.89	118.2	78504.0
2020-02-26	AGZD	ETF	23.99	23.99	23.87	23.915	15400.0
2020-02-26	AIA	ETF	63.05	63.5587	62.91	62.91	68990.0
2020-02-26	AIEQ	ETF	28.0	28.29	27.6	27.62	26400.0
2020-02-26	AIQ	ETF	18.15	18.4671	18.045	18.1134	25292.0
2020-02-26	AIRR	ETF	27.5	27.5	26.885	26.91	3900.0
2020-02-26	AIVI	ETF	39.37	39.67	39.08	39.16	177800.0
2020-02-26	ALTY	ETF	14.27	14.433	14.23	14.245	13700.0
2020-02-26	AMJ	ETF	18.76	18.92	18.26	18.27	4216464.0
2020-02-26	AMLP	ETF	35.55	35.9	34.6	34.65	7218100.0
2020-02-26	AMOM	ETF	25.946	25.946	25.946	25.946	100.0
2020-02-26	AMUB	ETF	11.68	11.86	11.5276	11.5276	2463.0
2020-02-26	AMZA	ETF	34.6	34.9	32.5	32.7	204240.0
2020-02-26	ANGL	ETF	29.75	29.92	29.74	29.86	689900.0
2020-02-26	AOA	ETF	56.13	56.63	55.9	55.9	108400.0
2020-02-26	AOK	ETF	36.28	36.3921	36.21	36.26	200132.0
2020-02-26	AOM	ETF	40.04	40.13	39.85	39.88	214317.0
2020-02-26	AOR	ETF	46.97	47.2256	46.76	46.77	172369.0
2020-02-26	ARCM	ETF	100.13	100.19	100.13	100.19	200.0
2020-02-26	ARGT	ETF	24.36	24.5	23.93	23.95	27900.0

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

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