PREVIEW / etf_daily / 2013-05-02

all etf daily files

  file:    by_date/etf_daily/2013/2013-05-02.parquet
  size:    40 KB
  rows:    989

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-02	SPY	ETF	158.68	159.89	158.53	159.75	96407600.0
2013-05-02	QQQ	ETF	70.51	71.43	70.45	71.28	31744162.0
2013-05-02	IWM	ETF	92.34	93.47	92.17	93.28	38830300.0
2013-05-02	DIA	ETF	147.12	148.05	146.91	147.96	4340700.0
2013-05-02	GLD	ETF	142.0	142.47	141.64	141.92	11502200.0
2013-05-02	TLT	ETF	123.59	123.97	123.51	123.85	4171800.0
2013-05-02	AADR	ETF	34.38	34.38	34.36	34.36	300.0
2013-05-02	AAXJ	ETF	59.95	60.17	59.8	60.15	319800.0
2013-05-02	ACTV	ETF	4.99	5.11	4.81	5.07	872897.0
2013-05-02	ACWI	ETF	51.84	52.16	51.83	52.08	444800.0
2013-05-02	ACWV	ETF	63.58	63.73	63.51	63.69	104000.0
2013-05-02	ACWX	ETF	44.08	44.24	43.96	44.19	383201.0
2013-05-02	ADRE	ETF	38.83	38.99	38.83	38.892	27425.0
2013-05-02	AFK	ETF	29.31	29.65	29.23	29.6	28177.0
2013-05-02	AGEM	ETF	22.6099	22.61	22.4201	22.4201	1048.0
2013-05-02	AGG	ETF	111.37	111.48	111.36	111.4	875500.0
2013-05-02	AGQ	ETF	104.32	105.0	102.04	102.72	361775.0
2013-05-02	AGZ	ETF	113.75	113.83	113.75	113.781	10358.0
2013-05-02	AIA	ETF	46.81	46.9226	46.735	46.9023	9176.0
2013-05-02	AIQ	ETF	12.99	13.15	12.05	12.17	114337.0
2013-05-02	AIVI	ETF	43.65	44.0	43.65	43.94	19300.0
2013-05-02	ALTL	ETF	29.59	29.59	29.45	29.45	12000.0
2013-05-02	AMJ	ETF	45.89	47.18	45.51	46.65	1031205.0
2013-05-02	AMLP	ETF	89.8	89.8	87.6	87.75	807300.0
2013-05-02	ANGL	ETF	28.19	28.19	28.19	28.19	1000.0
2013-05-02	AOA	ETF	40.24	40.47	40.22	40.45	78100.0
2013-05-02	AOK	ETF	31.52	31.5494	31.4501	31.52	18308.0
2013-05-02	AOM	ETF	33.1011	33.22	33.1011	33.22	20913.0
2013-05-02	AOR	ETF	36.05	36.2	36.04	36.19	23495.0
2013-05-02	ARB	ETF	46.75	46.8	46.6	46.64	211145.0
2013-05-02	ARGT	ETF	17.26	17.26	17.22	17.22	1900.0
2013-05-02	ASEA	ETF	18.31	18.42	18.31	18.4	20700.0
2013-05-02	ATMP	ETF	26.14	26.14	25.74	25.74	196100.0
2013-05-02	AVIV	ETF	25.45	26.72	25.35	26.43	197079.0
2013-05-02	AWAY	ETF	29.56	29.79	29.062	29.52	1040983.0
2013-05-02	BAB	ETF	31.04	31.09	31.023	31.08	106854.0
2013-05-02	BAL	ETF	53.5197	54.6455	53.3503	53.92	12825.0
2013-05-02	BALT	ETF	3.22	3.31	3.17	3.28	72524.0
2013-05-02	BBH	ETF	69.92	70.72	69.62	70.4	48900.0
2013-05-02	BCM	ETF	40.29	40.39	40.29	40.39	1911.0
2013-05-02	BIB	ETF	22.555	23.225	22.4725	23.0275	138240.0
2013-05-02	BICK	ETF	24.04	24.11	24.04	24.08	601.0
2013-05-02	BIL	ETF	91.62	91.62	91.6	91.62	71800.0
2013-05-02	BIS	ETF	1610.8	1617.6	1563.64	1573.6	192.0
2013-05-02	BIV	ETF	88.71	88.74	88.64	88.73	198600.0
2013-05-02	BIZD	ETF	20.31	20.48	20.31	20.4	15200.0
2013-05-02	BJK	ETF	41.92	42.14	41.9	42.12	3800.0
2013-05-02	BKF	ETF	39.27	39.33	39.13	39.32	175819.0
2013-05-02	BKLN	ETF	25.2	25.22	25.2	25.21	1517200.0
2013-05-02	BLV	ETF	95.25	95.25	94.81	95.18	62400.0

> showing 50 of 989 rows — these rows as CSV

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