PREVIEW / etf_daily / 2014-04-02

all etf daily files

  file:    by_date/etf_daily/2014/2014-04-02.parquet
  size:    44 KB
  rows:    1,085

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-04-02	SPY	ETF	188.49	189.13	188.14	188.88	78774000.0
2014-04-02	QQQ	ETF	89.59	89.68	89.035	89.44	34631615.0
2014-04-02	IWM	ETF	118.29	118.48	117.71	118.4	33856500.0
2014-04-02	DIA	ETF	165.19	165.57	164.75	165.37	5597700.0
2014-04-02	GLD	ETF	124.41	124.75	124.19	124.32	4907800.0
2014-04-02	TLT	ETF	107.39	107.55	107.17	107.27	6887200.0
2014-04-02	AADR	ETF	38.41	38.41	38.2	38.4	900.0
2014-04-02	AAXJ	ETF	59.79	60.01	59.76	59.94	539700.0
2014-04-02	ACWI	ETF	58.64	58.75	58.52	58.7	1377600.0
2014-04-02	ACWV	ETF	64.38	64.5	64.29	64.49	7300.0
2014-04-02	ACWX	ETF	46.8	47.01	46.8	46.95	306249.0
2014-04-02	ADRE	ETF	36.77	37.0699	36.77	37.065	7424.0
2014-04-02	AFK	ETF	31.46	31.62	31.39	31.62	9013.0
2014-04-02	AGG	ETF	107.35	107.49	107.33	107.36	1550700.0
2014-04-02	AGQ	ETF	65.08	66.0	65.08	65.11	228900.0
2014-04-02	AGZ	ETF	111.62	111.7099	111.29	111.3271	11485.0
2014-04-02	AIA	ETF	46.35	46.6	46.35	46.6	22242.0
2014-04-02	AIQ	ETF	34.06	34.2	33.31	33.85	63564.0
2014-04-02	AIRR	ETF	19.86	19.95	19.832	19.94	27800.0
2014-04-02	AIVI	ETF	49.38	49.43	49.28	49.36	13300.0
2014-04-02	AMJ	ETF	47.09	47.354	47.0101	47.12	514302.0
2014-04-02	AMLP	ETF	89.15	89.35	88.95	89.1	672440.0
2014-04-02	ANGL	ETF	27.53	27.53	27.53	27.53	800.0
2014-04-02	AOA	ETF	45.67	45.67	45.48	45.62	14500.0
2014-04-02	AOK	ETF	32.3	32.4	32.3	32.39	20766.0
2014-04-02	AOM	ETF	34.88	34.88	34.7704	34.83	14261.0
2014-04-02	AOR	ETF	39.35	39.35	39.1339	39.24	20829.0
2014-04-02	ARGT	ETF	19.97	20.09	19.81	19.98	2900.0
2014-04-02	ASEA	ETF	16.16	16.19	16.15	16.17	54600.0
2014-04-02	ASHR	ETF	22.25	22.28	22.18	22.26	74500.0
2014-04-02	ATMP	ETF	28.22	28.24	28.13	28.16	17100.0
2014-04-02	AVIV	ETF	24.66	25.3	24.66	25.14	244098.0
2014-04-02	AWAY	ETF	38.69	39.24	38.29	38.58	1342977.0
2014-04-02	BAB	ETF	28.64	28.64	28.52	28.58	73961.0
2014-04-02	BAL	ETF	57.88	58.0	57.08	57.12	37483.0
2014-04-02	BALT	ETF	6.4	6.46	6.32	6.36	312544.0
2014-04-02	BBH	ETF	94.21	94.72	92.43	93.33	267100.0
2014-04-02	BCM	ETF	40.6	40.6	40.57	40.599	2029.0
2014-04-02	BFOR	ETF	7.7	7.715	7.68	7.715	118000.0
2014-04-02	BIB	ETF	42.715	43.1	41.023	41.77	596840.0
2014-04-02	BICK	ETF	24.83	25.02	24.785	25.01	1908.0
2014-04-02	BIL	ETF	91.54	91.56	91.54	91.54	455200.0
2014-04-02	BIS	ETF	670.8	694.8	660.0	682.4	7842.0
2014-04-02	BIV	ETF	82.91	82.99	82.75	82.8	178600.0
2014-04-02	BIZD	ETF	20.37	20.52	20.37	20.51	8300.0
2014-04-02	BJK	ETF	53.14	53.14	52.78	52.84	7700.0
2014-04-02	BKF	ETF	36.31	36.77	36.31	36.7401	31214.0
2014-04-02	BKLN	ETF	24.84	24.85	24.81	24.84	3055300.0
2014-04-02	BLV	ETF	85.8	85.85	85.59	85.64	74700.0
2014-04-02	BMVP	ETF	24.05	24.11	24.0	24.07	59612.0

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

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