PREVIEW / etf_daily / 2014-07-02

all etf daily files

  file:    by_date/etf_daily/2014/2014-07-02.parquet
  size:    45 KB
  rows:    1,102

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-02	SPY	ETF	197.05	197.48	196.96	197.23	52475000.0
2014-07-02	QQQ	ETF	94.98	95.24	94.91	95.1	18784391.0
2014-07-02	IWM	ETF	119.56	119.96	118.89	119.1	30796700.0
2014-07-02	DIA	ETF	169.31	169.51	169.18	169.4	1929800.0
2014-07-02	GLD	ETF	127.76	128.24	127.64	127.7	5738900.0
2014-07-02	TLT	ETF	111.63	111.67	110.97	111.08	9382500.0
2014-07-02	AADR	ETF	39.23	39.39	39.23	39.3	14300.0
2014-07-02	AAXJ	ETF	62.86	63.87	62.86	63.83	471400.0
2014-07-02	ACWI	ETF	60.84	60.84	60.69	60.84	1883900.0
2014-07-02	ACWV	ETF	67.16	67.89	66.99	67.1	36600.0
2014-07-02	ACWX	ETF	48.54	48.56	48.4332	48.56	113921.0
2014-07-02	ADRE	ETF	39.7	39.73	39.57	39.63	8715.0
2014-07-02	AFK	ETF	33.03	33.34	33.0299	33.26	61032.0
2014-07-02	AGG	ETF	108.94	108.94	108.69	108.69	1381400.0
2014-07-02	AGQ	ETF	71.77	72.83	71.66	72.03	243300.0
2014-07-02	AGZ	ETF	112.36	112.5095	112.3	112.3	6276.0
2014-07-02	AGZD	ETF	25.095	25.095	24.98	25.06	32200.0
2014-07-02	AIA	ETF	49.1129	49.116	48.95	49.02	9000.0
2014-07-02	AIQ	ETF	28.61	30.99	28.51	29.41	39225.0
2014-07-02	AIRR	ETF	19.73	19.73	19.56	19.58	16500.0
2014-07-02	AIVI	ETF	51.09	51.19	51.04	51.13	35100.0
2014-07-02	ALTL	ETF	35.84	35.84	35.84	35.84	332.0
2014-07-02	AMJ	ETF	52.62	52.7	52.21	52.24	249060.0
2014-07-02	AMLP	ETF	95.25	95.3	94.7	94.85	499280.0
2014-07-02	ANGL	ETF	28.44	28.44	28.15	28.3	10600.0
2014-07-02	AOA	ETF	47.1	47.1	46.98	47.0	19100.0
2014-07-02	AOK	ETF	32.99	32.99	32.91	32.91	19285.0
2014-07-02	AOM	ETF	35.59	35.67	35.51	35.56	28698.0
2014-07-02	AOR	ETF	40.36	40.36	40.25	40.25	32630.0
2014-07-02	ARGT	ETF	22.78	22.78	22.37	22.57	28000.0
2014-07-02	ASEA	ETF	16.88	16.88	16.86	16.86	2000.0
2014-07-02	ASHR	ETF	22.65	22.7	22.4	22.6	132700.0
2014-07-02	ASHS	ETF	26.65	26.7	26.65	26.66	2600.0
2014-07-02	ATMP	ETF	31.68	31.68	31.48	31.5	39500.0
2014-07-02	AVIV	ETF	28.24	28.24	27.8	28.12	243823.0
2014-07-02	AWAY	ETF	34.49	34.94	34.04	34.21	1120095.0
2014-07-02	BAB	ETF	29.15	29.1613	29.01	29.09	107822.0
2014-07-02	BAL	ETF	48.9863	49.2	48.83	48.91	9007.0
2014-07-02	BALT	ETF	6.22	6.24	5.92	5.97	848445.0
2014-07-02	BBH	ETF	97.75	99.12	97.75	98.54	76100.0
2014-07-02	BCM	ETF	41.47	41.47	41.47	41.47	540.0
2014-07-02	BFOR	ETF	7.945	7.96	7.9175	7.9175	42400.0
2014-07-02	BIB	ETF	48.77	49.6499	48.2801	49.28	442242.0
2014-07-02	BICK	ETF	27.06	27.12	26.93	26.93	1959.0
2014-07-02	BIL	ETF	91.52	91.54	91.52	91.54	217800.0
2014-07-02	BIS	ETF	544.4	545.2	531.996	535.6	7565.5
2014-07-02	BIV	ETF	84.29	84.29	84.01	84.03	174000.0
2014-07-02	BIZD	ETF	20.77	20.88	20.76	20.83	13000.0
2014-07-02	BJK	ETF	51.23	51.65	51.23	51.45	12900.0
2014-07-02	BKF	ETF	39.06	39.26	39.01	39.18	79007.0

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

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