PREVIEW / etf_daily / 2014-08-04

all etf daily files

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

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-04	SPY	ETF	192.87	194.3	192.05	193.89	91340000.0
2014-08-04	QQQ	ETF	94.9	95.69	94.52	95.32	33230537.0
2014-08-04	IWM	ETF	111.16	111.8	109.89	111.66	34646200.0
2014-08-04	DIA	ETF	164.8	165.61	164.11	165.33	4400000.0
2014-08-04	GLD	ETF	124.36	124.47	123.73	123.99	6499400.0
2014-08-04	TLT	ETF	114.53	114.81	114.26	114.26	5183800.0
2014-08-04	AADR	ETF	37.74	37.86	37.57	37.83	8300.0
2014-08-04	AAXJ	ETF	65.05	65.31	64.82	65.26	746300.0
2014-08-04	ACWI	ETF	59.27	59.68	59.05	59.56	899300.0
2014-08-04	ACWV	ETF	65.97	66.3	65.75	66.23	14400.0
2014-08-04	ACWX	ETF	47.18	47.4299	47.04	47.35	166480.0
2014-08-04	ADRE	ETF	41.0	41.32	40.8701	41.3196	25077.0
2014-08-04	AFK	ETF	33.35	33.694	33.35	33.6688	37492.0
2014-08-04	AGG	ETF	109.2	109.28	109.12	109.12	1496900.0
2014-08-04	AGQ	ETF	66.38	66.58	65.0	65.38	146900.0
2014-08-04	AGZ	ETF	112.36	112.57	112.34	112.42	6615.0
2014-08-04	AGZD	ETF	24.85	24.91	24.825	24.825	51000.0
2014-08-04	AIA	ETF	50.12	50.31	49.96	50.27	19063.0
2014-08-04	AIQ	ETF	27.71	27.97	27.07	27.71	55785.0
2014-08-04	AIRR	ETF	17.99	18.08	17.77	18.08	16100.0
2014-08-04	AIVI	ETF	49.51	49.56	49.24	49.52	12000.0
2014-08-04	AMJ	ETF	50.04	51.1	49.897	51.06	563638.0
2014-08-04	AMLP	ETF	91.85	93.3	91.6	93.3	817200.0
2014-08-04	ANGL	ETF	27.8	27.82	27.58	27.63	3000.0
2014-08-04	AOA	ETF	46.16	46.16	45.62	46.01	26900.0
2014-08-04	AOK	ETF	32.5	32.62	32.5	32.62	48505.0
2014-08-04	AOM	ETF	35.1	35.15	34.981	35.13	24527.0
2014-08-04	AOR	ETF	39.69	39.69	39.43	39.68	20689.0
2014-08-04	ARGT	ETF	22.31	22.44	21.84	21.97	23700.0
2014-08-04	ASEA	ETF	17.39	17.39	17.3	17.39	12500.0
2014-08-04	ASHR	ETF	25.01	25.12	24.94	25.08	320900.0
2014-08-04	ASHS	ETF	28.92	29.29	28.92	29.29	5700.0
2014-08-04	ATMP	ETF	30.72	31.0	30.39	31.0	18800.0
2014-08-04	AVIV	ETF	28.35	28.35	27.845	28.03	158272.0
2014-08-04	AWAY	ETF	33.63	34.29	33.4	33.75	1578295.0
2014-08-04	BAB	ETF	29.56	29.56	29.41	29.46	67353.0
2014-08-04	BAL	ETF	42.94	43.29	42.81	43.24	19247.0
2014-08-04	BALT	ETF	5.05	5.145	4.95	5.11	455235.0
2014-08-04	BBH	ETF	96.88	97.57	96.06	97.22	65800.0
2014-08-04	BCHP	ETF	20.05	20.069	20.032	20.052	3091.0
2014-08-04	BCM	ETF	40.038	40.038	40.038	40.038	172.0
2014-08-04	BFOR	ETF	7.5575	7.625	7.5225	7.61	132400.0
2014-08-04	BIB	ETF	44.375	44.798	43.335	44.405	244370.0
2014-08-04	BICK	ETF	26.98	27.06	26.92	27.06	1060.0
2014-08-04	BIL	ETF	91.5	91.52	91.5	91.52	385750.0
2014-08-04	BIS	ETF	582.4	594.0	573.6	578.8	7797.0
2014-08-04	BIV	ETF	84.48	84.6	84.46	84.51	179300.0
2014-08-04	BIZD	ETF	19.99	20.13	19.99	20.05	47100.0
2014-08-04	BJK	ETF	50.12	50.74	50.12	50.73	4000.0
2014-08-04	BKF	ETF	39.88	40.0465	39.5901	40.01	77286.0

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

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