PREVIEW / etf_daily / 2014-06-18

all etf daily files

  file:    by_date/etf_daily/2014/2014-06-18.parquet
  size:    45 KB
  rows:    1,097

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-06-18	SPY	ETF	194.83	196.37	194.4	196.26	105267000.0
2014-06-18	QQQ	ETF	92.55	93.1	91.98	92.97	34514013.0
2014-06-18	IWM	ETF	116.9	117.81	116.5	117.76	37448900.0
2014-06-18	DIA	ETF	168.05	169.06	167.35	168.93	4729200.0
2014-06-18	GLD	ETF	122.22	122.8	122.09	122.67	4601700.0
2014-06-18	TLT	ETF	111.8	112.76	111.56	112.4	11256500.0
2014-06-18	AADR	ETF	38.62	38.64	38.62	38.64	300.0
2014-06-18	AAXJ	ETF	62.56	63.1	62.34	63.07	961400.0
2014-06-18	ACWI	ETF	60.53	61.07	60.49	61.04	619300.0
2014-06-18	ACWV	ETF	66.81	67.37	66.81	67.29	28000.0
2014-06-18	ACWX	ETF	48.56	49.01	48.56	48.98	313357.0
2014-06-18	ADRE	ETF	38.76	39.34	38.76	39.34	29552.0
2014-06-18	AFK	ETF	33.1499	33.1499	32.68	32.78	18490.0
2014-06-18	AGG	ETF	108.73	108.91	108.64	108.91	504400.0
2014-06-18	AGQ	ETF	62.94	63.61	62.76	63.5	208600.0
2014-06-18	AGZ	ETF	111.97	112.306	111.97	112.306	7279.0
2014-06-18	AIA	ETF	48.37	48.72	48.1601	48.72	19211.0
2014-06-18	AIQ	ETF	26.81	27.09	26.19	27.03	12797.0
2014-06-18	AIRR	ETF	19.19	19.236	19.04	19.236	9300.0
2014-06-18	AIVI	ETF	51.55	52.0	51.51	52.0	14600.0
2014-06-18	AMJ	ETF	50.69	50.69	49.87	50.14	494414.0
2014-06-18	AMLP	ETF	92.6	92.65	91.55	91.9	1002100.0
2014-06-18	ANGL	ETF	28.46	28.46	28.28	28.37	4100.0
2014-06-18	AOA	ETF	46.8	47.12	46.69	47.08	23500.0
2014-06-18	AOK	ETF	32.9	33.0	32.85	33.0	21261.0
2014-06-18	AOM	ETF	35.472	35.7	35.42	35.7	30873.0
2014-06-18	AOR	ETF	40.1	40.35	40.08	40.33	12881.0
2014-06-18	ARGT	ETF	20.25	21.1	20.21	21.04	8700.0
2014-06-18	ASEA	ETF	16.57	16.71	16.51	16.71	1900.0
2014-06-18	ASHR	ETF	22.31	22.44	22.21	22.35	733900.0
2014-06-18	ASHS	ETF	25.67	25.71	25.67	25.71	800.0
2014-06-18	ATMP	ETF	30.42	30.49	30.17	30.35	33000.0
2014-06-18	AVIV	ETF	27.99	28.21	27.961	28.15	420902.0
2014-06-18	AWAY	ETF	32.07	32.77	31.78	32.22	1250613.0
2014-06-18	BAB	ETF	29.19	29.23	29.07	29.07	275952.0
2014-06-18	BAL	ETF	51.78	52.374	51.647	52.2762	9160.0
2014-06-18	BALT	ETF	6.6	6.64	6.48	6.6	392113.0
2014-06-18	BBH	ETF	91.93	92.47	91.18	92.4	66600.0
2014-06-18	BCHP	ETF	20.46	20.47	20.4	20.47	14100.0
2014-06-18	BCM	ETF	41.389	41.39	41.3201	41.378	2897.0
2014-06-18	BFOR	ETF	7.7525	7.79	7.72	7.79	123200.0
2014-06-18	BIB	ETF	43.4	43.8499	42.58	43.835	300108.0
2014-06-18	BICK	ETF	26.58	26.9	26.48	26.8001	31596.0
2014-06-18	BIL	ETF	91.52	91.54	91.52	91.54	205950.0
2014-06-18	BIS	ETF	614.8	622.4	604.0	604.86	10230.0
2014-06-18	BIV	ETF	84.05	84.28	83.93	84.28	300000.0
2014-06-18	BIZD	ETF	20.23	20.34	20.13	20.34	33500.0
2014-06-18	BJK	ETF	48.34	48.59	47.83	48.47	41300.0
2014-06-18	BKF	ETF	38.91	39.54	38.8301	39.54	46747.0
2014-06-18	BKLN	ETF	24.86	24.86	24.8	24.85	2763500.0

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

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