PREVIEW / etf_daily / 2013-05-03

all etf daily files

  file:    by_date/etf_daily/2013/2013-05-03.parquet
  size:    41 KB
  rows:    997

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-03	SPY	ETF	161.14	161.88	159.78	161.37	144202300.0
2013-05-03	QQQ	ETF	71.94	72.34	71.91	72.12	34061652.0
2013-05-03	IWM	ETF	94.53	95.47	94.35	94.76	51981000.0
2013-05-03	DIA	ETF	149.26	149.82	149.2	149.36	5929900.0
2013-05-03	GLD	ETF	141.7	142.71	141.4	142.09	11667100.0
2013-05-03	TLT	ETF	122.16	122.19	120.83	120.93	11283600.0
2013-05-03	AADR	ETF	34.52	34.53	33.58	34.45	2500.0
2013-05-03	AAXJ	ETF	60.25	60.69	60.19	60.43	428000.0
2013-05-03	ACTV	ETF	4.74	5.57	4.69	5.55	801275.0
2013-05-03	ACWI	ETF	52.61	52.81	52.51	52.65	882800.0
2013-05-03	ACWV	ETF	64.04	64.04	63.82	63.89	68600.0
2013-05-03	ACWX	ETF	44.47	44.73	44.47	44.61	542750.0
2013-05-03	ADRE	ETF	39.06	39.406	39.06	39.181	84466.0
2013-05-03	AFK	ETF	29.7	30.066	29.56	29.9717	26443.0
2013-05-03	AGEM	ETF	22.62	22.76	22.62	22.76	2175.0
2013-05-03	AGG	ETF	111.2	111.2	110.94	110.99	580000.0
2013-05-03	AGQ	ETF	103.52	107.8	102.84	105.08	436025.0
2013-05-03	AGZ	ETF	113.77	113.77	113.4701	113.61	18593.0
2013-05-03	AIA	ETF	47.19	47.44	47.18	47.33	22181.0
2013-05-03	AIQ	ETF	12.15	12.47	12.021	12.41	32263.0
2013-05-03	AIVI	ETF	44.3	44.54	44.3	44.48	36100.0
2013-05-03	AMJ	ETF	46.93	47.6	46.74	47.45	514844.0
2013-05-03	AMLP	ETF	89.75	89.75	88.0	88.4	589220.0
2013-05-03	ANGL	ETF	28.15	28.15	27.73	27.75	1100.0
2013-05-03	AOA	ETF	40.74	40.9	40.72	40.81	59900.0
2013-05-03	AOK	ETF	31.6128	31.6299	31.576	31.59	17469.0
2013-05-03	AOM	ETF	33.27	33.36	33.27	33.33	60040.0
2013-05-03	AOR	ETF	36.38	36.46	36.37	36.4	72969.0
2013-05-03	ARB	ETF	46.7	46.75	46.66	46.75	181173.0
2013-05-03	ARGT	ETF	17.34	17.48	17.34	17.34	600.0
2013-05-03	ASEA	ETF	18.3	18.34	18.23	18.27	31100.0
2013-05-03	ATMP	ETF	26.03	26.05	25.92	26.04	5500.0
2013-05-03	AVIV	ETF	26.5	27.09	26.25	26.81	483805.0
2013-05-03	AWAY	ETF	29.93	30.49	29.55	30.05	1305830.0
2013-05-03	BAB	ETF	30.99	30.99	30.742	30.78	202346.0
2013-05-03	BAL	ETF	54.4178	54.74	54.19	54.39	31237.0
2013-05-03	BALT	ETF	3.34	3.6	3.25	3.46	165797.0
2013-05-03	BBH	ETF	71.61	72.34	71.22	71.36	151000.0
2013-05-03	BCM	ETF	41.05	41.07	41.044	41.044	510.0
2013-05-03	BIB	ETF	23.47	24.3248	23.47	23.7095	145108.0
2013-05-03	BICK	ETF	24.31	24.317	24.27	24.276	1723.0
2013-05-03	BIL	ETF	91.62	91.62	91.6	91.6	263600.0
2013-05-03	BIS	ETF	1560.0	1560.0	1496.0	1528.0	238.0
2013-05-03	BIV	ETF	88.45	88.46	88.15	88.15	235700.0
2013-05-03	BIZD	ETF	20.71	20.71	20.54	20.58	22000.0
2013-05-03	BJK	ETF	42.24	42.39	42.24	42.34	13000.0
2013-05-03	BKF	ETF	39.52	39.98	39.52	39.72	251092.0
2013-05-03	BKLN	ETF	25.23	25.23	25.22	25.23	2971800.0
2013-05-03	BLNG	ETF	42.22	42.22	42.22	42.22	200.0
2013-05-03	BLV	ETF	94.34	94.35	93.8	93.88	125400.0

> showing 50 of 997 rows — these rows as CSV

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