PREVIEW / etf_daily / 2013-11-08

all etf daily files

  file:    by_date/etf_daily/2013/2013-11-08.parquet
  size:    43 KB
  rows:    1,057

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-08	SPY	ETF	174.87	177.31	174.85	177.29	136713000.0
2013-11-08	QQQ	ETF	81.73	82.56	81.51	82.54	31480519.0
2013-11-08	IWM	ETF	107.44	109.46	107.39	109.23	48147500.0
2013-11-08	DIA	ETF	155.66	157.49	155.58	157.49	7594900.0
2013-11-08	GLD	ETF	124.46	124.46	123.62	124.28	8427300.0
2013-11-08	TLT	ETF	103.97	104.11	103.39	103.41	16889900.0
2013-11-08	AADR	ETF	35.85	36.21	35.85	36.08	5900.0
2013-11-08	AAXJ	ETF	58.7	59.01	58.54	59.0	344700.0
2013-11-08	ACTV	ETF	14.48	14.48	14.47	14.48	311096.0
2013-11-08	ACWI	ETF	55.3	55.94	55.3	55.94	790300.0
2013-11-08	ACWV	ETF	63.77	64.03	63.56	64.02	25200.0
2013-11-08	ACWX	ETF	45.39	45.74	45.39	45.67	433991.0
2013-11-08	ADRE	ETF	37.17	37.319	36.916	37.28	6863.0
2013-11-08	AFK	ETF	31.15	31.34	31.1	31.22	12842.0
2013-11-08	AGG	ETF	106.89	106.94	106.76	106.82	796600.0
2013-11-08	AGQ	ETF	77.64	78.0	76.24	77.8	253975.0
2013-11-08	AGZ	ETF	111.29	111.67	111.1201	111.14	13948.0
2013-11-08	AIA	ETF	46.95	47.379	46.88	47.379	14844.0
2013-11-08	AIQ	ETF	23.62	24.84	23.62	24.6	49487.0
2013-11-08	AIVI	ETF	46.5	46.88	46.5	46.88	26300.0
2013-11-08	ALTL	ETF	31.35	31.35	31.33	31.33	744.0
2013-11-08	AMJ	ETF	45.65	45.71	45.03	45.48	1577446.0
2013-11-08	AMLP	ETF	87.65	87.85	86.8	87.5	591560.0
2013-11-08	ANGL	ETF	26.79	26.79	26.71	26.78	2500.0
2013-11-08	AOA	ETF	42.86	43.21	42.86	43.21	28100.0
2013-11-08	AOK	ETF	31.61	31.71	31.6001	31.71	22578.0
2013-11-08	AOM	ETF	33.68	33.84	33.68	33.84	34839.0
2013-11-08	AOR	ETF	37.43	37.69	37.43	37.65	18573.0
2013-11-08	ARGT	ETF	19.52	19.61	19.5	19.58	2200.0
2013-11-08	ASEA	ETF	16.67	16.71	16.63	16.67	8200.0
2013-11-08	ASHR	ETF	24.41	24.48	24.36	24.45	99000.0
2013-11-08	ATMP	ETF	26.38	26.63	26.38	26.63	28200.0
2013-11-08	AVIV	ETF	25.57	25.9	24.85	25.1	314830.0
2013-11-08	AWAY	ETF	33.74	34.09	33.08	33.41	2438496.0
2013-11-08	BAB	ETF	27.5	27.53	27.23	27.28	156510.0
2013-11-08	BAL	ETF	48.49	49.42	48.45	48.8301	12462.0
2013-11-08	BALT	ETF	4.69	4.84	4.62	4.67	687006.0
2013-11-08	BBH	ETF	78.33	80.59	78.33	80.2	76800.0
2013-11-08	BCM	ETF	38.97	39.03	38.97	39.03	2200.0
2013-11-08	BFOR	ETF	6.9775	7.0875	6.9775	7.085	201600.0
2013-11-08	BIB	ETF	29.02	30.8725	29.0	30.5525	428776.0
2013-11-08	BICK	ETF	23.8965	23.8965	23.8965	23.8965	716.0
2013-11-08	BIL	ETF	91.58	91.58	91.56	91.56	296000.0
2013-11-08	BIS	ETF	1103.6	1103.6	1030.8	1037.2	992.0
2013-11-08	BIV	ETF	83.45	83.46	83.3	83.35	170000.0
2013-11-08	BIZD	ETF	20.33	20.6	20.33	20.55	8500.0
2013-11-08	BJK	ETF	48.97	49.32	48.68	49.07	156700.0
2013-11-08	BKF	ETF	37.14	37.375	36.98	37.36	51633.0
2013-11-08	BKLN	ETF	24.84	24.89	24.84	24.84	2369100.0
2013-11-08	BLV	ETF	82.08	82.14	81.79	81.83	115100.0

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

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