PREVIEW / etf_daily / 2014-04-07

all etf daily files

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

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-07	SPY	ETF	185.95	186.26	183.96	184.34	140803000.0
2014-04-07	QQQ	ETF	85.84	86.63	84.951	85.55	83995771.0
2014-04-07	IWM	ETF	113.95	114.24	112.08	112.82	68537700.0
2014-04-07	DIA	ETF	163.58	163.93	162.12	162.16	8624100.0
2014-04-07	GLD	ETF	125.07	125.47	124.84	124.91	3967200.0
2014-04-07	TLT	ETF	108.62	109.29	108.6	109.11	7562500.0
2014-04-07	AADR	ETF	36.92	36.92	36.92	36.92	800.0
2014-04-07	AAXJ	ETF	59.59	59.9	59.37	59.53	475000.0
2014-04-07	ACWI	ETF	57.94	58.17	57.6	57.74	942400.0
2014-04-07	ACWV	ETF	64.0	64.23	63.8	63.81	42600.0
2014-04-07	ACWX	ETF	46.77	46.79	46.4798	46.6	642380.0
2014-04-07	ADRE	ETF	36.84	37.09	36.75	37.0696	24380.0
2014-04-07	AFK	ETF	31.18	31.58	31.011	31.3	20549.0
2014-04-07	AGG	ETF	107.94	108.06	107.89	107.94	679500.0
2014-04-07	AGQ	ETF	64.3	65.48	64.25	64.56	194000.0
2014-04-07	AGZ	ETF	111.79	111.79	111.68	111.69	6046.0
2014-04-07	AIA	ETF	46.61	46.79	46.45	46.6162	18773.0
2014-04-07	AIQ	ETF	32.35	33.6385	31.52	32.64	28229.0
2014-04-07	AIRR	ETF	19.51	19.51	18.902	18.978	17200.0
2014-04-07	AIVI	ETF	49.23	49.25	48.83	48.96	16400.0
2014-04-07	AMJ	ETF	47.34	47.71	46.751	46.84	356211.0
2014-04-07	AMLP	ETF	89.45	89.55	88.55	88.7	516860.0
2014-04-07	ANGL	ETF	27.61	27.61	27.56	27.57	2900.0
2014-04-07	AOA	ETF	45.13	45.13	44.73	44.83	35100.0
2014-04-07	AOK	ETF	32.33	32.33	32.21	32.26	27116.0
2014-04-07	AOM	ETF	34.68	34.698	34.54	34.58	36203.0
2014-04-07	AOR	ETF	38.97	38.98	38.7004	38.77	37149.0
2014-04-07	ARGT	ETF	20.11	20.11	19.65	19.65	2700.0
2014-04-07	ASEA	ETF	16.15	16.22	16.15	16.17	4600.0
2014-04-07	ASHR	ETF	22.16	22.32	22.16	22.29	292900.0
2014-04-07	ATMP	ETF	27.97	28.23	27.86	27.94	26800.0
2014-04-07	AVIV	ETF	25.02	25.15	24.86	24.97	66643.0
2014-04-07	AWAY	ETF	34.23	35.07	33.185	34.01	2602643.0
2014-04-07	BAB	ETF	28.78	28.8399	28.75	28.81	262960.0
2014-04-07	BAL	ETF	57.15	57.28	56.5265	56.6294	13572.0
2014-04-07	BALT	ETF	6.41	6.455	6.17	6.24	1190722.0
2014-04-07	BBH	ETF	86.46	88.76	85.62	87.32	586600.0
2014-04-07	BCM	ETF	40.834	40.834	40.834	40.834	316.0
2014-04-07	BFOR	ETF	7.515	7.5325	7.3725	7.405	447200.0
2014-04-07	BIB	ETF	35.8	38.0745	35.17	36.7145	1615794.0
2014-04-07	BICK	ETF	24.8004	24.8004	24.8004	24.8004	163.0
2014-04-07	BIL	ETF	91.54	91.56	91.54	91.54	1296300.0
2014-04-07	BIS	ETF	787.2	800.0	737.6	766.0	32921.5
2014-04-07	BIV	ETF	83.37	83.47	83.34	83.35	151100.0
2014-04-07	BIZD	ETF	20.45	20.45	20.16	20.21	20400.0
2014-04-07	BJK	ETF	50.83	51.01	50.08	50.34	38200.0
2014-04-07	BKF	ETF	36.39	36.66	36.39	36.58	59751.0
2014-04-07	BKLN	ETF	24.84	24.85	24.79	24.79	3354900.0
2014-04-07	BLV	ETF	86.45	86.77	86.34	86.73	61300.0
2014-04-07	BMVP	ETF	23.597	23.6	23.16	23.233	20367.0

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

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