PREVIEW / etf_daily / 2014-05-14

all etf daily files

  file:    by_date/etf_daily/2014/2014-05-14.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-05-14	SPY	ETF	189.79	189.88	188.79	189.06	72367000.0
2014-05-14	QQQ	ETF	88.03	88.35	87.62	87.83	26483571.0
2014-05-14	IWM	ETF	111.1	111.12	109.42	109.62	65720700.0
2014-05-14	DIA	ETF	167.09	167.14	165.92	166.11	3104700.0
2014-05-14	GLD	ETF	125.8	125.96	125.44	125.81	4015900.0
2014-05-14	TLT	ETF	112.63	113.23	112.56	112.96	8851400.0
2014-05-14	AADR	ETF	37.98	37.98	37.96	37.96	1000.0
2014-05-14	AAXJ	ETF	60.83	61.22	60.83	61.01	219000.0
2014-05-14	ACWI	ETF	59.4	59.4	59.11	59.18	660900.0
2014-05-14	ACWV	ETF	66.09	66.09	65.69	65.82	19900.0
2014-05-14	ACWX	ETF	47.83	47.91	47.73	47.79	126155.0
2014-05-14	ADRE	ETF	38.65	38.9	38.65	38.75	8952.0
2014-05-14	AFK	ETF	33.36	33.51	33.27	33.45	11916.0
2014-05-14	AGG	ETF	108.91	109.15	108.91	109.09	1321600.0
2014-05-14	AGQ	ETF	63.7	63.93	62.92	63.34	272100.0
2014-05-14	AGZ	ETF	112.19	112.38	111.921	112.2899	18552.0
2014-05-14	AGZD	ETF	25.03	25.03	25.03	25.03	200.0
2014-05-14	AIA	ETF	47.55	47.89	47.5401	47.5401	49424.0
2014-05-14	AIQ	ETF	30.17	30.22	29.04	29.12	19424.0
2014-05-14	AIRR	ETF	18.81	18.81	18.54	18.58	30300.0
2014-05-14	AIVI	ETF	50.8	50.89	50.61	50.77	33100.0
2014-05-14	AMJ	ETF	49.0	49.32	48.8001	49.28	243798.0
2014-05-14	AMLP	ETF	90.1	90.35	89.9	90.35	638740.0
2014-05-14	ANGL	ETF	28.0	28.0	27.91	27.93	5800.0
2014-05-14	AOA	ETF	45.86	45.86	45.61	45.7	14400.0
2014-05-14	AOK	ETF	32.58	32.64	32.5701	32.5736	21903.0
2014-05-14	AOM	ETF	35.13	35.13	35.0	35.05	25324.0
2014-05-14	AOR	ETF	39.55	39.55	39.39	39.43	24963.0
2014-05-14	ARGT	ETF	19.81	20.02	19.81	19.86	8700.0
2014-05-14	ASEA	ETF	16.68	16.78	16.68	16.77	57900.0
2014-05-14	ASHR	ETF	22.27	22.4	22.25	22.33	454000.0
2014-05-14	ATMP	ETF	29.44	29.61	29.41	29.61	15300.0
2014-05-14	AVIV	ETF	27.22	27.41	27.0	27.41	159470.0
2014-05-14	AWAY	ETF	31.8	32.34	31.28	31.52	869089.0
2014-05-14	BAB	ETF	29.28	29.3699	29.27	29.35	72355.0
2014-05-14	BAL	ETF	56.55	56.67	55.91	55.9996	22108.0
2014-05-14	BALT	ETF	6.26	6.35	6.19	6.25	230134.0
2014-05-14	BBH	ETF	88.35	89.65	87.63	88.84	69700.0
2014-05-14	BCHP	ETF	20.266	20.266	20.266	20.266	250.0
2014-05-14	BCM	ETF	41.55	41.55	41.5499	41.5499	690.0
2014-05-14	BFOR	ETF	7.475	7.475	7.395	7.395	94800.0
2014-05-14	BIB	ETF	37.105	38.48	36.66	37.78	438046.0
2014-05-14	BICK	ETF	25.4399	25.4399	25.332	25.332	872.0
2014-05-14	BIL	ETF	91.52	91.54	91.52	91.54	217900.0
2014-05-14	BIS	ETF	720.8	730.0	696.4	710.04	10634.5
2014-05-14	BIV	ETF	84.4	84.65	84.39	84.53	152300.0
2014-05-14	BIZD	ETF	19.45	19.5	19.38	19.44	8800.0
2014-05-14	BJK	ETF	49.42	49.42	48.72	48.72	7100.0
2014-05-14	BKF	ETF	37.42	37.71	37.42	37.59	61088.0
2014-05-14	BKLN	ETF	24.85	24.86	24.83	24.85	1391900.0

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

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