PREVIEW / etf_daily / 2015-12-08

all etf daily files

  file:    by_date/etf_daily/2015/2015-12-08.parquet
  size:    50 KB
  rows:    1,235

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
2015-12-08	SPY	ETF	206.49	208.29	205.78	206.95	103372400.0
2015-12-08	QQQ	ETF	113.44	114.995	113.38	114.63	30792648.0
2015-12-08	IWM	ETF	114.96	116.01	114.46	115.37	30946000.0
2015-12-08	DIA	ETF	175.68	176.86	174.92	175.77	6890200.0
2015-12-08	GLD	ETF	103.13	103.26	102.53	102.84	3412300.0
2015-12-08	TLT	ETF	122.28	122.43	121.45	121.81	7257500.0
2015-12-08	AADR	ETF	38.2	38.88	38.2	38.88	1100.0
2015-12-08	AAXJ	ETF	53.89	54.31	53.69	54.28	1759000.0
2015-12-08	ACTX	ETF	9.4401	9.4401	7.0801	7.6701	2328.0
2015-12-08	ACWI	ETF	56.71	57.07	56.54	56.85	2900100.0
2015-12-08	ACWV	ETF	69.57	70.01	69.44	69.89	110700.0
2015-12-08	ACWX	ETF	40.01	40.21	39.92	40.13	939902.0
2015-12-08	ADRE	ETF	29.84	30.02	29.79	30.02	3907.0
2015-12-08	AFK	ETF	18.22	18.34	18.1597	18.29	15409.0
2015-12-08	AFTY	ETF	16.15	16.39	16.15	16.34	27400.0
2015-12-08	AGG	ETF	108.59	108.6	108.37	108.44	2311800.0
2015-12-08	AGGY	ETF	49.35	49.45	49.35	49.35	2200.0
2015-12-08	AGQ	ETF	28.93	29.04	28.4	28.55	107800.0
2015-12-08	AGZ	ETF	113.26	113.373	113.09	113.17	14589.0
2015-12-08	AIA	ETF	43.19	43.51	43.13	43.46	49455.0
2015-12-08	AIQ	ETF	8.58	8.58	8.268	8.56	11714.0
2015-12-08	AIRR	ETF	17.1	17.22	17.05	17.09	16300.0
2015-12-08	AIVI	ETF	38.26	38.38	38.18	38.31	33500.0
2015-12-08	ALTY	ETF	13.82	13.89	13.82	13.89	400.0
2015-12-08	AMJ	ETF	24.36	26.22	24.05	25.77	9747326.0
2015-12-08	AMLP	ETF	47.75	53.1	47.75	52.25	6322200.0
2015-12-08	AMUB	ETF	16.24	16.24	16.21	16.21	300.0
2015-12-08	AMZA	ETF	91.5	98.9	89.6	96.5	4630.0
2015-12-08	ANGL	ETF	24.93	25.13	24.92	24.99	16600.0
2015-12-08	AOA	ETF	45.36	45.56	45.25	45.38	255400.0
2015-12-08	AOK	ETF	31.87	31.93	31.8275	31.85	146368.0
2015-12-08	AOM	ETF	34.45	34.51	34.28	34.42	537599.0
2015-12-08	AOR	ETF	39.33	39.36	39.17	39.31	708116.0
2015-12-08	ARGT	ETF	17.5	17.68	17.47	17.66	10600.0
2015-12-08	ARKG	ETF	19.52	20.01	19.52	19.98	1800.0
2015-12-08	ARKK	ETF	20.72	20.99	20.72	20.99	1000.0
2015-12-08	ARKQ	ETF	19.29	19.29	19.29	19.29	200.0
2015-12-08	ARKW	ETF	23.32	24.002	23.32	23.995	7800.0
2015-12-08	ASEA	ETF	12.6	12.6	12.6	12.6	100.0
2015-12-08	ASET	ETF	24.3599	24.36	24.3599	24.36	768.0
2015-12-08	ASHR	ETF	35.42	35.85	35.42	35.7	2111600.0
2015-12-08	ASHS	ETF	44.19	44.7	44.05	44.46	121900.0
2015-12-08	ATMP	ETF	15.85	17.13	15.85	16.84	350600.0
2015-12-08	AWAY	ETF	35.21	35.98	34.8994	35.83	3683055.0
2015-12-08	BAB	ETF	29.32	29.32	29.15	29.23	52423.0
2015-12-08	BAL	ETF	42.91	43.02	42.91	42.97	1319.0
2015-12-08	BBC	ETF	28.59	29.9399	28.59	29.76	5362.0
2015-12-08	BBH	ETF	120.5	124.13	120.5	123.84	83700.0
2015-12-08	BBP	ETF	29.79	30.665	29.75	30.5	3800.0
2015-12-08	BCM	ETF	24.35	24.35	24.1401	24.1601	7216.0

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

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