PREVIEW / etf_daily / 2012-06-07

all etf daily files

  file:    by_date/etf_daily/2012/2012-06-07.parquet
  size:    38 KB
  rows:    930

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
2012-06-07	SPY	ETF	133.47	133.53	131.78	132.05	184772700.0
2012-06-07	QQQ	ETF	63.16	63.18	62.22	62.27	38414776.0
2012-06-07	IWM	ETF	77.66	77.72	75.94	75.94	57907100.0
2012-06-07	DIA	ETF	125.17	125.43	124.26	124.52	8806300.0
2012-06-07	GLD	ETF	157.82	157.84	153.19	154.5	18921600.0
2012-06-07	TLT	ETF	124.65	125.74	124.39	125.24	18898200.0
2012-06-07	AAXJ	ETF	52.19	52.25	51.46	51.56	1193300.0
2012-06-07	ACTV	ETF	14.8	14.89	14.51	14.6	658053.0
2012-06-07	ACWI	ETF	43.31	43.37	42.79	42.87	1803300.0
2012-06-07	ACWV	ETF	53.59	53.59	53.14	53.15	6200.0
2012-06-07	ACWX	ETF	36.8	36.82	36.19	36.25	477399.0
2012-06-07	ADRE	ETF	37.39	37.6	36.94	36.99	17240.0
2012-06-07	AFK	ETF	27.91	27.91	27.3805	27.3805	18347.0
2012-06-07	AGG	ETF	110.82	110.95	110.78	110.95	751800.0
2012-06-07	AGQ	ETF	178.88	179.0	164.16	166.8	572100.0
2012-06-07	AGZ	ETF	113.43	113.562	113.36	113.38	9491.0
2012-06-07	AIA	ETF	41.48	41.52	40.8907	40.8907	22439.0
2012-06-07	AIQ	ETF	5.2	5.2	4.8	4.85	33044.0
2012-06-07	AIS	ETF	3.19	3.19	3.1	3.13	1065047.0
2012-06-07	AIVI	ETF	37.52	37.57	36.92	37.03	243700.0
2012-06-07	AMJ	ETF	36.63	36.92	36.34	36.38	986768.0
2012-06-07	AMLP	ETF	79.0	79.25	78.2	78.25	447060.0
2012-06-07	ANGL	ETF	25.14	25.14	24.81	24.81	1400.0
2012-06-07	AOA	ETF	34.55	34.55	34.16	34.16	6100.0
2012-06-07	AOK	ETF	29.71	29.71	29.578	29.58	13533.0
2012-06-07	AOM	ETF	30.49	30.53	30.34	30.39	13740.0
2012-06-07	AOR	ETF	32.21	32.21	31.9201	31.97	12696.0
2012-06-07	ARB	ETF	34.98	35.05	34.16	34.19	112394.0
2012-06-07	ARGT	ETF	16.02	16.28	15.82	15.82	14350.0
2012-06-07	ASEA	ETF	15.25	15.25	14.84	14.84	8100.0
2012-06-07	AWAY	ETF	22.17	22.8	21.9	22.12	518322.0
2012-06-07	BAB	ETF	29.84	29.87	29.7201	29.86	208890.0
2012-06-07	BAL	ETF	45.23	46.46	44.66	46.19	42254.0
2012-06-07	BALT	ETF	3.5	3.5	3.11	3.14	279487.0
2012-06-07	BBH	ETF	45.62	45.62	44.99	44.99	3700.0
2012-06-07	BCM	ETF	41.04	41.2	40.62	40.62	10267.0
2012-06-07	BIB	ETF	12.1937	12.275	11.6387	11.6387	24120.0
2012-06-07	BICK	ETF	22.48	22.7699	22.24	22.25	19227.0
2012-06-07	BIL	ETF	91.66	91.66	91.62	91.64	441500.0
2012-06-07	BIS	ETF	3520.0	3620.8	3489.6	3620.784	20.95
2012-06-07	BIV	ETF	88.33	88.45	88.12	88.38	238300.0
2012-06-07	BJK	ETF	32.65	32.65	31.84	31.84	6700.0
2012-06-07	BKF	ETF	36.13	36.28	35.54	35.6	183178.0
2012-06-07	BKLN	ETF	24.02	24.05	23.83	24.04	381900.0
2012-06-07	BLV	ETF	94.03	94.42	93.75	94.31	67300.0
2012-06-07	BMVP	ETF	14.69	14.69	14.46	14.46	6135.0
2012-06-07	BND	ETF	84.09	84.17	84.01	84.11	2325800.0
2012-06-07	BNO	ETF	36.08	36.115	35.07	35.085	91400.0
2012-06-07	BOIL	ETF	733800.0	741000.0	650000.0	657600.0	17.4
2012-06-07	BOND	ETF	104.92	105.11	104.87	105.08	600970.0

> showing 50 of 930 rows — these rows as CSV

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