PREVIEW / etf_daily / 2013-10-15

all etf daily files

  file:    by_date/etf_daily/2013/2013-10-15.parquet
  size:    42 KB
  rows:    1,036

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
2013-10-15	SPY	ETF	170.51	171.15	169.47	169.7	155485000.0
2013-10-15	QQQ	ETF	79.73	80.11	79.38	79.48	38683993.0
2013-10-15	IWM	ETF	107.99	108.23	106.92	107.16	42263500.0
2013-10-15	DIA	ETF	152.6	152.8	151.34	151.34	8144700.0
2013-10-15	GLD	ETF	122.28	124.36	122.22	123.73	8384200.0
2013-10-15	TLT	ETF	105.15	105.3	104.53	104.54	8291000.0
2013-10-15	AADR	ETF	35.6	35.83	35.52	35.52	10100.0
2013-10-15	AAXJ	ETF	61.05	61.09	60.42	60.42	472800.0
2013-10-15	ACTV	ETF	14.39	14.4	14.36	14.37	2993802.0
2013-10-15	ACWI	ETF	54.82	54.94	54.56	54.64	4980600.0
2013-10-15	ACWV	ETF	62.53	62.53	62.09	62.18	45800.0
2013-10-15	ACWX	ETF	45.64	45.69	45.47	45.52	262933.0
2013-10-15	ADRE	ETF	38.328	38.3513	38.09	38.16	8230.0
2013-10-15	AFK	ETF	30.95	30.95	30.72	30.79	7231.0
2013-10-15	AGG	ETF	107.06	107.09	106.79	106.82	946900.0
2013-10-15	AGQ	ETF	75.64	78.4	75.48	77.16	542475.0
2013-10-15	AGZ	ETF	110.84	112.2899	110.84	111.23	26240.0
2013-10-15	AIA	ETF	48.16	48.355	48.0	48.044	26231.0
2013-10-15	AIQ	ETF	27.83	29.65	27.83	28.42	25497.0
2013-10-15	AIVI	ETF	46.1	46.25	46.1	46.11	25800.0
2013-10-15	ALTL	ETF	30.53	30.61	30.29	30.36	130720.0
2013-10-15	AMJ	ETF	44.92	44.92	44.2	44.29	452741.0
2013-10-15	AMLP	ETF	87.95	88.15	87.1	87.2	1221080.0
2013-10-15	ANGL	ETF	26.35	26.6	26.35	26.6	4600.0
2013-10-15	AOA	ETF	42.41	42.47	42.22	42.24	27200.0
2013-10-15	AOK	ETF	31.5	31.5	31.4	31.4	7606.0
2013-10-15	AOM	ETF	33.39	33.46	33.34	33.34	27803.0
2013-10-15	AOR	ETF	37.0501	37.0937	36.95	36.98	23039.0
2013-10-15	ARGT	ETF	20.37	20.58	20.37	20.53	11900.0
2013-10-15	ASEA	ETF	17.13	17.15	17.05	17.07	4800.0
2013-10-15	ATMP	ETF	26.28	26.28	25.78	25.84	53500.0
2013-10-15	AVIV	ETF	23.51	23.8	23.31	23.7	67181.0
2013-10-15	AWAY	ETF	28.86	29.27	28.16	28.4	767635.0
2013-10-15	BAB	ETF	27.24	27.252	27.09	27.09	162079.0
2013-10-15	BAL	ETF	53.52	53.55	53.34	53.54	3277.0
2013-10-15	BALT	ETF	4.92	5.13	4.88	4.97	588827.0
2013-10-15	BBH	ETF	79.19	79.63	78.37	78.53	64500.0
2013-10-15	BCM	ETF	40.04	40.14	40.04	40.11	5900.0
2013-10-15	BFOR	ETF	6.925	6.9425	6.8675	6.8925	460400.0
2013-10-15	BIB	ETF	30.325	30.725	29.75	29.8125	217788.0
2013-10-15	BICK	ETF	24.8	24.8	24.8	24.8	185.0
2013-10-15	BIL	ETF	91.56	91.56	91.54	91.54	562650.0
2013-10-15	BIS	ETF	1065.12	1098.3	1060.0	1092.8	460.5
2013-10-15	BIV	ETF	83.22	83.33	83.1	83.1	169000.0
2013-10-15	BIZD	ETF	20.2	20.24	20.04	20.13	12600.0
2013-10-15	BJK	ETF	49.75	49.88	49.35	49.49	37200.0
2013-10-15	BKF	ETF	38.98	39.02	38.72	38.81	80112.0
2013-10-15	BKLN	ETF	24.66	24.67	24.63	24.65	1197700.0
2013-10-15	BLNG	ETF	36.52	36.78	36.52	36.78	1400.0
2013-10-15	BLV	ETF	82.53	82.75	82.32	82.32	101000.0

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

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