PREVIEW / etf_daily / 2015-01-16

all etf daily files

  file:    by_date/etf_daily/2015/2015-01-16.parquet
  size:    47 KB
  rows:    1,163

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-01-16	SPY	ETF	198.77	201.82	198.55	201.63	211879600.0
2015-01-16	QQQ	ETF	99.52	100.95	99.36	100.82	35362210.0
2015-01-16	IWM	ETF	114.41	116.94	114.2	116.7	41895700.0
2015-01-16	DIA	ETF	172.57	174.97	172.12	174.67	8721900.0
2015-01-16	GLD	ETF	121.73	123.15	121.71	122.52	14428200.0
2015-01-16	TLT	ETF	134.33	134.68	133.03	133.19	9390500.0
2015-01-16	AADR	ETF	36.25	36.25	36.25	36.25	200.0
2015-01-16	AAXJ	ETF	61.51	62.2	61.48	62.17	1174800.0
2015-01-16	ACWI	ETF	57.22	57.93	57.11	57.88	2580400.0
2015-01-16	ACWV	ETF	69.53	70.26	69.51	70.21	104900.0
2015-01-16	ACWX	ETF	42.23	42.78	42.23	42.77	614686.0
2015-01-16	ADRE	ETF	35.63	36.0	35.63	36.0	6491.0
2015-01-16	AFK	ETF	25.14	25.44	25.0501	25.44	25227.0
2015-01-16	AGG	ETF	111.68	111.83	111.42	111.5	2744500.0
2015-01-16	AGQ	ETF	45.07	48.73	45.06	48.0	603200.0
2015-01-16	AGZ	ETF	114.5	114.94	114.3417	114.9302	31022.0
2015-01-16	AGZD	ETF	24.455	24.52	24.345	24.395	15200.0
2015-01-16	AIA	ETF	47.57	47.9999	47.57	47.84	55338.0
2015-01-16	AIQ	ETF	20.91	21.7	20.91	21.51	18795.0
2015-01-16	AIRR	ETF	16.61	16.9	16.576	16.9	111800.0
2015-01-16	AIVI	ETF	42.43	42.98	42.43	42.91	41900.0
2015-01-16	AMJ	ETF	42.49	43.92	42.45	43.9	2963566.0
2015-01-16	AMLP	ETF	83.0	84.8	82.9	84.8	1624160.0
2015-01-16	AMZA	ETF	200.5	207.89	200.5	207.89	640.0
2015-01-16	ANGL	ETF	26.38	26.99	25.84	26.99	19900.0
2015-01-16	AOA	ETF	45.6	46.03	45.54	46.03	84700.0
2015-01-16	AOK	ETF	32.45	32.6	32.45	32.6	88024.0
2015-01-16	AOM	ETF	34.9	35.13	34.9	35.13	224858.0
2015-01-16	AOR	ETF	39.67	39.98	39.65	39.98	78900.0
2015-01-16	ARGT	ETF	18.12	18.2	18.12	18.2	1900.0
2015-01-16	ARKG	ETF	22.12	22.28	22.06	22.27	2500.0
2015-01-16	ARKK	ETF	19.99	19.99	19.59	19.61	900.0
2015-01-16	ARKQ	ETF	18.37	18.51	18.37	18.51	800.0
2015-01-16	ARKW	ETF	19.689	19.689	19.689	19.689	300.0
2015-01-16	ASEA	ETF	15.38	15.52	15.38	15.52	2400.0
2015-01-16	ASHR	ETF	36.15	36.44	35.91	36.27	2212000.0
2015-01-16	ASHS	ETF	35.43	35.49	35.36	35.49	6500.0
2015-01-16	ATMP	ETF	28.44	29.1	28.43	29.06	40100.0
2015-01-16	AVIV	ETF	38.53	39.21	38.53	39.18	104012.0
2015-01-16	AWAY	ETF	26.04	26.41	25.82	25.92	815877.0
2015-01-16	BAB	ETF	31.0	31.0	30.78	30.83	425166.0
2015-01-16	BAL	ETF	40.49	40.7201	40.38	40.469	27793.0
2015-01-16	BALT	ETF	1.77	1.86	1.74	1.74	425048.0
2015-01-16	BAR	ETF	3.35	3.4436	3.345	3.4029	231840.0
2015-01-16	BBC	ETF	27.2	28.86	27.2	28.85	13708.0
2015-01-16	BBH	ETF	117.83	121.47	117.55	121.33	207400.0
2015-01-16	BBP	ETF	26.79	27.786	26.79	27.786	2500.0
2015-01-16	BCM	ETF	30.92	31.23	30.881	31.23	7007.0
2015-01-16	BFOR	ETF	7.53	7.67	7.53	7.67	82800.0
2015-01-16	BIB	ETF	64.13	68.585	64.1	68.53	682622.0

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

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