PREVIEW / etf_daily / 2014-07-07

all etf daily files

  file:    by_date/etf_daily/2014/2014-07-07.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-07-07	SPY	ETF	197.82	197.98	197.22	197.51	61696000.0
2014-07-07	QQQ	ETF	95.59	95.71	95.23	95.41	23266428.0
2014-07-07	IWM	ETF	119.44	119.47	117.7	117.77	32279000.0
2014-07-07	DIA	ETF	169.88	170.01	169.55	169.86	2937700.0
2014-07-07	GLD	ETF	126.63	127.03	126.23	127.02	4630200.0
2014-07-07	TLT	ETF	111.27	111.81	111.23	111.49	5928900.0
2014-07-07	AADR	ETF	39.27	39.28	39.18	39.22	29800.0
2014-07-07	AAXJ	ETF	63.9	64.12	63.89	64.08	194700.0
2014-07-07	ACWI	ETF	60.94	60.94	60.76	60.86	1462000.0
2014-07-07	ACWV	ETF	67.18	67.18	66.98	67.07	37200.0
2014-07-07	ACWX	ETF	48.44	48.4441	48.33	48.39	419360.0
2014-07-07	ADRE	ETF	39.79	39.797	39.6201	39.63	4589.0
2014-07-07	AFK	ETF	33.4	33.44	33.19	33.38	20869.0
2014-07-07	AGG	ETF	108.68	108.75	108.62	108.65	1253300.0
2014-07-07	AGQ	ETF	70.6	70.9	69.73	70.9	231300.0
2014-07-07	AGZ	ETF	112.13	112.22	112.05	112.17	6586.0
2014-07-07	AGZD	ETF	24.885	24.885	24.88	24.88	2800.0
2014-07-07	AIA	ETF	48.74	48.8565	48.74	48.85	7431.0
2014-07-07	AIQ	ETF	29.46	29.46	27.95	28.15	22724.0
2014-07-07	AIRR	ETF	19.87	19.87	19.36	19.36	12900.0
2014-07-07	AIVI	ETF	51.04	51.04	50.85	50.91	33200.0
2014-07-07	ALTL	ETF	35.85	35.876	35.828	35.8595	9957.0
2014-07-07	AMJ	ETF	51.92	51.9399	51.0601	51.26	443865.0
2014-07-07	AMLP	ETF	94.15	94.3	93.05	93.35	647420.0
2014-07-07	ANGL	ETF	28.0	28.31	28.0	28.31	4900.0
2014-07-07	AOA	ETF	47.23	47.23	46.91	46.94	24100.0
2014-07-07	AOK	ETF	32.97	32.97	32.894	32.92	20110.0
2014-07-07	AOM	ETF	35.61	35.61	35.4701	35.49	25796.0
2014-07-07	AOR	ETF	40.49	40.49	40.22	40.27	32502.0
2014-07-07	ARGT	ETF	22.83	22.83	22.49	22.64	12000.0
2014-07-07	ASEA	ETF	17.0	17.1	17.0	17.09	10500.0
2014-07-07	ASHR	ETF	22.69	22.69	22.54	22.6	331400.0
2014-07-07	ASHS	ETF	26.88	26.94	26.88	26.9	1500.0
2014-07-07	ATMP	ETF	31.62	31.62	30.85	30.92	24400.0
2014-07-07	AVIV	ETF	28.06	28.21	27.83	27.94	383587.0
2014-07-07	AWAY	ETF	34.58	34.76	33.92	34.06	583694.0
2014-07-07	BAB	ETF	28.95	29.12	28.95	29.08	52453.0
2014-07-07	BAL	ETF	48.11	48.11	47.16	47.32	39785.0
2014-07-07	BALT	ETF	5.93	5.93	5.57	5.65	1372444.0
2014-07-07	BBH	ETF	98.58	99.32	97.22	97.35	66100.0
2014-07-07	BCHP	ETF	21.02	21.02	21.02	21.02	500.0
2014-07-07	BCM	ETF	41.2	41.25	41.158	41.23	3147.0
2014-07-07	BFOR	ETF	7.9675	7.9675	7.89	7.905	129600.0
2014-07-07	BIB	ETF	49.625	49.635	47.09	47.255	633508.0
2014-07-07	BICK	ETF	26.99	26.99	26.99	26.99	130.0
2014-07-07	BIL	ETF	91.52	91.54	91.52	91.54	357200.0
2014-07-07	BIS	ETF	529.6	558.0	529.6	557.2	6834.5
2014-07-07	BIV	ETF	84.01	84.13	83.99	84.1	184200.0
2014-07-07	BIZD	ETF	20.79	20.79	20.6	20.65	137400.0
2014-07-07	BJK	ETF	51.61	51.61	51.23	51.34	3600.0

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

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