PREVIEW / etf_daily / 2014-05-20

all etf daily files

  file:    by_date/etf_daily/2014/2014-05-20.parquet
  size:    44 KB
  rows:    1,080

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-20	SPY	ETF	188.65	188.67	187.07	187.55	111644000.0
2014-05-20	QQQ	ETF	88.28	88.6	87.64	88.0	33715953.0
2014-05-20	IWM	ETF	110.48	110.51	108.42	109.06	89567900.0
2014-05-20	DIA	ETF	164.7	164.72	163.04	163.32	4856600.0
2014-05-20	GLD	ETF	124.12	124.91	124.09	124.69	3770800.0
2014-05-20	TLT	ETF	112.6	113.48	112.59	112.95	6549800.0
2014-05-20	AADR	ETF	37.86	37.86	37.86	37.86	500.0
2014-05-20	AAXJ	ETF	61.36	61.54	61.16	61.28	111600.0
2014-05-20	ACWI	ETF	59.0	59.1	58.54	58.66	1445600.0
2014-05-20	ACWV	ETF	65.85	65.85	65.38	65.51	56200.0
2014-05-20	ACWX	ETF	47.56	47.56	47.27	47.36	153438.0
2014-05-20	ADRE	ETF	38.37	38.68	38.2404	38.2404	8674.0
2014-05-20	AFK	ETF	33.16	33.16	32.3004	32.61	37500.0
2014-05-20	AGG	ETF	109.16	109.31	109.16	109.21	1102200.0
2014-05-20	AGQ	ETF	60.26	61.36	60.2	61.06	108100.0
2014-05-20	AGZ	ETF	112.4	112.4799	112.34	112.4509	15082.0
2014-05-20	AIA	ETF	47.83	47.95	47.71	47.79	38598.0
2014-05-20	AIQ	ETF	29.73	29.94	27.59	28.18	42755.0
2014-05-20	AIRR	ETF	18.71	18.85	18.34	18.43	22700.0
2014-05-20	AIVI	ETF	50.86	50.88	50.42	50.57	52700.0
2014-05-20	ALTL	ETF	33.9099	33.9099	33.9099	33.9099	120.0
2014-05-20	AMJ	ETF	49.41	49.5	49.12	49.4699	218504.0
2014-05-20	AMLP	ETF	90.35	90.6	90.15	90.5	579900.0
2014-05-20	ANGL	ETF	28.0	28.02	27.98	28.02	12100.0
2014-05-20	AOA	ETF	45.65	45.65	45.26	45.39	16500.0
2014-05-20	AOK	ETF	32.61	32.61	32.5	32.53	13484.0
2014-05-20	AOM	ETF	35.05	35.05	34.8703	34.94	17489.0
2014-05-20	AOR	ETF	39.41	39.41	39.18	39.27	42737.0
2014-05-20	ARGT	ETF	19.4	19.4	19.2	19.2	800.0
2014-05-20	ASEA	ETF	16.72	16.72	16.62	16.65	26000.0
2014-05-20	ASHR	ETF	21.67	21.7	21.64	21.69	37100.0
2014-05-20	ATMP	ETF	29.55	29.71	29.53	29.71	36100.0
2014-05-20	AVIV	ETF	27.35	27.42	27.19	27.22	205973.0
2014-05-20	AWAY	ETF	31.16	31.31	30.36	30.64	1180866.0
2014-05-20	BAB	ETF	29.21	29.31	29.21	29.29	113354.0
2014-05-20	BAL	ETF	54.88	54.97	54.7	54.97	2552.0
2014-05-20	BALT	ETF	6.44	6.525	6.34	6.38	539896.0
2014-05-20	BBH	ETF	88.35	88.4	86.7	87.02	39300.0
2014-05-20	BCHP	ETF	20.09	20.09	19.9599	19.98	14169.0
2014-05-20	BCM	ETF	41.41	41.43	41.29	41.34	8087.0
2014-05-20	BFOR	ETF	7.4225	7.4225	7.335	7.3575	136400.0
2014-05-20	BIB	ETF	37.75	37.8075	36.271	36.63	323836.0
2014-05-20	BICK	ETF	25.48	25.63	25.37	25.37	13503.0
2014-05-20	BIL	ETF	91.52	91.54	91.52	91.54	94850.0
2014-05-20	BIS	ETF	711.2	735.996	709.6	727.2	9490.5
2014-05-20	BIV	ETF	84.61	84.77	84.59	84.72	208200.0
2014-05-20	BIZD	ETF	19.54	19.59	19.38	19.42	18100.0
2014-05-20	BJK	ETF	48.42	48.72	48.03	48.3	12000.0
2014-05-20	BKF	ETF	37.6	37.9	37.431	37.54	80283.0
2014-05-20	BKLN	ETF	24.76	24.78	24.75	24.75	3188900.0

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

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