PREVIEW / etf_daily / 2017-11-14

all etf daily files

  file:    by_date/etf_daily/2017/2017-11-14.parquet
  size:    59 KB
  rows:    1,517

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
2017-11-14	SPY	ETF	257.41	257.85	256.52	257.73	61315200.0
2017-11-14	QQQ	ETF	153.31	153.5	152.57	153.31	25173763.0
2017-11-14	IWM	ETF	146.06	146.49	145.59	146.21	19682200.0
2017-11-14	DIA	ETF	233.97	234.35	232.91	234.28	2566500.0
2017-11-14	GLD	ETF	120.9	121.91	120.77	121.56	6189000.0
2017-11-14	TLT	ETF	124.77	125.24	124.77	125.2	6195900.0
2017-11-14	AADR	ETF	56.06	56.06	55.09	55.12	44000.0
2017-11-14	AAXJ	ETF	75.89	75.93	75.57	75.67	483400.0
2017-11-14	ACSI	ETF	29.7	29.7	29.6	29.65	1941.0
2017-11-14	ACTX	ETF	50.1505	51.9205	46.3744	47.7904	832.0
2017-11-14	ACWF	ETF	30.0	30.06	29.9445	30.04	8253.0
2017-11-14	ACWI	ETF	70.14	70.18	69.9	70.14	1108100.0
2017-11-14	ACWV	ETF	82.6	83.0	82.52	82.95	108400.0
2017-11-14	ACWX	ETF	48.94	48.96	48.8	48.94	530607.0
2017-11-14	ADRE	ETF	42.7	42.7	42.24	42.3	6042.0
2017-11-14	AFK	ETF	23.74	23.74	23.39	23.39	10744.0
2017-11-14	AFTY	ETF	18.44	18.44	18.29	18.29	5000.0
2017-11-14	AGG	ETF	109.01	109.12	109.0	109.1	2799900.0
2017-11-14	AGGY	ETF	50.5	50.55	50.5	50.54	26600.0
2017-11-14	AGNG	ETF	19.242	19.311	19.213	19.304	1500.0
2017-11-14	AGQ	ETF	34.26	34.72	33.88	34.45	42400.0
2017-11-14	AGZ	ETF	113.314	113.35	113.28	113.33	7983.0
2017-11-14	AGZD	ETF	24.085	24.085	24.085	24.085	1000.0
2017-11-14	AIA	ETF	65.89	65.89	65.5	65.63	39263.0
2017-11-14	AIEQ	ETF	24.29	24.37	24.211	24.34	158300.0
2017-11-14	AIRR	ETF	25.6	25.7	25.52	25.54	18000.0
2017-11-14	AIVI	ETF	42.63	42.72	42.6	42.68	4000.0
2017-11-14	ALTY	ETF	15.375	15.38	15.375	15.375	5100.0
2017-11-14	AMJ	ETF	26.65	26.73	26.27	26.29	3007389.0
2017-11-14	AMLP	ETF	51.5	51.75	50.75	50.75	3803140.0
2017-11-14	AMZA	ETF	81.6	81.7	79.8	80.1	159080.0
2017-11-14	ANGL	ETF	29.78	29.78	29.67	29.72	238400.0
2017-11-14	AOA	ETF	54.13	54.22	54.03	54.22	45300.0
2017-11-14	AOK	ETF	34.48	34.56	34.4752	34.52	57217.0
2017-11-14	AOM	ETF	38.07	38.11	38.0091	38.11	81813.0
2017-11-14	AOR	ETF	45.15	45.18	45.08	45.14	78816.0
2017-11-14	ARGT	ETF	31.89	31.89	30.68	30.68	129800.0
2017-11-14	ARKG	ETF	24.33	24.35	23.411	23.87	73500.0
2017-11-14	ARKK	ETF	34.72	35.14	34.26	34.51	161000.0
2017-11-14	ARKQ	ETF	33.15	33.62	32.92	33.11	51700.0
2017-11-14	ARKW	ETF	43.0	43.17	42.81	42.93	83100.0
2017-11-14	ASEA	ETF	16.26	16.26	16.06	16.22	3900.0
2017-11-14	ASET	ETF	28.27	28.27	28.25	28.259	3446.0
2017-11-14	ASHR	ETF	31.25	31.29	31.17	31.19	883700.0
2017-11-14	ASHS	ETF	36.37	36.37	36.14	36.19	3000.0
2017-11-14	ASHX	ETF	23.2	23.2	23.06	23.06	453.0
2017-11-14	ATMP	ETF	20.23	20.23	19.85	19.86	20100.0
2017-11-14	BAB	ETF	30.51	30.64	30.51	30.51	79575.0
2017-11-14	BAL	ETF	45.48	45.48	45.22	45.22	933.0
2017-11-14	BAR	ETF	12.769	12.806	12.769	12.791	65810.0

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

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