PREVIEW / etf_daily / 2014-07-14

all etf daily files

  file:    by_date/etf_daily/2014/2014-07-14.parquet
  size:    45 KB
  rows:    1,101

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-07-14	SPY	ETF	197.61	197.86	197.44	197.6	58658000.0
2014-07-14	QQQ	ETF	95.7	96.055	95.535	95.84	19579041.0
2014-07-14	IWM	ETF	116.42	116.46	115.4	115.69	28823400.0
2014-07-14	DIA	ETF	170.15	170.61	170.04	170.29	2831200.0
2014-07-14	GLD	ETF	125.5	126.1	125.45	125.72	11465500.0
2014-07-14	TLT	ETF	113.28	113.41	112.93	113.09	4743300.0
2014-07-14	AADR	ETF	39.14	39.14	38.99	38.99	4000.0
2014-07-14	AAXJ	ETF	63.68	63.85	63.68	63.79	404900.0
2014-07-14	ACWI	ETF	60.74	60.76	60.58	60.59	516400.0
2014-07-14	ACWV	ETF	67.41	67.53	67.27	67.36	30100.0
2014-07-14	ACWX	ETF	48.2	48.2	48.05	48.08	291390.0
2014-07-14	ADRE	ETF	40.03	40.41	40.03	40.38	9043.0
2014-07-14	AFK	ETF	33.11	33.26	33.0	33.24	22459.0
2014-07-14	AGG	ETF	109.11	109.13	109.0	109.07	710400.0
2014-07-14	AGQ	ETF	70.28	70.65	69.76	70.35	441400.0
2014-07-14	AGZ	ETF	112.32	112.43	112.32	112.3477	4060.0
2014-07-14	AGZD	ETF	25.0	25.06	25.0	25.03	23000.0
2014-07-14	AIA	ETF	48.81	48.83	48.75	48.76	8009.0
2014-07-14	AIQ	ETF	29.14	29.23	28.21	28.37	38314.0
2014-07-14	AIRR	ETF	18.98	18.99	18.92	18.92	6900.0
2014-07-14	AIVI	ETF	50.38	50.48	50.32	50.34	38300.0
2014-07-14	AMJ	ETF	51.67	51.93	51.43	51.56	184872.0
2014-07-14	AMLP	ETF	94.0	94.2	93.65	93.85	463820.0
2014-07-14	ANGL	ETF	28.03	28.2	28.02	28.2	5200.0
2014-07-14	AOA	ETF	46.91	46.91	46.77	46.79	25600.0
2014-07-14	AOK	ETF	32.95	32.95	32.87	32.9	17370.0
2014-07-14	AOM	ETF	35.53	35.53	35.43	35.46	22455.0
2014-07-14	AOR	ETF	40.27	40.27	40.15	40.15	29598.0
2014-07-14	ARGT	ETF	23.67	23.67	23.2	23.26	40300.0
2014-07-14	ASEA	ETF	17.16	17.26	17.16	17.24	6600.0
2014-07-14	ASHR	ETF	22.8	22.82	22.66	22.73	86000.0
2014-07-14	ASHS	ETF	27.67	27.67	27.46	27.55	7100.0
2014-07-14	ATMP	ETF	31.48	31.48	31.12	31.15	34500.0
2014-07-14	AVIV	ETF	28.0	28.0	27.81	27.9	283098.0
2014-07-14	AWAY	ETF	33.42	33.5499	32.85	32.9	878494.0
2014-07-14	BAB	ETF	29.33	29.4062	29.3	29.35	295290.0
2014-07-14	BAL	ETF	45.87	46.42	45.82	46.19	11376.0
2014-07-14	BALT	ETF	5.48	5.48	5.3	5.3	337598.0
2014-07-14	BBH	ETF	97.81	97.84	96.9	97.3	92100.0
2014-07-14	BCHP	ETF	20.91	20.91	20.75	20.75	2724.0
2014-07-14	BCM	ETF	40.52	40.59	40.47	40.59	9700.0
2014-07-14	BFOR	ETF	7.815	7.8425	7.81	7.815	200000.0
2014-07-14	BIB	ETF	47.42	47.42	46.35	46.815	421248.0
2014-07-14	BICK	ETF	26.4	26.42	26.35	26.35	1338.0
2014-07-14	BIL	ETF	91.52	91.52	91.5	91.52	137450.0
2014-07-14	BIS	ETF	557.2	565.2	552.0	560.0	5098.0
2014-07-14	BIV	ETF	84.54	84.54	84.43	84.5	159700.0
2014-07-14	BIZD	ETF	20.55	20.61	20.39	20.55	27400.0
2014-07-14	BJK	ETF	50.12	50.25	49.79	49.79	5400.0
2014-07-14	BKF	ETF	39.3	39.61	39.3	39.55	80326.0

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

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