PREVIEW / etf_daily / 2012-11-05

all etf daily files

  file:    by_date/etf_daily/2012/2012-11-05.parquet
  size:    38 KB
  rows:    939

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-05	SPY	ETF	141.35	142.17	140.93	141.85	98378500.0
2012-11-05	QQQ	ETF	65.195	65.73	65.04	65.6	28104128.0
2012-11-05	IWM	ETF	81.18	81.84	80.92	81.73	26861600.0
2012-11-05	DIA	ETF	130.46	131.13	130.11	130.87	2710700.0
2012-11-05	GLD	ETF	163.12	163.42	162.81	163.23	6156200.0
2012-11-05	TLT	ETF	122.82	123.25	122.79	122.95	2935700.0
2012-11-05	AAXJ	ETF	57.08	57.34	56.79	57.29	226600.0
2012-11-05	ACTV	ETF	5.33	5.67	5.28	5.61	3453668.0
2012-11-05	ACWI	ETF	46.58	46.79	46.48	46.72	162700.0
2012-11-05	ACWV	ETF	56.12	56.27	55.86	56.22	66100.0
2012-11-05	ACWX	ETF	39.62	39.81	39.6	39.75	251954.0
2012-11-05	ADRE	ETF	39.02	39.3	39.02	39.21	39097.0
2012-11-05	AFK	ETF	31.57	31.72	31.39	31.671	10500.0
2012-11-05	AGEM	ETF	22.65	22.65	22.5	22.5	600.0
2012-11-05	AGG	ETF	112.0	112.09	111.95	112.06	2684000.0
2012-11-05	AGQ	ETF	186.96	189.48	185.52	188.76	223450.0
2012-11-05	AGZ	ETF	113.59	113.81	113.58	113.74	10090.0
2012-11-05	AIA	ETF	44.8	45.1732	44.8	45.1592	6169.0
2012-11-05	AIQ	ETF	7.45	7.95	7.25	7.6	104574.0
2012-11-05	AIVI	ETF	39.9	40.01	39.78	39.98	23100.0
2012-11-05	AMJ	ETF	40.73	40.8398	40.45	40.58	262896.0
2012-11-05	AMLP	ETF	83.05	83.3	82.75	83.0	284480.0
2012-11-05	ANGL	ETF	26.89	26.89	26.89	26.89	200.0
2012-11-05	AOA	ETF	36.42	36.52	36.36	36.49	4400.0
2012-11-05	AOK	ETF	30.44	30.46	30.41	30.41	11579.0
2012-11-05	AOM	ETF	31.42	31.54	31.42	31.54	34499.0
2012-11-05	AOR	ETF	33.51	33.62	33.49	33.62	30840.0
2012-11-05	ARB	ETF	36.86	37.43	36.46	37.31	133924.0
2012-11-05	ASEA	ETF	16.67	16.71	16.63	16.71	2200.0
2012-11-05	AWAY	ETF	22.84	23.25	22.0	22.8	1358151.0
2012-11-05	BAB	ETF	30.17	30.1894	30.09	30.11	225088.0
2012-11-05	BAL	ETF	46.22	46.42	46.147	46.41	4403.0
2012-11-05	BALT	ETF	3.43	3.44	3.35	3.4	42945.0
2012-11-05	BBH	ETF	51.23	51.77	50.89	51.75	66400.0
2012-11-05	BCM	ETF	43.76	43.86	43.76	43.8471	2970.0
2012-11-05	BIB	ETF	13.29	13.7175	13.2854	13.6925	41448.0
2012-11-05	BICK	ETF	23.84	24.0	23.84	23.97	4055.0
2012-11-05	BIL	ETF	91.62	91.64	91.62	91.62	528000.0
2012-11-05	BIS	ETF	2964.4	2964.4	2920.068	2920.068	15.95
2012-11-05	BIV	ETF	90.17	90.26	90.13	90.19	331800.0
2012-11-05	BJK	ETF	34.85	35.01	34.72	34.81	19500.0
2012-11-05	BKF	ETF	38.85	39.152	38.75	39.1	32599.0
2012-11-05	BKLN	ETF	24.84	24.86	24.82	24.86	903700.0
2012-11-05	BLV	ETF	96.42	96.65	96.37	96.42	96000.0
2012-11-05	BMVP	ETF	15.7033	15.7937	15.6833	15.7937	1103.0
2012-11-05	BND	ETF	84.83	84.94	84.82	84.92	1520800.0
2012-11-05	BNO	ETF	38.29	39.275	38.29	39.235	45200.0
2012-11-05	BOIL	ETF	979600.0	991800.0	970200.0	978600.0	5.2
2012-11-05	BOND	ETF	109.48	109.4994	109.37	109.41	577435.0
2012-11-05	BRF	ETF	41.18	41.32	41.01	41.25	104534.0

> showing 50 of 939 rows — these rows as CSV

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