PREVIEW / etf_daily / 2014-07-10

all etf daily files

  file:    by_date/etf_daily/2014/2014-07-10.parquet
  size:    45 KB
  rows:    1,109

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-07-10	SPY	ETF	195.22	196.86	195.06	196.34	99040000.0
2014-07-10	QQQ	ETF	93.78	95.05	93.63	94.66	44250020.0
2014-07-10	IWM	ETF	114.13	116.05	113.97	115.25	50834300.0
2014-07-10	DIA	ETF	167.89	169.34	167.7	168.96	4932100.0
2014-07-10	GLD	ETF	129.11	129.21	128.49	128.54	6313300.0
2014-07-10	TLT	ETF	113.54	113.66	112.82	112.86	7196900.0
2014-07-10	AADR	ETF	38.59	38.75	38.44	38.63	3300.0
2014-07-10	AAXJ	ETF	62.86	63.61	62.86	63.61	323000.0
2014-07-10	ACWI	ETF	60.01	60.3	59.69	60.2	645300.0
2014-07-10	ACWV	ETF	66.79	67.11	66.27	66.97	29300.0
2014-07-10	ACWX	ETF	47.46	47.7699	47.37	47.74	246170.0
2014-07-10	ADRE	ETF	39.39	39.79	39.38	39.79	17924.0
2014-07-10	AFK	ETF	33.04	33.0899	32.63	32.9	17096.0
2014-07-10	AGG	ETF	109.18	109.19	109.01	109.01	791500.0
2014-07-10	AGQ	ETF	74.03	74.31	73.32	73.46	633900.0
2014-07-10	AGZ	ETF	112.5563	112.57	112.34	112.34	10500.0
2014-07-10	AGZD	ETF	24.96	25.09	24.96	25.03	37400.0
2014-07-10	AIA	ETF	48.18	48.621	48.18	48.621	12862.0
2014-07-10	AIQ	ETF	28.28	28.92	27.86	28.04	51413.0
2014-07-10	AIRR	ETF	18.84	18.917	18.81	18.85	8000.0
2014-07-10	AIVI	ETF	49.69	49.97	49.58	49.97	17300.0
2014-07-10	ALTL	ETF	35.555	35.555	35.555	35.555	394.0
2014-07-10	AMJ	ETF	51.23	51.749	51.11	51.37	577530.0
2014-07-10	AMLP	ETF	93.6	93.7	92.9	93.55	633000.0
2014-07-10	ANGL	ETF	28.08	28.08	28.06	28.06	800.0
2014-07-10	AOA	ETF	46.35	46.66	46.2	46.53	29000.0
2014-07-10	AOK	ETF	32.79	32.83	32.731	32.81	19351.0
2014-07-10	AOM	ETF	35.3	35.37	35.2502	35.35	30417.0
2014-07-10	AOR	ETF	39.91	40.08	39.81	40.03	33341.0
2014-07-10	ARGT	ETF	23.42	23.67	23.06	23.48	63500.0
2014-07-10	ASEA	ETF	17.13	17.16	17.11	17.16	3200.0
2014-07-10	ASHR	ETF	22.13	22.23	22.06	22.19	66900.0
2014-07-10	ASHS	ETF	26.38	26.54	26.38	26.54	900.0
2014-07-10	ATMP	ETF	30.84	31.11	30.84	31.11	25300.0
2014-07-10	AVIV	ETF	27.75	28.05	27.62	27.95	299195.0
2014-07-10	AWAY	ETF	32.44	33.52	31.99	33.14	992853.0
2014-07-10	BAB	ETF	29.38	29.38	29.23	29.35	519368.0
2014-07-10	BAL	ETF	46.71	46.71	46.3701	46.39	8185.0
2014-07-10	BALT	ETF	5.27	5.46	5.14	5.45	704943.0
2014-07-10	BBH	ETF	95.04	97.01	95.0	96.56	53100.0
2014-07-10	BCHP	ETF	20.56	20.68	20.56	20.68	3150.0
2014-07-10	BCM	ETF	41.0	41.03	40.91	40.95	72629.0
2014-07-10	BFOR	ETF	7.77	7.8125	7.7225	7.7825	180800.0
2014-07-10	BIB	ETF	44.27	46.335	44.18	45.885	451960.0
2014-07-10	BICK	ETF	26.07	26.08	26.07	26.07	1100.0
2014-07-10	BIL	ETF	91.52	91.54	91.52	91.52	444400.0
2014-07-10	BIS	ETF	589.6	592.0	565.2	572.8	9806.0
2014-07-10	BIV	ETF	84.55	84.66	84.43	84.47	132400.0
2014-07-10	BIZD	ETF	20.54	20.54	20.38	20.47	10000.0
2014-07-10	BJK	ETF	49.5	49.81	49.1	49.77	12100.0

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

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