PREVIEW / etf_daily / 2014-05-29

all etf daily files

  file:    by_date/etf_daily/2014/2014-05-29.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-29	SPY	ETF	191.82	192.4	191.33	192.37	64377000.0
2014-05-29	QQQ	ETF	91.05	91.31	90.86	91.3	33036099.0
2014-05-29	IWM	ETF	113.33	113.59	112.7	113.37	25556800.0
2014-05-29	DIA	ETF	166.47	166.79	166.03	166.78	2763500.0
2014-05-29	GLD	ETF	120.78	121.46	120.77	120.94	5551900.0
2014-05-29	TLT	ETF	114.87	115.19	114.13	114.15	10692000.0
2014-05-29	AADR	ETF	38.33	38.33	38.21	38.26	1400.0
2014-05-29	AAXJ	ETF	62.15	62.26	62.09	62.19	886700.0
2014-05-29	ACWI	ETF	59.92	60.02	59.74	60.01	747400.0
2014-05-29	ACWV	ETF	66.17	66.48	66.17	66.48	30100.0
2014-05-29	ACWX	ETF	48.3	48.32	48.15	48.28	800612.0
2014-05-29	ADRE	ETF	38.43	38.43	38.29	38.32	4830.0
2014-05-29	AFK	ETF	33.28	33.28	32.691	33.07	12257.0
2014-05-29	AGG	ETF	109.74	109.83	109.54	109.57	981400.0
2014-05-29	AGQ	ETF	58.11	59.1	58.0	58.75	215500.0
2014-05-29	AGZ	ETF	112.69	112.82	112.6201	112.6201	6953.0
2014-05-29	AGZD	ETF	24.95	24.995	24.95	24.99	29000.0
2014-05-29	AIA	ETF	48.75	48.75	48.6	48.67	25350.0
2014-05-29	AIQ	ETF	29.65	30.08	28.79	28.94	31720.0
2014-05-29	AIRR	ETF	19.05	19.08	18.92	18.98	16100.0
2014-05-29	AIVI	ETF	51.19	51.19	50.99	51.15	22900.0
2014-05-29	AMJ	ETF	48.96	49.29	48.96	49.14	1712675.0
2014-05-29	AMLP	ETF	90.8	91.1	90.6	90.75	517460.0
2014-05-29	ANGL	ETF	28.15	28.21	28.15	28.21	4600.0
2014-05-29	AOA	ETF	46.4	46.4	46.13	46.28	16000.0
2014-05-29	AOK	ETF	33.08	33.08	32.82	32.83	31948.0
2014-05-29	AOM	ETF	35.43	35.43	35.3	35.32	58894.0
2014-05-29	AOR	ETF	39.92	39.92	39.76	39.87	36177.0
2014-05-29	ARGT	ETF	19.92	20.0	19.9	19.9	2300.0
2014-05-29	ASEA	ETF	16.8	16.82	16.76	16.79	9900.0
2014-05-29	ASHR	ETF	22.03	22.17	22.03	22.08	171000.0
2014-05-29	ASHS	ETF	25.62	25.62	25.56	25.59	1700.0
2014-05-29	ATMP	ETF	29.45	29.68	29.45	29.54	21600.0
2014-05-29	AVIV	ETF	27.89	27.89	27.53	27.55	211636.0
2014-05-29	AWAY	ETF	30.07	31.26	29.33	31.19	3729611.0
2014-05-29	BAB	ETF	29.64	29.64	29.47	29.52	78507.0
2014-05-29	BAL	ETF	52.35	53.4403	52.2051	53.19	6405.0
2014-05-29	BALT	ETF	6.71	6.775	6.53	6.54	434562.0
2014-05-29	BBH	ETF	90.69	91.25	90.5	90.77	48500.0
2014-05-29	BCHP	ETF	20.4	20.43	20.374	20.43	3594.0
2014-05-29	BCM	ETF	41.119	41.119	41.119	41.119	301.0
2014-05-29	BFOR	ETF	7.59	7.59	7.5375	7.59	120400.0
2014-05-29	BIB	ETF	40.795	41.24	40.45	40.8	335168.0
2014-05-29	BICK	ETF	25.94	25.9499	25.84	25.8612	9097.0
2014-05-29	BIL	ETF	91.54	91.54	91.52	91.52	90150.0
2014-05-29	BIS	ETF	659.2	659.2	645.6	658.0	4237.5
2014-05-29	BIV	ETF	85.12	85.31	84.93	84.99	275800.0
2014-05-29	BIZD	ETF	19.89	20.04	19.89	19.94	31200.0
2014-05-29	BJK	ETF	49.79	50.11	49.64	50.09	33100.0
2014-05-29	BKF	ETF	37.86	37.9099	37.7776	37.85	21226.0

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

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