PREVIEW / etf_daily / 2013-03-08

all etf daily files

  file:    by_date/etf_daily/2013/2013-03-08.parquet
  size:    40 KB
  rows:    979

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-03-08	SPY	ETF	155.46	155.65	154.66	155.44	123477800.0
2013-03-08	QQQ	ETF	68.93	69.02	68.5	68.77	26162116.0
2013-03-08	IWM	ETF	93.6	93.75	92.92	93.73	38066100.0
2013-03-08	DIA	ETF	143.95	144.02	143.21	143.76	5680700.0
2013-03-08	GLD	ETF	151.61	153.29	151.4	152.71	11859500.0
2013-03-08	TLT	ETF	114.87	115.36	114.62	114.75	15423600.0
2013-03-08	AADR	ETF	33.01	33.25	33.01	33.25	1300.0
2013-03-08	AAXJ	ETF	60.72	60.78	60.42	60.71	545600.0
2013-03-08	ACTV	ETF	4.69	4.85	4.67	4.82	445493.0
2013-03-08	ACWI	ETF	50.89	50.94	50.67	50.9	273800.0
2013-03-08	ACWV	ETF	60.29	60.32	60.04	60.26	47300.0
2013-03-08	ACWX	ETF	43.32	43.35	43.11	43.31	104328.0
2013-03-08	ADRE	ETF	40.03	40.1625	39.9	40.1	18162.0
2013-03-08	AFK	ETF	30.65	30.7452	30.5	30.73	12346.0
2013-03-08	AGEM	ETF	23.19	23.45	23.17	23.44	4883.0
2013-03-08	AGG	ETF	109.86	109.96	109.78	109.82	2006800.0
2013-03-08	AGQ	ETF	153.16	161.2	152.72	157.8	389825.0
2013-03-08	AGZ	ETF	112.93	113.04	112.83	112.86	16609.0
2013-03-08	AIA	ETF	47.51	47.51	47.2344	47.42	26678.0
2013-03-08	AIQ	ETF	7.04	7.2	7.02	7.07	11013.0
2013-03-08	AIVI	ETF	42.51	42.64	42.36	42.61	20000.0
2013-03-08	AMJ	ETF	43.49	43.77	43.35	43.74	664306.0
2013-03-08	AMLP	ETF	85.8	86.1	85.65	86.05	651660.0
2013-03-08	ANGL	ETF	26.85	27.23	26.85	27.23	800.0
2013-03-08	AOA	ETF	39.52	39.57	39.39	39.54	54500.0
2013-03-08	AOK	ETF	31.08	31.08	31.0101	31.08	14902.0
2013-03-08	AOM	ETF	32.65	32.65	32.5799	32.65	16060.0
2013-03-08	AOR	ETF	35.384	35.49	35.364	35.45	39805.0
2013-03-08	ARB	ETF	47.03	47.1	46.99	47.06	415712.0
2013-03-08	ARGT	ETF	17.46	17.6	17.46	17.54	850.0
2013-03-08	ASEA	ETF	17.54	17.54	17.4	17.44	18900.0
2013-03-08	AWAY	ETF	30.66	30.95	30.14	30.43	808712.0
2013-03-08	BAB	ETF	30.1	30.12	30.05	30.065	270908.0
2013-03-08	BAL	ETF	57.25	57.31	55.72	56.13	52317.0
2013-03-08	BALT	ETF	3.88	3.93	3.86	3.93	137784.0
2013-03-08	BBH	ETF	62.78	62.78	61.88	62.46	62700.0
2013-03-08	BCM	ETF	42.82	42.9899	42.74	42.98	1301.0
2013-03-08	BIB	ETF	18.51	18.6125	18.2275	18.59	75672.0
2013-03-08	BICK	ETF	25.59	25.64	25.46	25.64	4885.0
2013-03-08	BIL	ETF	91.62	91.62	91.6	91.6	291400.0
2013-03-08	BIS	ETF	2040.0	2058.24	2031.12	2040.4	50.5
2013-03-08	BIV	ETF	87.09	87.19	86.99	87.01	386700.0
2013-03-08	BIZD	ETF	20.72	20.72	20.59	20.68	4900.0
2013-03-08	BJK	ETF	38.52	38.67	38.52	38.66	8100.0
2013-03-08	BKF	ETF	40.94	41.06	40.69	40.98	147890.0
2013-03-08	BKLN	ETF	25.07	25.08	25.04	25.07	2096400.0
2013-03-08	BLV	ETF	90.27	90.58	90.17	90.25	93000.0
2013-03-08	BMVP	ETF	18.146	18.193	18.113	18.193	14440.0
2013-03-08	BND	ETF	83.12	83.15	82.9	83.06	6339500.0
2013-03-08	BNO	ETF	41.415	41.77	41.375	41.655	130400.0

> showing 50 of 979 rows — these rows as CSV

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