PREVIEW / etf_daily / 2013-03-19

all etf daily files

  file:    by_date/etf_daily/2013/2013-03-19.parquet
  size:    40 KB
  rows:    980

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-19	SPY	ETF	155.3	155.51	153.59	154.61	167567300.0
2013-03-19	QQQ	ETF	68.54	68.7	67.62	68.23	33134570.0
2013-03-19	IWM	ETF	94.41	94.71	93.01	93.83	51516400.0
2013-03-19	DIA	ETF	144.51	144.83	143.48	144.3	9298500.0
2013-03-19	GLD	ETF	155.22	156.34	155.1	156.08	11023400.0
2013-03-19	TLT	ETF	116.78	117.89	116.7	117.43	11986200.0
2013-03-19	AADR	ETF	32.9	32.9	32.9	32.9	300.0
2013-03-19	AAXJ	ETF	58.23	58.24	57.54	57.87	426900.0
2013-03-19	ACTV	ETF	4.63	4.66	4.41	4.5	544232.0
2013-03-19	ACWI	ETF	50.7	50.72	50.09	50.4	913000.0
2013-03-19	ACWV	ETF	60.54	60.66	60.25	60.47	66300.0
2013-03-19	ACWX	ETF	43.02	43.04	42.5	42.75	129267.0
2013-03-19	ADRE	ETF	38.5	38.57	38.091	38.26	69083.0
2013-03-19	AFK	ETF	30.51	30.51	30.03	30.1	26211.0
2013-03-19	AGEM	ETF	22.48	22.48	22.0994	22.2108	2464.0
2013-03-19	AGG	ETF	110.42	110.61	110.39	110.47	1104800.0
2013-03-19	AGQ	ETF	156.16	159.28	155.92	156.84	170900.0
2013-03-19	AGZ	ETF	113.24	113.3	113.18	113.29	12082.0
2013-03-19	AIA	ETF	45.51	45.5276	45.01	45.3	35892.0
2013-03-19	AIQ	ETF	7.0	7.05	6.91	7.05	32842.0
2013-03-19	AIVI	ETF	42.66	42.78	42.17	42.48	31500.0
2013-03-19	ALTL	ETF	28.91	28.91	28.63	28.74	1165.0
2013-03-19	AMJ	ETF	43.3	43.3	42.99	43.23	1456774.0
2013-03-19	AMLP	ETF	85.9	85.9	85.1	85.6	710000.0
2013-03-19	ANGL	ETF	27.05	27.05	27.05	27.05	1400.0
2013-03-19	AOA	ETF	39.62	39.67	39.28	39.41	17700.0
2013-03-19	AOK	ETF	31.12	31.16	31.0501	31.08	20683.0
2013-03-19	AOM	ETF	32.74	32.79	32.57	32.68	18227.0
2013-03-19	AOR	ETF	35.53	35.6	35.3301	35.49	15825.0
2013-03-19	ARB	ETF	46.94	46.99	46.85	46.87	307710.0
2013-03-19	ARGT	ETF	17.88	17.88	17.6	17.6	6900.0
2013-03-19	ASEA	ETF	17.09	17.17	17.03	17.08	10600.0
2013-03-19	ATMP	ETF	24.77	24.81	24.68	24.78	381200.0
2013-03-19	AWAY	ETF	30.0	30.51	30.0	30.15	808964.0
2013-03-19	BAB	ETF	30.18	30.3	30.16	30.27	114905.0
2013-03-19	BAL	ETF	58.85	59.23	58.58	58.96	25595.0
2013-03-19	BALT	ETF	3.91	3.93	3.8265	3.9	37512.0
2013-03-19	BBH	ETF	62.17	62.47	61.47	61.92	15200.0
2013-03-19	BCM	ETF	42.91	42.91	42.67	42.73	965.0
2013-03-19	BIB	ETF	18.53	18.6565	18.095	18.259	58212.0
2013-03-19	BICK	ETF	24.24	24.24	23.96	24.05	7269.0
2013-03-19	BIL	ETF	91.6	91.62	91.6	91.6	93550.0
2013-03-19	BIS	ETF	2013.2	2060.8	2012.0	2058.24	30.0
2013-03-19	BIV	ETF	87.52	87.76	87.52	87.61	280400.0
2013-03-19	BIZD	ETF	20.71	20.72	20.38	20.45	14400.0
2013-03-19	BJK	ETF	38.86	38.96	38.5	38.61	10400.0
2013-03-19	BKF	ETF	38.94	39.0263	38.43	38.7	179060.0
2013-03-19	BKLN	ETF	25.07	25.07	25.04	25.06	3837700.0
2013-03-19	BLV	ETF	91.32	91.63	91.03	91.4	57500.0
2013-03-19	BMVP	ETF	18.31	18.31	18.1667	18.27	4610.0

> showing 50 of 980 rows — these rows as CSV

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