PREVIEW / etf_daily / 2014-06-26

all etf daily files

  file:    by_date/etf_daily/2014/2014-06-26.parquet
  size:    44 KB
  rows:    1,092

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-06-26	SPY	ETF	195.61	195.63	194.13	195.44	84312000.0
2014-06-26	QQQ	ETF	93.35	93.36	92.62	93.34	22572172.0
2014-06-26	IWM	ETF	117.79	117.82	116.59	117.55	28018300.0
2014-06-26	DIA	ETF	168.38	168.39	167.06	168.08	4052400.0
2014-06-26	GLD	ETF	126.53	126.92	126.2	126.73	5529800.0
2014-06-26	TLT	ETF	113.21	113.8	113.21	113.41	6628900.0
2014-06-26	AADR	ETF	39.13	39.13	38.63	38.63	300.0
2014-06-26	AAXJ	ETF	62.74	62.74	62.32	62.51	437300.0
2014-06-26	ACWI	ETF	60.01	60.11	59.7	60.1	510100.0
2014-06-26	ACWV	ETF	66.62	66.62	66.28	66.53	43700.0
2014-06-26	ACWX	ETF	47.82	47.9376	47.62	47.92	172693.0
2014-06-26	ADRE	ETF	38.89	39.0	38.8601	38.98	7713.0
2014-06-26	AFK	ETF	32.79	32.88	32.58	32.67	54009.0
2014-06-26	AGG	ETF	109.25	109.41	109.25	109.39	673700.0
2014-06-26	AGQ	ETF	70.9	71.78	70.66	71.55	164200.0
2014-06-26	AGZ	ETF	112.5	112.7865	112.5	112.63	7940.0
2014-06-26	AGZD	ETF	24.965	24.965	24.965	24.965	200.0
2014-06-26	AIA	ETF	48.02	48.13	48.02	48.13	9853.0
2014-06-26	AIQ	ETF	26.96	28.11	26.96	27.51	16722.0
2014-06-26	AIRR	ETF	19.41	19.41	19.14	19.17	12300.0
2014-06-26	AIVI	ETF	50.62	50.72	50.35	50.57	101700.0
2014-06-26	AMJ	ETF	51.8	52.4299	51.675	51.8	220422.0
2014-06-26	AMLP	ETF	94.3	94.4	94.05	94.35	521640.0
2014-06-26	ANGL	ETF	28.43	28.46	28.43	28.46	1000.0
2014-06-26	AOA	ETF	47.1	47.1	46.81	47.01	34600.0
2014-06-26	AOK	ETF	33.01	33.04	32.9502	33.03	14995.0
2014-06-26	AOM	ETF	35.63	35.67	35.56	35.67	16807.0
2014-06-26	AOR	ETF	40.4	40.4	40.22	40.36	53215.0
2014-06-26	ARGT	ETF	22.26	22.26	22.0	22.08	22900.0
2014-06-26	ASEA	ETF	16.67	16.7	16.67	16.7	1400.0
2014-06-26	ASHR	ETF	22.25	22.25	22.14	22.16	52100.0
2014-06-26	ASHS	ETF	25.75	25.75	25.59	25.71	4700.0
2014-06-26	ATMP	ETF	31.28	31.36	31.25	31.34	17600.0
2014-06-26	AVIV	ETF	28.53	28.728	28.4	28.51	357094.0
2014-06-26	AWAY	ETF	35.09	35.2889	34.38	34.85	1660026.0
2014-06-26	BAB	ETF	29.26	29.33	29.18	29.21	177573.0
2014-06-26	BAL	ETF	50.55	50.6499	49.86	50.63	11505.0
2014-06-26	BALT	ETF	6.14	6.17	5.96	6.1	564081.0
2014-06-26	BBH	ETF	95.48	95.48	94.02	95.26	38100.0
2014-06-26	BCM	ETF	42.011	42.06	41.998	42.06	1067.0
2014-06-26	BFOR	ETF	7.815	7.815	7.7475	7.785	72400.0
2014-06-26	BIB	ETF	46.01	46.26	44.995	46.25	253866.0
2014-06-26	BIL	ETF	91.54	91.54	91.52	91.52	120600.0
2014-06-26	BIS	ETF	569.2	586.24	569.2	572.0	7433.5
2014-06-26	BIV	ETF	84.64	84.76	84.61	84.69	127700.0
2014-06-26	BIZD	ETF	20.43	20.76	20.43	20.75	56900.0
2014-06-26	BJK	ETF	49.53	50.02	49.53	49.93	60400.0
2014-06-26	BKF	ETF	38.5501	38.687	38.4905	38.59	31775.0
2014-06-26	BKLN	ETF	24.85	24.85	24.84	24.84	836000.0
2014-06-26	BLV	ETF	89.61	89.98	89.61	89.77	50500.0

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

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