PREVIEW / etf_daily / 2013-09-17

all etf daily files

  file:    by_date/etf_daily/2013/2013-09-17.parquet
  size:    41 KB
  rows:    1,018

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-09-17	SPY	ETF	170.46	171.11	170.46	171.07	82523300.0
2013-09-17	QQQ	ETF	77.99	78.47	77.98	78.37	27182212.0
2013-09-17	IWM	ETF	105.06	106.08	105.04	106.08	28901400.0
2013-09-17	DIA	ETF	155.02	155.51	154.98	155.29	4517600.0
2013-09-17	GLD	ETF	126.81	126.99	126.11	126.5	8135500.0
2013-09-17	TLT	ETF	103.37	103.74	102.97	103.71	8795300.0
2013-09-17	AADR	ETF	35.38	35.42	35.29	35.39	5900.0
2013-09-17	AAXJ	ETF	59.14	59.31	58.98	59.09	325200.0
2013-09-17	ACTV	ETF	10.36	10.78	10.3327	10.78	637625.0
2013-09-17	ACWI	ETF	54.01	54.1	53.95	54.07	1105300.0
2013-09-17	ACWV	ETF	61.99	62.08	61.86	62.0	66200.0
2013-09-17	ACWX	ETF	44.64	44.84	44.64	44.82	231032.0
2013-09-17	ADRE	ETF	37.53	37.58	37.42	37.49	8205.0
2013-09-17	AFK	ETF	29.47	29.82	29.47	29.71	18459.0
2013-09-17	AGEM	ETF	22.57	22.68	22.5301	22.64	23280.0
2013-09-17	AGG	ETF	106.0	106.06	105.9	106.01	865400.0
2013-09-17	AGQ	ETF	82.04	82.36	81.24	81.48	338950.0
2013-09-17	AGZ	ETF	110.12	110.232	110.12	110.16	9800.0
2013-09-17	AIA	ETF	47.22	47.22	47.03	47.1	26501.0
2013-09-17	AIQ	ETF	24.86	25.4	24.81	24.87	59155.0
2013-09-17	AIVI	ETF	45.12	45.28	45.12	45.28	51700.0
2013-09-17	ALTL	ETF	30.465	30.51	30.39	30.43	71900.0
2013-09-17	AMJ	ETF	43.55	43.93	42.9	42.99	1514042.0
2013-09-17	AMLP	ETF	85.75	85.8	85.1	85.2	1367420.0
2013-09-17	ANGL	ETF	26.43	26.44	26.39	26.44	1500.0
2013-09-17	AOA	ETF	41.99	42.11	41.99	42.09	14300.0
2013-09-17	AOK	ETF	31.21	31.28	31.21	31.28	17842.0
2013-09-17	AOM	ETF	33.2599	33.29	33.2101	33.29	33004.0
2013-09-17	AOR	ETF	36.76	36.87	36.76	36.85	19450.0
2013-09-17	ARB	ETF	47.51	47.51	47.41	47.5	92058.0
2013-09-17	ARGT	ETF	19.44	19.44	19.33	19.33	5600.0
2013-09-17	ASEA	ETF	16.78	16.8	16.71	16.74	14000.0
2013-09-17	ATMP	ETF	25.21	25.3	25.11	25.18	116600.0
2013-09-17	AVIV	ETF	22.78	22.91	22.41	22.6	131653.0
2013-09-17	AWAY	ETF	31.97	32.16	31.6	31.76	864641.0
2013-09-17	BAB	ETF	26.92	27.034	26.91	27.01	113169.0
2013-09-17	BAL	ETF	54.19	54.28	53.924	53.924	11559.0
2013-09-17	BALT	ETF	5.05	5.21	4.98	5.17	1132078.0
2013-09-17	BBH	ETF	82.91	83.18	82.42	83.09	44500.0
2013-09-17	BFOR	ETF	6.7525	6.7975	6.7525	6.795	173600.0
2013-09-17	BIB	ETF	32.43	32.6125	32.0525	32.435	84132.0
2013-09-17	BICK	ETF	23.78	23.78	23.75	23.75	300.0
2013-09-17	BIL	ETF	91.58	91.6	91.58	91.58	158050.0
2013-09-17	BIS	ETF	1028.0	1040.0	1026.4	1026.4	98.5
2013-09-17	BIV	ETF	82.24	82.24	82.05	82.23	222800.0
2013-09-17	BIZD	ETF	20.55	20.59	20.39	20.58	17500.0
2013-09-17	BJK	ETF	46.98	47.04	46.92	47.01	8500.0
2013-09-17	BKF	ETF	37.6	37.71	37.6	37.69	91072.0
2013-09-17	BKLN	ETF	24.79	24.8	24.77	24.79	1692300.0
2013-09-17	BLV	ETF	81.07	81.38	80.95	81.36	136500.0

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

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