PREVIEW / etf_daily / 2012-10-11

all etf daily files

  file:    by_date/etf_daily/2012/2012-10-11.parquet
  size:    39 KB
  rows:    940

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-10-11	SPY	ETF	144.28	144.49	143.33	143.36	123601500.0
2012-10-11	QQQ	ETF	67.44	67.47	66.67	66.71	30476076.0
2012-10-11	IWM	ETF	83.1	83.44	82.6	82.77	38978500.0
2012-10-11	DIA	ETF	133.91	134.1	133.08	133.13	3669100.0
2012-10-11	GLD	ETF	171.3	171.95	171.13	171.32	5714900.0
2012-10-11	TLT	ETF	121.96	123.66	121.89	123.66	5194100.0
2012-10-11	AAXJ	ETF	56.4	56.52	56.22	56.27	302800.0
2012-10-11	ACTV	ETF	10.8	11.16	10.76	10.86	720988.0
2012-10-11	ACWI	ETF	46.95	47.02	46.71	46.71	289600.0
2012-10-11	ACWV	ETF	56.64	56.77	56.35	56.35	16500.0
2012-10-11	ACWX	ETF	39.54	39.62	39.4199	39.42	55577.0
2012-10-11	ADRE	ETF	39.15	39.3	38.7001	39.12	26542.0
2012-10-11	AFK	ETF	31.36	31.5882	31.36	31.51	20191.0
2012-10-11	AGEM	ETF	22.37	22.37	22.37	22.37	200.0
2012-10-11	AGG	ETF	111.97	112.25	111.97	112.23	523400.0
2012-10-11	AGQ	ETF	227.44	229.6	225.16	225.16	165500.0
2012-10-11	AGZ	ETF	113.94	113.94	113.77	113.82	9561.0
2012-10-11	AIA	ETF	44.44	44.46	44.41	44.41	4798.0
2012-10-11	AIQ	ETF	6.7	7.1	6.7	6.9	29284.0
2012-10-11	AIVI	ETF	40.26	40.28	40.0	40.04	14300.0
2012-10-11	AMJ	ETF	40.77	41.07	40.64	40.69	1854446.0
2012-10-11	AMLP	ETF	83.65	83.75	83.3	83.35	214160.0
2012-10-11	AOA	ETF	36.72	36.79	36.59	36.6	6300.0
2012-10-11	AOK	ETF	30.5	30.5	30.45	30.49	12260.0
2012-10-11	AOM	ETF	31.56	31.583	31.52	31.52	19731.0
2012-10-11	AOR	ETF	33.67	33.769	33.6352	33.6454	16858.0
2012-10-11	ARB	ETF	37.91	38.4	37.88	38.16	51003.0
2012-10-11	ARGT	ETF	17.62	17.66	17.56	17.66	750.0
2012-10-11	ASEA	ETF	16.81	16.82	16.72	16.74	2200.0
2012-10-11	AWAY	ETF	26.33	27.36	26.29	27.11	854077.0
2012-10-11	BAB	ETF	29.77	30.0	29.77	29.999	143607.0
2012-10-11	BAL	ETF	46.6501	46.84	46.561	46.84	7752.0
2012-10-11	BALT	ETF	3.0805	3.19	3.05	3.16	97776.0
2012-10-11	BBH	ETF	54.45	54.81	54.29	54.31	16000.0
2012-10-11	BCM	ETF	46.18	46.35	46.18	46.35	2670.0
2012-10-11	BIB	ETF	15.7325	16.0846	15.5	15.82	86880.0
2012-10-11	BICK	ETF	23.8	23.83	23.6735	23.68	5562.0
2012-10-11	BIL	ETF	91.62	91.64	91.62	91.64	69900.0
2012-10-11	BIS	ETF	2544.8	2544.8	2499.2	2511.2	51.5
2012-10-11	BIV	ETF	89.97	90.27	89.9	90.27	276400.0
2012-10-11	BJK	ETF	33.4	33.53	33.31	33.37	4400.0
2012-10-11	BKF	ETF	38.29	38.47	38.23	38.23	40782.0
2012-10-11	BKLN	ETF	25.0	25.0	24.98	24.99	614200.0
2012-10-11	BLV	ETF	96.08	96.93	95.96	96.89	24800.0
2012-10-11	BMVP	ETF	16.06	16.158	16.007	16.007	3136.0
2012-10-11	BND	ETF	84.8	84.94	84.76	84.94	821900.0
2012-10-11	BNO	ETF	41.585	41.78	41.465	41.78	42400.0
2012-10-11	BOIL	ETF	1132800.0	1188800.0	1120000.0	1188000.0	17.6
2012-10-11	BOND	ETF	109.07	109.13	109.0	109.13	560082.0
2012-10-11	BRF	ETF	41.26	41.37	41.17	41.18	44030.0

> showing 50 of 940 rows — these rows as CSV

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