PREVIEW / etf_daily / 2012-09-07

all etf daily files

  file:    by_date/etf_daily/2012/2012-09-07.parquet
  size:    39 KB
  rows:    942

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-07	SPY	ETF	144.01	144.39	143.88	144.33	107272100.0
2012-09-07	QQQ	ETF	69.37	69.55	69.23	69.43	32966134.0
2012-09-07	IWM	ETF	83.86	84.4	83.7	84.26	32012900.0
2012-09-07	DIA	ETF	132.89	133.09	132.57	132.94	4827700.0
2012-09-07	GLD	ETF	167.77	169.0	167.37	168.44	19138600.0
2012-09-07	TLT	ETF	126.14	126.18	123.92	124.03	7335300.0
2012-09-07	AAXJ	ETF	53.96	54.32	53.9	54.31	317700.0
2012-09-07	ACTV	ETF	12.41	12.45	12.13	12.25	251405.0
2012-09-07	ACWI	ETF	46.58	46.75	46.52	46.75	877100.0
2012-09-07	ACWV	ETF	56.4	56.7	56.27	56.38	34700.0
2012-09-07	ACWX	ETF	39.01	39.28	39.01	39.251	132628.0
2012-09-07	ADRE	ETF	38.28	39.0198	38.28	38.8899	23186.0
2012-09-07	AFK	ETF	30.78	31.07	30.74	31.06	18414.0
2012-09-07	AGEM	ETF	22.21	22.2365	22.21	22.2365	601.0
2012-09-07	AGG	ETF	112.15	112.2	111.85	111.89	1554400.0
2012-09-07	AGQ	ETF	220.4	224.52	218.24	223.92	540425.0
2012-09-07	AGZ	ETF	113.8	113.9499	113.48	113.88	20442.0
2012-09-07	AIA	ETF	42.55	42.86	42.55	42.83	14062.0
2012-09-07	AIQ	ETF	6.65	6.9	6.6	6.6	32760.0
2012-09-07	AIVI	ETF	40.54	40.8	40.53	40.76	24000.0
2012-09-07	AMJ	ETF	39.61	39.77	39.5	39.76	319760.0
2012-09-07	AMLP	ETF	82.0	82.0	81.55	81.75	304200.0
2012-09-07	ANGL	ETF	26.27	26.35	26.26	26.35	2200.0
2012-09-07	AOA	ETF	36.66	36.84	36.66	36.8	10200.0
2012-09-07	AOK	ETF	30.45	30.49	30.37	30.46	25862.0
2012-09-07	AOM	ETF	31.63	31.66	31.58	31.6	13559.0
2012-09-07	AOR	ETF	33.68	33.81	33.68	33.78	14679.0
2012-09-07	ARB	ETF	38.07	38.46	37.83	38.32	108810.0
2012-09-07	ASEA	ETF	16.29	16.41	16.29	16.39	4700.0
2012-09-07	AWAY	ETF	23.38	23.5	23.02	23.18	238973.0
2012-09-07	BAB	ETF	30.32	30.38	30.1145	30.14	159235.0
2012-09-07	BAL	ETF	50.07	50.71	49.91	50.37	48157.0
2012-09-07	BALT	ETF	3.16	3.27	3.13	3.24	62183.0
2012-09-07	BBH	ETF	53.14	53.14	52.5	52.84	20100.0
2012-09-07	BCM	ETF	46.59	46.69	46.59	46.69	700.0
2012-09-07	BIB	ETF	15.6237	15.6237	15.2272	15.3936	58424.0
2012-09-07	BICK	ETF	22.84	23.2499	22.84	23.13	8376.0
2012-09-07	BIL	ETF	91.62	91.64	91.62	91.62	580850.0
2012-09-07	BIS	ETF	2616.0	2659.2	2616.0	2622.4	10.0
2012-09-07	BIV	ETF	89.87	89.89	89.55	89.58	229700.0
2012-09-07	BJK	ETF	32.61	32.96	32.61	32.96	2400.0
2012-09-07	BKF	ETF	36.62	37.1322	36.61	37.07	206663.0
2012-09-07	BKLN	ETF	24.86	24.9	24.85	24.9	232100.0
2012-09-07	BLV	ETF	96.85	96.88	95.69	95.78	49200.0
2012-09-07	BMVP	ETF	16.23	16.2334	16.1733	16.1788	2464.0
2012-09-07	BND	ETF	84.93	84.97	84.74	84.74	928300.0
2012-09-07	BNO	ETF	40.84	41.2	40.51	41.19	48200.0
2012-09-07	BOIL	ETF	753000.0	779800.0	748200.0	757000.0	15.8
2012-09-07	BOND	ETF	107.63	107.734	107.48	107.59	405117.0
2012-09-07	BRF	ETF	39.82	41.09	39.82	40.94	749500.0

> showing 50 of 942 rows — these rows as CSV

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