PREVIEW / etf_daily / 2013-05-17

all etf daily files

  file:    by_date/etf_daily/2013/2013-05-17.parquet
  size:    41 KB
  rows:    999

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
2013-05-17	SPY	ETF	165.95	167.04	165.73	166.94	129801000.0
2013-05-17	QQQ	ETF	73.95	74.33	73.7301	74.3	31117108.0
2013-05-17	IWM	ETF	98.4	99.07	97.96	99.05	35675100.0
2013-05-17	DIA	ETF	152.42	153.24	152.21	153.14	5503200.0
2013-05-17	GLD	ETF	133.17	133.48	131.02	131.07	20346500.0
2013-05-17	TLT	ETF	117.95	118.15	116.98	117.06	7435500.0
2013-05-17	AAXJ	ETF	60.78	60.9	60.66	60.86	141100.0
2013-05-17	ACTV	ETF	6.33	6.37	6.22	6.25	303323.0
2013-05-17	ACWI	ETF	53.48	53.78	53.4	53.76	608200.0
2013-05-17	ACWV	ETF	63.94	64.11	63.8	64.1	96100.0
2013-05-17	ACWX	ETF	44.76	45.0	44.67	44.98	524600.0
2013-05-17	ADRE	ETF	39.07	39.174	38.96	39.12	95754.0
2013-05-17	AFK	ETF	30.48	30.48	30.33	30.3856	29056.0
2013-05-17	AGEM	ETF	22.7	22.7742	22.7	22.7742	51411.0
2013-05-17	AGG	ETF	110.5	110.51	110.25	110.31	621800.0
2013-05-17	AGQ	ETF	92.16	92.72	88.52	88.56	560125.0
2013-05-17	AGZ	ETF	113.29	113.35	113.25	113.28	52735.0
2013-05-17	AIA	ETF	46.99	47.14	46.99	47.1	24310.0
2013-05-17	AIQ	ETF	12.4035	12.59	12.4	12.59	9623.0
2013-05-17	AIVI	ETF	43.9	44.17	43.9	44.17	14000.0
2013-05-17	ALTL	ETF	29.8399	30.02	29.8399	30.01	1240.0
2013-05-17	AMJ	ETF	46.82	47.52	46.82	47.48	545434.0
2013-05-17	AMLP	ETF	88.7	89.0	88.5	89.0	538960.0
2013-05-17	ANGL	ETF	27.93	27.97	27.81	27.91	3100.0
2013-05-17	AOA	ETF	41.52	41.68	41.44	41.68	31000.0
2013-05-17	AOK	ETF	31.7	31.73	31.67	31.73	29498.0
2013-05-17	AOM	ETF	33.47	33.6	33.47	33.6	24290.0
2013-05-17	AOR	ETF	36.76	36.91	36.76	36.91	47527.0
2013-05-17	ARB	ETF	46.86	46.91	46.83	46.91	376894.0
2013-05-17	ARGT	ETF	17.88	17.93	17.88	17.88	300.0
2013-05-17	ASEA	ETF	18.67	18.8	18.65	18.73	52200.0
2013-05-17	ATMP	ETF	26.73	26.73	26.47	26.58	149200.0
2013-05-17	AVIV	ETF	30.44	30.71	30.01	30.3	306512.0
2013-05-17	AWAY	ETF	30.55	30.67	30.01	30.21	712403.0
2013-05-17	BAB	ETF	30.47	30.48	30.3164	30.35	127403.0
2013-05-17	BAL	ETF	54.05	54.374	54.05	54.35	14714.0
2013-05-17	BALT	ETF	3.82	3.9	3.75	3.88	81581.0
2013-05-17	BBH	ETF	72.75	73.12	71.97	73.01	131500.0
2013-05-17	BCM	ETF	40.23	40.2999	40.19	40.2999	1409.0
2013-05-17	BIB	ETF	25.1775	25.2425	24.5009	25.045	170704.0
2013-05-17	BICK	ETF	24.35	24.3628	24.32	24.34	7290.0
2013-05-17	BIL	ETF	91.6	91.62	91.6	91.62	181600.0
2013-05-17	BIS	ETF	1440.4	1466.0	1434.32	1434.32	622.0
2013-05-17	BIV	ETF	87.68	87.73	87.39	87.46	185200.0
2013-05-17	BIZD	ETF	20.68	20.68	20.54	20.65	7900.0
2013-05-17	BJK	ETF	43.12	43.46	43.12	43.46	8100.0
2013-05-17	BKF	ETF	39.7	39.87	39.62	39.75	251898.0
2013-05-17	BKLN	ETF	25.2	25.21	25.2	25.21	1843100.0
2013-05-17	BLV	ETF	91.95	92.1	91.43	91.67	41400.0
2013-05-17	BMVP	ETF	19.3633	19.5367	19.3633	19.5367	6817.0

> showing 50 of 999 rows — these rows as CSV

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