PREVIEW / etf_daily / 2012-11-08

all etf daily files

  file:    by_date/etf_daily/2012/2012-11-08.parquet
  size:    39 KB
  rows:    951

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-08	SPY	ETF	139.7	140.41	137.93	138.04	181517300.0
2012-11-08	QQQ	ETF	64.33	64.495	63.16	63.16	58585722.0
2012-11-08	IWM	ETF	80.17	80.5	79.15	79.21	42653100.0
2012-11-08	DIA	ETF	129.18	129.68	127.99	127.99	8427500.0
2012-11-08	GLD	ETF	166.14	168.16	166.12	167.99	8829000.0
2012-11-08	TLT	ETF	123.79	125.86	123.43	125.84	8579500.0
2012-11-08	AAXJ	ETF	56.69	57.02	56.13	56.17	265200.0
2012-11-08	ACTV	ETF	5.72	5.87	5.65	5.67	790247.0
2012-11-08	ACWI	ETF	46.25	46.38	45.73	45.77	922000.0
2012-11-08	ACWV	ETF	55.87	55.91	55.38	55.42	15500.0
2012-11-08	ACWX	ETF	39.37	39.5	39.07	39.11	112550.0
2012-11-08	ADRE	ETF	38.84	39.09	38.42	38.421	31663.0
2012-11-08	AFK	ETF	31.72	31.82	31.56	31.57	7526.0
2012-11-08	AGEM	ETF	22.32	22.32	22.32	22.32	187.0
2012-11-08	AGG	ETF	111.98	112.21	111.95	112.14	1411400.0
2012-11-08	AGQ	ETF	196.08	204.04	196.04	203.6	289975.0
2012-11-08	AGZ	ETF	113.86	113.9099	113.8001	113.87	8987.0
2012-11-08	AIA	ETF	44.69	44.91	44.27	44.28	90703.0
2012-11-08	AIQ	ETF	7.25	7.6	7.05	7.6	24727.0
2012-11-08	AIVI	ETF	39.37	39.47	39.01	39.02	23200.0
2012-11-08	ALTL	ETF	25.01	25.01	25.01	25.01	1550.0
2012-11-08	AMJ	ETF	40.38	40.6275	40.03	40.03	716938.0
2012-11-08	AMLP	ETF	81.65	81.75	81.1	81.35	438100.0
2012-11-08	ANGL	ETF	26.77	26.82	26.68	26.82	6000.0
2012-11-08	AOA	ETF	36.2	36.23	35.79	35.79	19100.0
2012-11-08	AOK	ETF	30.35	30.35	30.28	30.28	13479.0
2012-11-08	AOM	ETF	31.32	31.38	31.2662	31.27	13700.0
2012-11-08	AOR	ETF	33.37	33.39	33.13	33.13	11968.0
2012-11-08	ARB	ETF	36.07	36.18	35.42	35.85	167002.0
2012-11-08	ARGT	ETF	16.1	16.1	16.1	16.1	50.0
2012-11-08	ASEA	ETF	16.67	16.67	16.42	16.42	8500.0
2012-11-08	AWAY	ETF	22.16	22.7038	21.65	21.73	519857.0
2012-11-08	BAB	ETF	30.33	30.67	30.29	30.65	276850.0
2012-11-08	BAL	ETF	46.0314	46.0314	45.34	45.5758	9246.0
2012-11-08	BALT	ETF	3.33	3.4	3.27	3.4	133917.0
2012-11-08	BBH	ETF	50.93	50.93	50.1	50.15	32200.0
2012-11-08	BCM	ETF	44.0	44.26	44.0	44.2551	882.0
2012-11-08	BIB	ETF	12.875	13.1875	12.635	12.69	195936.0
2012-11-08	BICK	ETF	23.57	23.5852	23.4501	23.5101	3953.0
2012-11-08	BIL	ETF	91.64	91.64	91.62	91.64	452750.0
2012-11-08	BIS	ETF	2992.0	3085.596	2992.0	3064.4	158.0
2012-11-08	BIV	ETF	90.26	90.48	90.15	90.46	210400.0
2012-11-08	BJK	ETF	34.44	34.44	34.04	34.04	1200.0
2012-11-08	BKF	ETF	38.52	38.7219	38.01	38.03	125178.0
2012-11-08	BKLN	ETF	24.87	24.87	24.85	24.86	2559800.0
2012-11-08	BLV	ETF	96.69	97.57	96.33	97.53	98900.0
2012-11-08	BMVP	ETF	15.7	15.769	15.5867	15.5967	14019.0
2012-11-08	BND	ETF	84.85	85.05	84.82	84.98	667800.0
2012-11-08	BNO	ETF	38.805	39.06	38.62	38.85	18800.0
2012-11-08	BOIL	ETF	971400.0	1010000.0	970000.0	1001200.0	6.6

> showing 50 of 951 rows — these rows as CSV

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