PREVIEW / etf_daily / 2012-09-04

all etf daily files

  file:    by_date/etf_daily/2012/2012-09-04.parquet
  size:    39 KB
  rows:    939

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-09-04	SPY	ETF	141.04	141.46	140.13	141.03	120226200.0
2012-09-04	QQQ	ETF	68.03	68.35	67.42	68.09	32017183.0
2012-09-04	IWM	ETF	81.18	82.4	80.55	82.11	69560700.0
2012-09-04	DIA	ETF	130.74	130.8	129.63	130.23	4106900.0
2012-09-04	GLD	ETF	164.11	164.77	163.66	164.48	12034800.0
2012-09-04	TLT	ETF	126.92	127.63	126.76	127.32	6009300.0
2012-09-04	AADR	ETF	29.25	29.25	28.98	28.98	600.0
2012-09-04	AAXJ	ETF	52.86	53.04	52.59	52.79	200800.0
2012-09-04	ACTV	ETF	11.16	11.71	11.1399	11.63	224111.0
2012-09-04	ACWI	ETF	45.48	45.49	45.14	45.33	468600.0
2012-09-04	ACWV	ETF	55.7	55.89	55.61	55.85	30900.0
2012-09-04	ACWX	ETF	38.07	38.07	37.74	37.86	78642.0
2012-09-04	ADRE	ETF	37.61	37.61	37.2701	37.31	12724.0
2012-09-04	AFK	ETF	29.7001	29.96	29.6	29.9	38519.0
2012-09-04	AGEM	ETF	21.21	21.23	21.0101	21.148	1526.0
2012-09-04	AGG	ETF	112.14	112.15	111.96	112.13	1596700.0
2012-09-04	AGQ	ETF	205.32	208.4	202.28	207.36	631275.0
2012-09-04	AGZ	ETF	113.91	113.97	113.72	113.95	52125.0
2012-09-04	AIA	ETF	41.6	41.779	41.42	41.58	15094.0
2012-09-04	AIQ	ETF	6.95	6.95	6.5	6.5	3230.0
2012-09-04	AIVI	ETF	39.56	39.65	39.37	39.57	44900.0
2012-09-04	AMJ	ETF	39.65	39.74	39.57	39.74	842222.0
2012-09-04	AMLP	ETF	81.75	81.9	81.6	81.75	337340.0
2012-09-04	ANGL	ETF	26.48	26.48	26.45	26.45	3300.0
2012-09-04	AOA	ETF	35.96	36.09	35.82	36.08	4600.0
2012-09-04	AOK	ETF	30.23	30.28	30.1964	30.28	3866.0
2012-09-04	AOM	ETF	31.22	31.32	31.17	31.28	13634.0
2012-09-04	AOR	ETF	33.2	33.32	33.09	33.29	10022.0
2012-09-04	ARB	ETF	35.02	36.04	34.56	35.93	111607.0
2012-09-04	ARGT	ETF	17.0	17.0	16.98	16.98	5050.0
2012-09-04	ASEA	ETF	16.23	16.28	16.15	16.23	2400.0
2012-09-04	AWAY	ETF	22.6	23.26	22.1001	22.42	576410.0
2012-09-04	BAB	ETF	30.37	30.46	30.3	30.42	301733.0
2012-09-04	BAL	ETF	51.07	51.07	49.73	50.16	26000.0
2012-09-04	BALT	ETF	3.09	3.09	3.01	3.03	66726.0
2012-09-04	BBH	ETF	51.1	51.94	50.78	51.84	37800.0
2012-09-04	BIB	ETF	14.4537	14.955	14.4062	14.9275	19080.0
2012-09-04	BICK	ETF	22.08	22.1725	21.9501	22.1474	4540.0
2012-09-04	BIL	ETF	91.62	91.64	91.62	91.62	122850.0
2012-09-04	BIS	ETF	2819.2	2838.4	2720.0	2732.784	34.65
2012-09-04	BIV	ETF	89.9	89.92	89.62	89.71	595100.0
2012-09-04	BJK	ETF	31.96	32.08	31.96	32.01	900.0
2012-09-04	BKF	ETF	35.46	35.58	35.2445	35.29	104738.0
2012-09-04	BKLN	ETF	24.82	24.83	24.77	24.82	570100.0
2012-09-04	BLV	ETF	97.31	97.54	96.95	97.09	225100.0
2012-09-04	BMVP	ETF	15.96	16.03	15.88	16.03	1974.0
2012-09-04	BND	ETF	84.95	84.99	84.88	84.94	2076400.0
2012-09-04	BNO	ETF	41.64	41.64	41.06	41.085	22000.0
2012-09-04	BOIL	ETF	844200.0	864000.0	836000.0	840200.0	14.0
2012-09-04	BOND	ETF	107.6	107.69	107.51	107.55	319045.0

> showing 50 of 939 rows — these rows as CSV

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