PREVIEW / etf_daily / 2016-10-07

all etf daily files

  file:    by_date/etf_daily/2016/2016-10-07.parquet
  size:    51 KB
  rows:    1,294

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
2016-10-07	SPY	ETF	216.1	216.3	214.19	215.04	89788300.0
2016-10-07	QQQ	ETF	118.86	119.01	117.89	118.47	19984158.0
2016-10-07	IWM	ETF	124.04	124.32	122.23	122.83	28732700.0
2016-10-07	DIA	ETF	182.8	182.99	181.32	182.22	2527700.0
2016-10-07	GLD	ETF	120.49	120.58	118.42	119.74	17907300.0
2016-10-07	TLT	ETF	133.93	134.29	133.09	133.92	9953200.0
2016-10-07	AADR	ETF	40.23	40.41	40.23	40.41	200.0
2016-10-07	AAXJ	ETF	60.94	61.04	60.37	60.75	909000.0
2016-10-07	ACTX	ETF	5.9001	9.4991	5.9001	7.6701	11587.0
2016-10-07	ACWI	ETF	58.95	59.02	58.43	58.76	1093600.0
2016-10-07	ACWV	ETF	74.75	74.9	74.23	74.57	188400.0
2016-10-07	ACWX	ETF	41.3	41.35	40.92	41.21	210507.0
2016-10-07	ADRE	ETF	35.57	35.57	35.14	35.33	3480.0
2016-10-07	AFK	ETF	20.71	20.71	20.58	20.588	2094.0
2016-10-07	AFTY	ETF	13.522	13.54	13.49	13.49	800.0
2016-10-07	AGG	ETF	111.64	111.67	111.41	111.58	1867600.0
2016-10-07	AGGY	ETF	51.657	51.69	51.551	51.64	34900.0
2016-10-07	AGNG	ETF	16.24	16.24	16.24	16.24	300.0
2016-10-07	AGQ	ETF	40.22	40.48	38.06	39.8	276200.0
2016-10-07	AGZ	ETF	115.1369	115.18	114.955	115.1147	20495.0
2016-10-07	AGZD	ETF	23.945	23.95	23.945	23.95	3400.0
2016-10-07	AIA	ETF	50.81	50.82	50.3	50.58	63328.0
2016-10-07	AIQ	ETF	7.31	7.31	7.11	7.13	6554.0
2016-10-07	AIRR	ETF	20.6	20.6	20.19	20.21	14200.0
2016-10-07	AIVI	ETF	38.47	38.47	38.16	38.38	14000.0
2016-10-07	ALTY	ETF	15.23	15.23	15.16	15.16	2500.0
2016-10-07	AMJ	ETF	30.7	30.9846	30.675	30.68	1055057.0
2016-10-07	AMLP	ETF	62.45	62.85	62.25	62.45	2005940.0
2016-10-07	AMZA	ETF	108.0	108.7	107.5	107.7	12630.0
2016-10-07	ANGL	ETF	28.93	28.97	28.86	28.95	139900.0
2016-10-07	AOA	ETF	47.17	47.17	46.84	47.11	22900.0
2016-10-07	AOK	ETF	33.2	33.2	33.01	33.1	41933.0
2016-10-07	AOM	ETF	35.71	35.77	35.561	35.64	51596.0
2016-10-07	AOR	ETF	40.81	40.81	40.51	40.75	28400.0
2016-10-07	ARGT	ETF	24.37	24.37	24.2	24.35	7400.0
2016-10-07	ARKG	ETF	19.19	19.19	19.19	19.19	400.0
2016-10-07	ARKK	ETF	21.701	21.701	21.701	21.701	200.0
2016-10-07	ARKQ	ETF	22.176	22.176	21.974	21.974	1300.0
2016-10-07	ARKW	ETF	25.4	25.4	25.301	25.32	1200.0
2016-10-07	ASEA	ETF	13.87	13.91	13.87	13.91	600.0
2016-10-07	ASET	ETF	25.7	25.7	25.7	25.7	320.0
2016-10-07	ASHR	ETF	24.66	24.67	24.52	24.66	581600.0
2016-10-07	ASHS	ETF	34.81	34.87	34.65	34.73	7600.0
2016-10-07	ATMP	ETF	22.89	22.95	22.75	22.78	64500.0
2016-10-07	BAB	ETF	31.02	31.09	30.9669	31.09	84584.0
2016-10-07	BAL	ETF	44.66	44.89	44.19	44.2101	25025.0
2016-10-07	BBC	ETF	22.0	22.02	21.62	21.73	3309.0
2016-10-07	BBH	ETF	113.06	113.42	111.98	113.12	41800.0
2016-10-07	BBP	ETF	33.2	33.2	32.498	32.83	10100.0
2016-10-07	BCM	ETF	26.67	26.67	26.48	26.5461	2971.0

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

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