PREVIEW / etf_daily / 2010-06-17

all etf daily files

  file:    by_date/etf_daily/2010/2010-06-17.parquet
  size:    32 KB
  rows:    747

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
2010-06-17	SPY	ETF	112.28	112.33	111.05	112.14	263185800.0
2010-06-17	QQQ	ETF	47.16	47.18	46.64	47.05	77111819.0
2010-06-17	IWM	ETF	67.08	67.2	65.97	66.76	67327600.0
2010-06-17	DIA	ETF	104.51	104.62	103.38	104.56	9742800.0
2010-06-17	GLD	ETF	121.64	122.41	121.49	121.9	19792200.0
2010-06-17	TLT	ETF	97.15	98.23	97.07	97.85	5650900.0
2010-06-17	AAXJ	ETF	54.65	54.65	53.9	54.24	485900.0
2010-06-17	ACWI	ETF	41.08	41.08	40.44	40.84	176300.0
2010-06-17	ACWX	ETF	38.15	38.15	37.73	38.13	108863.0
2010-06-17	ADRE	ETF	42.0	42.1425	41.446	41.83	67766.0
2010-06-17	AFK	ETF	29.42	29.42	28.78	29.29	16741.0
2010-06-17	AGG	ETF	105.95	106.35	105.95	106.22	776100.0
2010-06-17	AGQ	ETF	129.18	129.72	127.26	127.7	107800.0
2010-06-17	AGZ	ETF	109.46	109.59	109.4001	109.4001	21446.0
2010-06-17	AIA	ETF	38.6	38.6	38.11	38.35	24576.0
2010-06-17	AIQ	ETF	24.5	25.45	24.1	25.2	20525.0
2010-06-17	AIS	ETF	1.9	1.95	1.86	1.91	955118.0
2010-06-17	AIVI	ETF	39.6	39.77	39.32	39.6	114500.0
2010-06-17	AMJ	ETF	30.75	30.85	30.25	30.53	386729.0
2010-06-17	AOA	ETF	30.28	30.28	30.02	30.12	5100.0
2010-06-17	AOK	ETF	27.7556	27.79	27.7556	27.758	10698.0
2010-06-17	AOM	ETF	28.33	28.4	28.25	28.4	17122.0
2010-06-17	AOR	ETF	29.08	29.1	28.96	29.02	17292.0
2010-06-17	ARB	ETF	28.63	28.78	28.18	28.57	84199.0
2010-06-17	BAB	ETF	25.87	26.0	25.85	25.95	123821.0
2010-06-17	BAL	ETF	38.75	38.8	38.51	38.5101	866.0
2010-06-17	BALT	ETF	12.51	12.54	12.24	12.36	84322.0
2010-06-17	BBH	ETF	30.3433	30.52	30.1933	30.5167	49200.0
2010-06-17	BIB	ETF	5.9488	5.9863	5.9488	5.9863	11952.0
2010-06-17	BICK	ETF	28.76	28.76	27.8901	28.41	3374.0
2010-06-17	BIL	ETF	91.72	91.72	91.7	91.7	317700.0
2010-06-17	BITS	ETF	28.2	28.6	26.6	27.6	2743.0
2010-06-17	BIV	ETF	82.05	82.45	82.05	82.39	201400.0
2010-06-17	BJK	ETF	24.8	24.94	24.62	24.84	4800.0
2010-06-17	BKF	ETF	43.5	43.5	42.74	43.09	91842.0
2010-06-17	BLV	ETF	79.9	80.4	79.87	80.31	33600.0
2010-06-17	BMVP	ETF	12.7233	12.7367	12.6133	12.6917	8760.0
2010-06-17	BND	ETF	80.47	80.72	80.46	80.65	785200.0
2010-06-17	BNE	ETF	11.19	11.21	11.16	11.18	447817.0
2010-06-17	BNO	ETF	26.745	26.845	26.7	26.715	39400.0
2010-06-17	BRF	ETF	45.55	45.6	44.75	45.21	227316.0
2010-06-17	BSCE	ETF	20.19	20.22	20.19	20.19	7399.0
2010-06-17	BSV	ETF	80.52	80.62	80.48	80.6	476800.0
2010-06-17	BTF	ETF	66.95	67.3	66.75	66.9	4605.2
2010-06-17	BWX	ETF	26.69	26.79	26.605	26.77	326096.0
2010-06-17	BWZ	ETF	33.66	33.8399	33.66	33.738	4048.0
2010-06-17	BZQ	ETF	3804.8	3960.0	3788.8	3873.6	967.5
2010-06-17	CEF	ETF	15.35	15.37	15.18	15.22	1142100.0
2010-06-17	CEW	ETF	21.61	21.61	21.45	21.48	70601.0
2010-06-17	CGO	ETF	13.48	13.48	13.34	13.4	16664.0

> showing 50 of 747 rows — these rows as CSV

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