PREVIEW / etf_daily / 2012-10-10

all etf daily files

  file:    by_date/etf_daily/2012/2012-10-10.parquet
  size:    38 KB
  rows:    937

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-10	SPY	ETF	144.18	144.32	143.09	143.28	124247500.0
2012-10-10	QQQ	ETF	67.25	67.43	66.8	66.92	45134294.0
2012-10-10	IWM	ETF	82.67	82.83	82.18	82.47	32465600.0
2012-10-10	DIA	ETF	134.4	134.45	133.07	133.28	10138700.0
2012-10-10	GLD	ETF	170.54	171.34	170.3	170.84	7361300.0
2012-10-10	TLT	ETF	121.46	122.96	121.26	122.81	5429800.0
2012-10-10	AAXJ	ETF	56.21	56.21	55.7	55.81	203800.0
2012-10-10	ACTV	ETF	10.64	10.78	10.48	10.75	544031.0
2012-10-10	ACWI	ETF	46.75	46.81	46.43	46.53	632400.0
2012-10-10	ACWV	ETF	57.55	57.55	56.55	56.6	24200.0
2012-10-10	ACWX	ETF	39.3	39.35	39.06	39.12	458364.0
2012-10-10	ADRE	ETF	39.0	39.07	38.72	38.74	16006.0
2012-10-10	AFK	ETF	31.18	31.4	31.1201	31.2	26155.0
2012-10-10	AGEM	ETF	22.07	22.2349	22.07	22.2349	612.0
2012-10-10	AGG	ETF	111.9	112.16	111.88	112.09	555400.0
2012-10-10	AGQ	ETF	224.12	227.76	222.8	225.96	230650.0
2012-10-10	AGZ	ETF	113.75	113.82	113.71	113.82	13316.0
2012-10-10	AIA	ETF	44.26	44.3299	44.07	44.07	11795.0
2012-10-10	AIQ	ETF	6.85	7.0	6.75	6.75	3789.0
2012-10-10	AIVI	ETF	39.91	39.97	39.64	39.71	17100.0
2012-10-10	AMJ	ETF	41.07	41.14	40.81	40.87	826209.0
2012-10-10	AMLP	ETF	83.85	83.95	83.4	83.55	357920.0
2012-10-10	ANGL	ETF	26.44	26.49	26.44	26.48	800.0
2012-10-10	AOA	ETF	36.6	36.62	36.47	36.48	2800.0
2012-10-10	AOK	ETF	30.46	30.46	30.43	30.44	4820.0
2012-10-10	AOM	ETF	31.53	31.54	31.4601	31.48	13640.0
2012-10-10	AOR	ETF	33.68	33.68	33.53	33.5599	3778.0
2012-10-10	ARB	ETF	37.63	38.12	37.55	37.68	51340.0
2012-10-10	ARGT	ETF	17.68	17.76	17.42	17.42	3000.0
2012-10-10	ASEA	ETF	16.71	16.71	16.62	16.62	900.0
2012-10-10	AWAY	ETF	26.55	27.47	26.55	27.25	1240712.0
2012-10-10	BAB	ETF	29.79	29.95	29.75	29.89	106897.0
2012-10-10	BAL	ETF	47.3601	47.4899	47.32	47.4336	4700.0
2012-10-10	BALT	ETF	3.06	3.13	3.04	3.08	106926.0
2012-10-10	BBH	ETF	54.75	54.82	53.91	54.12	51800.0
2012-10-10	BCM	ETF	45.99	46.05	45.772	45.772	545.0
2012-10-10	BIB	ETF	15.745	15.8975	15.415	15.5996	137020.0
2012-10-10	BICK	ETF	23.6	23.6	23.35	23.4183	4920.0
2012-10-10	BIL	ETF	91.62	91.64	91.62	91.64	253600.0
2012-10-10	BIS	ETF	2535.6	2562.404	2532.0	2560.464	54.5
2012-10-10	BIV	ETF	89.94	90.2	89.85	90.16	153000.0
2012-10-10	BJK	ETF	33.48	33.48	33.15	33.25	2400.0
2012-10-10	BKF	ETF	38.0	38.014	37.6538	37.75	63502.0
2012-10-10	BKLN	ETF	24.98	25.0	24.98	24.99	767300.0
2012-10-10	BLV	ETF	95.5	96.34	95.48	96.3	46700.0
2012-10-10	BMVP	ETF	16.09	16.09	15.95	15.95	4762.0
2012-10-10	BND	ETF	84.76	84.89	84.69	84.87	633000.0
2012-10-10	BNO	ETF	41.24	41.6	41.14	41.16	53200.0
2012-10-10	BOIL	ETF	1109000.0	1133600.0	1088200.0	1111200.0	8.4
2012-10-10	BOND	ETF	108.99	109.15	108.9501	109.13	626807.0

> showing 50 of 937 rows — these rows as CSV

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