PREVIEW / etf_daily / 2014-05-02

all etf daily files

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

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-05-02	SPY	ETF	188.31	189.14	187.78	188.06	98122000.0
2014-05-02	QQQ	ETF	87.94	88.11	87.28	87.49	40074150.0
2014-05-02	IWM	ETF	112.09	113.12	111.68	112.03	43450300.0
2014-05-02	DIA	ETF	165.16	165.85	164.53	164.75	7036100.0
2014-05-02	GLD	ETF	123.69	125.67	123.33	125.06	9912900.0
2014-05-02	TLT	ETF	111.54	113.1	111.3	112.71	12702100.0
2014-05-02	AADR	ETF	37.92	37.92	37.87	37.87	600.0
2014-05-02	AAXJ	ETF	59.6	59.99	59.6	59.85	276100.0
2014-05-02	ACWI	ETF	58.86	59.01	58.67	58.77	1389500.0
2014-05-02	ACWV	ETF	65.41	65.55	65.16	65.34	55500.0
2014-05-02	ACWX	ETF	47.29	47.51	47.26	47.38	337107.0
2014-05-02	ADRE	ETF	37.36	37.7201	37.36	37.6943	7978.0
2014-05-02	AFK	ETF	32.7	33.29	32.7	33.1816	23923.0
2014-05-02	AGG	ETF	108.45	108.78	108.35	108.68	1075300.0
2014-05-02	AGQ	ETF	59.63	62.97	59.21	61.54	507500.0
2014-05-02	AGZ	ETF	112.1	113.232	111.8701	112.098	11518.0
2014-05-02	AIA	ETF	46.6499	46.72	46.5706	46.72	71037.0
2014-05-02	AIQ	ETF	28.17	28.75	27.98	28.23	19301.0
2014-05-02	AIRR	ETF	19.22	19.25	19.11	19.11	21700.0
2014-05-02	AIVI	ETF	50.07	50.18	49.97	50.08	8500.0
2014-05-02	AMJ	ETF	48.71	48.97	48.5201	48.94	794009.0
2014-05-02	AMLP	ETF	91.05	91.35	90.8	91.35	459200.0
2014-05-02	ANGL	ETF	27.78	27.8	27.68	27.8	2300.0
2014-05-02	AOA	ETF	45.48	45.66	45.4	45.5	12700.0
2014-05-02	AOK	ETF	32.42	32.53	32.42	32.52	18667.0
2014-05-02	AOM	ETF	34.91	34.972	34.8901	34.94	8605.0
2014-05-02	AOR	ETF	39.26	39.335	39.23	39.28	25456.0
2014-05-02	ARGT	ETF	20.12	20.12	20.12	20.12	400.0
2014-05-02	ASEA	ETF	16.53	16.53	16.47	16.53	2100.0
2014-05-02	ASHR	ETF	22.1	22.11	22.02	22.09	37200.0
2014-05-02	ATMP	ETF	29.28	29.3	29.08	29.3	23800.0
2014-05-02	AVIV	ETF	26.28	26.98	26.28	26.87	297287.0
2014-05-02	AWAY	ETF	33.6	33.78	33.1101	33.49	741547.0
2014-05-02	BAB	ETF	29.0	29.25	29.0	29.23	55971.0
2014-05-02	BAL	ETF	58.7	58.82	58.1	58.1554	11971.0
2014-05-02	BALT	ETF	6.2	6.48	6.19	6.38	729031.0
2014-05-02	BBH	ETF	88.39	88.64	86.21	86.83	149600.0
2014-05-02	BCHP	ETF	20.119	20.14	20.1	20.14	1556.0
2014-05-02	BCM	ETF	41.242	41.242	41.242	41.242	484.0
2014-05-02	BFOR	ETF	7.445	7.5325	7.445	7.4825	163600.0
2014-05-02	BIB	ETF	38.415	38.415	36.575	37.02	705462.0
2014-05-02	BICK	ETF	24.59	24.7599	24.59	24.66	1258.0
2014-05-02	BIL	ETF	91.52	91.54	91.52	91.54	71850.0
2014-05-02	BIS	ETF	703.2	738.0	702.8	729.2	12627.0
2014-05-02	BIV	ETF	83.7	84.06	83.6	83.98	450500.0
2014-05-02	BIZD	ETF	19.86	20.02	19.81	19.81	14600.0
2014-05-02	BJK	ETF	50.35	50.82	50.35	50.79	50500.0
2014-05-02	BKF	ETF	35.89	36.3	35.85	36.3	58416.0
2014-05-02	BKLN	ETF	24.76	24.78	24.75	24.78	2576000.0
2014-05-02	BLNG	ETF	36.07	36.07	36.02	36.02	400.0

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

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