PREVIEW / etf_daily / 2013-11-25

all etf daily files

  file:    by_date/etf_daily/2013/2013-11-25.parquet
  size:    42 KB
  rows:    1,053

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-11-25	SPY	ETF	181.13	181.17	180.37	180.63	79486000.0
2013-11-25	QQQ	ETF	84.29	84.38	83.98	84.19	21699975.0
2013-11-25	IWM	ETF	112.13	112.28	111.63	111.99	22968600.0
2013-11-25	DIA	ETF	160.81	160.85	160.3	160.61	5114400.0
2013-11-25	GLD	ETF	119.18	121.0	119.13	120.46	7266300.0
2013-11-25	TLT	ETF	103.84	104.42	103.84	104.21	3755500.0
2013-11-25	AADR	ETF	36.99	37.0	36.58	36.9	2700.0
2013-11-25	AAXJ	ETF	60.25	60.26	59.56	59.64	669900.0
2013-11-25	ACWI	ETF	56.91	56.95	56.66	56.72	825000.0
2013-11-25	ACWV	ETF	64.59	64.59	64.24	64.24	64600.0
2013-11-25	ACWX	ETF	46.44	46.44	46.18	46.22	153537.0
2013-11-25	ADRE	ETF	38.02	38.02	37.61	37.62	9300.0
2013-11-25	AFK	ETF	31.62	31.62	31.27	31.31	15840.0
2013-11-25	AGG	ETF	107.25	107.39	107.23	107.32	692300.0
2013-11-25	AGQ	ETF	66.0	68.0	65.96	67.4	370275.0
2013-11-25	AGZ	ETF	111.5101	111.9099	111.5101	111.58	25164.0
2013-11-25	AIA	ETF	48.85	48.85	48.29	48.31	37738.0
2013-11-25	AIQ	ETF	25.01	26.0	24.9	25.57	46430.0
2013-11-25	AIVI	ETF	47.06	47.13	46.94	46.94	38100.0
2013-11-25	ALTL	ETF	32.07	32.07	32.07	32.07	100.0
2013-11-25	AMJ	ETF	46.24	46.43	46.16	46.21	767186.0
2013-11-25	AMLP	ETF	88.45	88.7	88.3	88.55	796680.0
2013-11-25	ANGL	ETF	27.09	27.1	27.07	27.1	2300.0
2013-11-25	AOA	ETF	43.99	43.99	43.82	43.87	14200.0
2013-11-25	AOK	ETF	31.96	31.96	31.9	31.94	23511.0
2013-11-25	AOM	ETF	34.16	34.2	34.1418	34.17	18267.0
2013-11-25	AOR	ETF	38.21	38.21	38.116	38.14	29902.0
2013-11-25	ARGT	ETF	20.13	20.19	19.96	19.96	2600.0
2013-11-25	ASEA	ETF	16.41	16.41	16.21	16.21	3800.0
2013-11-25	ASHR	ETF	25.12	25.12	24.9	24.91	179400.0
2013-11-25	ATMP	ETF	27.19	27.2	27.16	27.16	7400.0
2013-11-25	AVIV	ETF	25.79	25.8	25.47	25.59	119813.0
2013-11-25	AWAY	ETF	36.67	36.93	35.55	35.7	1095605.0
2013-11-25	BAB	ETF	27.4	27.6	27.4	27.54	87583.0
2013-11-25	BAL	ETF	48.7	49.3742	48.7	49.2	7075.0
2013-11-25	BALT	ETF	4.67	4.76	4.666	4.72	227326.0
2013-11-25	BBH	ETF	87.8	88.13	87.1	87.62	124900.0
2013-11-25	BCM	ETF	39.344	39.39	39.344	39.39	2073.0
2013-11-25	BFOR	ETF	7.29	7.3	7.2525	7.27	279600.0
2013-11-25	BIB	ETF	36.565	36.8723	35.7975	36.5075	286688.0
2013-11-25	BICK	ETF	24.72	24.72	24.452	24.452	4522.0
2013-11-25	BIL	ETF	91.58	91.58	91.56	91.56	630850.0
2013-11-25	BIS	ETF	880.0	880.0	854.4	863.6	1274.0
2013-11-25	BIV	ETF	83.63	83.79	83.63	83.79	311800.0
2013-11-25	BIZD	ETF	21.69	21.69	21.4	21.43	13000.0
2013-11-25	BJK	ETF	49.56	49.56	49.22	49.28	12100.0
2013-11-25	BKF	ETF	38.58	38.7	38.13	38.24	82281.0
2013-11-25	BKLN	ETF	24.83	24.85	24.83	24.83	3393800.0
2013-11-25	BLV	ETF	82.52	82.82	82.5	82.82	235900.0
2013-11-25	BMVP	ETF	22.3633	22.3933	22.28	22.3066	22234.0

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

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