PREVIEW / etf_daily / 2019-12-04

all etf daily files

  file:    by_date/etf_daily/2019/2019-12-04.parquet
  size:    73 KB
  rows:    1,911

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-12-04	SPY	ETF	310.7	312.12	310.32	311.46	49080000.0
2019-12-04	QQQ	ETF	202.49	202.91	202.14	202.43	15336754.0
2019-12-04	IWM	ETF	160.5	161.22	160.3	160.78	10833200.0
2019-12-04	DIA	ETF	277.0	277.76	276.61	277.05	1928500.0
2019-12-04	GLD	ETF	139.16	139.17	138.59	138.92	6322300.0
2019-12-04	TLT	ETF	140.34	140.5	139.21	139.8	8586300.0
2019-12-04	AAAU	ETF	14.74	14.74	14.69	14.72	22000.0
2019-12-04	AADR	ETF	50.96	51.2	50.69	51.12	11600.0
2019-12-04	AAXJ	ETF	69.47	69.56	69.39	69.43	529100.0
2019-12-04	ACES	ETF	32.29	32.45	32.288	32.35	30300.0
2019-12-04	ACIO	ETF	25.226	25.27	25.2	25.23	12200.0
2019-12-04	ACSI	ETF	34.891	35.05	34.891	34.9802	1301.0
2019-12-04	ACTX	ETF	5.9001	7.0801	5.9001	7.0742	578.0
2019-12-04	ACWF	ETF	30.3504	30.4638	30.3435	30.3981	4577.0
2019-12-04	ACWI	ETF	76.98	77.26	76.93	77.18	2282800.0
2019-12-04	ACWV	ETF	95.47	95.71	95.26	95.65	230300.0
2019-12-04	ACWX	ETF	47.81	47.94	47.78	47.94	1624345.0
2019-12-04	ADME	ETF	30.106	30.115	30.086	30.092	2200.0
2019-12-04	ADRE	ETF	41.44	41.62	41.415	41.415	1809.0
2019-12-04	AFIF	ETF	9.97	9.97	9.7594	9.7594	4624.0
2019-12-04	AFK	ETF	20.7	20.83	20.7	20.7481	2812.0
2019-12-04	AFLG	ETF	20.03	20.05	19.9925	19.9925	7495.0
2019-12-04	AFMC	ETF	20.1	20.11	19.9843	19.9843	1138.0
2019-12-04	AFSM	ETF	20.1	20.13	20.0537	20.0537	4758.0
2019-12-04	AFTY	ETF	17.202	17.218	17.16	17.163	2600.0
2019-12-04	AGG	ETF	112.87	112.95	112.68	112.81	5806500.0
2019-12-04	AGGY	ETF	52.37	52.39	52.26	52.35	114800.0
2019-12-04	AGNG	ETF	23.73	23.82	23.615	23.815	10100.0
2019-12-04	AGQ	ETF	29.1	29.1	28.14	28.32	310700.0
2019-12-04	AGZ	ETF	116.09	116.17	115.96	116.0	14653.0
2019-12-04	AGZD	ETF	23.985	24.015	23.925	23.97	34400.0
2019-12-04	AIA	ETF	61.22	61.365	61.195	61.273	12317.0
2019-12-04	AIEQ	ETF	27.55	27.64	27.42	27.53	53200.0
2019-12-04	AIQ	ETF	17.05	17.1	17.0315	17.09	3165.0
2019-12-04	AIRR	ETF	28.45	28.525	28.431	28.502	6600.0
2019-12-04	AIVI	ETF	41.64	41.81	41.64	41.81	5000.0
2019-12-04	ALTY	ETF	14.622	14.635	14.588	14.63	10500.0
2019-12-04	AMJ	ETF	19.86	20.12	19.73	20.12	4617042.0
2019-12-04	AMLP	ETF	38.75	39.0	38.35	38.55	9634660.0
2019-12-04	AMOM	ETF	26.572	26.572	26.572	26.572	100.0
2019-12-04	AMUB	ETF	12.561	12.561	12.561	12.561	4.0
2019-12-04	AMZA	ETF	39.9	40.4	39.6	40.1	92990.0
2019-12-04	ANGL	ETF	29.25	29.28	29.22	29.27	522500.0
2019-12-04	AOA	ETF	56.64	56.83	56.64	56.79	84900.0
2019-12-04	AOK	ETF	35.96	36.0292	35.96	35.96	83610.0
2019-12-04	AOM	ETF	39.82	39.8509	39.77	39.78	227837.0
2019-12-04	AOR	ETF	47.0	47.14	47.0	47.14	154227.0
2019-12-04	ARGT	ETF	22.99	23.54	22.99	23.41	59800.0
2019-12-04	ARKF	ETF	23.6	23.69	23.591	23.595	9600.0
2019-12-04	ARKG	ETF	34.54	34.65	34.15	34.45	75300.0

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

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