PREVIEW / etf_daily / 2019-01-15

all etf daily files

  file:    by_date/etf_daily/2019/2019-01-15.parquet
  size:    67 KB
  rows:    1,739

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-01-15	SPY	ETF	257.82	260.7	257.81	260.35	85208300.0
2019-01-15	QQQ	ETF	159.97	162.6	159.9096	162.38	40874224.0
2019-01-15	IWM	ETF	142.65	143.65	142.09	143.45	25678900.0
2019-01-15	DIA	ETF	238.94	241.03	238.89	240.64	3940300.0
2019-01-15	GLD	ETF	122.28	122.38	121.62	121.88	7512500.0
2019-01-15	TLT	ETF	120.56	120.57	119.95	120.04	8997400.0
2019-01-15	AAAU	ETF	12.93	12.93	12.86	12.88	137900.0
2019-01-15	AADR	ETF	42.57	42.8	42.47	42.55	7900.0
2019-01-15	AAXJ	ETF	65.28	65.7	65.21	65.34	1552600.0
2019-01-15	ACES	ETF	24.346	24.346	24.2	24.24	7500.0
2019-01-15	ACSI	ETF	30.1382	30.3789	30.1382	30.3789	1038.0
2019-01-15	ACTX	ETF	54.2805	54.2805	49.5604	50.7405	391.0
2019-01-15	ACWF	ETF	27.0	27.2328	27.0	27.16	99970.0
2019-01-15	ACWI	ETF	66.43	66.92	66.43	66.84	4393300.0
2019-01-15	ACWV	ETF	82.62	83.05	82.53	82.96	167200.0
2019-01-15	ACWX	ETF	43.48	43.69	43.39	43.62	4054489.0
2019-01-15	ADRE	ETF	38.42	38.5308	38.2185	38.3409	3203.0
2019-01-15	AFIF	ETF	9.93	9.955	9.92	9.95	12888.0
2019-01-15	AFK	ETF	20.68	20.684	20.6	20.6	5441.0
2019-01-15	AFTY	ETF	13.97	13.97	13.86	13.899	1300.0
2019-01-15	AGG	ETF	106.54	106.55	106.33	106.42	3690200.0
2019-01-15	AGGY	ETF	48.405	48.41	48.33	48.355	187300.0
2019-01-15	AGNG	ETF	20.29	20.29	20.29	20.29	23100.0
2019-01-15	AGQ	ETF	26.96	27.02	26.54	26.59	41700.0
2019-01-15	AGZ	ETF	112.21	112.23	112.12	112.18	8791.0
2019-01-15	AGZD	ETF	23.665	23.705	23.635	23.685	18600.0
2019-01-15	AIA	ETF	56.84	57.07	56.64	56.82	101630.0
2019-01-15	AIEQ	ETF	23.32	23.55	23.32	23.54	50400.0
2019-01-15	AIQ	ETF	13.7	13.9	13.7	13.88	10141.0
2019-01-15	AIRR	ETF	23.19	23.24	23.02	23.21	25600.0
2019-01-15	AIVI	ETF	39.15	39.15	38.97	39.12	5500.0
2019-01-15	ALTY	ETF	14.02	14.18	14.02	14.17	18400.0
2019-01-15	AMJ	ETF	24.37	24.75	24.32	24.66	2037061.0
2019-01-15	AMLP	ETF	48.1	48.8	47.9	48.55	5138140.0
2019-01-15	AMUB	ETF	15.5486	15.5486	15.5486	15.5486	0.0
2019-01-15	AMZA	ETF	57.3	58.8	57.3	58.6	32750.0
2019-01-15	ANGL	ETF	27.84	27.9	27.77	27.9	309000.0
2019-01-15	AOA	ETF	49.98	50.2	49.95	50.15	76900.0
2019-01-15	AOK	ETF	33.06	33.1699	33.06	33.14	92809.0
2019-01-15	AOM	ETF	36.23	36.31	36.21	36.3	238769.0
2019-01-15	AOR	ETF	42.12	42.3	42.12	42.26	394441.0
2019-01-15	ARCM	ETF	99.77	99.805	99.7	99.805	49200.0
2019-01-15	ARGT	ETF	26.34	26.34	26.11	26.31	11800.0
2019-01-15	ARKG	ETF	27.62	28.14	27.36	28.12	137100.0
2019-01-15	ARKK	ETF	41.42	42.32	41.42	42.28	591500.0
2019-01-15	ARKQ	ETF	31.31	31.71	31.02	31.647	20600.0
2019-01-15	ARKW	ETF	46.57	47.583	46.57	47.34	156800.0
2019-01-15	ASEA	ETF	15.95	16.0	15.94	15.94	8800.0
2019-01-15	ASET	ETF	26.79	26.79	26.7	26.7299	1378.0
2019-01-15	ASHR	ETF	23.12	23.22	23.08	23.22	1653600.0

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

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