PREVIEW / etf_daily / 2015-01-07

all etf daily files

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

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-07	SPY	ETF	201.42	202.72	200.88	202.31	125346700.0
2015-01-07	QQQ	ETF	100.73	101.6	100.485	101.36	37577361.0
2015-01-07	IWM	ETF	116.06	116.76	115.48	116.73	32252100.0
2015-01-07	DIA	ETF	174.85	175.79	174.24	175.59	5547000.0
2015-01-07	GLD	ETF	116.47	116.88	116.17	116.43	6434200.0
2015-01-07	TLT	ETF	130.7	131.97	130.17	131.39	9762900.0
2015-01-07	AAXJ	ETF	60.0	60.37	59.96	60.36	837800.0
2015-01-07	ACWI	ETF	57.08	57.44	56.94	57.36	2697900.0
2015-01-07	ACWV	ETF	68.31	68.71	68.18	68.62	100300.0
2015-01-07	ACWX	ETF	41.7	41.9599	41.56	41.87	519981.0
2015-01-07	ADRE	ETF	34.92	35.244	34.92	35.11	15895.0
2015-01-07	AFK	ETF	25.64	25.69	25.5	25.69	20307.0
2015-01-07	AGG	ETF	111.0	111.04	110.74	110.93	3984400.0
2015-01-07	AGQ	ETF	41.42	42.7	41.32	42.13	185200.0
2015-01-07	AGZ	ETF	113.9	114.2	113.76	113.92	144296.0
2015-01-07	AGZD	ETF	24.625	24.625	24.52	24.55	8600.0
2015-01-07	AIA	ETF	46.57	46.8399	46.52	46.81	14261.0
2015-01-07	AIQ	ETF	20.73	20.73	20.0	20.47	23040.0
2015-01-07	AIRR	ETF	17.56	17.59	17.37	17.48	22400.0
2015-01-07	AIVI	ETF	41.55	41.73	41.25	41.72	33500.0
2015-01-07	AMJ	ETF	44.27	44.6	43.37	43.93	1988580.0
2015-01-07	AMLP	ETF	85.35	85.65	83.95	84.45	1028900.0
2015-01-07	AMZA	ETF	213.9	213.9	206.61	208.16	830.0
2015-01-07	ANGL	ETF	26.08	26.4	26.05	26.4	2400.0
2015-01-07	AOA	ETF	45.57	45.7	45.39	45.63	97100.0
2015-01-07	AOK	ETF	32.35	32.46	32.35	32.46	34211.0
2015-01-07	AOM	ETF	34.8	34.9	34.79	34.9	91956.0
2015-01-07	AOR	ETF	39.48	39.74	39.48	39.74	69752.0
2015-01-07	ARGT	ETF	18.16	18.19	18.09	18.16	13400.0
2015-01-07	ARKG	ETF	21.09	21.31	21.09	21.28	8100.0
2015-01-07	ARKK	ETF	19.83	19.83	19.65	19.7	3900.0
2015-01-07	ARKQ	ETF	18.929	18.929	18.929	18.929	200.0
2015-01-07	ARKW	ETF	20.1	20.1	20.012	20.034	500.0
2015-01-07	ASEA	ETF	15.3	15.39	15.3	15.37	15200.0
2015-01-07	ASHR	ETF	37.98	38.25	37.86	38.01	1194100.0
2015-01-07	ASHS	ETF	36.36	36.56	36.33	36.49	29700.0
2015-01-07	ATMP	ETF	29.8	29.8	28.86	29.0	668200.0
2015-01-07	AVIV	ETF	37.19	38.04	36.79	37.92	204987.0
2015-01-07	AWAY	ETF	27.03	27.37	26.33	26.88	1931727.0
2015-01-07	BAB	ETF	30.86	30.93	30.6101	30.87	183313.0
2015-01-07	BAL	ETF	40.87	41.22	40.87	41.22	2033.0
2015-01-07	BALT	ETF	2.12	2.21	1.93	2.12	1276915.0
2015-01-07	BAR	ETF	2.947	2.947	2.8771	2.897	24860.0
2015-01-07	BBC	ETF	28.2899	28.59	28.02	28.569	13664.0
2015-01-07	BBH	ETF	116.13	118.61	116.07	118.6	181600.0
2015-01-07	BBP	ETF	26.72	27.27	26.69	27.27	3900.0
2015-01-07	BCHP	ETF	17.45	17.49	17.338	17.47	826.0
2015-01-07	BCM	ETF	31.516	31.516	31.3701	31.396	957.0
2015-01-07	BFOR	ETF	7.6525	7.68	7.6375	7.68	58400.0
2015-01-07	BIB	ETF	63.255	66.125	62.945	66.125	777594.0

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

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