PREVIEW / etf_daily / 2013-02-08

all etf daily files

  file:    by_date/etf_daily/2013/2013-02-08.parquet
  size:    40 KB
  rows:    962

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-02-08	SPY	ETF	151.22	151.89	151.22	151.8	103133700.0
2013-02-08	QQQ	ETF	67.64	68.13	67.63	67.99	39845725.0
2013-02-08	IWM	ETF	90.28	90.86	90.24	90.8	25189600.0
2013-02-08	DIA	ETF	139.37	140.03	139.37	139.73	3573800.0
2013-02-08	GLD	ETF	161.46	162.02	161.2	161.57	6085900.0
2013-02-08	TLT	ETF	116.8	117.16	116.23	117.12	5603400.0
2013-02-08	AAXJ	ETF	59.84	60.21	59.78	60.13	330600.0
2013-02-08	ACTV	ETF	5.75	6.12	5.72	6.03	625033.0
2013-02-08	ACWI	ETF	49.95	50.11	49.93	50.06	1303300.0
2013-02-08	ACWV	ETF	58.37	58.48	58.34	58.42	32000.0
2013-02-08	ACWX	ETF	42.74	42.94	42.74	42.88	224717.0
2013-02-08	ADRE	ETF	40.14	40.3005	40.14	40.29	32434.0
2013-02-08	AFK	ETF	31.49	31.59	31.35	31.55	31707.0
2013-02-08	AGEM	ETF	23.48	23.5275	23.48	23.5275	371.0
2013-02-08	AGG	ETF	110.17	110.28	110.05	110.28	681400.0
2013-02-08	AGQ	ETF	187.2	190.2	185.92	187.76	185900.0
2013-02-08	AGZ	ETF	113.104	113.12	113.038	113.1	8256.0
2013-02-08	AIA	ETF	46.791	47.21	46.791	47.17	89999.0
2013-02-08	AIQ	ETF	6.8	6.9	6.8	6.9	12400.0
2013-02-08	AIVI	ETF	42.26	42.48	42.26	42.39	53100.0
2013-02-08	AMJ	ETF	42.3	43.106	42.23	42.8	2602883.0
2013-02-08	AMLP	ETF	84.75	85.0	84.6	85.0	463680.0
2013-02-08	ANGL	ETF	26.66	26.78	26.66	26.73	2400.0
2013-02-08	AOA	ETF	38.78	38.9	38.78	38.86	20000.0
2013-02-08	AOK	ETF	30.97	30.97	30.8601	30.92	19723.0
2013-02-08	AOM	ETF	32.28	32.37	32.23	32.37	72010.0
2013-02-08	AOR	ETF	34.99	35.06	34.97	35.06	44290.0
2013-02-08	ARB	ETF	47.07	47.084	46.98	47.03	498843.0
2013-02-08	ARGT	ETF	18.16	18.16	17.98	17.98	1750.0
2013-02-08	ASEA	ETF	17.07	17.13	17.07	17.11	10000.0
2013-02-08	AWAY	ETF	24.0	24.69	23.91	24.2	396802.0
2013-02-08	BAB	ETF	30.15	30.22	30.12	30.22	147083.0
2013-02-08	BAL	ETF	52.99	54.1988	52.99	54.14	48890.0
2013-02-08	BALT	ETF	3.18	3.22	3.08	3.13	29003.0
2013-02-08	BBH	ETF	57.85	58.3	57.85	58.1	42000.0
2013-02-08	BCM	ETF	45.24	45.24	45.2399	45.2399	1626.0
2013-02-08	BIB	ETF	15.855	16.5175	15.8325	16.485	54352.0
2013-02-08	BICK	ETF	25.25	25.252	25.229	25.229	3500.0
2013-02-08	BIL	ETF	91.62	91.62	91.6	91.62	579750.0
2013-02-08	BIV	ETF	87.35	87.43	87.2	87.37	321200.0
2013-02-08	BJK	ETF	38.78	39.15	38.78	39.11	19100.0
2013-02-08	BKF	ETF	40.98	41.2092	40.98	41.16	54385.0
2013-02-08	BKLN	ETF	25.0	25.01	24.98	25.01	2189100.0
2013-02-08	BLV	ETF	91.2	91.2	90.67	91.2	77700.0
2013-02-08	BMVP	ETF	17.92	17.95	17.9	17.9	11411.0
2013-02-08	BND	ETF	83.39	83.42	83.25	83.39	892100.0
2013-02-08	BNO	ETF	44.15	44.355	44.135	44.205	49200.0
2013-02-08	BOIL	ETF	744400.0	752200.0	722800.0	725400.0	15.8
2013-02-08	BOND	ETF	109.37	109.37	109.154	109.28	378402.0
2013-02-08	BRF	ETF	43.74	43.74	43.39	43.6	60886.0

> showing 50 of 962 rows — these rows as CSV

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