PREVIEW / etf_daily / 2013-12-11

all etf daily files

  file:    by_date/etf_daily/2013/2013-12-11.parquet
  size:    43 KB
  rows:    1,049

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
2013-12-11	SPY	ETF	180.82	180.85	178.5	178.72	130591000.0
2013-12-11	QQQ	ETF	86.27	86.401	85.06	85.18	36830565.0
2013-12-11	IWM	ETF	111.53	111.55	109.32	109.6	47181600.0
2013-12-11	DIA	ETF	159.84	159.9	158.23	158.31	7906700.0
2013-12-11	GLD	ETF	121.49	121.81	120.76	120.86	9934900.0
2013-12-11	TLT	ETF	103.55	103.77	103.02	103.1	8190900.0
2013-12-11	AADR	ETF	36.8	36.8	36.8	36.8	100.0
2013-12-11	AAXJ	ETF	60.51	60.51	59.62	59.71	567900.0
2013-12-11	ACWI	ETF	56.53	56.53	55.83	55.88	733200.0
2013-12-11	ACWV	ETF	63.78	63.78	63.06	63.14	55100.0
2013-12-11	ACWX	ETF	45.89	45.89	45.31	45.35	397792.0
2013-12-11	ADRE	ETF	37.57	37.57	36.91	36.91	17503.0
2013-12-11	AFK	ETF	31.08	31.12	30.576	30.576	10704.0
2013-12-11	AGG	ETF	106.93	106.95	106.76	106.76	4010300.0
2013-12-11	AGQ	ETF	69.96	70.04	68.68	69.04	309950.0
2013-12-11	AGZ	ETF	111.2	111.2	111.01	111.01	27011.0
2013-12-11	AIA	ETF	48.37	48.37	47.6172	47.6172	19677.0
2013-12-11	AIQ	ETF	21.33	22.17	20.25	20.44	41380.0
2013-12-11	AIVI	ETF	46.1	46.42	45.92	45.92	22700.0
2013-12-11	ALTL	ETF	31.674	31.674	31.674	31.674	400.0
2013-12-11	AMJ	ETF	44.1	44.1199	43.65	43.72	491417.0
2013-12-11	AMLP	ETF	86.3	86.5	85.5	85.55	444800.0
2013-12-11	ANGL	ETF	26.95	27.1	26.95	27.1	5000.0
2013-12-11	AOA	ETF	43.85	43.85	43.33	43.33	13800.0
2013-12-11	AOK	ETF	31.8399	31.84	31.7046	31.71	39795.0
2013-12-11	AOM	ETF	34.1	34.1	33.84	33.84	73392.0
2013-12-11	AOR	ETF	38.09	38.112	37.7299	37.76	17699.0
2013-12-11	ARGT	ETF	19.9	19.9	19.71	19.78	3200.0
2013-12-11	ASEA	ETF	16.1	16.1	15.9	15.9	7900.0
2013-12-11	ASHR	ETF	25.42	25.42	25.14	25.23	404500.0
2013-12-11	ATMP	ETF	25.92	25.92	25.67	25.71	58900.0
2013-12-11	AVIV	ETF	24.44	24.44	24.08	24.12	84744.0
2013-12-11	AWAY	ETF	38.56	39.63	37.76	37.93	1697810.0
2013-12-11	BAB	ETF	27.62	27.678	27.56	27.57	130838.0
2013-12-11	BAL	ETF	50.76	52.07	50.72	51.54	4908.0
2013-12-11	BALT	ETF	5.28	5.52	5.15	5.52	1098660.0
2013-12-11	BBH	ETF	86.26	86.26	84.1	84.3	115300.0
2013-12-11	BCM	ETF	39.79	39.82	39.79	39.818	148980.0
2013-12-11	BFOR	ETF	7.2525	7.2525	7.1275	7.14	174400.0
2013-12-11	BIB	ETF	35.6125	35.6125	33.4425	33.725	286152.0
2013-12-11	BICK	ETF	24.76	24.76	24.76	24.76	916.0
2013-12-11	BIL	ETF	91.56	91.58	91.56	91.58	95000.0
2013-12-11	BIS	ETF	897.6	938.76	897.6	928.0	1276.0
2013-12-11	BIV	ETF	83.3	83.4	83.16	83.16	310800.0
2013-12-11	BIZD	ETF	21.08	21.08	21.01	21.04	5800.0
2013-12-11	BJK	ETF	51.66	51.66	50.86	51.17	47900.0
2013-12-11	BKF	ETF	38.06	38.06	37.38	37.5	99314.0
2013-12-11	BKLN	ETF	24.85	24.87	24.85	24.87	2864300.0
2013-12-11	BLV	ETF	82.44	82.48	82.19	82.29	107500.0
2013-12-11	BMVP	ETF	22.33	22.33	21.98	21.98	2615.0

> showing 50 of 1,049 rows — these rows as CSV

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