PREVIEW / etf_daily / 2013-11-04

all etf daily files

  file:    by_date/etf_daily/2013/2013-11-04.parquet
  size:    42 KB
  rows:    1,048

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-11-04	SPY	ETF	176.69	176.9	175.98	176.83	85677000.0
2013-11-04	QQQ	ETF	83.05	83.07	82.64	82.93	16843634.0
2013-11-04	IWM	ETF	109.24	110.15	108.83	109.97	31960000.0
2013-11-04	DIA	ETF	156.26	156.36	155.53	156.06	4042500.0
2013-11-04	GLD	ETF	127.18	127.52	126.74	126.81	3819300.0
2013-11-04	TLT	ETF	106.47	106.67	106.22	106.29	4733200.0
2013-11-04	AADR	ETF	36.38	36.38	36.38	36.38	100.0
2013-11-04	AAXJ	ETF	60.55	60.55	60.3	60.48	260300.0
2013-11-04	ACTV	ETF	14.47	14.48	14.45	14.47	651471.0
2013-11-04	ACWI	ETF	56.12	56.31	56.06	56.3	767800.0
2013-11-04	ACWV	ETF	64.08	64.31	64.04	64.31	30200.0
2013-11-04	ACWX	ETF	46.15	46.355	46.15	46.355	221304.0
2013-11-04	ADRE	ETF	38.54	38.75	38.48	38.55	9314.0
2013-11-04	AFK	ETF	31.62	31.62	31.4	31.528	20212.0
2013-11-04	AGG	ETF	107.55	107.6	107.48	107.56	421700.0
2013-11-04	AGQ	ETF	80.2	80.56	78.8	79.08	191125.0
2013-11-04	AGZ	ETF	111.74	111.74	111.5701	111.71	5168.0
2013-11-04	AIA	ETF	48.04	48.35	48.04	48.31	12834.0
2013-11-04	AIQ	ETF	25.53	27.0	25.5224	25.73	53338.0
2013-11-04	AIVI	ETF	47.06	47.27	47.04	47.27	32700.0
2013-11-04	ALTL	ETF	31.57	31.57	31.57	31.57	160.0
2013-11-04	AMJ	ETF	45.88	46.11	45.61	46.05	217220.0
2013-11-04	AMLP	ETF	89.55	89.55	88.6	89.4	431760.0
2013-11-04	ANGL	ETF	27.04	27.04	26.5	26.79	2100.0
2013-11-04	AOA	ETF	43.4	43.5	43.35	43.5	31500.0
2013-11-04	AOK	ETF	31.83	31.84	31.77	31.84	16396.0
2013-11-04	AOM	ETF	34.0	34.0	33.891	33.98	47631.0
2013-11-04	AOR	ETF	37.82	37.87	37.7614	37.87	10092.0
2013-11-04	ARGT	ETF	20.08	20.37	20.08	20.37	9300.0
2013-11-04	ASEA	ETF	16.94	16.99	16.86	16.95	12500.0
2013-11-04	ATMP	ETF	26.68	26.82	26.68	26.82	10300.0
2013-11-04	AVIV	ETF	25.35	26.0	25.3	26.0	151084.0
2013-11-04	AWAY	ETF	29.54	29.62	29.1901	29.53	649803.0
2013-11-04	BAB	ETF	27.49	27.86	27.49	27.81	277512.0
2013-11-04	BAL	ETF	48.78	48.9	48.3	48.32	12608.0
2013-11-04	BALT	ETF	5.0	5.12	4.79	4.93	576777.0
2013-11-04	BBH	ETF	83.0	83.0	81.95	82.04	64800.0
2013-11-04	BCM	ETF	39.4	39.4	39.34	39.38	3585.0
2013-11-04	BFOR	ETF	7.0725	7.1225	7.0625	7.12	344800.0
2013-11-04	BIB	ETF	31.7025	31.7475	31.1175	31.265	125596.0
2013-11-04	BICK	ETF	24.87	24.87	24.8408	24.87	420.0
2013-11-04	BIL	ETF	91.56	91.58	91.56	91.56	138100.0
2013-11-04	BIS	ETF	1028.8	1035.96	1010.8	1035.16	75.0
2013-11-04	BIV	ETF	84.03	84.07	83.93	83.98	91900.0
2013-11-04	BIZD	ETF	20.59	20.61	20.56	20.61	1400.0
2013-11-04	BJK	ETF	50.02	50.02	49.83	49.99	86400.0
2013-11-04	BKF	ETF	38.87	38.889	38.77	38.87	54213.0
2013-11-04	BKLN	ETF	24.85	24.87	24.84	24.86	1429500.0
2013-11-04	BLV	ETF	83.71	83.78	83.4	83.45	51000.0
2013-11-04	BMVP	ETF	21.59	21.6233	21.5867	21.6198	1327.0

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

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