PREVIEW / etf_daily / 2016-10-18

all etf daily files

  file:    by_date/etf_daily/2016/2016-10-18.parquet
  size:    52 KB
  rows:    1,306

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-18	SPY	ETF	214.24	214.31	213.27	213.71	76869700.0
2016-10-18	QQQ	ETF	118.18	118.41	117.8	117.86	19276656.0
2016-10-18	IWM	ETF	121.52	121.58	120.66	120.98	19158900.0
2016-10-18	DIA	ETF	181.94	182.1	181.12	181.37	1720700.0
2016-10-18	GLD	ETF	120.08	120.64	119.82	120.42	4919700.0
2016-10-18	TLT	ETF	131.86	132.89	131.83	132.86	7151000.0
2016-10-18	AADR	ETF	41.0	41.17	40.89	40.89	1000.0
2016-10-18	AAXJ	ETF	60.01	60.05	59.79	59.92	386100.0
2016-10-18	ACTX	ETF	10.0301	11.2101	8.8501	11.2101	3388.0
2016-10-18	ACWI	ETF	58.41	58.49	58.23	58.35	1156800.0
2016-10-18	ACWV	ETF	74.5	74.65	74.24	74.43	138300.0
2016-10-18	ACWX	ETF	40.99	41.07	40.89	41.01	126506.0
2016-10-18	ADRE	ETF	35.67	35.82	35.6	35.69	15122.0
2016-10-18	AFK	ETF	20.12	20.405	19.8901	20.25	7147.0
2016-10-18	AFTY	ETF	13.52	13.56	13.52	13.56	3300.0
2016-10-18	AGG	ETF	111.54	111.74	111.47	111.74	1582900.0
2016-10-18	AGGY	ETF	51.56	51.73	51.56	51.705	30000.0
2016-10-18	AGQ	ETF	40.16	40.7	39.83	40.37	135700.0
2016-10-18	AGZ	ETF	114.83	115.2599	114.7546	115.18	8800.0
2016-10-18	AGZD	ETF	23.975	23.98	23.975	23.98	800.0
2016-10-18	AIA	ETF	49.57	49.64	49.47	49.63	33825.0
2016-10-18	AIQ	ETF	7.8	8.05	7.8	7.925	6787.0
2016-10-18	AIRR	ETF	19.93	20.03	19.88	19.98	11200.0
2016-10-18	AIVI	ETF	38.08	38.12	37.99	38.09	22000.0
2016-10-18	ALTY	ETF	15.19	15.227	15.115	15.22	1800.0
2016-10-18	AMJ	ETF	31.03	31.2641	30.965	31.23	889375.0
2016-10-18	AMLP	ETF	62.9	63.1	62.7	63.05	1185600.0
2016-10-18	AMZA	ETF	108.5	109.0	106.91	108.4	4490.0
2016-10-18	ANGL	ETF	29.15	29.16	29.09	29.16	146200.0
2016-10-18	AOA	ETF	46.93	46.94	46.78	46.78	38000.0
2016-10-18	AOK	ETF	33.02	33.07	32.887	33.07	169948.0
2016-10-18	AOM	ETF	35.56	35.65	35.5001	35.61	85876.0
2016-10-18	AOR	ETF	40.53	40.615	40.474	40.52	42108.0
2016-10-18	ARGT	ETF	24.27	24.27	23.98	24.11	9600.0
2016-10-18	ARKG	ETF	17.743	17.743	17.743	17.743	200.0
2016-10-18	ARKK	ETF	20.54	20.57	20.54	20.57	900.0
2016-10-18	ARKQ	ETF	21.48	21.48	21.23	21.23	1600.0
2016-10-18	ARKW	ETF	24.834	24.834	24.818	24.818	700.0
2016-10-18	ASEA	ETF	13.81	13.81	13.74	13.74	400.0
2016-10-18	ASET	ETF	25.91	26.0	25.91	25.97	424.0
2016-10-18	ASHR	ETF	24.75	24.9	24.75	24.86	1372300.0
2016-10-18	ASHS	ETF	35.3	35.37	35.24	35.29	8800.0
2016-10-18	ASHX	ETF	23.08	23.08	23.08	23.08	10711.0
2016-10-18	ATMP	ETF	23.01	23.01	22.9	22.99	7500.0
2016-10-18	BAB	ETF	30.8	30.94	30.75	30.93	64919.0
2016-10-18	BAL	ETF	47.17	47.6257	47.09	47.11	18939.0
2016-10-18	BBC	ETF	19.85	20.0199	19.85	19.91	3739.0
2016-10-18	BBH	ETF	106.99	108.0	106.99	107.4	38400.0
2016-10-18	BBP	ETF	30.68	30.76	30.48	30.48	3900.0
2016-10-18	BCM	ETF	26.69	26.69	26.69	26.69	264.0

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

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