PREVIEW / etf_daily / 2013-05-01

all etf daily files

  file:    by_date/etf_daily/2013/2013-05-01.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-01	SPY	ETF	159.33	159.41	158.1	158.28	138874200.0
2013-05-01	QQQ	ETF	70.71	70.85	70.25	70.39	28539538.0
2013-05-01	IWM	ETF	93.81	93.9	91.76	91.82	120177800.0
2013-05-01	DIA	ETF	147.56	147.81	146.58	146.74	5372800.0
2013-05-01	GLD	ETF	140.59	141.55	139.3	141.11	13931100.0
2013-05-01	TLT	ETF	123.46	124.26	123.43	124.01	10724600.0
2013-05-01	AAXJ	ETF	60.16	60.28	59.66	59.74	278200.0
2013-05-01	ACTV	ETF	5.0	5.14	4.89	5.04	868678.0
2013-05-01	ACWI	ETF	52.17	52.19	51.71	51.77	621400.0
2013-05-01	ACWV	ETF	63.86	63.86	63.42	63.46	173000.0
2013-05-01	ACWX	ETF	44.42	44.42	43.97	44.03	167448.0
2013-05-01	ADRE	ETF	39.12	39.12	38.68	38.73	42316.0
2013-05-01	AFK	ETF	29.56	29.56	29.31	29.35	6713.0
2013-05-01	AGEM	ETF	22.494	22.494	22.48	22.48	515.0
2013-05-01	AGG	ETF	111.48	111.5	111.36	111.39	1741300.0
2013-05-01	AGQ	ETF	100.0	103.88	97.88	101.32	691475.0
2013-05-01	AGZ	ETF	113.6732	113.83	113.6732	113.83	9380.0
2013-05-01	AIA	ETF	46.826	46.826	46.5199	46.5199	25962.0
2013-05-01	AIQ	ETF	12.89	13.4	12.59	13.23	88105.0
2013-05-01	AIVI	ETF	44.06	44.06	43.69	43.74	33600.0
2013-05-01	ALTL	ETF	29.8199	29.8199	29.8199	29.8199	102.0
2013-05-01	AMJ	ETF	46.45	46.83	45.87	45.98	839753.0
2013-05-01	AMLP	ETF	89.0	89.25	87.85	87.85	781180.0
2013-05-01	ANGL	ETF	27.7	27.99	27.5	27.5	18500.0
2013-05-01	AOA	ETF	40.49	40.49	40.14	40.14	8000.0
2013-05-01	AOK	ETF	31.55	31.57	31.51	31.51	12551.0
2013-05-01	AOM	ETF	33.22	33.22	33.07	33.09	13444.0
2013-05-01	AOR	ETF	36.14	36.16	35.9752	35.9999	15733.0
2013-05-01	ARB	ETF	46.56	46.75	46.56	46.66	273522.0
2013-05-01	ARGT	ETF	17.42	17.42	17.42	17.42	200.0
2013-05-01	ASEA	ETF	18.49	18.49	18.27	18.27	25500.0
2013-05-01	ATMP	ETF	26.6	26.6	25.85	25.85	50900.0
2013-05-01	AVIV	ETF	25.5	25.5	24.91	25.25	235813.0
2013-05-01	AWAY	ETF	30.42	30.46	29.19	29.35	999912.0
2013-05-01	BAB	ETF	31.09	31.1499	31.01	31.1	351031.0
2013-05-01	BAL	ETF	54.82	55.0899	52.59	53.07	73868.0
2013-05-01	BALT	ETF	3.45	3.55	3.24	3.24	38292.0
2013-05-01	BBH	ETF	69.8	69.97	69.0	69.07	92000.0
2013-05-01	BCM	ETF	39.93	40.03	39.93	40.0299	1794.0
2013-05-01	BIB	ETF	22.3775	22.9625	22.1575	22.215	79580.0
2013-05-01	BICK	ETF	24.11	24.13	23.95	23.95	4157.0
2013-05-01	BIL	ETF	91.6	91.62	91.6	91.6	704750.0
2013-05-01	BIS	ETF	1610.0	1625.2	1590.4	1623.2	280.5
2013-05-01	BIV	ETF	88.67	88.76	88.6	88.74	162000.0
2013-05-01	BIZD	ETF	20.61	20.61	20.15	20.15	19700.0
2013-05-01	BJK	ETF	42.14	42.14	41.79	41.88	4600.0
2013-05-01	BKF	ETF	39.36	39.47	38.88	38.99	170573.0
2013-05-01	BKLN	ETF	25.18	25.19	25.18	25.18	5172400.0
2013-05-01	BLNG	ETF	41.65	41.71	41.31	41.71	500.0
2013-05-01	BLV	ETF	94.66	95.21	94.63	94.93	47500.0

> showing 50 of 989 rows — these rows as CSV

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