PREVIEW / etf_daily / 2014-07-03

all etf daily files

  file:    by_date/etf_daily/2014/2014-07-03.parquet
  size:    44 KB
  rows:    1,096

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-07-03	SPY	ETF	197.79	198.29	197.64	198.2	52938800.0
2014-07-03	QQQ	ETF	95.41	95.7	95.15	95.7	15291700.0
2014-07-03	IWM	ETF	119.58	119.91	119.25	119.82	15933900.0
2014-07-03	DIA	ETF	169.85	170.47	169.73	170.47	2074800.0
2014-07-03	GLD	ETF	126.79	127.29	126.61	127.16	4922500.0
2014-07-03	TLT	ETF	110.38	110.86	110.34	110.68	6173900.0
2014-07-03	AADR	ETF	39.53	39.66	39.46	39.6	7700.0
2014-07-03	AAXJ	ETF	63.64	64.11	63.62	64.08	532300.0
2014-07-03	ACWI	ETF	60.8	61.16	60.8	61.14	1063600.0
2014-07-03	ACWV	ETF	67.22	67.29	67.12	67.29	35000.0
2014-07-03	ACWX	ETF	48.55	48.74	48.54	48.71	166686.0
2014-07-03	ADRE	ETF	39.62	39.89	39.62	39.88	3312.0
2014-07-03	AFK	ETF	33.09	33.38	33.03	33.38	12872.0
2014-07-03	AGG	ETF	108.55	108.66	108.47	108.62	634500.0
2014-07-03	AGQ	ETF	71.26	72.15	71.11	71.78	70200.0
2014-07-03	AGZ	ETF	112.25	112.28	112.0123	112.1241	11573.0
2014-07-03	AGZD	ETF	25.08	25.08	25.02	25.045	27000.0
2014-07-03	AIA	ETF	48.98	49.2	48.98	49.2	8175.0
2014-07-03	AIQ	ETF	29.65	30.67	27.68	29.51	36417.0
2014-07-03	AIRR	ETF	19.6	19.81	19.6	19.769	11000.0
2014-07-03	AIVI	ETF	51.25	51.37	51.22	51.35	37000.0
2014-07-03	AMJ	ETF	52.39	52.3999	51.74	51.91	171085.0
2014-07-03	AMLP	ETF	95.05	95.1	94.05	94.15	621800.0
2014-07-03	ANGL	ETF	28.39	28.39	28.39	28.39	300.0
2014-07-03	AOA	ETF	47.01	47.23	47.01	47.23	22500.0
2014-07-03	AOK	ETF	32.97	33.0	32.9201	33.0	14555.0
2014-07-03	AOM	ETF	35.58	35.61	35.52	35.61	24228.0
2014-07-03	AOR	ETF	40.26	40.42	40.26	40.37	21401.0
2014-07-03	ARGT	ETF	22.7	22.76	22.61	22.71	10600.0
2014-07-03	ASEA	ETF	16.87	16.94	16.86	16.91	4600.0
2014-07-03	ASHR	ETF	22.71	22.75	22.65	22.74	185000.0
2014-07-03	ASHS	ETF	26.9	27.02	26.9	26.98	1000.0
2014-07-03	ATMP	ETF	31.49	31.49	31.25	31.31	30200.0
2014-07-03	AVIV	ETF	28.1	28.1	27.92	28.08	129471.0
2014-07-03	AWAY	ETF	34.37	34.85	34.24	34.58	641656.0
2014-07-03	BAB	ETF	29.0	29.03	28.92	28.98	87241.0
2014-07-03	BAL	ETF	48.4	48.896	48.4	48.68	20097.0
2014-07-03	BALT	ETF	5.97	6.0	5.86	5.93	402242.0
2014-07-03	BBH	ETF	98.84	99.23	98.27	99.04	31300.0
2014-07-03	BCHP	ETF	20.92	20.92	20.92	20.92	286.0
2014-07-03	BCM	ETF	41.53	41.5495	41.4301	41.4301	3662.0
2014-07-03	BFOR	ETF	7.925	7.98	7.925	7.965	209600.0
2014-07-03	BIB	ETF	49.575	49.9	48.735	49.665	342932.0
2014-07-03	BICK	ETF	27.04	27.04	27.04	27.04	70.0
2014-07-03	BIL	ETF	91.52	91.54	91.52	91.52	74100.0
2014-07-03	BIS	ETF	534.8	540.4	528.0	531.24	4425.0
2014-07-03	BIV	ETF	83.86	83.99	83.8	83.99	131400.0
2014-07-03	BIZD	ETF	20.82	20.82	20.68	20.73	10600.0
2014-07-03	BJK	ETF	51.72	51.81	51.46	51.57	6500.0
2014-07-03	BKF	ETF	39.03	39.41	39.03	39.3601	47476.0

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

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