PREVIEW / etf_daily / 2019-10-21

all etf daily files

  file:    by_date/etf_daily/2019/2019-10-21.parquet
  size:    70 KB
  rows:    1,849

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-10-21	SPY	ETF	299.42	300.21	298.94	299.99	39048600.0
2019-10-21	QQQ	ETF	192.65	193.52	192.14	193.39	15868946.0
2019-10-21	IWM	ETF	154.17	154.98	153.91	154.04	17450300.0
2019-10-21	DIA	ETF	268.06	268.37	267.4	268.21	1379600.0
2019-10-21	GLD	ETF	140.72	140.76	139.6	139.79	8306200.0
2019-10-21	TLT	ETF	138.57	138.99	138.23	138.53	8038000.0
2019-10-21	AAAU	ETF	14.91	14.91	14.8	14.8	51200.0
2019-10-21	AADR	ETF	48.5	48.55	48.16	48.3	6200.0
2019-10-21	AAXJ	ETF	68.51	68.79	68.45	68.79	528600.0
2019-10-21	ACES	ETF	31.38	31.57	31.38	31.445	2700.0
2019-10-21	ACIO	ETF	24.73	24.74	24.713	24.719	11600.0
2019-10-21	ACSI	ETF	34.1	34.2598	34.1	34.2598	905.0
2019-10-21	ACTX	ETF	11.8001	11.8001	10.7381	11.8001	653.0
2019-10-21	ACWF	ETF	29.4	29.4	29.32	29.3702	5308.0
2019-10-21	ACWI	ETF	74.92	75.0	74.8	75.0	860600.0
2019-10-21	ACWV	ETF	95.6	95.6	95.26	95.43	79300.0
2019-10-21	ACWX	ETF	47.07	47.14	47.02	47.14	743178.0
2019-10-21	ADRE	ETF	39.34	39.67	39.34	39.67	3798.0
2019-10-21	AFIF	ETF	9.68	9.7	9.68	9.685	6607.0
2019-10-21	AFK	ETF	20.23	20.4799	20.23	20.3874	3611.0
2019-10-21	AFTY	ETF	17.46	17.474	17.44	17.474	700.0
2019-10-21	AGG	ETF	112.62	112.71	112.49	112.49	4241600.0
2019-10-21	AGGY	ETF	52.17	52.21	52.1	52.13	127900.0
2019-10-21	AGNG	ETF	21.79	21.79	21.79	21.79	900.0
2019-10-21	AGQ	ETF	32.11	32.2	31.03	31.18	270400.0
2019-10-21	AGZ	ETF	116.09	116.13	116.0039	116.0184	14979.0
2019-10-21	AGZD	ETF	23.9	23.955	23.9	23.94	19400.0
2019-10-21	AIA	ETF	60.84	60.91	60.6657	60.91	21647.0
2019-10-21	AIEQ	ETF	26.5	26.52	26.39	26.52	16700.0
2019-10-21	AIQ	ETF	15.9504	16.1026	15.9504	16.1026	3655.0
2019-10-21	AIRR	ETF	27.75	28.01	27.75	27.77	6300.0
2019-10-21	AIVI	ETF	41.42	41.51	41.39	41.43	10300.0
2019-10-21	ALTY	ETF	14.8	14.85	14.786	14.834	6700.0
2019-10-21	AMJ	ETF	22.2	22.29	22.1401	22.2	778921.0
2019-10-21	AMLP	ETF	43.7	43.85	43.5	43.55	2220460.0
2019-10-21	AMUB	ETF	13.9797	13.9797	13.9797	13.9797	0.0
2019-10-21	AMZA	ETF	46.1	46.3	45.7	45.9	52970.0
2019-10-21	ANGL	ETF	29.37	29.38	29.31	29.34	355300.0
2019-10-21	AOA	ETF	55.41	55.45	55.32	55.45	28200.0
2019-10-21	AOK	ETF	35.68	35.68	35.6	35.65	71735.0
2019-10-21	AOM	ETF	39.24	39.31	39.1861	39.25	93603.0
2019-10-21	AOR	ETF	46.16	46.25	46.14	46.25	70674.0
2019-10-21	ARCM	ETF	100.18	100.215	100.18	100.215	400.0
2019-10-21	ARGT	ETF	22.65	22.71	22.45	22.62	46300.0
2019-10-21	ARKF	ETF	21.77	21.98	21.77	21.963	11500.0
2019-10-21	ARKG	ETF	28.56	29.085	28.51	29.01	95900.0
2019-10-21	ARKK	ETF	42.23	42.58	41.94	42.41	151100.0
2019-10-21	ARKQ	ETF	32.42	32.426	32.214	32.293	3600.0
2019-10-21	ARKW	ETF	49.26	49.796	49.21	49.75	59100.0
2019-10-21	ASEA	ETF	15.81	15.81	15.67	15.77	4400.0

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

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