PREVIEW / etf_daily / 2019-10-16

all etf daily files

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

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-16	SPY	ETF	298.37	299.16	297.92	298.4	48928200.0
2019-10-16	QQQ	ETF	192.88	193.53	192.43	193.04	20689207.0
2019-10-16	IWM	ETF	151.21	152.27	151.14	151.55	13119100.0
2019-10-16	DIA	ETF	269.79	270.56	269.4	270.08	2415000.0
2019-10-16	GLD	ETF	140.14	140.53	139.7	140.41	10330300.0
2019-10-16	TLT	ETF	139.64	140.06	139.35	139.92	7729500.0
2019-10-16	AAAU	ETF	14.85	14.88	14.8	14.86	94900.0
2019-10-16	AADR	ETF	48.38	48.46	48.22	48.37	7700.0
2019-10-16	AAXJ	ETF	68.25	68.49	68.13	68.33	607300.0
2019-10-16	ACES	ETF	30.85	30.95	30.73	30.82	8600.0
2019-10-16	ACIO	ETF	24.63	24.63	24.61	24.61	15800.0
2019-10-16	ACSI	ETF	33.97	33.9962	33.9425	33.9425	2654.0
2019-10-16	ACTX	ETF	12.0951	13.3648	11.8001	11.8001	343.0
2019-10-16	ACWF	ETF	29.22	29.23	29.1192	29.1455	5366.0
2019-10-16	ACWI	ETF	74.41	74.64	74.32	74.53	2983200.0
2019-10-16	ACWV	ETF	94.7	94.92	94.55	94.86	177800.0
2019-10-16	ACWX	ETF	46.62	46.835	46.61	46.75	1014784.0
2019-10-16	ADRE	ETF	39.59	39.8041	39.59	39.8041	2749.0
2019-10-16	AFIF	ETF	9.74	9.75	9.73	9.735	20628.0
2019-10-16	AFK	ETF	20.11	20.1771	20.0833	20.1	2708.0
2019-10-16	AFTY	ETF	17.52	17.52	17.45	17.45	6600.0
2019-10-16	AGG	ETF	112.68	112.79	112.62	112.75	2430600.0
2019-10-16	AGGY	ETF	52.17	52.21	52.139	52.2	85100.0
2019-10-16	AGNG	ETF	21.48	21.679	21.48	21.51	900.0
2019-10-16	AGQ	ETF	30.46	30.7	30.15	30.59	211200.0
2019-10-16	AGZ	ETF	116.15	116.189	116.0664	116.155	21629.0
2019-10-16	AGZD	ETF	23.905	23.905	23.88	23.88	7200.0
2019-10-16	AIA	ETF	60.58	60.7999	60.58	60.67	32274.0
2019-10-16	AIEQ	ETF	26.47	26.47	26.312	26.385	8300.0
2019-10-16	AIQ	ETF	16.26	16.26	16.13	16.13	36510.0
2019-10-16	AIRR	ETF	26.86	27.01	26.85	26.85	7800.0
2019-10-16	AIVI	ETF	41.1	41.17	41.1	41.12	1700.0
2019-10-16	ALTY	ETF	14.71	14.76	14.67	14.76	30600.0
2019-10-16	AMJ	ETF	22.15	22.3499	22.08	22.14	2675721.0
2019-10-16	AMLP	ETF	43.75	44.05	43.45	43.6	2318500.0
2019-10-16	AMUB	ETF	13.9277	13.9277	13.9277	13.9277	0.0
2019-10-16	AMZA	ETF	46.7	47.1	46.3	46.4	44600.0
2019-10-16	ANGL	ETF	29.32	29.41	29.29	29.33	1727200.0
2019-10-16	AOA	ETF	55.08	55.18	55.04	55.15	43700.0
2019-10-16	AOK	ETF	35.56	35.65	35.5565	35.64	52185.0
2019-10-16	AOM	ETF	39.1	39.1899	39.08	39.12	69563.0
2019-10-16	AOR	ETF	46.0	46.1077	46.0	46.09	66972.0
2019-10-16	ARCM	ETF	100.22	100.23	100.17	100.17	800.0
2019-10-16	ARGT	ETF	22.96	22.98	22.61	22.69	22200.0
2019-10-16	ARKF	ETF	21.76	21.83	21.76	21.796	5100.0
2019-10-16	ARKG	ETF	29.15	29.263	28.98	29.1	82700.0
2019-10-16	ARKK	ETF	42.99	43.08	42.694	42.8	188400.0
2019-10-16	ARKQ	ETF	32.28	32.749	32.28	32.45	6100.0
2019-10-16	ARKW	ETF	50.34	50.34	49.77	49.93	112900.0
2019-10-16	ASEA	ETF	15.6	15.69	15.56	15.69	3500.0

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

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