PREVIEW / etf_daily / 2014-04-03

all etf daily files

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

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-04-03	SPY	ETF	189.17	189.22	188.05	188.63	77435000.0
2014-04-03	QQQ	ETF	89.55	89.679	88.22	88.73	30319074.0
2014-04-03	IWM	ETF	118.4	118.44	116.68	117.2	38473500.0
2014-04-03	DIA	ETF	165.72	165.75	164.96	165.34	4452600.0
2014-04-03	GLD	ETF	123.75	124.26	123.59	123.92	3658800.0
2014-04-03	TLT	ETF	107.52	107.94	107.44	107.74	4937400.0
2014-04-03	AADR	ETF	38.05	38.05	37.78	37.78	500.0
2014-04-03	AAXJ	ETF	59.68	59.84	59.34	59.78	720900.0
2014-04-03	ACWI	ETF	58.78	58.78	58.37	58.58	667300.0
2014-04-03	ACWV	ETF	64.56	64.56	64.12	64.41	42400.0
2014-04-03	ACWX	ETF	47.01	47.01	46.6701	46.87	55977.0
2014-04-03	ADRE	ETF	36.97	36.97	36.582	36.7101	14237.0
2014-04-03	AFK	ETF	31.4	31.71	31.31	31.38	12763.0
2014-04-03	AGG	ETF	107.46	107.54	107.39	107.44	1126700.0
2014-04-03	AGQ	ETF	64.29	64.82	63.92	64.33	141600.0
2014-04-03	AGZ	ETF	111.502	111.61	111.3401	111.4545	6487.0
2014-04-03	AIA	ETF	46.5	46.6103	46.342	46.61	41293.0
2014-04-03	AIQ	ETF	34.13	34.13	33.2	33.77	25689.0
2014-04-03	AIRR	ETF	19.87	19.9	19.73	19.82	47400.0
2014-04-03	AIVI	ETF	49.34	49.48	49.09	49.16	8200.0
2014-04-03	AMJ	ETF	47.02	47.47	46.93	47.2968	369763.0
2014-04-03	AMLP	ETF	89.25	89.6	89.0	89.25	546740.0
2014-04-03	ANGL	ETF	27.55	27.6	27.55	27.56	1900.0
2014-04-03	AOA	ETF	45.7	45.7	45.34	45.51	20000.0
2014-04-03	AOK	ETF	32.4196	32.42	32.33	32.38	26021.0
2014-04-03	AOM	ETF	34.83	34.84	34.7204	34.8	24577.0
2014-04-03	AOR	ETF	39.39	39.39	39.07	39.18	20657.0
2014-04-03	ARGT	ETF	20.03	20.16	19.97	20.01	7200.0
2014-04-03	ASEA	ETF	16.18	16.18	16.0	16.04	30600.0
2014-04-03	ASHR	ETF	22.07	22.07	21.88	22.0	74500.0
2014-04-03	ATMP	ETF	28.26	28.32	28.13	28.26	8100.0
2014-04-03	AVIV	ETF	25.08	25.19	24.66	25.03	124058.0
2014-04-03	AWAY	ETF	38.49	38.77	36.44	36.65	2385374.0
2014-04-03	BAB	ETF	28.61	28.649	28.5601	28.62	60495.0
2014-04-03	BAL	ETF	56.77	56.92	56.47	56.48	14414.0
2014-04-03	BALT	ETF	6.38	6.49	6.05	6.1	566163.0
2014-04-03	BBH	ETF	93.34	93.34	89.84	90.79	195200.0
2014-04-03	BCM	ETF	40.68	40.85	40.6	40.8	18309.0
2014-04-03	BFOR	ETF	7.7075	7.7375	7.64	7.675	167600.0
2014-04-03	BIB	ETF	41.96	41.96	38.525	39.5	820354.0
2014-04-03	BICK	ETF	24.672	24.6759	24.6	24.6	1755.0
2014-04-03	BIL	ETF	91.54	91.56	91.54	91.56	131750.0
2014-04-03	BIS	ETF	680.0	734.4	678.0	718.8	19040.0
2014-04-03	BIV	ETF	82.86	82.94	82.8	82.83	187700.0
2014-04-03	BIZD	ETF	20.45	20.46	20.33	20.45	26300.0
2014-04-03	BJK	ETF	52.83	53.04	52.2	52.42	17000.0
2014-04-03	BKF	ETF	36.63	36.63	36.11	36.47	110099.0
2014-04-03	BKLN	ETF	24.84	24.84	24.82	24.84	1960000.0
2014-04-03	BLV	ETF	85.76	85.9	85.65	85.88	46400.0
2014-04-03	BMVP	ETF	24.06	24.15	23.97	24.08	13449.0

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

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