PREVIEW / etf_daily / 2013-10-21

all etf daily files

  file:    by_date/etf_daily/2013/2013-10-21.parquet
  size:    42 KB
  rows:    1,041

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-10-21	SPY	ETF	174.45	174.75	174.01	174.4	104104000.0
2013-10-21	QQQ	ETF	82.31	82.54	82.07	82.33	31176938.0
2013-10-21	IWM	ETF	110.85	111.08	110.27	110.47	29198900.0
2013-10-21	DIA	ETF	153.69	153.76	153.27	153.53	3588300.0
2013-10-21	GLD	ETF	127.13	127.34	126.79	126.98	3395200.0
2013-10-21	TLT	ETF	106.91	106.92	106.46	106.7	6161600.0
2013-10-21	AADR	ETF	36.85	36.89	36.82	36.82	600.0
2013-10-21	AAXJ	ETF	61.48	61.48	61.05	61.15	1641000.0
2013-10-21	ACTV	ETF	14.38	14.405	14.38	14.38	1142894.0
2013-10-21	ACWI	ETF	56.07	56.13	55.97	56.07	2871200.0
2013-10-21	ACWV	ETF	63.51	63.64	63.42	63.64	77100.0
2013-10-21	ACWX	ETF	46.549	46.66	46.52	46.66	274756.0
2013-10-21	ADRE	ETF	39.0	39.0	38.75	38.98	14853.0
2013-10-21	AFK	ETF	31.38	31.68	31.31	31.58	23564.0
2013-10-21	AGG	ETF	107.71	107.73	107.58	107.66	734700.0
2013-10-21	AGQ	ETF	84.16	84.24	83.24	83.48	260550.0
2013-10-21	AGZ	ETF	111.5	111.5	111.16	111.2141	7759.0
2013-10-21	AIA	ETF	48.66	48.66	48.38	48.43	40707.0
2013-10-21	AIQ	ETF	31.37	31.57	30.83	31.22	25826.0
2013-10-21	AIVI	ETF	47.27	47.37	47.17	47.32	33900.0
2013-10-21	ALTL	ETF	31.11	31.12	31.09	31.11	1300.0
2013-10-21	AMJ	ETF	45.06	45.7898	45.0	45.73	421408.0
2013-10-21	AMLP	ETF	88.55	89.15	88.4	89.05	920760.0
2013-10-21	ANGL	ETF	26.36	26.89	26.36	26.69	1700.0
2013-10-21	AOA	ETF	43.26	43.27	43.19	43.25	17200.0
2013-10-21	AOK	ETF	31.791	31.804	31.73	31.73	79656.0
2013-10-21	AOM	ETF	33.91	33.92	33.841	33.89	26512.0
2013-10-21	AOR	ETF	37.7	37.72	37.641	37.67	26076.0
2013-10-21	ARGT	ETF	21.48	21.51	21.2	21.5	18500.0
2013-10-21	ASEA	ETF	17.2	17.2	17.12	17.12	17300.0
2013-10-21	ATMP	ETF	26.47	26.74	26.47	26.74	59800.0
2013-10-21	AVIV	ETF	24.04	24.77	23.78	24.7	463176.0
2013-10-21	AWAY	ETF	28.23	28.73	27.88	28.561	787430.0
2013-10-21	BAB	ETF	27.58	27.68	27.5	27.6	209253.0
2013-10-21	BAL	ETF	53.01	53.14	52.95	53.04	4398.0
2013-10-21	BALT	ETF	5.33	5.36	5.11	5.16	658516.0
2013-10-21	BBH	ETF	81.45	81.45	79.62	79.98	134900.0
2013-10-21	BCM	ETF	40.514	40.514	40.514	40.514	298.0
2013-10-21	BFOR	ETF	7.105	7.115	7.065	7.085	683600.0
2013-10-21	BIB	ETF	31.675	31.895	30.2875	30.665	433616.0
2013-10-21	BICK	ETF	25.23	25.23	25.171	25.171	885.0
2013-10-21	BIL	ETF	91.58	91.58	91.56	91.58	215550.0
2013-10-21	BIS	ETF	1028.0	1059.6	1024.64	1055.6	74.0
2013-10-21	BIV	ETF	84.01	84.09	83.85	84.03	369400.0
2013-10-21	BIZD	ETF	20.56	20.6	20.52	20.57	7600.0
2013-10-21	BJK	ETF	51.73	51.79	51.46	51.58	119900.0
2013-10-21	BKF	ETF	39.42	39.42	39.09	39.25	107480.0
2013-10-21	BKLN	ETF	24.72	24.73	24.71	24.72	3233600.0
2013-10-21	BLV	ETF	83.94	84.09	83.79	83.87	267000.0
2013-10-21	BMVP	ETF	21.3667	21.42	21.317	21.317	2887.0

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

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