PREVIEW / etf_daily / 2012-11-14

all etf daily files

  file:    by_date/etf_daily/2012/2012-11-14.parquet
  size:    39 KB
  rows:    959

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-14	SPY	ETF	138.21	138.43	135.62	135.93	191505000.0
2012-11-14	QQQ	ETF	63.27	63.36	62.14	62.24	82655213.0
2012-11-14	IWM	ETF	78.88	79.1	77.06	77.24	54653100.0
2012-11-14	DIA	ETF	127.82	128.04	125.46	125.76	9479400.0
2012-11-14	GLD	ETF	167.46	168.04	166.78	167.14	8510500.0
2012-11-14	TLT	ETF	125.72	126.79	125.6	126.73	4694600.0
2012-11-14	AADR	ETF	29.35	29.35	29.35	29.35	2000.0
2012-11-14	AAXJ	ETF	56.23	56.38	55.5	55.63	392300.0
2012-11-14	ACTV	ETF	5.34	5.34	5.09	5.12	1549299.0
2012-11-14	ACWI	ETF	45.74	45.74	44.88	44.97	535200.0
2012-11-14	ACWV	ETF	55.22	55.5	54.9	54.9	13500.0
2012-11-14	ACWX	ETF	39.02	39.02	38.38	38.45	599926.0
2012-11-14	ADRE	ETF	37.98	37.98	37.36	37.4	79454.0
2012-11-14	AFK	ETF	31.18	31.19	30.69	30.69	32103.0
2012-11-14	AGEM	ETF	21.8	21.8	21.47	21.47	1865.0
2012-11-14	AGG	ETF	112.05	112.28	112.04	112.28	1242700.0
2012-11-14	AGQ	ETF	206.28	210.0	203.2	206.64	345925.0
2012-11-14	AGZ	ETF	113.89	113.92	113.81	113.82	13129.0
2012-11-14	AIA	ETF	44.48	44.48	43.74	43.84	16581.0
2012-11-14	AIQ	ETF	7.05	7.06	6.25	6.35	47930.0
2012-11-14	AIVI	ETF	38.98	38.98	38.41	38.44	25000.0
2012-11-14	AMJ	ETF	38.71	39.24	38.08	38.14	867940.0
2012-11-14	AMLP	ETF	79.4	79.9	78.5	78.65	570820.0
2012-11-14	ANGL	ETF	26.58	26.58	26.53	26.53	900.0
2012-11-14	AOA	ETF	35.82	35.82	35.41	35.41	7300.0
2012-11-14	AOK	ETF	30.18	30.22	30.121	30.1261	17608.0
2012-11-14	AOM	ETF	31.23	31.23	31.0199	31.0199	9970.0
2012-11-14	AOR	ETF	33.11	33.11	32.79	32.79	9481.0
2012-11-14	ARB	ETF	35.99	36.365	35.18	35.4	98910.0
2012-11-14	ARGT	ETF	15.6	15.6	15.5	15.5	650.0
2012-11-14	ASEA	ETF	16.57	16.67	16.29	16.37	14900.0
2012-11-14	AWAY	ETF	20.73	20.77	20.0	20.23	308321.0
2012-11-14	BAB	ETF	30.55	30.6899	30.46	30.61	193612.0
2012-11-14	BAL	ETF	46.34	46.5844	46.2268	46.41	2685.0
2012-11-14	BALT	ETF	3.28	3.28	2.99	3.12	211268.0
2012-11-14	BBH	ETF	52.19	52.26	51.03	51.14	38000.0
2012-11-14	BIB	ETF	13.6525	13.6525	12.8525	12.8925	75384.0
2012-11-14	BICK	ETF	23.39	23.39	22.97	22.97	6635.0
2012-11-14	BIL	ETF	91.62	91.64	91.62	91.64	312900.0
2012-11-14	BIS	ETF	2896.0	3001.2	2896.0	3001.2	188.0
2012-11-14	BIV	ETF	90.34	90.51	90.28	90.51	284000.0
2012-11-14	BJK	ETF	33.92	33.92	33.27	33.3	2500.0
2012-11-14	BKF	ETF	37.53	37.59	36.85	36.93	121657.0
2012-11-14	BKLN	ETF	24.74	24.75	24.52	24.57	934300.0
2012-11-14	BLV	ETF	97.41	97.77	97.4	97.75	31800.0
2012-11-14	BMVP	ETF	15.52	15.53	15.2386	15.2633	31576.0
2012-11-14	BND	ETF	84.92	85.02	84.87	85.0	810800.0
2012-11-14	BNO	ETF	39.365	39.975	39.365	39.735	38800.0
2012-11-14	BOIL	ETF	1079200.0	1117200.0	1063400.0	1076400.0	8.2
2012-11-14	BOND	ETF	109.9	110.06	109.8712	110.05	599754.0

> showing 50 of 959 rows — these rows as CSV

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