PREVIEW / etf_daily / 2013-02-07

all etf daily files

  file:    by_date/etf_daily/2013/2013-02-07.parquet
  size:    40 KB
  rows:    964

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-02-07	SPY	ETF	151.21	151.35	149.86	150.96	162490000.0
2013-02-07	QQQ	ETF	67.33	67.371	66.56	67.3	46011203.0
2013-02-07	IWM	ETF	90.39	90.55	89.55	90.16	30206500.0
2013-02-07	DIA	ETF	139.59	139.64	138.32	139.29	6637600.0
2013-02-07	GLD	ETF	161.24	162.96	161.13	161.84	12827200.0
2013-02-07	TLT	ETF	116.77	117.59	116.62	116.67	5951700.0
2013-02-07	AAXJ	ETF	59.92	59.92	59.31	59.43	1441600.0
2013-02-07	ACTV	ETF	5.69	5.87	5.605	5.72	476930.0
2013-02-07	ACWI	ETF	49.96	49.96	49.43	49.79	1949200.0
2013-02-07	ACWV	ETF	58.36	58.37	57.83	58.24	51000.0
2013-02-07	ACWX	ETF	42.93	42.93	42.44	42.67	398002.0
2013-02-07	ADRE	ETF	40.35	40.35	39.93	40.02	75572.0
2013-02-07	AFK	ETF	31.65	31.65	31.24	31.3	22754.0
2013-02-07	AGEM	ETF	23.7	23.7	23.3856	23.3856	2551.0
2013-02-07	AGG	ETF	110.18	110.34	110.16	110.25	1147900.0
2013-02-07	AGQ	ETF	187.0	192.72	186.16	187.88	433975.0
2013-02-07	AGZ	ETF	113.0197	113.17	112.96	113.15	20580.0
2013-02-07	AIA	ETF	46.38	46.49	46.13	46.45	63524.0
2013-02-07	AIQ	ETF	6.7	6.79	6.7	6.73	18914.0
2013-02-07	AIVI	ETF	42.58	42.58	41.97	42.16	45900.0
2013-02-07	ALTL	ETF	27.86	27.86	27.8465	27.8465	900.0
2013-02-07	AMJ	ETF	42.96	42.98	42.67	42.82	1721593.0
2013-02-07	AMLP	ETF	84.7	84.85	84.4	84.7	524900.0
2013-02-07	ANGL	ETF	27.1	27.1	26.69	26.69	5400.0
2013-02-07	AOA	ETF	38.76	38.8	38.54	38.67	15800.0
2013-02-07	AOK	ETF	30.86	30.9	30.804	30.86	31557.0
2013-02-07	AOM	ETF	32.39	32.39	32.1942	32.24	19441.0
2013-02-07	AOR	ETF	34.95	35.0	34.79	34.92	56299.0
2013-02-07	ARB	ETF	46.95	47.1	46.95	47.07	146330.0
2013-02-07	ARGT	ETF	18.28	18.28	18.06	18.1	3050.0
2013-02-07	ASEA	ETF	16.97	16.97	16.87	16.91	9500.0
2013-02-07	AWAY	ETF	23.92	24.1599	23.7	23.89	297988.0
2013-02-07	BAB	ETF	30.15	30.2155	30.1144	30.12	301195.0
2013-02-07	BAL	ETF	53.2065	53.37	52.66	53.28	57462.0
2013-02-07	BALT	ETF	3.12	3.21	3.06	3.15	62107.0
2013-02-07	BBH	ETF	58.16	58.16	57.11	57.64	39500.0
2013-02-07	BCM	ETF	45.46	45.46	44.9932	44.9932	945.0
2013-02-07	BIB	ETF	16.4275	16.5224	15.9575	16.15	68632.0
2013-02-07	BICK	ETF	25.21	25.21	24.978	25.06	3066.0
2013-02-07	BIL	ETF	91.6	91.62	91.6	91.62	50900.0
2013-02-07	BIS	ETF	2364.0	2369.2	2353.2	2353.2	37.25
2013-02-07	BIV	ETF	87.35	87.51	87.27	87.35	197300.0
2013-02-07	BJK	ETF	38.24	38.25	38.01	38.13	15400.0
2013-02-07	BKF	ETF	41.39	41.39	40.74	40.92	107570.0
2013-02-07	BKLN	ETF	25.04	25.04	24.99	25.0	2456900.0
2013-02-07	BLV	ETF	91.09	91.41	90.89	91.04	55400.0
2013-02-07	BMVP	ETF	17.81	17.81	17.65	17.78	23633.0
2013-02-07	BND	ETF	83.4	83.48	83.36	83.41	1047200.0
2013-02-07	BNO	ETF	43.755	43.85	43.49	43.695	31200.0
2013-02-07	BOIL	ETF	788400.0	800000.0	732800.0	739200.0	22.8

> showing 50 of 964 rows — these rows as CSV

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