PREVIEW / etf_daily / 2014-02-25

all etf daily files

  file:    by_date/etf_daily/2014/2014-02-25.parquet
  size:    43 KB
  rows:    1,069

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-02-25	SPY	ETF	185.06	185.59	184.23	184.84	117085000.0
2014-02-25	QQQ	ETF	90.52	90.72	90.02	90.31	27464711.0
2014-02-25	IWM	ETF	116.66	117.24	116.18	116.63	28474200.0
2014-02-25	DIA	ETF	161.74	162.24	161.13	161.5	6067800.0
2014-02-25	GLD	ETF	128.62	129.53	128.57	129.21	5786000.0
2014-02-25	TLT	ETF	106.91	107.36	106.89	107.35	6225400.0
2014-02-25	AADR	ETF	37.75	38.05	37.75	38.05	1000.0
2014-02-25	AAXJ	ETF	57.46	57.57	57.09	57.21	559100.0
2014-02-25	ACWI	ETF	57.6	57.76	57.38	57.44	1284900.0
2014-02-25	ACWV	ETF	63.02	63.32	63.02	63.05	19400.0
2014-02-25	ACWX	ETF	46.43	46.43	46.133	46.18	112168.0
2014-02-25	ADRE	ETF	35.07	35.07	34.64	34.64	13524.0
2014-02-25	AFK	ETF	31.19	31.2499	31.01	31.02	14029.0
2014-02-25	AGG	ETF	107.85	108.02	107.85	107.99	542100.0
2014-02-25	AGQ	ETF	78.06	79.76	77.94	78.73	714700.0
2014-02-25	AGZ	ETF	111.8028	111.83	111.72	111.83	6542.0
2014-02-25	AIA	ETF	45.26	45.26	44.81	44.82	8538.0
2014-02-25	AIQ	ETF	31.43	31.47	30.28	30.6	10426.0
2014-02-25	AIVI	ETF	49.34	49.34	49.0	49.08	9500.0
2014-02-25	ALTL	ETF	33.36	33.36	33.36	33.36	276.0
2014-02-25	AMJ	ETF	46.29	46.53	46.11	46.29	456563.0
2014-02-25	AMLP	ETF	87.15	87.25	86.65	87.0	735680.0
2014-02-25	ANGL	ETF	27.49	27.49	27.34	27.45	3600.0
2014-02-25	AOA	ETF	44.91	44.94	44.75	44.79	26700.0
2014-02-25	AOK	ETF	32.22	32.28	32.22	32.23	16623.0
2014-02-25	AOM	ETF	34.54	34.64	34.526	34.54	48687.0
2014-02-25	AOR	ETF	38.81	38.85	38.69	38.71	83681.0
2014-02-25	ARGT	ETF	18.49	18.79	18.49	18.57	6500.0
2014-02-25	ASEA	ETF	15.42	15.52	15.4	15.4	5700.0
2014-02-25	ASHR	ETF	22.29	22.29	22.12	22.15	334800.0
2014-02-25	ATMP	ETF	27.36	27.36	27.17	27.34	21500.0
2014-02-25	AVIV	ETF	24.91	25.11	24.77	25.02	75446.0
2014-02-25	AWAY	ETF	46.15	46.73	44.77	45.49	2876815.0
2014-02-25	BAB	ETF	28.42	28.47	28.413	28.47	151897.0
2014-02-25	BAL	ETF	55.82	55.82	54.1638	54.422	14222.0
2014-02-25	BALT	ETF	6.6	6.6	6.42	6.47	611766.0
2014-02-25	BBH	ETF	106.14	106.54	104.83	105.78	106800.0
2014-02-25	BCM	ETF	40.99	41.14	40.92	41.04	102585.0
2014-02-25	BFOR	ETF	7.53	7.545	7.5	7.5175	185200.0
2014-02-25	BIB	ETF	54.67	54.87	52.895	54.0	657484.0
2014-02-25	BICK	ETF	23.29	23.32	23.19	23.19	1325.0
2014-02-25	BIL	ETF	91.56	91.56	91.54	91.56	178000.0
2014-02-25	BIS	ETF	547.2	559.6	540.8	550.0	7764.5
2014-02-25	BIV	ETF	83.5	83.67	83.42	83.65	133600.0
2014-02-25	BIZD	ETF	21.27	21.27	21.02	21.05	7500.0
2014-02-25	BJK	ETF	53.75	54.05	53.53	53.69	17200.0
2014-02-25	BKF	ETF	35.0	35.0	34.548	34.68	48048.0
2014-02-25	BKLN	ETF	24.84	24.84	24.82	24.84	1752000.0
2014-02-25	BLV	ETF	85.28	85.55	85.27	85.5	37400.0
2014-02-25	BMVP	ETF	23.17	23.2333	23.0719	23.0767	5530.0

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

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