PREVIEW / etf_daily / 2013-08-02

all etf daily files

  file:    by_date/etf_daily/2013/2013-08-02.parquet
  size:    41 KB
  rows:    1,011

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-08-02	SPY	ETF	170.28	170.97	170.05	170.95	91116700.0
2013-08-02	QQQ	ETF	76.56	76.99	76.3801	76.97	18105230.0
2013-08-02	IWM	ETF	104.72	105.28	104.56	105.16	22983000.0
2013-08-02	DIA	ETF	155.47	156.24	155.23	156.2	3620800.0
2013-08-02	GLD	ETF	126.74	127.25	126.32	126.36	6466300.0
2013-08-02	TLT	ETF	106.01	106.61	105.98	106.52	9568400.0
2013-08-02	AADR	ETF	34.56	34.56	34.33	34.33	800.0
2013-08-02	AAXJ	ETF	56.58	56.9	56.44	56.77	332700.0
2013-08-02	ACTV	ETF	9.76	10.85	9.1	10.33	4132816.0
2013-08-02	ACWI	ETF	53.02	53.18	52.85	53.18	621900.0
2013-08-02	ACWV	ETF	62.1	62.4	62.1	62.29	99900.0
2013-08-02	ACWX	ETF	43.06	43.42	43.06	43.38	390199.0
2013-08-02	ADRE	ETF	35.72	36.0	35.72	35.89	15308.0
2013-08-02	AFK	ETF	29.42	29.53	29.2601	29.45	21742.0
2013-08-02	AGEM	ETF	21.52	21.7299	21.5101	21.56	4607.0
2013-08-02	AGG	ETF	106.8	106.96	106.71	106.85	841800.0
2013-08-02	AGQ	ETF	69.8	70.24	68.92	68.92	381525.0
2013-08-02	AGZ	ETF	110.8727	111.1599	110.794	111.081	10959.0
2013-08-02	AIA	ETF	44.43	44.77	44.43	44.64	49334.0
2013-08-02	AIQ	ETF	19.44	19.79	19.32	19.75	97041.0
2013-08-02	AIVI	ETF	42.64	42.96	42.64	42.96	86800.0
2013-08-02	ALTL	ETF	30.22	30.22	30.204	30.204	655.0
2013-08-02	AMJ	ETF	47.02	47.13	46.64	47.13	338699.0
2013-08-02	AMLP	ETF	90.2	90.2	88.95	89.2	604580.0
2013-08-02	ANGL	ETF	27.12	27.5	27.12	27.35	5200.0
2013-08-02	AOA	ETF	41.74	41.85	41.68	41.85	14200.0
2013-08-02	AOK	ETF	31.2495	31.28	31.2005	31.2671	16122.0
2013-08-02	AOM	ETF	33.09	33.19	33.09	33.18	20888.0
2013-08-02	AOR	ETF	36.65	36.74	36.628	36.74	8045.0
2013-08-02	ARB	ETF	46.0	46.25	45.92	46.2	142933.0
2013-08-02	ARGT	ETF	17.9	18.03	17.89	17.89	1500.0
2013-08-02	ASEA	ETF	17.07	17.17	17.07	17.17	6400.0
2013-08-02	ATMP	ETF	26.52	26.56	26.46	26.47	12800.0
2013-08-02	AVIV	ETF	24.18	24.67	23.75	24.64	274077.0
2013-08-02	AWAY	ETF	30.64	30.7	29.83	30.11	757118.0
2013-08-02	BAB	ETF	27.66	27.809	27.66	27.73	270893.0
2013-08-02	BAL	ETF	54.53	54.73	54.39	54.45	13154.0
2013-08-02	BALT	ETF	3.79	3.87	3.77	3.8	96413.0
2013-08-02	BBH	ETF	80.41	80.61	80.15	80.46	52400.0
2013-08-02	BCM	ETF	39.82	39.82	39.64	39.7599	3419.0
2013-08-02	BFOR	ETF	6.6475	6.72	6.6475	6.715	289200.0
2013-08-02	BIB	ETF	30.1275	30.385	30.0	30.2825	113292.0
2013-08-02	BICK	ETF	21.8	21.9701	21.8	21.9265	8720.0
2013-08-02	BIL	ETF	91.58	91.6	91.58	91.6	273800.0
2013-08-02	BIS	ETF	1138.0	1143.6	1126.4	1136.0	52.5
2013-08-02	BIV	ETF	83.15	83.45	83.15	83.41	286400.0
2013-08-02	BIZD	ETF	20.44	20.53	20.44	20.52	3900.0
2013-08-02	BJK	ETF	42.67	42.95	42.67	42.95	11700.0
2013-08-02	BKF	ETF	35.03	35.3764	35.03	35.19	75101.0
2013-08-02	BKLN	ETF	24.95	24.97	24.93	24.96	3083900.0

> showing 50 of 1,011 rows — these rows as CSV

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