PREVIEW / etf_daily / 2013-05-13

all etf daily files

  file:    by_date/etf_daily/2013/2013-05-13.parquet
  size:    40 KB
  rows:    992

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-05-13	SPY	ETF	163.2	163.81	162.82	163.54	81843200.0
2013-05-13	QQQ	ETF	72.93	73.32	72.86	73.14	29730022.0
2013-05-13	IWM	ETF	96.74	97.12	96.43	96.76	22522300.0
2013-05-13	DIA	ETF	150.75	151.01	150.48	150.86	3841500.0
2013-05-13	GLD	ETF	138.46	138.97	138.16	138.43	6714100.0
2013-05-13	TLT	ETF	117.88	118.19	117.63	117.84	8050800.0
2013-05-13	AADR	ETF	34.62	34.76	34.62	34.75	600.0
2013-05-13	AAXJ	ETF	60.34	60.43	60.21	60.24	225400.0
2013-05-13	ACTV	ETF	6.02	6.24	5.91	6.13	605354.0
2013-05-13	ACWI	ETF	53.03	53.13	52.89	53.1	598000.0
2013-05-13	ACWV	ETF	63.57	63.59	63.16	63.52	40800.0
2013-05-13	ACWX	ETF	44.68	44.78	44.65	44.77	143335.0
2013-05-13	ADRE	ETF	39.39	39.44	39.23	39.3	21500.0
2013-05-13	AFK	ETF	30.54	30.66	30.37	30.5925	49581.0
2013-05-13	AGEM	ETF	22.98	22.98	22.7	22.8669	4453.0
2013-05-13	AGG	ETF	110.35	110.39	110.29	110.38	563400.0
2013-05-13	AGQ	ETF	102.0	102.6	100.64	100.8	192100.0
2013-05-13	AGZ	ETF	113.16	113.279	113.14	113.24	30357.0
2013-05-13	AIA	ETF	46.88	46.88	46.68	46.7006	19267.0
2013-05-13	AIQ	ETF	12.54	12.68	11.55	12.54	25331.0
2013-05-13	AIVI	ETF	44.11	44.2	44.03	44.14	23900.0
2013-05-13	AMJ	ETF	47.69	48.0	47.56	47.91	669875.0
2013-05-13	AMLP	ETF	89.3	89.5	88.85	89.0	443600.0
2013-05-13	ANGL	ETF	27.98	28.01	27.76	27.79	4500.0
2013-05-13	AOA	ETF	41.12	41.16	41.01	41.1	42700.0
2013-05-13	AOK	ETF	31.59	31.6	31.5	31.59	15538.0
2013-05-13	AOM	ETF	33.33	33.43	33.33	33.42	29104.0
2013-05-13	AOR	ETF	36.54	36.59	36.43	36.55	73571.0
2013-05-13	ARB	ETF	46.81	46.81	46.71	46.78	130639.0
2013-05-13	ARGT	ETF	17.92	17.92	17.76	17.88	2750.0
2013-05-13	ASEA	ETF	18.82	18.85	18.75	18.78	55400.0
2013-05-13	ATMP	ETF	26.59	26.59	26.48	26.56	36300.0
2013-05-13	AVIV	ETF	29.07	29.44	28.82	29.4	211770.0
2013-05-13	AWAY	ETF	29.51	30.43	29.26	29.56	696941.0
2013-05-13	BAB	ETF	30.52	30.53	30.46	30.48	252741.0
2013-05-13	BAL	ETF	53.69	54.28	53.6001	54.12	19529.0
2013-05-13	BALT	ETF	3.53	3.68	3.48	3.51	484887.0
2013-05-13	BBH	ETF	72.87	73.8	72.29	73.58	206300.0
2013-05-13	BCM	ETF	40.67	40.67	40.67	40.67	100.0
2013-05-13	BIB	ETF	24.7725	25.5625	24.6082	25.4825	310956.0
2013-05-13	BICK	ETF	24.06	24.13	24.05	24.05	5495.0
2013-05-13	BIL	ETF	91.62	91.62	91.6	91.62	90700.0
2013-05-13	BIS	ETF	1463.56	1463.6	1416.32	1426.0	329.5
2013-05-13	BIV	ETF	87.51	87.63	87.5	87.55	281900.0
2013-05-13	BIZD	ETF	20.52	20.52	20.4	20.46	13400.0
2013-05-13	BJK	ETF	43.45	43.52	43.33	43.52	21700.0
2013-05-13	BKF	ETF	39.7	39.78	39.55	39.62	194553.0
2013-05-13	BKLN	ETF	25.31	25.32	25.3	25.31	2155300.0
2013-05-13	BLV	ETF	91.92	92.16	91.72	91.78	64100.0
2013-05-13	BMVP	ETF	19.1633	19.17	19.13	19.13	5696.0

> showing 50 of 992 rows — these rows as CSV

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