PREVIEW / etf_daily / 2013-09-16

all etf daily files

  file:    by_date/etf_daily/2013/2013-09-16.parquet
  size:    42 KB
  rows:    1,031

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-16	SPY	ETF	171.16	171.24	170.04	170.31	106299200.0
2013-09-16	QQQ	ETF	78.69	78.72	77.67	77.85	25909886.0
2013-09-16	IWM	ETF	106.05	106.08	104.85	105.04	28755900.0
2013-09-16	DIA	ETF	155.33	155.49	154.66	154.94	6569000.0
2013-09-16	GLD	ETF	127.48	128.02	126.33	126.45	9829100.0
2013-09-16	TLT	ETF	104.33	104.41	102.85	102.86	8231600.0
2013-09-16	AADR	ETF	35.38	35.49	35.32	35.34	21400.0
2013-09-16	AAXJ	ETF	59.38	59.51	59.17	59.25	1306600.0
2013-09-16	ACTV	ETF	10.45	10.539	10.22	10.4	365106.0
2013-09-16	ACWI	ETF	54.19	54.3	53.9	53.94	1481700.0
2013-09-16	ACWV	ETF	62.25	62.28	61.8	61.8	53000.0
2013-09-16	ACWX	ETF	44.87	45.016	44.75	44.77	302437.0
2013-09-16	ADRE	ETF	37.69	37.73	37.328	37.328	15774.0
2013-09-16	AFK	ETF	29.99	29.99	29.66	29.7	30131.0
2013-09-16	AGEM	ETF	22.7	22.78	22.52	22.5501	40027.0
2013-09-16	AGG	ETF	106.28	106.28	105.86	105.91	866200.0
2013-09-16	AGQ	ETF	84.04	84.6	81.16	81.28	500675.0
2013-09-16	AGZ	ETF	110.275	110.376	110.21	110.21	6806.0
2013-09-16	AIA	ETF	47.33	47.5	47.2	47.22	81632.0
2013-09-16	AIQ	ETF	24.21	24.749	24.17	24.53	56822.0
2013-09-16	AIVI	ETF	45.32	45.47	45.06	45.1	18300.0
2013-09-16	ALTL	ETF	30.34	30.5	30.26	30.27	54500.0
2013-09-16	AMJ	ETF	43.83	44.25	43.44	43.49	1573983.0
2013-09-16	AMLP	ETF	86.4	86.65	85.6	85.75	846160.0
2013-09-16	ANGL	ETF	26.41	26.44	26.41	26.43	2400.0
2013-09-16	AOA	ETF	42.16	42.17	41.91	41.97	12700.0
2013-09-16	AOK	ETF	31.34	31.34	31.12	31.12	21964.0
2013-09-16	AOM	ETF	33.4	33.4	33.15	33.16	114664.0
2013-09-16	AOR	ETF	36.95	36.95	36.73	36.78	35925.0
2013-09-16	ARB	ETF	47.47	47.6	47.4	47.42	106309.0
2013-09-16	ARGT	ETF	19.37	19.4	19.24	19.35	1600.0
2013-09-16	ASEA	ETF	16.75	16.87	16.75	16.79	51600.0
2013-09-16	ATMP	ETF	25.85	25.85	25.34	25.34	20600.0
2013-09-16	AVIV	ETF	22.79	22.79	22.41	22.7	155126.0
2013-09-16	AWAY	ETF	31.85	32.58	31.75	32.18	1575782.0
2013-09-16	BAB	ETF	26.99	27.08	26.83	26.84	95573.0
2013-09-16	BAL	ETF	53.74	53.87	53.5464	53.71	11368.0
2013-09-16	BALT	ETF	5.15	5.24	5.0	5.05	618549.0
2013-09-16	BBH	ETF	83.61	83.61	82.47	82.89	79500.0
2013-09-16	BFOR	ETF	6.7975	6.7975	6.74	6.7425	262400.0
2013-09-16	BIB	ETF	32.815	32.9875	32.04	32.215	223076.0
2013-09-16	BIL	ETF	91.58	91.6	91.58	91.58	185150.0
2013-09-16	BIS	ETF	1032.8	1045.52	1012.4	1036.0	230.0
2013-09-16	BIV	ETF	82.47	82.56	82.03	82.03	423500.0
2013-09-16	BIZD	ETF	20.39	20.9	20.39	20.49	10400.0
2013-09-16	BJK	ETF	47.29	47.45	46.87	46.9	19400.0
2013-09-16	BKF	ETF	37.73	37.9	37.51	37.55	40555.0
2013-09-16	BKLN	ETF	24.76	24.78	24.75	24.78	5508300.0
2013-09-16	BLV	ETF	81.81	81.82	80.8	80.84	231000.0
2013-09-16	BMVP	ETF	20.36	20.44	20.25	20.25	10925.0

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

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