PREVIEW / etf_daily / 2012-11-09

all etf daily files

  file:    by_date/etf_daily/2012/2012-11-09.parquet
  size:    39 KB
  rows:    959

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-11-09	SPY	ETF	137.62	139.44	137.55	138.16	201055300.0
2012-11-09	QQQ	ETF	63.19	64.11	63.16	63.43	51549536.0
2012-11-09	IWM	ETF	78.87	79.97	78.7	79.38	33030000.0
2012-11-09	DIA	ETF	127.36	128.79	127.28	127.92	6571600.0
2012-11-09	GLD	ETF	168.21	168.54	167.55	167.82	7361000.0
2012-11-09	TLT	ETF	125.63	125.98	125.18	125.98	5036900.0
2012-11-09	AADR	ETF	29.4	29.4	29.4	29.4	200.0
2012-11-09	AAXJ	ETF	56.16	56.82	56.14	56.52	335200.0
2012-11-09	ACTV	ETF	5.71	5.84	5.63	5.74	869926.0
2012-11-09	ACWI	ETF	45.71	46.07	45.58	45.73	958700.0
2012-11-09	ACWV	ETF	55.53	55.56	55.34	55.5	12000.0
2012-11-09	ACWX	ETF	39.06	39.3	38.9201	39.09	244583.0
2012-11-09	ADRE	ETF	38.29	38.724	35.27	38.39	146942.0
2012-11-09	AFK	ETF	31.46	31.68	31.42	31.5	14605.0
2012-11-09	AGEM	ETF	21.93	21.98	21.92	21.92	1910.0
2012-11-09	AGG	ETF	112.01	112.11	111.92	112.08	1295200.0
2012-11-09	AGQ	ETF	205.04	208.36	204.0	205.68	384300.0
2012-11-09	AGZ	ETF	113.85	114.09	113.85	113.86	33758.0
2012-11-09	AIA	ETF	44.49	44.75	44.31	44.5	25065.0
2012-11-09	AIQ	ETF	6.95	7.35	6.95	7.05	11048.0
2012-11-09	AIVI	ETF	38.83	39.24	38.81	38.97	52000.0
2012-11-09	ALTL	ETF	24.84	24.84	24.84	24.84	200.0
2012-11-09	AMJ	ETF	40.0	40.07	39.6	39.64	545013.0
2012-11-09	AMLP	ETF	81.1	81.45	80.5	80.75	527120.0
2012-11-09	ANGL	ETF	26.83	26.83	26.68	26.79	2900.0
2012-11-09	AOA	ETF	35.71	36.02	35.6	35.91	8800.0
2012-11-09	AOK	ETF	30.21	30.3199	30.08	30.2799	11814.0
2012-11-09	AOM	ETF	31.2	31.34	31.2	31.3	16932.0
2012-11-09	AOR	ETF	32.98	33.264	32.9501	33.1201	20198.0
2012-11-09	ARB	ETF	35.61	36.3	35.61	36.11	91263.0
2012-11-09	ARGT	ETF	16.26	16.26	16.16	16.16	600.0
2012-11-09	ASEA	ETF	16.49	16.65	16.49	16.61	6800.0
2012-11-09	AWAY	ETF	21.7	21.93	20.9	21.06	867314.0
2012-11-09	BAB	ETF	30.53	30.61	30.44	30.59	125011.0
2012-11-09	BAL	ETF	45.95	45.95	45.391	45.7438	10563.0
2012-11-09	BALT	ETF	3.35	3.4	3.25	3.4	97640.0
2012-11-09	BBH	ETF	49.9	51.1	49.77	50.69	82800.0
2012-11-09	BCM	ETF	44.06	44.06	44.06	44.06	274.0
2012-11-09	BIB	ETF	12.5	13.275	12.2525	13.0025	155504.0
2012-11-09	BICK	ETF	23.52	23.62	23.4544	23.4544	3066.0
2012-11-09	BIL	ETF	91.62	91.64	91.62	91.64	1463250.0
2012-11-09	BIS	ETF	3068.0	3176.4	2957.6	3005.2	191.0
2012-11-09	BIV	ETF	90.48	90.55	90.24	90.32	285100.0
2012-11-09	BJK	ETF	34.04	34.32	33.99	34.24	21000.0
2012-11-09	BKF	ETF	37.83	38.21	37.8101	37.92	155106.0
2012-11-09	BKLN	ETF	24.87	24.87	24.82	24.84	2166100.0
2012-11-09	BLV	ETF	97.42	97.53	96.83	97.51	55400.0
2012-11-09	BMVP	ETF	15.49	15.65	15.49	15.55	4018.0
2012-11-09	BND	ETF	84.88	84.98	84.82	84.9	1533200.0
2012-11-09	BNO	ETF	38.85	39.775	38.83	39.745	59000.0

> showing 50 of 959 rows — these rows as CSV

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