PREVIEW / etf_daily / 2019-02-25

all etf daily files

  file:    by_date/etf_daily/2019/2019-02-25.parquet
  size:    68 KB
  rows:    1,751

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
2019-02-25	SPY	ETF	280.73	281.31	279.43	279.52	69030700.0
2019-02-25	QQQ	ETF	174.2	174.66	173.4	173.52	32608754.0
2019-02-25	IWM	ETF	159.08	159.5	158.09	158.19	17957100.0
2019-02-25	DIA	ETF	261.85	262.36	260.75	260.89	3585000.0
2019-02-25	GLD	ETF	125.78	125.9	125.23	125.37	4882600.0
2019-02-25	TLT	ETF	121.17	121.3	120.92	121.21	6293500.0
2019-02-25	AAAU	ETF	13.31	13.31	13.25	13.26	17700.0
2019-02-25	AADR	ETF	46.5	46.6	46.31	46.44	3600.0
2019-02-25	AAXJ	ETF	70.77	71.06	70.71	70.82	1042300.0
2019-02-25	ACES	ETF	27.26	27.26	27.094	27.094	1100.0
2019-02-25	ACSI	ETF	32.7	32.7	32.51	32.51	1653.0
2019-02-25	ACTX	ETF	63.4256	64.9006	56.6405	61.9506	1292.0
2019-02-25	ACWF	ETF	29.51	29.5899	29.37	29.37	22374.0
2019-02-25	ACWI	ETF	71.63	71.75	71.37	71.38	1959700.0
2019-02-25	ACWV	ETF	88.02	88.1	87.47	87.54	170200.0
2019-02-25	ACWX	ETF	46.24	46.33	46.13	46.15	465239.0
2019-02-25	ADRE	ETF	41.17	41.17	41.0	41.1326	3507.0
2019-02-25	AFIF	ETF	9.99	10.0223	9.98	9.98	3707.0
2019-02-25	AFK	ETF	22.4248	22.465	22.409	22.42	1564.0
2019-02-25	AFTY	ETF	16.41	16.65	16.41	16.62	23800.0
2019-02-25	AGG	ETF	107.35	107.4	107.3	107.37	3645400.0
2019-02-25	AGGY	ETF	48.93	48.94	48.87	48.92	91600.0
2019-02-25	AGNG	ETF	21.61	21.778	21.41	21.489	3000.0
2019-02-25	AGQ	ETF	27.61	27.68	27.24	27.35	116000.0
2019-02-25	AGZ	ETF	112.28	112.3	112.2019	112.3	53642.0
2019-02-25	AGZD	ETF	23.83	23.86	23.8	23.855	3600.0
2019-02-25	AIA	ETF	61.89	62.38	61.89	62.05	199139.0
2019-02-25	AIEQ	ETF	25.83	25.955	25.77	25.77	41400.0
2019-02-25	AIQ	ETF	15.58	15.6	15.45	15.5	67454.0
2019-02-25	AIRR	ETF	25.78	25.928	25.71	25.71	434700.0
2019-02-25	AIVI	ETF	40.97	40.98	40.82	40.82	8900.0
2019-02-25	ALTY	ETF	14.91	14.97	14.9	14.91	29500.0
2019-02-25	AMJ	ETF	25.48	25.72	25.45	25.64	1157444.0
2019-02-25	AMLP	ETF	49.2	49.7	49.1	49.55	3143620.0
2019-02-25	AMUB	ETF	16.166	16.166	16.166	16.166	0.0
2019-02-25	AMZA	ETF	59.6	60.15	59.5	60.0	89940.0
2019-02-25	ANGL	ETF	28.57	28.62	28.5	28.57	274800.0
2019-02-25	AOA	ETF	53.14	53.25	52.97	52.99	53900.0
2019-02-25	AOK	ETF	34.1	34.1198	34.07	34.08	37719.0
2019-02-25	AOM	ETF	37.59	37.65	37.55	37.58	131860.0
2019-02-25	AOR	ETF	44.28	44.4099	44.18	44.18	87899.0
2019-02-25	ARCM	ETF	100.13	100.13	100.13	100.13	100.0
2019-02-25	ARGT	ETF	27.82	28.01	27.54	27.6	55800.0
2019-02-25	ARKF	ETF	21.3	21.4	21.196	21.206	54400.0
2019-02-25	ARKG	ETF	30.0	30.65	30.0	30.5	189300.0
2019-02-25	ARKK	ETF	46.46	46.84	46.148	46.39	357800.0
2019-02-25	ARKQ	ETF	35.39	35.679	35.373	35.381	30600.0
2019-02-25	ARKW	ETF	52.3	52.63	51.831	51.93	176000.0
2019-02-25	ASEA	ETF	16.23	16.45	16.23	16.38	8200.0
2019-02-25	ASET	ETF	28.51	28.6	28.51	28.52	2823.0

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

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