PREVIEW / etf_daily / 2014-07-25

all etf daily files

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

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-25	SPY	ETF	198.09	198.26	197.33	197.72	76837000.0
2014-07-25	QQQ	ETF	96.65	96.87	96.23	96.74	29903633.0
2014-07-25	IWM	ETF	113.77	114.01	113.21	113.6	46514500.0
2014-07-25	DIA	ETF	169.77	169.85	168.76	169.16	5714000.0
2014-07-25	GLD	ETF	124.48	125.93	124.43	125.79	5638800.0
2014-07-25	TLT	ETF	115.34	115.68	115.16	115.67	7041800.0
2014-07-25	AADR	ETF	39.34	39.34	38.71	38.71	600.0
2014-07-25	AAXJ	ETF	64.99	64.99	64.73	64.89	523400.0
2014-07-25	ACWI	ETF	60.84	60.84	60.54	60.66	854600.0
2014-07-25	ACWV	ETF	67.36	67.47	67.3	67.38	9500.0
2014-07-25	ACWX	ETF	48.27	48.385	48.11	48.19	112393.0
2014-07-25	ADRE	ETF	41.54	41.66	41.5	41.6	10930.0
2014-07-25	AFK	ETF	33.85	33.94	33.7	33.88	30018.0
2014-07-25	AGG	ETF	109.36	109.39	109.26	109.33	506200.0
2014-07-25	AGQ	ETF	66.92	68.87	66.6	68.82	249900.0
2014-07-25	AGZ	ETF	112.5	112.6044	112.39	112.6044	20267.0
2014-07-25	AGZD	ETF	24.99	24.99	24.99	24.99	200.0
2014-07-25	AIA	ETF	49.92	49.92	49.83	49.8414	22024.0
2014-07-25	AIQ	ETF	29.7	29.87	28.92	29.46	67398.0
2014-07-25	AIRR	ETF	18.42	18.5	18.39	18.42	12100.0
2014-07-25	AIVI	ETF	50.79	50.96	50.58	50.74	15500.0
2014-07-25	ALTL	ETF	35.62	35.62	35.62	35.62	371.0
2014-07-25	AMJ	ETF	52.31	52.35	52.05	52.21	315072.0
2014-07-25	AMLP	ETF	94.9	95.05	94.5	94.7	402280.0
2014-07-25	ANGL	ETF	28.18	28.22	28.11	28.17	2600.0
2014-07-25	AOA	ETF	46.89	46.89	46.7	46.78	16000.0
2014-07-25	AOK	ETF	32.87	32.92	32.85	32.86	15146.0
2014-07-25	AOM	ETF	35.44	35.49	35.43	35.47	29877.0
2014-07-25	AOR	ETF	40.28	40.28	40.142	40.19	22932.0
2014-07-25	ARGT	ETF	22.2	22.32	21.89	22.03	44700.0
2014-07-25	ASEA	ETF	17.45	17.45	17.42	17.42	1200.0
2014-07-25	ASHR	ETF	24.09	24.09	23.82	23.87	366400.0
2014-07-25	ASHS	ETF	28.25	28.25	28.04	28.05	2400.0
2014-07-25	ATMP	ETF	31.86	31.89	31.81	31.84	15500.0
2014-07-25	AVIV	ETF	29.19	29.3299	28.8	28.85	157376.0
2014-07-25	AWAY	ETF	36.5	36.9	34.0	35.57	5169849.0
2014-07-25	BAB	ETF	29.58	29.63	29.5559	29.62	40938.0
2014-07-25	BAL	ETF	44.43	44.43	43.3101	43.86	18230.0
2014-07-25	BALT	ETF	5.45	5.5	5.31	5.32	344972.0
2014-07-25	BBH	ETF	96.6	97.08	95.75	96.67	49600.0
2014-07-25	BCHP	ETF	20.63	20.6365	20.61	20.61	832.0
2014-07-25	BCM	ETF	40.299	40.4293	40.299	40.428	1828.0
2014-07-25	BFOR	ETF	7.825	7.825	7.7775	7.785	52400.0
2014-07-25	BIB	ETF	45.15	45.625	44.405	45.25	311064.0
2014-07-25	BICK	ETF	27.2	27.253	27.18	27.253	2086.0
2014-07-25	BIL	ETF	91.5	91.52	91.5	91.52	73150.0
2014-07-25	BIS	ETF	572.8	580.4	566.0	570.0	11216.5
2014-07-25	BIV	ETF	84.73	84.77	84.62	84.74	289000.0
2014-07-25	BIZD	ETF	20.51	20.64	20.51	20.64	7400.0
2014-07-25	BJK	ETF	50.09	50.37	50.07	50.37	3400.0

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

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