PREVIEW / etf_daily / 2013-07-19

all etf daily files

  file:    by_date/etf_daily/2013/2013-07-19.parquet
  size:    41 KB
  rows:    1,004

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-07-19	SPY	ETF	168.52	169.23	168.31	169.17	103831700.0
2013-07-19	QQQ	ETF	74.72	74.74	74.37	74.59	37734062.0
2013-07-19	IWM	ETF	104.06	104.31	103.74	104.31	22806600.0
2013-07-19	DIA	ETF	154.88	155.14	154.57	155.12	4828400.0
2013-07-19	GLD	ETF	124.89	125.42	124.65	125.11	5767800.0
2013-07-19	TLT	ETF	108.31	109.21	108.25	109.2	8523800.0
2013-07-19	AADR	ETF	33.74	33.89	33.74	33.89	2600.0
2013-07-19	AAXJ	ETF	55.87	55.95	55.71	55.87	351900.0
2013-07-19	ACTV	ETF	8.9	9.08	8.84	8.98	717326.0
2013-07-19	ACWI	ETF	52.43	52.61	52.33	52.57	622700.0
2013-07-19	ACWV	ETF	62.04	62.15	61.93	62.12	12500.0
2013-07-19	ACWX	ETF	42.82	42.93	42.71	42.89	323028.0
2013-07-19	ADRE	ETF	34.97	34.99	34.83	34.93	13733.0
2013-07-19	AFK	ETF	28.97	29.0	28.7782	28.98	43683.0
2013-07-19	AGEM	ETF	21.3182	21.3182	21.3182	21.3182	464.0
2013-07-19	AGG	ETF	107.39	107.55	107.29	107.52	563200.0
2013-07-19	AGQ	ETF	67.12	67.56	66.6	67.28	251275.0
2013-07-19	AGZ	ETF	111.2727	111.41	111.2501	111.275	9319.0
2013-07-19	AIA	ETF	43.25	43.38	43.19	43.35	11774.0
2013-07-19	AIQ	ETF	18.48	19.36	18.0	18.18	63396.0
2013-07-19	AIVI	ETF	42.06	42.27	41.99	42.22	39900.0
2013-07-19	ALTL	ETF	29.8399	29.93	29.828	29.921	4100.0
2013-07-19	AMJ	ETF	48.15	48.66	48.15	48.24	546092.0
2013-07-19	AMLP	ETF	90.25	91.0	89.85	90.15	343640.0
2013-07-19	ANGL	ETF	26.92	27.11	26.81	26.85	1800.0
2013-07-19	AOA	ETF	41.35	41.45	41.29	41.45	24200.0
2013-07-19	AOK	ETF	31.249	31.27	31.22	31.25	22824.0
2013-07-19	AOM	ETF	33.01	33.099	33.01	33.0954	11854.0
2013-07-19	AOR	ETF	36.42	36.54	36.398	36.54	15921.0
2013-07-19	ARB	ETF	46.35	46.4	46.3	46.37	92199.0
2013-07-19	ARGT	ETF	17.17	17.17	17.07	17.07	1500.0
2013-07-19	ASEA	ETF	17.19	17.2	17.14	17.19	6300.0
2013-07-19	ATMP	ETF	26.6	26.63	26.49	26.63	43400.0
2013-07-19	AVIV	ETF	26.21	26.29	25.78	26.07	122230.0
2013-07-19	AWAY	ETF	31.45	31.86	31.29	31.67	855488.0
2013-07-19	BAB	ETF	28.17	28.17	28.01	28.02	110496.0
2013-07-19	BAL	ETF	54.79	55.242	54.79	55.03	5000.0
2013-07-19	BALT	ETF	3.92	3.92	3.77	3.77	109461.0
2013-07-19	BBH	ETF	76.79	78.31	76.79	78.28	65900.0
2013-07-19	BCM	ETF	40.002	40.1599	40.002	40.1599	1792.0
2013-07-19	BFOR	ETF	6.545	6.5575	6.5175	6.5575	110400.0
2013-07-19	BIB	ETF	27.5	28.6855	27.2225	28.595	144812.0
2013-07-19	BICK	ETF	21.69	21.75	21.62	21.67	7043.0
2013-07-19	BIL	ETF	91.58	91.6	91.58	91.6	85550.0
2013-07-19	BIS	ETF	1298.0	1298.0	1200.56	1206.0	198.0
2013-07-19	BIV	ETF	83.88	84.09	83.86	84.06	344400.0
2013-07-19	BIZD	ETF	20.4	20.46	20.35	20.35	9400.0
2013-07-19	BJK	ETF	42.06	42.13	41.97	42.11	6400.0
2013-07-19	BKF	ETF	35.05	35.09	34.98	35.06	63029.0
2013-07-19	BKLN	ETF	24.93	24.96	24.91	24.96	2913300.0

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

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