PREVIEW / etf_daily / 2013-06-13

all etf daily files

  file:    by_date/etf_daily/2013/2013-06-13.parquet
  size:    41 KB
  rows:    1,009

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-06-13	SPY	ETF	161.66	164.5	161.3	164.21	163587800.0
2013-06-13	QQQ	ETF	71.76	72.92	71.55	72.76	28230371.0
2013-06-13	IWM	ETF	96.73	98.7	96.37	98.47	47768600.0
2013-06-13	DIA	ETF	149.74	151.99	149.48	151.76	6208200.0
2013-06-13	GLD	ETF	133.31	134.2	132.82	133.74	7161800.0
2013-06-13	TLT	ETF	113.07	114.17	112.89	114.09	12506300.0
2013-06-13	AADR	ETF	33.2	33.54	33.2	33.53	1800.0
2013-06-13	AAXJ	ETF	55.4	56.56	55.34	56.49	904400.0
2013-06-13	ACTV	ETF	7.44	7.67	7.16	7.46	295417.0
2013-06-13	ACWI	ETF	51.11	52.03	51.11	51.94	866300.0
2013-06-13	ACWV	ETF	60.37	61.02	60.24	61.02	69300.0
2013-06-13	ACWX	ETF	42.24	42.8799	42.205	42.83	193302.0
2013-06-13	ADRE	ETF	35.28	35.86	35.21	35.82	153347.0
2013-06-13	AFK	ETF	28.64	28.94	28.3	28.94	137478.0
2013-06-13	AGEM	ETF	20.63	20.87	20.63	20.86	9014.0
2013-06-13	AGG	ETF	108.24	108.75	108.24	108.75	999000.0
2013-06-13	AGQ	ETF	84.4	86.28	83.32	84.96	466075.0
2013-06-13	AGZ	ETF	111.75	112.09	111.75	111.908	17629.0
2013-06-13	AIA	ETF	43.04	43.7401	43.04	43.72	28724.0
2013-06-13	AIQ	ETF	16.11	16.2	16.02	16.1	13752.0
2013-06-13	AIVI	ETF	42.44	43.05	42.41	43.05	41500.0
2013-06-13	ALTL	ETF	28.09	28.09	28.09	28.09	239.0
2013-06-13	AMJ	ETF	45.99	46.0	45.41	45.73	755845.0
2013-06-13	AMLP	ETF	86.8	87.4	86.55	87.4	625160.0
2013-06-13	ANGL	ETF	27.03	27.04	26.81	27.04	3600.0
2013-06-13	AOA	ETF	40.06	40.65	40.03	40.64	37400.0
2013-06-13	AOK	ETF	30.9508	31.19	30.9508	31.19	14774.0
2013-06-13	AOM	ETF	32.59	32.9399	32.59	32.89	22673.0
2013-06-13	AOR	ETF	35.73	36.15	35.7024	36.08	34180.0
2013-06-13	ARB	ETF	46.88	46.98	46.82	46.94	120871.0
2013-06-13	ARGT	ETF	17.04	17.04	16.95	16.95	6800.0
2013-06-13	ASEA	ETF	16.69	17.03	16.62	17.03	25400.0
2013-06-13	ATMP	ETF	25.28	25.46	25.15	25.44	22200.0
2013-06-13	AVIV	ETF	25.97	26.52	25.81	26.44	162583.0
2013-06-13	AWAY	ETF	29.43	30.51	29.22	30.27	706310.0
2013-06-13	BAB	ETF	28.82	28.98	28.56	28.95	695707.0
2013-06-13	BAL	ETF	56.32	57.29	56.18	57.03	76857.0
2013-06-13	BALT	ETF	3.46	3.66	3.46	3.65	180892.0
2013-06-13	BBH	ETF	68.5	69.69	67.69	69.46	62200.0
2013-06-13	BCM	ETF	40.43	40.519	40.43	40.519	4300.0
2013-06-13	BFOR	ETF	6.19	6.295	6.1725	6.2875	583600.0
2013-06-13	BIB	ETF	22.7825	23.72	22.4028	23.5375	112604.0
2013-06-13	BICK	ETF	21.93	22.0883	21.87	22.0883	3832.0
2013-06-13	BIL	ETF	91.6	91.62	91.6	91.62	2133200.0
2013-06-13	BIS	ETF	1544.0	1558.08	1482.8	1495.896	380.5
2013-06-13	BIV	ETF	85.27	85.64	85.17	85.52	345200.0
2013-06-13	BIZD	ETF	19.49	19.82	19.49	19.82	6700.0
2013-06-13	BJK	ETF	41.49	41.99	41.47	41.97	261000.0
2013-06-13	BKF	ETF	35.38	36.149	35.33	36.05	178944.0
2013-06-13	BKLN	ETF	24.94	24.96	24.9	24.96	4795600.0

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

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