PREVIEW / etf_daily / 2014-08-08

all etf daily files

  file:    by_date/etf_daily/2014/2014-08-08.parquet
  size:    45 KB
  rows:    1,105

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-08-08	SPY	ETF	191.46	193.37	190.95	193.24	117014000.0
2014-08-08	QQQ	ETF	94.38	95.01	93.97	94.9	40238383.0
2014-08-08	IWM	ETF	111.33	112.4	110.99	112.27	32667200.0
2014-08-08	DIA	ETF	163.67	165.38	163.44	165.34	5412300.0
2014-08-08	GLD	ETF	126.08	126.41	125.89	126.19	5728200.0
2014-08-08	TLT	ETF	115.93	116.42	115.38	115.52	9536700.0
2014-08-08	AADR	ETF	37.46	37.63	37.46	37.63	700.0
2014-08-08	AAXJ	ETF	64.09	64.45	64.03	64.35	1065400.0
2014-08-08	ACWI	ETF	58.42	59.02	58.24	58.99	1923400.0
2014-08-08	ACWV	ETF	65.81	66.24	65.62	66.17	154100.0
2014-08-08	ACWX	ETF	46.21	46.58	46.19	46.57	174261.0
2014-08-08	ADRE	ETF	40.59	40.686	40.39	40.66	41414.0
2014-08-08	AFK	ETF	33.5	33.64	33.36	33.5454	33911.0
2014-08-08	AGG	ETF	109.47	109.63	109.35	109.38	1339200.0
2014-08-08	AGQ	ETF	63.95	64.26	63.32	63.82	118700.0
2014-08-08	AGZ	ETF	112.65	112.73	112.2389	112.2389	8016.0
2014-08-08	AGZD	ETF	24.88	24.925	24.88	24.925	1400.0
2014-08-08	AIA	ETF	49.63	49.78	49.43	49.78	25093.0
2014-08-08	AIQ	ETF	27.66	28.86	27.66	28.39	41489.0
2014-08-08	AIRR	ETF	18.31	18.44	18.16	18.42	81100.0
2014-08-08	AIVI	ETF	48.31	48.66	48.22	48.6	11700.0
2014-08-08	ALTL	ETF	34.61	34.6999	34.49	34.6999	770.0
2014-08-08	AMJ	ETF	50.07	50.43	49.811	50.37	1297261.0
2014-08-08	AMLP	ETF	90.9	91.0	90.05	90.8	513780.0
2014-08-08	ANGL	ETF	27.54	27.75	27.54	27.75	1400.0
2014-08-08	AOA	ETF	45.39	45.68	45.37	45.67	13100.0
2014-08-08	AOK	ETF	32.51	32.57	32.46	32.57	21596.0
2014-08-08	AOM	ETF	34.86	35.05	34.86	35.05	12540.0
2014-08-08	AOR	ETF	39.39	39.55	39.283	39.55	29579.0
2014-08-08	ARGT	ETF	21.52	21.73	21.52	21.71	28000.0
2014-08-08	ASEA	ETF	17.12	17.15	17.08	17.14	7800.0
2014-08-08	ASHR	ETF	24.57	24.74	24.53	24.71	198700.0
2014-08-08	ASHS	ETF	29.56	29.7	29.56	29.7	2100.0
2014-08-08	ATMP	ETF	30.62	30.81	30.19	30.56	15400.0
2014-08-08	AVIV	ETF	27.32	27.71	27.28	27.7	152190.0
2014-08-08	AWAY	ETF	33.4	33.79	33.14	33.52	572998.0
2014-08-08	BAB	ETF	29.66	29.705	29.51	29.539	110728.0
2014-08-08	BAL	ETF	43.134	43.28	42.86	43.13	8151.0
2014-08-08	BALT	ETF	5.06	5.1228	5.0	5.1	320712.0
2014-08-08	BBH	ETF	96.24	97.5	95.86	97.27	59000.0
2014-08-08	BCHP	ETF	19.78	19.89	19.78	19.89	50045.0
2014-08-08	BCM	ETF	39.87	39.87	39.87	39.87	1062.0
2014-08-08	BFOR	ETF	7.54	7.615	7.53	7.615	115200.0
2014-08-08	BIB	ETF	42.925	44.3499	42.86	44.165	349562.0
2014-08-08	BICK	ETF	26.34	26.4	26.34	26.4	720.0
2014-08-08	BIL	ETF	91.52	91.52	91.5	91.5	351600.0
2014-08-08	BIS	ETF	599.6	600.0	578.0	581.2	8735.0
2014-08-08	BIV	ETF	84.92	85.04	84.75	84.8	217200.0
2014-08-08	BIZD	ETF	19.98	20.16	19.98	20.16	11200.0
2014-08-08	BJK	ETF	47.58	48.07	47.34	47.91	7200.0

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

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