PREVIEW / etf_daily / 2012-09-14

all etf daily files

  file:    by_date/etf_daily/2012/2012-09-14.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-14	SPY	ETF	146.88	148.11	146.76	147.24	169777000.0
2012-09-14	QQQ	ETF	69.84	70.43	69.79	70.18	38888047.0
2012-09-14	IWM	ETF	85.86	86.96	85.83	86.4	46040200.0
2012-09-14	DIA	ETF	135.62	136.48	135.41	135.86	5186100.0
2012-09-14	GLD	ETF	171.89	172.23	171.31	171.8	16847500.0
2012-09-14	TLT	ETF	119.76	119.85	118.05	118.3	16871600.0
2012-09-14	AADR	ETF	30.46	30.46	30.46	30.46	500.0
2012-09-14	AAXJ	ETF	56.89	57.37	56.69	56.87	489400.0
2012-09-14	ACTV	ETF	12.1	12.47	12.1	12.39	414349.0
2012-09-14	ACWI	ETF	48.03	48.41	47.95	48.08	1015200.0
2012-09-14	ACWV	ETF	57.46	57.46	56.15	56.19	214500.0
2012-09-14	ACWX	ETF	40.72	41.17	40.72	40.98	206530.0
2012-09-14	ADRE	ETF	40.37	41.14	40.37	40.52	117429.0
2012-09-14	AFK	ETF	31.51	32.0	31.51	31.85	55430.0
2012-09-14	AGEM	ETF	22.84	23.16	22.84	23.16	1022.0
2012-09-14	AGG	ETF	111.61	111.61	111.33	111.37	1011200.0
2012-09-14	AGQ	ETF	235.6	237.2	232.48	236.64	499175.0
2012-09-14	AGZ	ETF	113.67	113.67	113.33	113.63	10150.0
2012-09-14	AIA	ETF	44.92	45.42	44.92	45.05	30124.0
2012-09-14	AIQ	ETF	7.2	7.2	6.95	6.95	8301.0
2012-09-14	AIVI	ETF	42.27	42.66	42.24	42.31	41000.0
2012-09-14	ALTL	ETF	26.19	26.27	26.19	26.263	5014.0
2012-09-14	AMJ	ETF	40.09	40.5	39.98	40.5	631551.0
2012-09-14	AMLP	ETF	82.3	83.0	82.25	82.85	467320.0
2012-09-14	ANGL	ETF	26.57	26.57	26.57	26.57	400.0
2012-09-14	AOA	ETF	37.51	37.76	37.51	37.54	27400.0
2012-09-14	AOK	ETF	30.67	30.72	30.66	30.7	19428.0
2012-09-14	AOM	ETF	31.98	32.04	31.93	31.96	27721.0
2012-09-14	AOR	ETF	34.27	34.42	34.24	34.2699	22254.0
2012-09-14	ARB	ETF	38.17	38.83	38.13	38.39	142602.0
2012-09-14	ARGT	ETF	17.94	18.42	17.94	18.42	3100.0
2012-09-14	ASEA	ETF	16.94	17.11	16.94	17.0	7700.0
2012-09-14	AWAY	ETF	24.23	25.29	24.23	24.6	706306.0
2012-09-14	BAB	ETF	29.52	29.52	29.1	29.116	1013932.0
2012-09-14	BAL	ETF	49.1099	50.11	49.0	49.78	19125.0
2012-09-14	BALT	ETF	3.38	3.49	3.325	3.41	61678.0
2012-09-14	BBH	ETF	52.81	53.15	52.49	53.02	17600.0
2012-09-14	BCM	ETF	47.95	48.11	47.9	47.92	6179.0
2012-09-14	BIB	ETF	15.5388	15.6376	15.3912	15.52	49648.0
2012-09-14	BICK	ETF	24.33	24.6	24.2	24.26	10871.0
2012-09-14	BIL	ETF	91.62	91.64	91.62	91.62	97100.0
2012-09-14	BIS	ETF	2560.0	2624.0	2560.0	2603.2	47.0
2012-09-14	BIV	ETF	89.34	89.37	89.0	89.13	297900.0
2012-09-14	BJK	ETF	34.48	34.89	34.35	34.36	7300.0
2012-09-14	BKF	ETF	38.77	39.26	38.68	38.81	190594.0
2012-09-14	BKLN	ETF	24.96	24.99	24.94	24.98	1112700.0
2012-09-14	BLV	ETF	93.9	93.98	92.86	93.08	100300.0
2012-09-14	BMVP	ETF	16.473	16.541	16.41	16.433	46618.0
2012-09-14	BND	ETF	84.52	84.52	84.26	84.28	2127500.0
2012-09-14	BNO	ETF	42.37	42.5	42.07	42.205	158400.0

> showing 50 of 953 rows — these rows as CSV

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