PREVIEW / etf_daily / 2014-07-18

all etf daily files

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

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-18	SPY	ETF	196.35	197.91	196.24	197.71	124330000.0
2014-07-18	QQQ	ETF	95.14	96.17	95.0	96.12	36690832.0
2014-07-18	IWM	ETF	112.69	114.45	112.46	114.23	46164100.0
2014-07-18	DIA	ETF	169.95	170.76	169.74	170.58	6924600.0
2014-07-18	GLD	ETF	125.79	126.21	125.67	126.13	6460900.0
2014-07-18	TLT	ETF	114.88	114.96	114.11	114.52	6677900.0
2014-07-18	AADR	ETF	38.61	38.61	38.56	38.6	800.0
2014-07-18	AAXJ	ETF	63.8	63.91	63.7	63.84	261000.0
2014-07-18	ACWI	ETF	60.36	60.69	60.23	60.61	591400.0
2014-07-18	ACWV	ETF	67.13	67.49	66.9	67.42	36800.0
2014-07-18	ACWX	ETF	47.75	48.11	47.75	48.07	524904.0
2014-07-18	ADRE	ETF	40.27	40.68	40.257	40.56	10782.0
2014-07-18	AFK	ETF	33.16	33.58	33.0223	33.58	17353.0
2014-07-18	AGG	ETF	109.28	109.33	109.18	109.22	543600.0
2014-07-18	AGQ	ETF	69.9	70.17	68.97	69.81	191700.0
2014-07-18	AGZ	ETF	112.35	113.0299	112.35	112.5	11220.0
2014-07-18	AGZD	ETF	24.975	24.975	24.975	24.975	200.0
2014-07-18	AIA	ETF	48.92	48.95	48.78	48.83	12213.0
2014-07-18	AIQ	ETF	27.96	28.97	27.96	28.79	158091.0
2014-07-18	AIRR	ETF	18.48	18.7	18.48	18.69	17300.0
2014-07-18	AIVI	ETF	50.11	50.58	50.11	50.5	18400.0
2014-07-18	ALTL	ETF	35.6399	35.6399	35.6399	35.6399	632.0
2014-07-18	AMJ	ETF	51.88	52.2	51.855	52.0	212144.0
2014-07-18	AMLP	ETF	94.75	94.9	94.5	94.7	404300.0
2014-07-18	ANGL	ETF	28.15	28.17	28.04	28.17	3200.0
2014-07-18	AOA	ETF	46.41	46.77	46.41	46.77	14300.0
2014-07-18	AOK	ETF	32.8099	32.9	32.8001	32.89	44915.0
2014-07-18	AOM	ETF	35.23	35.46	35.23	35.46	71549.0
2014-07-18	AOR	ETF	39.93	40.17	39.93	40.17	20946.0
2014-07-18	ARGT	ETF	22.66	23.15	22.56	23.14	36700.0
2014-07-18	ASEA	ETF	17.23	17.35	17.23	17.3	41600.0
2014-07-18	ASHR	ETF	22.6	22.71	22.6	22.62	37200.0
2014-07-18	ASHS	ETF	27.48	27.48	27.33	27.36	2600.0
2014-07-18	ATMP	ETF	31.47	31.59	31.46	31.55	25000.0
2014-07-18	AVIV	ETF	28.08	28.44	28.07	28.4	264865.0
2014-07-18	AWAY	ETF	31.98	33.2	31.884	33.16	832736.0
2014-07-18	BAB	ETF	29.47	29.47	29.35	29.41	75211.0
2014-07-18	BAL	ETF	45.52	45.6499	45.4999	45.6499	3518.0
2014-07-18	BALT	ETF	5.26	5.49	5.26	5.44	313476.0
2014-07-18	BBH	ETF	92.26	94.88	91.84	94.6	107300.0
2014-07-18	BCM	ETF	40.46	40.46	40.35	40.35	6500.0
2014-07-18	BFOR	ETF	7.71	7.7825	7.71	7.77	68400.0
2014-07-18	BIB	ETF	42.0	44.18	41.69	43.96	535294.0
2014-07-18	BICK	ETF	26.47	26.47	26.47	26.47	548.0
2014-07-18	BIL	ETF	91.52	91.52	91.5	91.5	99150.0
2014-07-18	BIS	ETF	624.8	626.592	586.4	591.2	22513.0
2014-07-18	BIV	ETF	84.86	84.86	84.64	84.69	402300.0
2014-07-18	BIZD	ETF	20.39	20.45	20.32	20.4	7000.0
2014-07-18	BJK	ETF	49.16	49.64	49.16	49.42	14700.0
2014-07-18	BKF	ETF	39.35	39.66	39.35	39.52	31678.0

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

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