PREVIEW / etf_daily / 2014-05-23

all etf daily files

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

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-23	SPY	ETF	189.76	190.48	189.59	190.35	61092800.0
2014-05-23	QQQ	ETF	89.33	89.9	89.12	89.88	22691254.0
2014-05-23	IWM	ETF	110.69	112.02	110.51	111.97	42643800.0
2014-05-23	DIA	ETF	165.29	165.87	165.19	165.83	2857000.0
2014-05-23	GLD	ETF	124.6	124.66	124.19	124.51	2205900.0
2014-05-23	TLT	ETF	112.52	112.91	112.45	112.7	3835000.0
2014-05-23	AADR	ETF	38.04	38.18	38.04	38.18	600.0
2014-05-23	AAXJ	ETF	62.2	62.26	62.14	62.15	338100.0
2014-05-23	ACWI	ETF	59.22	59.51	59.22	59.49	324200.0
2014-05-23	ACWV	ETF	66.04	66.26	66.02	66.2	36200.0
2014-05-23	ACWX	ETF	47.8	48.02	47.8	47.99	85923.0
2014-05-23	ADRE	ETF	38.64	38.6472	38.51	38.51	9104.0
2014-05-23	AFK	ETF	33.37	33.49	33.1	33.3	12301.0
2014-05-23	AGG	ETF	109.18	109.25	109.14	109.23	435500.0
2014-05-23	AGQ	ETF	61.19	61.42	60.83	61.23	114500.0
2014-05-23	AGZ	ETF	112.4036	112.53	112.4036	112.49	5336.0
2014-05-23	AGZD	ETF	24.96	24.96	24.96	24.96	600.0
2014-05-23	AIA	ETF	48.29	48.429	48.28	48.28	19623.0
2014-05-23	AIQ	ETF	29.87	30.205	29.14	29.83	28623.0
2014-05-23	AIRR	ETF	18.55	18.81	18.55	18.805	10200.0
2014-05-23	AIVI	ETF	50.83	51.01	50.83	51.0	24800.0
2014-05-23	AMJ	ETF	49.82	49.8999	49.58	49.71	964795.0
2014-05-23	AMLP	ETF	91.1	91.2	90.8	91.05	865840.0
2014-05-23	ANGL	ETF	27.98	28.11	27.98	28.09	1800.0
2014-05-23	AOA	ETF	45.68	45.96	45.68	45.96	16100.0
2014-05-23	AOK	ETF	32.6	32.73	32.6	32.73	10572.0
2014-05-23	AOM	ETF	35.2	35.2	35.081	35.15	71860.0
2014-05-23	AOR	ETF	39.64	39.64	39.52	39.62	35018.0
2014-05-23	ARGT	ETF	19.41	19.72	19.41	19.63	19300.0
2014-05-23	ASEA	ETF	16.76	16.81	16.74	16.76	5500.0
2014-05-23	ASHR	ETF	22.1	22.1	21.96	22.05	28900.0
2014-05-23	ASHS	ETF	25.43	25.45	25.41	25.41	8800.0
2014-05-23	ATMP	ETF	29.96	30.01	29.87	29.91	9300.0
2014-05-23	AVIV	ETF	27.19	27.65	27.19	27.65	126274.0
2014-05-23	AWAY	ETF	32.2	32.63	31.96	32.6	1097539.0
2014-05-23	BAB	ETF	29.22	29.31	29.22	29.3	46655.0
2014-05-23	BAL	ETF	53.13	53.39	52.56	53.29	16910.0
2014-05-23	BALT	ETF	6.63	6.92	6.63	6.84	376663.0
2014-05-23	BBH	ETF	89.02	89.28	88.45	88.64	66100.0
2014-05-23	BCHP	ETF	20.2555	20.302	20.2555	20.27	134500.0
2014-05-23	BCM	ETF	41.58	41.62	41.53	41.6	6103.0
2014-05-23	BFOR	ETF	7.45	7.51	7.4475	7.5075	173600.0
2014-05-23	BIB	ETF	38.93	39.02	37.905	38.74	354670.0
2014-05-23	BICK	ETF	25.86	25.94	25.8	25.94	605.0
2014-05-23	BIL	ETF	91.54	91.54	91.52	91.54	101500.0
2014-05-23	BIS	ETF	685.2	704.0	683.2	690.0	6237.5
2014-05-23	BIV	ETF	84.7	84.75	84.59	84.69	150600.0
2014-05-23	BIZD	ETF	19.66	19.79	19.64	19.76	22500.0
2014-05-23	BJK	ETF	49.45	49.8	49.36	49.71	21300.0
2014-05-23	BKF	ETF	38.11	38.2197	38.07	38.08	39895.0

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

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