PREVIEW / etf_daily / 2013-11-07

all etf daily files

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

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-07	SPY	ETF	177.5	177.64	174.76	174.93	157000000.0
2013-11-07	QQQ	ETF	82.99	83.13	81.37	81.44	52173216.0
2013-11-07	IWM	ETF	109.62	109.81	107.14	107.28	60459700.0
2013-11-07	DIA	ETF	157.72	157.8	155.68	155.85	10211000.0
2013-11-07	GLD	ETF	126.14	126.85	125.86	126.16	7700100.0
2013-11-07	TLT	ETF	105.05	106.05	104.97	105.96	7893700.0
2013-11-07	AADR	ETF	36.31	36.31	36.31	36.31	100.0
2013-11-07	AAXJ	ETF	59.95	59.95	58.89	58.97	952700.0
2013-11-07	ACTV	ETF	14.48	14.49	14.47	14.47	2843598.0
2013-11-07	ACWI	ETF	56.28	56.29	55.36	55.39	1791700.0
2013-11-07	ACWV	ETF	64.66	64.66	63.75	63.77	51500.0
2013-11-07	ACWX	ETF	46.25	46.25	45.51	45.53	136203.0
2013-11-07	ADRE	ETF	38.03	38.03	37.32	37.32	14169.0
2013-11-07	AFK	ETF	31.29	31.5999	31.04	31.04	30474.0
2013-11-07	AGG	ETF	107.5	107.59	107.43	107.49	804300.0
2013-11-07	AGQ	ETF	78.72	79.6	78.36	78.68	255825.0
2013-11-07	AGZ	ETF	111.6	112.516	111.58	111.81	9417.0
2013-11-07	AIA	ETF	47.5	47.74	47.05	47.18	12684.0
2013-11-07	AIQ	ETF	20.72	24.66	20.72	23.67	46280.0
2013-11-07	AIVI	ETF	47.21	47.22	46.54	46.58	28200.0
2013-11-07	AMJ	ETF	45.83	46.1072	45.41	45.56	654392.0
2013-11-07	AMLP	ETF	88.5	88.65	87.3	87.6	517000.0
2013-11-07	ANGL	ETF	26.98	26.98	26.98	26.98	100.0
2013-11-07	AOA	ETF	43.43	43.44	42.9	42.9	43800.0
2013-11-07	AOK	ETF	31.81	31.8166	31.68	31.69	76432.0
2013-11-07	AOM	ETF	33.96	33.96	33.744	33.78	23616.0
2013-11-07	AOR	ETF	37.87	37.87	37.486	37.51	14329.0
2013-11-07	ARGT	ETF	20.17	20.17	19.68	19.68	11100.0
2013-11-07	ASEA	ETF	17.0	17.04	16.69	16.69	20900.0
2013-11-07	ASHR	ETF	24.67	26.37	24.55	24.55	35100.0
2013-11-07	ATMP	ETF	27.24	27.24	26.65	26.69	13700.0
2013-11-07	AVIV	ETF	25.09	25.93	25.0101	25.69	199840.0
2013-11-07	AWAY	ETF	34.9	34.93	33.3	33.7	7876672.0
2013-11-07	BAB	ETF	27.66	27.75	27.53	27.68	99440.0
2013-11-07	BAL	ETF	49.21	49.21	48.781	48.8499	6174.0
2013-11-07	BALT	ETF	5.19	5.2	4.62	4.7	1125851.0
2013-11-07	BBH	ETF	79.71	80.63	78.06	78.14	149300.0
2013-11-07	BCM	ETF	39.09	39.12	39.06	39.06	5112.0
2013-11-07	BFOR	ETF	7.11	7.11	6.9375	6.9425	517200.0
2013-11-07	BIB	ETF	29.925	30.65	28.6502	28.82	453808.0
2013-11-07	BICK	ETF	23.9	23.93	23.9	23.9	200.0
2013-11-07	BIL	ETF	91.56	91.58	91.56	91.56	156350.0
2013-11-07	BIS	ETF	1111.6	1113.44	1047.6	1112.8	623.5
2013-11-07	BIV	ETF	84.03	84.13	83.94	84.0	159200.0
2013-11-07	BIZD	ETF	20.55	20.55	20.39	20.39	5800.0
2013-11-07	BJK	ETF	50.16	50.16	48.79	48.79	151200.0
2013-11-07	BKF	ETF	38.08	38.13	37.42	37.47	140594.0
2013-11-07	BKLN	ETF	24.87	24.89	24.83	24.83	2426800.0
2013-11-07	BLV	ETF	82.94	83.28	82.81	83.25	29000.0
2013-11-07	BMVP	ETF	21.536	21.536	21.187	21.187	729.0

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

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