PREVIEW / etf_daily / 2013-10-31

all etf daily files

  file:    by_date/etf_daily/2013/2013-10-31.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-10-31	SPY	ETF	176.15	176.89	175.53	175.79	133795000.0
2013-10-31	QQQ	ETF	82.77	83.3	82.48	82.79	31309909.0
2013-10-31	IWM	ETF	109.77	110.18	108.89	109.19	47370000.0
2013-10-31	DIA	ETF	155.61	156.18	155.1	155.29	8157400.0
2013-10-31	GLD	ETF	128.04	128.49	127.3	127.74	7753300.0
2013-10-31	TLT	ETF	107.91	108.01	107.14	107.64	11452100.0
2013-10-31	AAXJ	ETF	60.81	60.88	60.21	60.21	369900.0
2013-10-31	ACTV	ETF	14.45	14.465	14.44	14.44	1983472.0
2013-10-31	ACWI	ETF	56.31	56.43	56.04	56.05	718800.0
2013-10-31	ACWV	ETF	64.45	64.5	64.17	64.26	33800.0
2013-10-31	ACWX	ETF	46.5	46.65	46.36	46.395	205263.0
2013-10-31	ADRE	ETF	38.97	38.97	38.44	38.44	21996.0
2013-10-31	AFK	ETF	31.62	31.73	31.49	31.55	43263.0
2013-10-31	AGG	ETF	108.11	108.12	107.8	107.9	1793600.0
2013-10-31	AGQ	ETF	82.0	82.6	80.6	81.16	429125.0
2013-10-31	AGZ	ETF	114.44	114.44	111.69	111.754	24599.0
2013-10-31	AIA	ETF	48.235	48.24	48.01	48.02	26306.0
2013-10-31	AIQ	ETF	23.96	25.32	23.635	25.21	62147.0
2013-10-31	AIVI	ETF	47.3	47.41	47.06	47.25	29000.0
2013-10-31	ALTL	ETF	31.52	31.52	31.52	31.52	224.0
2013-10-31	AMJ	ETF	45.86	46.02	45.44	45.82	495047.0
2013-10-31	AMLP	ETF	89.4	89.65	88.65	89.35	576880.0
2013-10-31	ANGL	ETF	27.0	27.0	26.89	27.0	13900.0
2013-10-31	AOA	ETF	43.44	43.55	43.3	43.34	12900.0
2013-10-31	AOK	ETF	31.91	31.91	31.81	31.83	25162.0
2013-10-31	AOM	ETF	34.03	34.03	33.9101	33.97	9247.0
2013-10-31	AOR	ETF	37.87	37.919	37.728	37.77	28548.0
2013-10-31	ARGT	ETF	20.51	20.51	20.23	20.36	8600.0
2013-10-31	ASEA	ETF	17.09	17.12	17.03	17.08	22100.0
2013-10-31	ATMP	ETF	26.68	26.87	26.58	26.79	38100.0
2013-10-31	AVIV	ETF	25.48	25.59	25.12	25.4	182967.0
2013-10-31	AWAY	ETF	29.47	29.93	29.25	29.65	641097.0
2013-10-31	BAB	ETF	27.9	27.9	27.74	27.77	93037.0
2013-10-31	BAL	ETF	50.06	50.34	48.59	49.05	23048.0
2013-10-31	BALT	ETF	4.51	4.65	4.36	4.48	1624437.0
2013-10-31	BBH	ETF	82.84	83.2	81.78	82.0	71800.0
2013-10-31	BFOR	ETF	7.0975	7.1175	7.0375	7.0775	230000.0
2013-10-31	BIB	ETF	31.4825	31.8775	30.75	31.111	156960.0
2013-10-31	BICK	ETF	24.89	24.89	24.79	24.87	5300.0
2013-10-31	BIL	ETF	91.58	91.58	91.56	91.56	143900.0
2013-10-31	BIS	ETF	1020.8	1050.0	1006.84	1039.6	310.0
2013-10-31	BIV	ETF	84.69	84.71	84.33	84.39	236700.0
2013-10-31	BIZD	ETF	20.87	20.87	20.51	20.54	55300.0
2013-10-31	BJK	ETF	50.12	50.13	49.68	49.73	35500.0
2013-10-31	BKF	ETF	38.94	39.01	38.55	38.57	58933.0
2013-10-31	BKLN	ETF	24.84	24.84	24.81	24.83	1593000.0
2013-10-31	BLV	ETF	84.91	84.91	84.4	84.62	66300.0
2013-10-31	BMVP	ETF	21.37	21.5033	21.37	21.4248	635.0
2013-10-31	BND	ETF	81.47	81.53	81.31	81.4	1615500.0
2013-10-31	BNDX	ETF	50.17	50.17	49.9	50.09	454300.0

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

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