PREVIEW / etf_daily / 2012-11-06

all etf daily files

  file:    by_date/etf_daily/2012/2012-11-06.parquet
  size:    39 KB
  rows:    941

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-06	SPY	ETF	142.28	143.52	142.13	142.96	107068100.0
2012-11-06	QQQ	ETF	65.71	66.17	65.46	65.72	29608306.0
2012-11-06	IWM	ETF	82.03	82.57	81.97	82.34	27342500.0
2012-11-06	DIA	ETF	131.28	132.63	131.2	132.05	4408300.0
2012-11-06	GLD	ETF	163.91	166.77	163.61	166.3	16051800.0
2012-11-06	TLT	ETF	122.55	122.86	121.78	121.79	4484600.0
2012-11-06	AAXJ	ETF	57.37	57.81	57.31	57.71	153900.0
2012-11-06	ACTV	ETF	5.62	6.05	5.42	5.92	2773162.0
2012-11-06	ACWI	ETF	46.81	47.2	46.81	46.87	586000.0
2012-11-06	ACWV	ETF	56.03	56.55	56.03	56.55	2300.0
2012-11-06	ACWX	ETF	39.82	40.1599	39.82	40.1	106033.0
2012-11-06	ADRE	ETF	39.27	39.6499	39.27	39.56	18146.0
2012-11-06	AFK	ETF	31.99	32.1611	31.86	32.06	12241.0
2012-11-06	AGEM	ETF	22.79	22.79	22.79	22.79	685.0
2012-11-06	AGG	ETF	112.0	112.01	111.72	111.74	589600.0
2012-11-06	AGQ	ETF	190.16	202.0	187.92	199.08	392475.0
2012-11-06	AGZ	ETF	113.67	113.79	113.67	113.69	11456.0
2012-11-06	AIA	ETF	45.21	45.63	45.18	45.54	28042.0
2012-11-06	AIQ	ETF	7.6	7.6	7.1	7.4	102616.0
2012-11-06	AIVI	ETF	39.97	40.3	39.97	40.21	36500.0
2012-11-06	AMJ	ETF	40.68	41.01	40.43	40.99	502967.0
2012-11-06	AMLP	ETF	83.15	83.45	83.05	83.45	308500.0
2012-11-06	ANGL	ETF	26.96	26.97	26.68	26.82	215000.0
2012-11-06	AOA	ETF	36.62	36.83	36.62	36.76	9800.0
2012-11-06	AOK	ETF	30.4799	30.52	30.45	30.466	9050.0
2012-11-06	AOM	ETF	31.58	31.65	31.58	31.6056	12276.0
2012-11-06	AOR	ETF	33.65	33.78	33.65	33.68	8616.0
2012-11-06	ARB	ETF	37.3	37.56	36.69	37.29	116336.0
2012-11-06	ARGT	ETF	16.5	16.58	16.5	16.58	150.0
2012-11-06	ASEA	ETF	16.7	16.76	16.7	16.74	3700.0
2012-11-06	AWAY	ETF	22.26	22.51	22.095	22.25	1223389.0
2012-11-06	BAB	ETF	30.16	30.17	30.03	30.0332	94976.0
2012-11-06	BAL	ETF	46.27	46.27	46.06	46.06	2575.0
2012-11-06	BALT	ETF	3.41	3.44	3.36	3.41	79198.0
2012-11-06	BBH	ETF	51.68	52.16	51.67	51.91	68400.0
2012-11-06	BIB	ETF	13.9475	13.9475	13.5858	13.6575	47800.0
2012-11-06	BICK	ETF	24.04	24.2611	24.04	24.18	4183.0
2012-11-06	BIL	ETF	91.62	91.64	91.62	91.62	106500.0
2012-11-06	BIS	ETF	2872.8	2875.6	2836.004	2864.004	56.5
2012-11-06	BIV	ETF	90.12	90.17	89.84	89.86	225900.0
2012-11-06	BJK	ETF	34.85	35.14	34.85	35.06	4000.0
2012-11-06	BKF	ETF	39.1	39.5	39.06	39.37	107440.0
2012-11-06	BKLN	ETF	24.86	24.87	24.84	24.87	1002800.0
2012-11-06	BLV	ETF	96.3	96.42	95.86	95.94	41000.0
2012-11-06	BMVP	ETF	15.95	16.0809	15.95	16.05	3938.0
2012-11-06	BND	ETF	84.79	84.86	84.61	84.65	1074400.0
2012-11-06	BNO	ETF	39.66	40.42	39.515	40.33	60000.0
2012-11-06	BOIL	ETF	980000.0	1015400.0	976800.0	1005600.0	5.6
2012-11-06	BOND	ETF	109.39	109.4144	109.18	109.18	546209.0
2012-11-06	BRF	ETF	41.25	41.82	41.25	41.7	90090.0

> showing 50 of 941 rows — these rows as CSV

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