PREVIEW / etf_daily / 2014-07-23

all etf daily files

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

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-23	SPY	ETF	198.5	198.85	198.1	198.64	65612000.0
2014-07-23	QQQ	ETF	96.94	97.34	96.77	97.227	28947464.0
2014-07-23	IWM	ETF	115.01	115.44	114.51	114.87	26417600.0
2014-07-23	DIA	ETF	170.81	170.81	170.2	170.56	2607900.0
2014-07-23	GLD	ETF	125.72	126.04	125.4	125.62	3041400.0
2014-07-23	TLT	ETF	115.51	115.63	115.17	115.18	3489600.0
2014-07-23	AADR	ETF	39.0	39.05	38.93	39.03	20700.0
2014-07-23	AAXJ	ETF	65.04	65.08	64.86	64.9	213700.0
2014-07-23	ACWI	ETF	60.82	60.94	60.79	60.89	433900.0
2014-07-23	ACWV	ETF	67.55	67.6	67.42	67.6	51200.0
2014-07-23	ACWX	ETF	48.33	48.3651	48.26	48.32	105501.0
2014-07-23	ADRE	ETF	41.39	41.39	41.21	41.284	12024.0
2014-07-23	AFK	ETF	33.9	33.9962	33.65	33.8	53867.0
2014-07-23	AGG	ETF	109.5	109.55	109.41	109.46	711800.0
2014-07-23	AGQ	ETF	70.32	70.8	70.15	70.25	103200.0
2014-07-23	AGZ	ETF	112.54	112.54	112.49	112.5	15805.0
2014-07-23	AGZD	ETF	24.985	24.995	24.985	24.995	2800.0
2014-07-23	AIA	ETF	49.69	49.7899	49.68	49.7899	29798.0
2014-07-23	AIQ	ETF	28.48	29.79	28.36	29.71	44394.0
2014-07-23	AIRR	ETF	18.75	18.84	18.67	18.68	10800.0
2014-07-23	AIVI	ETF	50.85	50.85	50.72	50.75	15000.0
2014-07-23	ALTL	ETF	35.7228	35.79	35.7228	35.79	1586.0
2014-07-23	AMJ	ETF	52.51	52.97	52.51	52.59	265043.0
2014-07-23	AMLP	ETF	95.25	95.8	95.2	95.25	500060.0
2014-07-23	ANGL	ETF	28.43	28.43	28.2	28.25	2100.0
2014-07-23	AOA	ETF	47.0	47.0	46.88	46.93	18400.0
2014-07-23	AOK	ETF	32.9201	32.96	32.9201	32.94	17514.0
2014-07-23	AOM	ETF	35.46	35.55	35.46	35.51	38109.0
2014-07-23	AOR	ETF	40.47	40.47	40.2681	40.3	43948.0
2014-07-23	ARGT	ETF	22.52	22.52	21.97	21.98	77000.0
2014-07-23	ASEA	ETF	17.54	17.54	17.47	17.53	5400.0
2014-07-23	ASHR	ETF	23.2	23.2	23.1	23.12	324000.0
2014-07-23	ASHS	ETF	27.56	27.66	27.56	27.66	7400.0
2014-07-23	ATMP	ETF	31.99	32.0	31.91	31.91	66600.0
2014-07-23	AVIV	ETF	29.14	29.18	29.04	29.11	129105.0
2014-07-23	AWAY	ETF	33.19	33.88	33.19	33.88	1116271.0
2014-07-23	BAB	ETF	29.6	29.6199	29.55	29.57	45161.0
2014-07-23	BAL	ETF	45.95	46.03	45.512	45.92	11213.0
2014-07-23	BALT	ETF	5.6	5.64	5.43	5.55	492306.0
2014-07-23	BBH	ETF	97.48	98.29	97.33	98.19	81700.0
2014-07-23	BCHP	ETF	20.8415	20.85	20.79	20.796	2297.0
2014-07-23	BFOR	ETF	7.8075	7.845	7.805	7.8225	72800.0
2014-07-23	BIB	ETF	46.475	47.425	46.2751	46.995	512390.0
2014-07-23	BICK	ETF	27.11	27.1665	27.1088	27.12	904.0
2014-07-23	BIL	ETF	91.5	91.52	91.5	91.52	167400.0
2014-07-23	BIS	ETF	558.4	560.4	544.8	550.8	19903.5
2014-07-23	BIV	ETF	84.86	84.89	84.79	84.82	283800.0
2014-07-23	BIZD	ETF	20.43	20.47	20.41	20.46	3500.0
2014-07-23	BJK	ETF	50.63	50.69	50.46	50.59	10400.0
2014-07-23	BKF	ETF	40.28	40.34	40.18	40.23	8487.0

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

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