PREVIEW / etf_daily / 2014-05-12

all etf daily files

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

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-12	SPY	ETF	188.8	189.88	188.0	189.79	86940000.0
2014-05-12	QQQ	ETF	87.31	88.26	87.24	88.23	38951060.0
2014-05-12	IWM	ETF	110.68	113.04	110.51	112.53	76291700.0
2014-05-12	DIA	ETF	166.31	166.93	166.28	166.8	3944700.0
2014-05-12	GLD	ETF	125.4	125.42	124.69	124.94	4025500.0
2014-05-12	TLT	ETF	111.01	111.13	110.54	110.79	4563800.0
2014-05-12	AAXJ	ETF	60.21	60.56	60.21	60.54	271200.0
2014-05-12	ACWI	ETF	58.89	59.26	58.89	59.24	409400.0
2014-05-12	ACWV	ETF	65.72	65.77	65.56	65.68	55600.0
2014-05-12	ACWX	ETF	47.62	47.71	47.52	47.7	255201.0
2014-05-12	ADRE	ETF	38.27	38.61	38.25	38.6	23191.0
2014-05-12	AFK	ETF	33.11	33.21	33.0712	33.21	10543.0
2014-05-12	AGG	ETF	108.64	108.65	108.54	108.6	472900.0
2014-05-12	AGQ	ETF	62.31	62.67	61.87	62.08	349600.0
2014-05-12	AGZ	ETF	111.38	112.24	111.38	112.01	9118.0
2014-05-12	AGZD	ETF	25.1	25.105	25.09	25.1	8400.0
2014-05-12	AIA	ETF	47.0	47.3	47.0	47.3	23359.0
2014-05-12	AIQ	ETF	30.0	32.37	29.44	31.83	99854.0
2014-05-12	AIRR	ETF	18.77	19.17	18.77	19.15	48000.0
2014-05-12	AIVI	ETF	50.72	50.83	50.7	50.83	8100.0
2014-05-12	AMJ	ETF	48.98	49.31	48.85	49.17	568466.0
2014-05-12	AMLP	ETF	90.25	90.45	90.0	90.2	447460.0
2014-05-12	ANGL	ETF	27.99	27.99	27.84	27.88	15000.0
2014-05-12	AOA	ETF	45.54	45.83	45.54	45.81	24200.0
2014-05-12	AOK	ETF	32.5	32.59	32.5	32.57	12964.0
2014-05-12	AOM	ETF	35.0	35.07	34.98	35.04	49496.0
2014-05-12	AOR	ETF	39.29	39.5	39.29	39.4801	39985.0
2014-05-12	ARGT	ETF	20.0	20.12	19.91	19.91	10400.0
2014-05-12	ASEA	ETF	16.5	16.58	16.5	16.57	7500.0
2014-05-12	ASHR	ETF	22.19	22.39	22.19	22.39	127600.0
2014-05-12	ATMP	ETF	29.45	29.48	29.44	29.44	6300.0
2014-05-12	AVIV	ETF	27.19	27.49	27.1807	27.32	147387.0
2014-05-12	AWAY	ETF	31.29	32.4	31.07	32.12	1166821.0
2014-05-12	BAB	ETF	29.05	29.12	29.0	29.0503	69935.0
2014-05-12	BAL	ETF	56.73	56.73	55.96	56.24	8217.0
2014-05-12	BALT	ETF	6.12	6.28	6.09	6.24	442110.0
2014-05-12	BBH	ETF	87.24	88.96	87.02	88.92	120000.0
2014-05-12	BCHP	ETF	20.16	20.31	20.16	20.31	2915.0
2014-05-12	BCM	ETF	41.3	41.3	41.293	41.293	2743.0
2014-05-12	BFOR	ETF	7.4025	7.5275	7.4025	7.52	170400.0
2014-05-12	BIB	ETF	36.715	38.0	36.2901	37.9	675358.0
2014-05-12	BICK	ETF	24.9	25.17	24.9	25.17	816.0
2014-05-12	BIL	ETF	91.52	91.54	91.52	91.52	896250.0
2014-05-12	BIS	ETF	732.8	740.4	704.4	706.4	12846.5
2014-05-12	BIV	ETF	84.02	84.02	83.91	83.94	133900.0
2014-05-12	BIZD	ETF	19.52	19.61	19.52	19.61	5700.0
2014-05-12	BJK	ETF	49.2	49.49	49.11	49.38	12900.0
2014-05-12	BKF	ETF	36.96	37.19	36.96	37.17	69426.0
2014-05-12	BKLN	ETF	24.85	24.88	24.84	24.87	1826400.0
2014-05-12	BLNG	ETF	36.18	36.19	36.01	36.05	41300.0

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

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