PREVIEW / etf_daily / 2012-10-26

all etf daily files

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

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-26	SPY	ETF	141.3	141.84	140.39	141.35	146023500.0
2012-10-26	QQQ	ETF	65.18	65.623	64.65	65.35	54222197.0
2012-10-26	IWM	ETF	81.44	81.9	80.46	81.14	41402800.0
2012-10-26	DIA	ETF	130.68	131.23	130.09	130.79	4182600.0
2012-10-26	GLD	ETF	166.23	166.6	165.77	165.93	6441300.0
2012-10-26	TLT	ETF	121.44	122.65	121.27	122.64	5889400.0
2012-10-26	AADR	ETF	29.87	29.87	29.82	29.85	3500.0
2012-10-26	AAXJ	ETF	56.43	56.5	56.06	56.39	494900.0
2012-10-26	ACTV	ETF	9.19	9.2	8.94	8.97	984940.0
2012-10-26	ACWI	ETF	46.5	46.69	46.32	46.52	440200.0
2012-10-26	ACWV	ETF	56.39	56.39	56.13	56.2	6200.0
2012-10-26	ACWX	ETF	39.65	39.73	39.486	39.58	185304.0
2012-10-26	ADRE	ETF	39.24	39.34	39.04	39.16	62231.0
2012-10-26	AFK	ETF	31.73	31.73	31.4801	31.64	23038.0
2012-10-26	AGEM	ETF	22.5086	22.5086	22.5086	22.5086	549.0
2012-10-26	AGG	ETF	111.89	112.08	111.88	112.03	908900.0
2012-10-26	AGQ	ETF	202.8	203.68	199.32	200.4	203600.0
2012-10-26	AGZ	ETF	113.5	113.63	113.5	113.63	10752.0
2012-10-26	AIA	ETF	44.76	44.8099	44.5	44.674	6599.0
2012-10-26	AIQ	ETF	6.65	7.0	6.65	7.0	22801.0
2012-10-26	AIVI	ETF	40.23	40.32	40.05	40.24	23300.0
2012-10-26	ALTL	ETF	25.22	25.22	25.22	25.22	100.0
2012-10-26	AMJ	ETF	40.88	40.88	40.47	40.63	405580.0
2012-10-26	AMLP	ETF	83.45	83.65	82.85	83.05	253900.0
2012-10-26	AOA	ETF	36.31	36.38	36.25	36.32	1700.0
2012-10-26	AOK	ETF	30.35	30.41	30.32	30.41	12605.0
2012-10-26	AOM	ETF	31.4399	31.45	31.3217	31.39	6705.0
2012-10-26	AOR	ETF	33.4	33.4547	33.3001	33.43	12408.0
2012-10-26	ARB	ETF	36.38	36.59	35.59	36.53	122513.0
2012-10-26	ARGT	ETF	17.02	17.02	17.02	17.02	250.0
2012-10-26	ASEA	ETF	16.67	16.77	16.67	16.77	1400.0
2012-10-26	AWAY	ETF	25.02	25.2	24.6	24.93	239569.0
2012-10-26	BAB	ETF	29.91	30.05	29.83	30.05	111030.0
2012-10-26	BAL	ETF	47.8456	48.1	47.626	47.7	1912.0
2012-10-26	BALT	ETF	3.45	3.48	3.4	3.48	29100.0
2012-10-26	BBH	ETF	52.49	52.51	51.73	52.06	15400.0
2012-10-26	BCM	ETF	44.56	44.56	44.4299	44.49	5458.0
2012-10-26	BIB	ETF	14.54	14.5625	13.9275	14.174	38192.0
2012-10-26	BICK	ETF	23.63	23.63	23.47	23.495	3342.0
2012-10-26	BIL	ETF	91.64	91.64	91.62	91.62	45600.0
2012-10-26	BIS	ETF	2759.2	2835.2	2759.2	2835.2	16.25
2012-10-26	BIV	ETF	89.87	90.05	89.78	90.05	155000.0
2012-10-26	BJK	ETF	34.81	34.94	34.5	34.69	3000.0
2012-10-26	BKF	ETF	38.43	38.54	38.26	38.32	38329.0
2012-10-26	BKLN	ETF	24.86	24.87	24.84	24.86	448100.0
2012-10-26	BLV	ETF	95.81	96.19	95.72	96.19	24100.0
2012-10-26	BMVP	ETF	15.7267	15.73	15.5634	15.5867	5171.0
2012-10-26	BND	ETF	84.64	84.78	84.61	84.75	583800.0
2012-10-26	BNO	ETF	39.59	39.85	39.485	39.845	97000.0
2012-10-26	BOIL	ETF	1088000.0	1089400.0	1057200.0	1070000.0	5.8

> showing 50 of 931 rows — these rows as CSV

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