PREVIEW / etf_daily / 2014-06-20

all etf daily files

  file:    by_date/etf_daily/2014/2014-06-20.parquet
  size:    45 KB
  rows:    1,104

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
2014-06-20	SPY	ETF	196.03	196.1	195.7	195.94	100587000.0
2014-06-20	QQQ	ETF	92.7	92.87	92.53	92.77	25897494.0
2014-06-20	IWM	ETF	117.87	118.3	117.56	118.25	30104400.0
2014-06-20	DIA	ETF	169.25	169.42	168.96	169.08	5370700.0
2014-06-20	GLD	ETF	126.32	127.07	126.21	126.5	9954700.0
2014-06-20	TLT	ETF	110.97	111.8	110.9	111.8	7319100.0
2014-06-20	AADR	ETF	39.1	39.1	38.97	39.1	4300.0
2014-06-20	AAXJ	ETF	62.6	62.6	62.41	62.51	221900.0
2014-06-20	ACWI	ETF	61.14	61.23	61.11	61.2	1231200.0
2014-06-20	ACWV	ETF	67.51	67.82	67.44	67.57	81500.0
2014-06-20	ACWX	ETF	49.03	49.11	48.97	49.07	328366.0
2014-06-20	ADRE	ETF	39.02	39.0288	38.94	38.98	3298.0
2014-06-20	AFK	ETF	32.61	33.0195	32.6	32.84	9832.0
2014-06-20	AGG	ETF	108.73	108.94	108.73	108.94	690600.0
2014-06-20	AGQ	ETF	69.57	70.95	69.55	70.03	388300.0
2014-06-20	AGZ	ETF	112.26	112.3199	112.22	112.3199	6466.0
2014-06-20	AIA	ETF	48.2	48.21	48.0401	48.21	5969.0
2014-06-20	AIQ	ETF	27.18	28.32	26.51	28.31	38312.0
2014-06-20	AIRR	ETF	19.398	19.4	19.312	19.36	20300.0
2014-06-20	AIVI	ETF	51.99	52.02	51.8	51.83	60400.0
2014-06-20	AMJ	ETF	50.85	50.9999	50.47	50.61	650541.0
2014-06-20	AMLP	ETF	93.25	93.3	92.55	92.75	822140.0
2014-06-20	ANGL	ETF	28.61	28.61	28.2	28.2	5900.0
2014-06-20	AOA	ETF	47.39	47.39	47.09	47.19	30500.0
2014-06-20	AOK	ETF	33.0087	33.04	32.98	33.04	35384.0
2014-06-20	AOM	ETF	35.88	35.88	35.65	35.68	19276.0
2014-06-20	AOR	ETF	40.57	40.57	40.3601	40.43	13051.0
2014-06-20	ARGT	ETF	21.0	21.77	21.0	21.69	6900.0
2014-06-20	ASEA	ETF	16.58	16.63	16.57	16.63	4600.0
2014-06-20	ASHR	ETF	22.08	22.27	21.96	22.04	157000.0
2014-06-20	ASHS	ETF	25.16	25.17	25.1	25.1	4800.0
2014-06-20	ATMP	ETF	30.82	30.82	30.65	30.67	13100.0
2014-06-20	AVIV	ETF	28.76	29.18	28.67	28.91	1107944.0
2014-06-20	AWAY	ETF	33.73	33.94	32.57	32.74	1720710.0
2014-06-20	BAB	ETF	28.95	29.08	28.89	29.0676	264800.0
2014-06-20	BAL	ETF	52.02	52.43	51.7815	52.21	8860.0
2014-06-20	BALT	ETF	6.6	6.83	6.56	6.74	542390.0
2014-06-20	BBH	ETF	93.02	94.77	93.0	94.77	70900.0
2014-06-20	BCHP	ETF	20.57	20.63	20.56	20.6268	66391.0
2014-06-20	BCM	ETF	41.96	42.05	41.96	42.032	2296.0
2014-06-20	BFOR	ETF	7.795	7.82	7.7925	7.8175	60400.0
2014-06-20	BIB	ETF	44.215	45.83	44.185	45.76	574198.0
2014-06-20	BICK	ETF	26.69	26.69	26.51	26.57	3356.0
2014-06-20	BIL	ETF	91.54	91.54	91.52	91.54	116850.0
2014-06-20	BIS	ETF	596.0	600.0	576.8	576.8	9424.5
2014-06-20	BIV	ETF	84.12	84.24	84.05	84.23	175300.0
2014-06-20	BIZD	ETF	20.23	20.33	20.23	20.25	35300.0
2014-06-20	BJK	ETF	49.1	49.16	48.76	49.11	10700.0
2014-06-20	BKF	ETF	39.0799	39.14	39.0	39.13	100258.0
2014-06-20	BKLN	ETF	24.85	24.86	24.82	24.83	1490500.0

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

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