PREVIEW / etf_daily / 2014-06-17

all etf daily files

  file:    by_date/etf_daily/2014/2014-06-17.parquet
  size:    44 KB
  rows:    1,094

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-17	SPY	ETF	194.02	194.97	193.81	194.83	84834000.0
2014-06-17	QQQ	ETF	92.34	92.7	92.18	92.45	19984787.0
2014-06-17	IWM	ETF	116.04	117.45	115.78	116.97	62573000.0
2014-06-17	DIA	ETF	167.43	168.2	167.24	168.0	2884700.0
2014-06-17	GLD	ETF	121.85	122.5	121.82	122.28	4032800.0
2014-06-17	TLT	ETF	112.07	112.09	111.48	111.54	6668800.0
2014-06-17	AADR	ETF	38.68	38.76	38.54	38.63	1100.0
2014-06-17	AAXJ	ETF	62.64	62.75	62.58	62.72	830600.0
2014-06-17	ACWI	ETF	60.27	60.58	60.27	60.54	420200.0
2014-06-17	ACWV	ETF	66.82	66.89	66.72	66.81	49400.0
2014-06-17	ACWX	ETF	48.35	48.56	48.35	48.56	117490.0
2014-06-17	ADRE	ETF	38.84	38.8442	38.75	38.8442	3220.0
2014-06-17	AFK	ETF	33.0	33.02	32.7	32.7	16940.0
2014-06-17	AGG	ETF	108.76	108.79	108.61	108.62	842300.0
2014-06-17	AGQ	ETF	62.18	62.91	62.08	62.71	173500.0
2014-06-17	AGZ	ETF	112.228	112.31	112.05	112.08	23630.0
2014-06-17	AIA	ETF	48.36	48.47	48.36	48.44	18283.0
2014-06-17	AIQ	ETF	27.65	27.8	26.49	26.91	29281.0
2014-06-17	AIRR	ETF	19.02	19.21	18.901	19.116	16400.0
2014-06-17	AIVI	ETF	51.24	51.39	51.19	51.35	20900.0
2014-06-17	AMJ	ETF	50.73	50.88	50.53	50.71	630055.0
2014-06-17	AMLP	ETF	92.9	92.9	92.4	92.45	556640.0
2014-06-17	ANGL	ETF	28.29	28.39	28.23	28.28	2500.0
2014-06-17	AOA	ETF	46.6	46.77	46.58	46.74	17500.0
2014-06-17	AOK	ETF	32.84	32.87	32.8184	32.86	22141.0
2014-06-17	AOM	ETF	35.39	35.48	35.389	35.46	26386.0
2014-06-17	AOR	ETF	40.0581	40.14	40.0498	40.09	20334.0
2014-06-17	ARGT	ETF	20.19	20.49	20.14	20.4	18600.0
2014-06-17	ASEA	ETF	16.62	16.62	16.6	16.62	6300.0
2014-06-17	ASHR	ETF	22.4	22.43	22.31	22.39	137200.0
2014-06-17	ASHS	ETF	25.88	25.91	25.85	25.87	5200.0
2014-06-17	ATMP	ETF	30.17	30.59	30.17	30.58	87200.0
2014-06-17	AVIV	ETF	28.32	28.49	27.97	28.03	352254.0
2014-06-17	AWAY	ETF	31.75	32.64	31.64	32.13	1691867.0
2014-06-17	BAB	ETF	29.2	29.2	29.1	29.12	75483.0
2014-06-17	BAL	ETF	52.32	52.32	51.55	51.5774	3974.0
2014-06-17	BALT	ETF	6.62	6.65	6.48	6.63	546367.0
2014-06-17	BBH	ETF	92.43	92.58	91.7	91.74	61800.0
2014-06-17	BCHP	ETF	20.46	20.49	20.4511	20.476	2040.0
2014-06-17	BCM	ETF	41.278	41.32	41.242	41.302	5082.0
2014-06-17	BFOR	ETF	7.705	7.7675	7.705	7.75	95200.0
2014-06-17	BIB	ETF	43.35	43.65	42.6501	43.09	216732.0
2014-06-17	BICK	ETF	26.515	26.59	26.515	26.56	3419.0
2014-06-17	BIL	ETF	91.52	91.54	91.52	91.52	108500.0
2014-06-17	BIS	ETF	612.0	619.6	607.36	614.4	4511.0
2014-06-17	BIV	ETF	84.1	84.1	83.88	83.88	306000.0
2014-06-17	BIZD	ETF	20.18	20.26	20.15	20.26	13300.0
2014-06-17	BJK	ETF	48.01	48.42	48.01	48.41	24200.0
2014-06-17	BKF	ETF	39.04	39.04	38.8201	39.0	185964.0
2014-06-17	BKLN	ETF	24.85	24.86	24.84	24.85	822600.0

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

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