PREVIEW / etf_daily / 2012-09-24

all etf daily files

  file:    by_date/etf_daily/2012/2012-09-24.parquet
  size:    39 KB
  rows:    953

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-24	SPY	ETF	145.15	145.98	145.04	145.65	95682000.0
2012-09-24	QQQ	ETF	69.56	69.86	69.42	69.735	32341549.0
2012-09-24	IWM	ETF	84.89	85.43	84.6	84.89	54635300.0
2012-09-24	DIA	ETF	134.92	135.73	134.88	135.32	2706900.0
2012-09-24	GLD	ETF	170.63	171.39	170.57	171.05	9177900.0
2012-09-24	TLT	ETF	122.25	122.7	122.18	122.5	3627400.0
2012-09-24	AAXJ	ETF	56.02	56.44	56.02	56.35	99700.0
2012-09-24	ACTV	ETF	12.44	12.61	12.39	12.53	409624.0
2012-09-24	ACWI	ETF	47.19	47.53	47.16	47.42	2286800.0
2012-09-24	ACWV	ETF	56.65	56.8	56.51	56.76	3500.0
2012-09-24	ACWX	ETF	40.03	40.37	40.03	40.31	64747.0
2012-09-24	ADRE	ETF	39.46	39.66	39.39	39.55	47695.0
2012-09-24	AFK	ETF	31.26	31.36	31.1	31.36	27117.0
2012-09-24	AGEM	ETF	22.35	22.5699	22.31	22.39	1349.0
2012-09-24	AGG	ETF	111.94	112.09	111.94	112.07	1220800.0
2012-09-24	AGQ	ETF	225.12	229.96	224.48	226.28	373125.0
2012-09-24	AGZ	ETF	113.79	113.92	113.71	113.91	16251.0
2012-09-24	AIA	ETF	44.48	44.74	44.48	44.7	20504.0
2012-09-24	AIQ	ETF	6.75	6.95	6.75	6.95	3729.0
2012-09-24	AIVI	ETF	41.1	41.4	41.01	41.26	15100.0
2012-09-24	ALTL	ETF	26.11	26.22	26.07	26.17	3600.0
2012-09-24	AMJ	ETF	40.35	40.56	40.2802	40.47	709528.0
2012-09-24	AMLP	ETF	81.95	82.95	81.95	82.8	310040.0
2012-09-24	ANGL	ETF	26.76	26.76	26.6	26.63	700.0
2012-09-24	AOA	ETF	37.16	37.31	37.14	37.19	7100.0
2012-09-24	AOK	ETF	30.57	30.63	30.57	30.61	15659.0
2012-09-24	AOM	ETF	31.82	31.89	31.7817	31.889	8863.0
2012-09-24	AOR	ETF	34.04	34.117	34.0017	34.09	5796.0
2012-09-24	ARB	ETF	37.8	38.5	37.69	38.09	80997.0
2012-09-24	ARGT	ETF	18.08	18.2	18.0	18.14	3000.0
2012-09-24	ASEA	ETF	16.64	16.65	16.53	16.62	5100.0
2012-09-24	AWAY	ETF	25.0	25.14	24.65	24.72	452374.0
2012-09-24	BAB	ETF	29.9	30.0	29.9	29.96	237256.0
2012-09-24	BAL	ETF	47.93	48.18	47.73	48.03	17117.0
2012-09-24	BALT	ETF	3.39	3.39	3.3	3.36	36891.0
2012-09-24	BBH	ETF	54.32	54.42	54.12	54.27	16500.0
2012-09-24	BCM	ETF	45.89	46.02	45.8124	46.0	5941.0
2012-09-24	BIB	ETF	16.305	16.305	15.855	15.883	26840.0
2012-09-24	BICK	ETF	23.93	24.12	23.91	24.0103	6794.0
2012-09-24	BIL	ETF	91.64	91.64	91.62	91.62	123950.0
2012-09-24	BIS	ETF	2555.2	2556.8	2526.4	2542.4	51.0
2012-09-24	BIV	ETF	89.8	89.92	89.79	89.85	183900.0
2012-09-24	BJK	ETF	33.68	33.9	33.66	33.82	16500.0
2012-09-24	BKF	ETF	38.11	38.31	38.03	38.27	46979.0
2012-09-24	BKLN	ETF	25.04	25.05	25.02	25.04	681000.0
2012-09-24	BLNG	ETF	53.17	53.31	53.17	53.31	1651.0
2012-09-24	BLV	ETF	95.49	95.85	95.49	95.79	58200.0
2012-09-24	BMVP	ETF	16.22	16.24	16.18	16.19	5870.0
2012-09-24	BND	ETF	84.78	84.84	84.75	84.81	1697300.0
2012-09-24	BNO	ETF	39.71	39.795	39.295	39.64	78600.0

> showing 50 of 953 rows — these rows as CSV

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