PREVIEW / etf_daily / 2014-08-14

all etf daily files

  file:    by_date/etf_daily/2014/2014-08-14.parquet
  size:    45 KB
  rows:    1,105

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
2014-08-14	SPY	ETF	195.16	195.76	194.98	195.76	57371000.0
2014-08-14	QQQ	ETF	96.54	96.95	96.43	96.93	25006602.0
2014-08-14	IWM	ETF	113.52	113.73	113.23	113.61	20882100.0
2014-08-14	DIA	ETF	166.69	167.1	166.46	167.1	2752400.0
2014-08-14	GLD	ETF	126.24	126.53	126.13	126.31	3348500.0
2014-08-14	TLT	ETF	115.93	116.5	115.39	116.44	9028200.0
2014-08-14	AADR	ETF	37.95	37.95	37.9	37.9	1500.0
2014-08-14	AAXJ	ETF	65.65	65.65	65.48	65.62	300700.0
2014-08-14	ACWI	ETF	59.62	59.8	59.62	59.8	264200.0
2014-08-14	ACWV	ETF	67.04	67.25	67.04	67.24	23400.0
2014-08-14	ACWX	ETF	47.18	47.31	47.16	47.31	50275.0
2014-08-14	ADRE	ETF	41.4	41.59	41.4	41.55	13217.0
2014-08-14	AFK	ETF	33.66	33.85	33.44	33.49	46045.0
2014-08-14	AGG	ETF	109.65	109.68	109.54	109.62	1072900.0
2014-08-14	AGQ	ETF	63.3	63.83	63.01	63.34	87200.0
2014-08-14	AGZ	ETF	112.67	112.7189	112.5506	112.62	6448.0
2014-08-14	AIA	ETF	50.59	50.6545	50.55	50.652	19116.0
2014-08-14	AIQ	ETF	28.57	29.1	28.35	28.51	30882.0
2014-08-14	AIRR	ETF	18.64	18.77	18.64	18.77	23900.0
2014-08-14	AIVI	ETF	49.2	49.3	49.08	49.28	20200.0
2014-08-14	AMJ	ETF	52.23	52.8399	52.23	52.7	1415372.0
2014-08-14	AMLP	ETF	93.8	94.3	93.7	94.15	539920.0
2014-08-14	ANGL	ETF	27.85	27.9	27.85	27.85	9800.0
2014-08-14	AOA	ETF	46.3	46.31	46.2	46.31	14200.0
2014-08-14	AOK	ETF	32.7368	32.77	32.722	32.77	11299.0
2014-08-14	AOM	ETF	35.32	35.32	35.26	35.32	28816.0
2014-08-14	AOR	ETF	39.8801	39.92	39.8618	39.9	17821.0
2014-08-14	ARGT	ETF	21.59	21.59	21.02	21.04	20700.0
2014-08-14	ASEA	ETF	17.45	17.48	17.44	17.45	12300.0
2014-08-14	ASHR	ETF	24.79	24.79	24.67	24.73	180500.0
2014-08-14	ASHS	ETF	30.01	30.03	29.97	29.97	4000.0
2014-08-14	ATMP	ETF	31.61	32.01	31.61	31.94	21600.0
2014-08-14	AVIV	ETF	27.95	27.99	27.77	27.81	177251.0
2014-08-14	AWAY	ETF	32.57	32.79	32.3	32.77	584518.0
2014-08-14	BAB	ETF	29.65	29.7	29.588	29.66	86842.0
2014-08-14	BAL	ETF	43.23	43.46	43.2	43.3602	13645.0
2014-08-14	BALT	ETF	5.66	5.94	5.66	5.87	328877.0
2014-08-14	BBH	ETF	99.84	101.39	99.6	101.39	69800.0
2014-08-14	BCHP	ETF	20.03	20.03	20.03	20.03	140.0
2014-08-14	BCM	ETF	39.412	39.412	39.37	39.37	931.0
2014-08-14	BFOR	ETF	7.675	7.6925	7.66	7.6925	38000.0
2014-08-14	BIB	ETF	46.42	47.605	46.0	47.515	523544.0
2014-08-14	BICK	ETF	26.9	26.91	26.9	26.91	256.0
2014-08-14	BIL	ETF	91.52	91.52	91.5	91.5	463700.0
2014-08-14	BIS	ETF	550.0	555.6	538.0	538.0	7917.0
2014-08-14	BIV	ETF	85.05	85.1	84.92	85.02	253600.0
2014-08-14	BIZD	ETF	20.21	20.33	20.21	20.26	15600.0
2014-08-14	BJK	ETF	48.69	49.02	48.69	49.0	8200.0
2014-08-14	BKF	ETF	40.23	40.3007	40.1601	40.29	17848.0
2014-08-14	BKLN	ETF	24.61	24.61	24.59	24.59	1242500.0

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

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