PREVIEW / etf_daily / 2013-10-04

all etf daily files

  file:    by_date/etf_daily/2013/2013-10-04.parquet
  size:    41 KB
  rows:    1,015

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-04	SPY	ETF	167.75	169.06	167.53	168.89	96878000.0
2013-10-04	QQQ	ETF	78.72	79.51	78.65	79.4	22854266.0
2013-10-04	IWM	ETF	106.34	107.32	106.15	107.02	25902800.0
2013-10-04	DIA	ETF	149.68	150.56	149.43	150.43	6867800.0
2013-10-04	GLD	ETF	127.05	127.15	126.0	126.53	6923700.0
2013-10-04	TLT	ETF	105.67	105.78	105.35	105.71	5545300.0
2013-10-04	AADR	ETF	35.26	35.66	35.26	35.66	700.0
2013-10-04	AAXJ	ETF	59.67	60.12	59.53	60.04	200400.0
2013-10-04	ACTV	ETF	14.38	14.38	14.35	14.36	1573022.0
2013-10-04	ACWI	ETF	53.96	54.3	53.88	54.25	566700.0
2013-10-04	ACWV	ETF	61.84	61.96	61.62	61.87	13400.0
2013-10-04	ACWX	ETF	44.83	45.16	44.83	45.11	117060.0
2013-10-04	ADRE	ETF	37.49	37.75	37.39	37.75	28930.0
2013-10-04	AFK	ETF	30.29	30.31	30.1	30.29	7223.0
2013-10-04	AGEM	ETF	22.47	22.6	22.22	22.55	15135.0
2013-10-04	AGG	ETF	107.06	107.1	106.96	107.06	558700.0
2013-10-04	AGQ	ETF	81.0	81.08	78.88	80.36	460800.0
2013-10-04	AGZ	ETF	111.07	111.1299	110.95	111.12	23415.0
2013-10-04	AIA	ETF	47.505	47.68	47.5	47.64	9437.0
2013-10-04	AIQ	ETF	28.61	30.48	27.78	30.18	65604.0
2013-10-04	AIVI	ETF	45.35	45.64	45.35	45.54	21600.0
2013-10-04	ALTL	ETF	30.228	30.228	30.228	30.228	132.0
2013-10-04	AMJ	ETF	44.53	44.81	44.5	44.58	218623.0
2013-10-04	AMLP	ETF	88.1	88.25	87.8	87.95	353380.0
2013-10-04	ANGL	ETF	26.17	26.21	26.1	26.21	900.0
2013-10-04	AOA	ETF	41.9	42.11	41.86	42.08	19300.0
2013-10-04	AOK	ETF	31.34	31.38	31.339	31.38	8942.0
2013-10-04	AOM	ETF	33.2058	33.31	33.2058	33.31	24231.0
2013-10-04	AOR	ETF	36.83	36.89	36.78	36.88	29451.0
2013-10-04	ARGT	ETF	19.89	19.9	19.78	19.82	8700.0
2013-10-04	ASEA	ETF	16.59	16.84	16.59	16.77	3700.0
2013-10-04	ATMP	ETF	26.17	26.17	26.06	26.06	21200.0
2013-10-04	AVIV	ETF	22.91	23.66	22.91	23.25	153918.0
2013-10-04	AWAY	ETF	29.68	30.77	29.66	29.97	1557990.0
2013-10-04	BAB	ETF	27.45	27.45	27.3001	27.42	174800.0
2013-10-04	BAL	ETF	55.99	55.99	55.68	55.7	6619.0
2013-10-04	BALT	ETF	5.38	5.38	5.15	5.15	935784.0
2013-10-04	BBH	ETF	82.25	83.54	82.25	83.32	33100.0
2013-10-04	BCM	ETF	40.26	40.3399	40.26	40.26	3528.0
2013-10-04	BFOR	ETF	6.815	6.9075	6.8075	6.895	185200.0
2013-10-04	BIB	ETF	32.96	33.8175	32.96	33.6205	189424.0
2013-10-04	BICK	ETF	24.02	24.0201	24.02	24.02	500.0
2013-10-04	BIL	ETF	91.58	91.6	91.58	91.6	283800.0
2013-10-04	BIS	ETF	1004.4	1007.6	983.6	992.0	249.5
2013-10-04	BIV	ETF	83.42	83.42	83.2	83.26	93800.0
2013-10-04	BIZD	ETF	19.95	20.18	19.76	20.14	4600.0
2013-10-04	BJK	ETF	48.09	48.54	48.09	48.45	4300.0
2013-10-04	BKF	ETF	37.91	38.228	37.82	38.18	40325.0
2013-10-04	BKLN	ETF	24.7	24.72	24.68	24.72	1164600.0
2013-10-04	BLV	ETF	82.78	82.78	82.5	82.77	44800.0

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

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