PREVIEW / etf_daily / 2013-05-28

all etf daily files

  file:    by_date/etf_daily/2013/2013-05-28.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-28	SPY	ETF	167.04	167.78	165.81	166.3	143679800.0
2013-05-28	QQQ	ETF	74.25	74.54	73.66	73.89	27065807.0
2013-05-28	IWM	ETF	99.2	100.1	98.48	99.15	46121100.0
2013-05-28	DIA	ETF	154.21	154.98	153.48	153.88	9374100.0
2013-05-28	GLD	ETF	133.68	135.57	132.8	133.49	12466400.0
2013-05-28	TLT	ETF	116.09	116.27	113.82	113.84	13567500.0
2013-05-28	AADR	ETF	34.83	34.83	34.83	34.83	200.0
2013-05-28	AAXJ	ETF	60.01	60.12	59.65	59.75	342000.0
2013-05-28	ACTV	ETF	6.38	6.38	6.2	6.37	371187.0
2013-05-28	ACWI	ETF	53.38	53.57	52.99	53.08	1637600.0
2013-05-28	ACWV	ETF	63.22	63.22	62.5	62.6	99100.0
2013-05-28	ACWX	ETF	44.42	44.5	44.03	44.11	153646.0
2013-05-28	ADRE	ETF	38.54	38.64	38.31	38.31	20422.0
2013-05-28	AFK	ETF	30.39	30.42	30.13	30.16	28467.0
2013-05-28	AGEM	ETF	22.44	22.44	22.4	22.4	658.0
2013-05-28	AGG	ETF	109.77	109.78	109.17	109.2	1082800.0
2013-05-28	AGQ	ETF	90.12	92.0	88.24	89.28	373350.0
2013-05-28	AGZ	ETF	113.08	113.08	112.63	112.776	32097.0
2013-05-28	AIA	ETF	46.5	46.5	46.19	46.22	25536.0
2013-05-28	AIQ	ETF	13.0	13.21	12.85	13.13	159004.0
2013-05-28	AIVI	ETF	44.13	44.23	43.79	43.91	57400.0
2013-05-28	AMJ	ETF	47.61	48.02	47.3	47.49	454743.0
2013-05-28	AMLP	ETF	90.35	90.5	89.65	89.85	509540.0
2013-05-28	ANGL	ETF	27.37	27.94	27.37	27.65	2300.0
2013-05-28	AOA	ETF	41.44	41.54	41.16	41.19	54600.0
2013-05-28	AOK	ETF	31.59	31.61	31.45	31.46	68522.0
2013-05-28	AOM	ETF	33.44	33.47	33.2501	33.29	17318.0
2013-05-28	AOR	ETF	36.75	36.7755	36.5135	36.56	36490.0
2013-05-28	ARB	ETF	46.86	47.0501	46.7599	47.0	790494.0
2013-05-28	ARGT	ETF	17.81	17.9	17.72	17.8	5300.0
2013-05-28	ASEA	ETF	18.39	18.47	18.32	18.37	54700.0
2013-05-28	ATMP	ETF	26.7	26.7	26.45	26.51	19600.0
2013-05-28	AVIV	ETF	28.26	28.26	27.1	27.2	699888.0
2013-05-28	AWAY	ETF	30.6	30.7799	29.555	29.65	794005.0
2013-05-28	BAB	ETF	30.24	30.33	29.97	29.97	201807.0
2013-05-28	BAL	ETF	51.57	51.65	51.16	51.23	20156.0
2013-05-28	BALT	ETF	3.91	3.966	3.83	3.92	82471.0
2013-05-28	BBH	ETF	73.7	74.44	73.15	73.66	176100.0
2013-05-28	BCM	ETF	40.646	40.646	40.54	40.54	1192.0
2013-05-28	BIB	ETF	25.6525	25.9096	24.9653	25.41	198440.0
2013-05-28	BICK	ETF	23.93	24.0899	23.93	23.93	2296.0
2013-05-28	BIL	ETF	91.6	91.62	91.6	91.6	110300.0
2013-05-28	BIS	ETF	1414.8	1431.6	1375.6	1414.0	289.0
2013-05-28	BIV	ETF	86.84	86.94	86.31	86.35	330100.0
2013-05-28	BIZD	ETF	20.69	20.74	20.35	20.37	19700.0
2013-05-28	BJK	ETF	42.68	42.88	42.58	42.59	15200.0
2013-05-28	BKF	ETF	39.42	39.5165	39.11	39.16	92904.0
2013-05-28	BKLN	ETF	25.17	25.17	25.15	25.16	3405600.0
2013-05-28	BLNG	ETF	38.09	39.86	38.09	39.55	4815.0
2013-05-28	BLV	ETF	90.84	90.89	89.54	89.56	76700.0

> showing 50 of 999 rows — these rows as CSV

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