PREVIEW / etf_daily / 2013-05-06

all etf daily files

  file:    by_date/etf_daily/2013/2013-05-06.parquet
  size:    40 KB
  rows:    991

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-06	SPY	ETF	161.49	162.01	161.42	161.78	66882100.0
2013-05-06	QQQ	ETF	72.25	72.51	72.19	72.4	19244277.0
2013-05-06	IWM	ETF	94.83	95.5	94.74	95.37	26893800.0
2013-05-06	DIA	ETF	149.36	149.6	149.14	149.43	3110600.0
2013-05-06	GLD	ETF	142.33	142.46	141.63	142.15	7730300.0
2013-05-06	TLT	ETF	121.15	121.25	120.32	120.63	5121900.0
2013-05-06	AAXJ	ETF	60.43	60.7	60.38	60.65	351200.0
2013-05-06	ACTV	ETF	5.53	6.08	5.43	6.05	1046830.0
2013-05-06	ACWI	ETF	52.64	52.77	52.59	52.72	691600.0
2013-05-06	ACWV	ETF	63.98	64.05	63.68	63.78	131100.0
2013-05-06	ACWX	ETF	44.47	44.62	44.46	44.58	407243.0
2013-05-06	ADRE	ETF	39.12	39.25	39.03	39.17	24689.0
2013-05-06	AFK	ETF	30.0	30.0	29.72	29.9	9496.0
2013-05-06	AGEM	ETF	22.7201	22.7201	22.7201	22.7201	400.0
2013-05-06	AGG	ETF	110.94	111.0	110.81	110.81	686300.0
2013-05-06	AGQ	ETF	104.68	105.04	102.96	104.2	197900.0
2013-05-06	AGZ	ETF	113.59	113.59	113.4701	113.51	6050.0
2013-05-06	AIA	ETF	47.16	47.216	47.0	47.12	21760.0
2013-05-06	AIQ	ETF	12.61	12.83	12.111	12.7	30925.0
2013-05-06	AIVI	ETF	44.32	44.38	44.2	44.36	14400.0
2013-05-06	AMJ	ETF	47.49	47.8799	47.1235	47.25	776696.0
2013-05-06	AMLP	ETF	88.6	88.95	88.4	88.7	476820.0
2013-05-06	ANGL	ETF	27.75	30.22	27.75	27.79	3400.0
2013-05-06	AOA	ETF	40.75	40.88	40.75	40.87	16800.0
2013-05-06	AOK	ETF	31.6	31.6	31.56	31.57	17769.0
2013-05-06	AOM	ETF	33.47	33.47	33.28	33.34	42629.0
2013-05-06	AOR	ETF	36.4	36.43	36.36	36.42	49469.0
2013-05-06	ARB	ETF	46.74	46.75	46.67	46.75	102973.0
2013-05-06	ARGT	ETF	17.48	17.52	17.4	17.4	4600.0
2013-05-06	ASEA	ETF	18.46	18.64	18.46	18.63	164400.0
2013-05-06	ATMP	ETF	26.34	26.34	25.95	26.01	62500.0
2013-05-06	AVIV	ETF	27.26	27.9	27.05	27.71	330048.0
2013-05-06	AWAY	ETF	29.95	30.29	29.17	29.25	708448.0
2013-05-06	BAB	ETF	30.74	30.8	30.66	30.72	113380.0
2013-05-06	BAL	ETF	54.9786	55.25	54.66	55.15	42228.0
2013-05-06	BALT	ETF	3.44	3.51	3.32	3.47	74775.0
2013-05-06	BBH	ETF	71.66	71.66	70.82	71.04	87700.0
2013-05-06	BCM	ETF	40.86	41.0096	40.86	40.941	2952.0
2013-05-06	BIB	ETF	24.0525	24.2072	23.2625	23.535	358028.0
2013-05-06	BICK	ETF	24.19	24.29	24.19	24.26	1252.0
2013-05-06	BIL	ETF	91.6	91.62	91.6	91.6	117300.0
2013-05-06	BIS	ETF	1519.4	1552.4	1519.4	1538.0	60.0
2013-05-06	BIV	ETF	88.23	88.23	88.0	88.09	377200.0
2013-05-06	BIZD	ETF	20.8	20.8	20.41	20.53	10500.0
2013-05-06	BJK	ETF	42.68	42.79	42.64	42.73	13800.0
2013-05-06	BKF	ETF	39.61	39.71	39.531	39.69	106224.0
2013-05-06	BKLN	ETF	25.25	25.26	25.24	25.26	1958600.0
2013-05-06	BLV	ETF	93.7	93.95	93.19	93.43	202800.0
2013-05-06	BMVP	ETF	18.91	19.0567	18.91	19.0567	2600.0
2013-05-06	BND	ETF	83.8	83.81	83.69	83.77	1101900.0

> showing 50 of 991 rows — these rows as CSV

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