PREVIEW / etf_daily / 2013-04-25

all etf daily files

  file:    by_date/etf_daily/2013/2013-04-25.parquet
  size:    40 KB
  rows:    990

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-04-25	SPY	ETF	158.34	159.27	158.1	158.52	131060600.0
2013-04-25	QQQ	ETF	69.63	70.05	69.59	69.79	26437042.0
2013-04-25	IWM	ETF	93.03	93.9	92.89	93.4	36543300.0
2013-04-25	DIA	ETF	146.64	147.42	146.36	146.76	4160500.0
2013-04-25	GLD	ETF	140.0	142.08	139.79	141.63	18886900.0
2013-04-25	TLT	ETF	122.25	122.37	122.1	122.27	4297800.0
2013-04-25	AAXJ	ETF	59.25	59.6	59.19	59.45	506900.0
2013-04-25	ACTV	ETF	5.07	5.21	4.99	5.16	626411.0
2013-04-25	ACWI	ETF	51.56	51.84	51.51	51.6	1240800.0
2013-04-25	ACWV	ETF	63.09	63.34	63.09	63.21	44400.0
2013-04-25	ACWX	ETF	43.56	43.85	43.56	43.64	154647.0
2013-04-25	ADRE	ETF	38.47	38.77	38.47	38.7	26541.0
2013-04-25	AFK	ETF	29.44	29.61	29.3	29.46	106942.0
2013-04-25	AGEM	ETF	22.3698	22.3698	22.3698	22.3698	200.0
2013-04-25	AGG	ETF	111.28	111.3	111.21	111.26	848700.0
2013-04-25	AGQ	ETF	101.36	107.8	101.04	107.0	717725.0
2013-04-25	AGZ	ETF	113.71	113.73	113.621	113.71	5696.0
2013-04-25	AIA	ETF	46.17	46.49	46.1	46.32	19449.0
2013-04-25	AIQ	ETF	10.78	11.419	10.78	11.12	26357.0
2013-04-25	AIVI	ETF	43.49	43.62	43.4	43.43	33600.0
2013-04-25	AMJ	ETF	48.0	48.85	46.68	46.97	2444675.0
2013-04-25	AMLP	ETF	89.6	89.85	88.95	89.35	709620.0
2013-04-25	ANGL	ETF	26.75	28.14	26.75	28.14	4500.0
2013-04-25	AOA	ETF	40.09	40.29	40.07	40.16	51600.0
2013-04-25	AOK	ETF	31.43	31.48	31.4	31.44	24725.0
2013-04-25	AOM	ETF	33.03	33.086	33.0162	33.03	21994.0
2013-04-25	AOR	ETF	35.926	36.06	35.9105	35.96	74430.0
2013-04-25	ARB	ETF	46.73	46.81	46.62	46.7	224159.0
2013-04-25	ARGT	ETF	17.1	17.2	17.1	17.2	2300.0
2013-04-25	ASEA	ETF	18.19	18.23	18.09	18.19	62900.0
2013-04-25	ATMP	ETF	26.53	26.58	26.31	26.31	37200.0
2013-04-25	AVIV	ETF	25.3	25.439	24.9	25.23	184349.0
2013-04-25	AWAY	ETF	32.19	32.49	31.74	31.91	964846.0
2013-04-25	BAB	ETF	30.77	30.87	30.77	30.87	210135.0
2013-04-25	BAL	ETF	52.5	52.72	52.34	52.35	36676.0
2013-04-25	BALT	ETF	3.43	3.5	3.3	3.34	145846.0
2013-04-25	BBH	ETF	69.81	70.43	69.38	70.26	182900.0
2013-04-25	BCM	ETF	40.49	40.778	40.49	40.778	1100.0
2013-04-25	BIB	ETF	22.54	22.8625	22.198	22.8275	259412.0
2013-04-25	BICK	ETF	23.78	24.0084	23.77	23.9625	4339.0
2013-04-25	BIL	ETF	91.6	91.62	91.6	91.6	104750.0
2013-04-25	BIS	ETF	1679.6	1679.6	1592.0	1592.0	396.5
2013-04-25	BIV	ETF	88.46	88.49	88.38	88.46	295800.0
2013-04-25	BIZD	ETF	20.39	20.39	20.24	20.31	49600.0
2013-04-25	BJK	ETF	41.3	41.84	41.3	41.73	25400.0
2013-04-25	BKF	ETF	38.81	39.048	38.71	38.86	28030.0
2013-04-25	BKLN	ETF	25.13	25.15	25.13	25.15	3339800.0
2013-04-25	BLV	ETF	94.0	94.34	94.0	94.29	37700.0
2013-04-25	BMVP	ETF	18.68	18.8	18.67	18.72	3610.0
2013-04-25	BND	ETF	84.05	84.05	83.98	84.0	875200.0

> showing 50 of 990 rows — these rows as CSV

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