PREVIEW / etf_daily / 2014-01-16

all etf daily files

  file:    by_date/etf_daily/2014/2014-01-16.parquet
  size:    43 KB
  rows:    1,068

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
2014-01-16	SPY	ETF	184.28	184.66	183.83	184.42	72290600.0
2014-01-16	QQQ	ETF	88.28	88.51	88.16	88.38	34260219.0
2014-01-16	IWM	ETF	116.05	116.38	115.83	116.34	23091900.0
2014-01-16	DIA	ETF	164.22	164.33	163.52	163.98	5170900.0
2014-01-16	GLD	ETF	119.84	119.96	119.57	119.79	3949500.0
2014-01-16	TLT	ETF	104.85	105.07	104.72	105.04	7137700.0
2014-01-16	AADR	ETF	37.46	37.51	37.46	37.47	2100.0
2014-01-16	AAXJ	ETF	58.28	58.47	58.16	58.28	1060800.0
2014-01-16	ACWI	ETF	57.35	57.35	57.13	57.33	1225800.0
2014-01-16	ACWV	ETF	62.61	62.94	62.61	62.91	62200.0
2014-01-16	ACWX	ETF	46.16	46.16	45.9001	46.15	2195932.0
2014-01-16	ADRE	ETF	35.88	35.92	35.71	35.71	24241.0
2014-01-16	AFK	ETF	30.65	30.8499	30.48	30.77	7818.0
2014-01-16	AGG	ETF	107.13	107.21	107.07	107.2	3113700.0
2014-01-16	AGQ	ETF	67.52	67.64	66.72	67.0	297225.0
2014-01-16	AGZ	ETF	111.0299	111.05	110.981	111.0307	12522.0
2014-01-16	AGZD	ETF	25.04	25.05	25.03	25.045	7000.0
2014-01-16	AIA	ETF	45.99	46.1	45.96	45.98	9307.0
2014-01-16	AIQ	ETF	27.49	27.6	27.11	27.16	14617.0
2014-01-16	AIVI	ETF	47.31	47.52	47.2	47.47	21700.0
2014-01-16	ALTL	ETF	32.92	32.9428	32.86	32.9428	1181.0
2014-01-16	AMJ	ETF	45.31	45.54	45.31	45.52	378311.0
2014-01-16	AMLP	ETF	87.3	87.65	87.25	87.65	453860.0
2014-01-16	ANGL	ETF	27.0	27.0	27.0	27.0	600.0
2014-01-16	AOA	ETF	44.64	44.64	44.53	44.59	41700.0
2014-01-16	AOK	ETF	32.13	32.13	32.064	32.12	14702.0
2014-01-16	AOM	ETF	34.42	34.42	34.356	34.39	57330.0
2014-01-16	AOR	ETF	38.51	38.585	38.4903	38.5599	44700.0
2014-01-16	ARGT	ETF	19.07	19.24	19.07	19.24	900.0
2014-01-16	ASEA	ETF	15.19	15.2	15.13	15.2	8100.0
2014-01-16	ASHR	ETF	23.27	23.27	23.18	23.2	66900.0
2014-01-16	ATMP	ETF	27.0	27.0	26.77	26.93	13500.0
2014-01-16	AVIV	ETF	24.42	24.42	23.96	24.2	115057.0
2014-01-16	AWAY	ETF	41.24	41.994	40.98	41.81	907357.0
2014-01-16	BAB	ETF	27.65	27.7	27.62	27.7	166894.0
2014-01-16	BAL	ETF	53.82	54.51	53.82	53.97	32922.0
2014-01-16	BALT	ETF	6.32	6.426	6.24	6.29	577190.0
2014-01-16	BBH	ETF	94.6	95.6	94.4	95.6	130000.0
2014-01-16	BCM	ETF	39.0	39.079	38.96	38.96	57783.0
2014-01-16	BFOR	ETF	7.4475	7.4475	7.405	7.44	159600.0
2014-01-16	BIB	ETF	43.205	44.377	43.205	44.377	407996.0
2014-01-16	BICK	ETF	23.9	23.9499	23.86	23.9499	2234.0
2014-01-16	BIL	ETF	91.56	91.56	91.54	91.56	176250.0
2014-01-16	BIS	ETF	716.0	716.4	696.8	698.0	908.0
2014-01-16	BIV	ETF	82.62	82.68	82.56	82.63	327300.0
2014-01-16	BIZD	ETF	21.22	21.29	21.17	21.28	14500.0
2014-01-16	BJK	ETF	54.37	54.47	53.95	54.29	13200.0
2014-01-16	BKF	ETF	36.39	36.39	36.11	36.13	54475.0
2014-01-16	BKLN	ETF	24.92	24.92	24.9	24.92	1970900.0
2014-01-16	BLNG	ETF	35.3	35.3	35.3	35.3	200.0

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

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