PREVIEW / etf_daily / 2012-12-27

all etf daily files

  file:    by_date/etf_daily/2012/2012-12-27.parquet
  size:    40 KB
  rows:    964

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-12-27	SPY	ETF	141.79	142.08	139.92	141.56	167920600.0
2012-12-27	QQQ	ETF	64.56	64.64	63.6	64.4	52943138.0
2012-12-27	IWM	ETF	83.26	83.43	82.05	83.12	35567700.0
2012-12-27	DIA	ETF	130.94	131.14	129.34	130.6	8308600.0
2012-12-27	GLD	ETF	160.23	161.31	160.05	161.16	8937700.0
2012-12-27	TLT	ETF	121.88	123.29	121.83	122.61	4262700.0
2012-12-27	AADR	ETF	30.84	31.11	30.74	30.83	7900.0
2012-12-27	AAXJ	ETF	59.41	59.41	58.9	59.3	206700.0
2012-12-27	ACTV	ETF	4.77	4.78	4.66	4.7	510161.0
2012-12-27	ACWI	ETF	47.9	47.9	47.33	47.72	1085700.0
2012-12-27	ACWV	ETF	55.63	55.64	55.2	55.48	26700.0
2012-12-27	ACWX	ETF	41.83	41.85	41.39	41.64	504223.0
2012-12-27	ADRE	ETF	39.9	39.9	39.3842	39.73	62449.0
2012-12-27	AFK	ETF	31.0799	31.0799	30.59	30.7614	10877.0
2012-12-27	AGEM	ETF	22.9	23.0	22.76	22.91	41901.0
2012-12-27	AGG	ETF	111.05	111.25	110.99	111.11	722100.0
2012-12-27	AGQ	ETF	172.4	178.12	171.32	175.0	380875.0
2012-12-27	AGZ	ETF	113.32	113.48	113.268	113.44	15044.0
2012-12-27	AIA	ETF	47.31	47.3199	46.96	47.1401	20489.0
2012-12-27	AIQ	ETF	6.45	7.0	6.0551	6.44	44632.0
2012-12-27	AIVI	ETF	41.84	41.84	41.42	41.63	161100.0
2012-12-27	AMJ	ETF	38.14	38.64	37.62	37.8	1252771.0
2012-12-27	AMLP	ETF	79.3	79.9	78.7	78.85	400020.0
2012-12-27	ANGL	ETF	26.94	26.94	26.75	26.75	5300.0
2012-12-27	AOA	ETF	36.98	37.01	36.67	36.86	7200.0
2012-12-27	AOK	ETF	30.52	30.5699	30.46	30.5301	14471.0
2012-12-27	AOM	ETF	31.61	31.6199	31.4901	31.6199	7780.0
2012-12-27	AOR	ETF	33.77	33.822	33.59	33.7801	53301.0
2012-12-27	ARB	ETF	46.6	46.65	46.49	46.6	419527.0
2012-12-27	ARGT	ETF	17.14	17.34	17.14	17.34	3250.0
2012-12-27	ASEA	ETF	16.82	16.84	16.55	16.7	119600.0
2012-12-27	AWAY	ETF	21.51	21.51	20.97	21.25	286778.0
2012-12-27	BAB	ETF	30.25	30.52	30.25	30.371	188103.0
2012-12-27	BAL	ETF	50.26	50.33	49.2	49.6	11410.0
2012-12-27	BALT	ETF	3.01	3.02	2.89	2.92	62220.0
2012-12-27	BBH	ETF	53.4	53.71	52.71	53.3	34500.0
2012-12-27	BCM	ETF	43.81	43.81	43.8099	43.8099	375.0
2012-12-27	BIB	ETF	14.4975	14.4975	13.9075	14.3625	77184.0
2012-12-27	BICK	ETF	24.81	24.94	24.7835	24.911	8075.0
2012-12-27	BIL	ETF	91.64	91.64	91.62	91.62	62100.0
2012-12-27	BIS	ETF	2722.4	2746.744	2671.2	2680.0	481.5
2012-12-27	BIV	ETF	88.23	88.5	88.2	88.3	544400.0
2012-12-27	BJK	ETF	35.4	35.4	34.95	35.27	4600.0
2012-12-27	BKF	ETF	40.16	40.29	39.91	40.25	65085.0
2012-12-27	BKLN	ETF	24.94	24.96	24.88	24.95	573100.0
2012-12-27	BLV	ETF	93.79	94.5	93.62	94.25	36100.0
2012-12-27	BMVP	ETF	16.17	16.17	15.96	16.12	7181.0
2012-12-27	BND	ETF	84.0	84.17	83.92	84.09	965200.0
2012-12-27	BNO	ETF	40.935	41.025	40.685	40.99	59400.0
2012-12-27	BOIL	ETF	793200.0	819600.0	787200.0	805800.0	9.2

> showing 50 of 964 rows — these rows as CSV

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