PREVIEW / etf_daily / 2013-11-01

all etf daily files

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

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-01	SPY	ETF	176.02	176.61	175.22	176.21	142805000.0
2013-11-01	QQQ	ETF	83.04	83.169	82.4	82.81	30873163.0
2013-11-01	IWM	ETF	109.41	109.63	107.92	108.72	117030400.0
2013-11-01	DIA	ETF	155.58	156.15	155.08	155.86	5909900.0
2013-11-01	GLD	ETF	126.86	127.17	126.05	126.95	9566200.0
2013-11-01	TLT	ETF	106.97	107.0	106.14	106.19	11349500.0
2013-11-01	AADR	ETF	36.26	36.6	36.26	36.59	1800.0
2013-11-01	AAXJ	ETF	60.37	60.63	60.12	60.48	165600.0
2013-11-01	ACTV	ETF	14.44	14.48	14.42	14.48	2580561.0
2013-11-01	ACWI	ETF	56.01	56.15	55.78	56.04	1841400.0
2013-11-01	ACWV	ETF	64.23	64.31	63.9	64.24	17000.0
2013-11-01	ACWX	ETF	46.25	46.25	45.94	46.15	2865247.0
2013-11-01	ADRE	ETF	38.37	38.6	38.198	38.41	29847.0
2013-11-01	AFK	ETF	31.58	31.58	31.3	31.3479	12525.0
2013-11-01	AGG	ETF	107.64	107.65	107.41	107.45	1262300.0
2013-11-01	AGQ	ETF	80.92	81.32	80.0	80.72	226150.0
2013-11-01	AGZ	ETF	111.8	111.8	111.48	111.68	7237.0
2013-11-01	AIA	ETF	48.22	48.3	48.15	48.29	11400.0
2013-11-01	AIQ	ETF	25.32	26.08	24.71	25.73	89776.0
2013-11-01	AIVI	ETF	47.15	47.15	46.76	46.96	22300.0
2013-11-01	AMJ	ETF	45.73	46.25	45.7	45.97	380462.0
2013-11-01	AMLP	ETF	89.25	89.55	89.0	89.2	750500.0
2013-11-01	ANGL	ETF	26.89	26.89	26.89	26.89	300.0
2013-11-01	AOA	ETF	43.32	43.35	43.09	43.31	16600.0
2013-11-01	AOK	ETF	31.84	31.84	31.72	31.78	19027.0
2013-11-01	AOM	ETF	33.94	33.96	33.8	33.87	42629.0
2013-11-01	AOR	ETF	37.76	37.83	37.6	37.71	17746.0
2013-11-01	ARGT	ETF	20.26	20.26	20.1	20.11	3900.0
2013-11-01	ASEA	ETF	16.94	16.97	16.86	16.92	10300.0
2013-11-01	ATMP	ETF	27.46	27.46	26.52	26.82	18900.0
2013-11-01	AVIV	ETF	25.34	25.57	24.5	25.25	111486.0
2013-11-01	AWAY	ETF	29.74	30.19	28.9	29.34	770273.0
2013-11-01	BAB	ETF	27.7	27.724	27.57	27.59	80178.0
2013-11-01	BAL	ETF	49.17	49.35	48.7691	48.78	11660.0
2013-11-01	BALT	ETF	4.52	4.91	4.52	4.9	762322.0
2013-11-01	BBH	ETF	82.18	82.68	81.74	82.64	55100.0
2013-11-01	BFOR	ETF	7.0775	7.08	7.0075	7.05	192400.0
2013-11-01	BIB	ETF	31.165	31.6224	30.6928	31.2475	159752.0
2013-11-01	BICK	ETF	24.84	24.84	24.762	24.8	12377.0
2013-11-01	BIL	ETF	91.58	91.58	91.56	91.56	539750.0
2013-11-01	BIS	ETF	1036.0	1043.92	1024.0	1024.0	487.5
2013-11-01	BIV	ETF	84.11	84.17	83.85	83.9	297200.0
2013-11-01	BIZD	ETF	20.44	20.53	20.32	20.42	8600.0
2013-11-01	BJK	ETF	49.73	50.15	49.73	50.01	40200.0
2013-11-01	BKF	ETF	38.71	38.85	38.45	38.65	110494.0
2013-11-01	BKLN	ETF	24.83	24.84	24.81	24.83	2739400.0
2013-11-01	BLV	ETF	84.1	84.1	83.5	83.54	39600.0
2013-11-01	BMVP	ETF	21.4016	21.4016	21.2967	21.2967	1255.0
2013-11-01	BND	ETF	81.16	81.19	81.0	81.0	1010100.0
2013-11-01	BNDX	ETF	50.08	50.09	50.0	50.08	99900.0

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

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