PREVIEW / etf_daily / 2014-07-08

all etf daily files

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

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-08	SPY	ETF	197.15	197.22	195.76	196.24	108143000.0
2014-07-08	QQQ	ETF	95.24	95.3	93.87	94.26	40612448.0
2014-07-08	IWM	ETF	117.51	117.7	115.7	116.34	52537600.0
2014-07-08	DIA	ETF	169.58	169.6	168.44	168.85	5438700.0
2014-07-08	GLD	ETF	127.29	127.53	126.43	127.07	6216600.0
2014-07-08	TLT	ETF	112.24	112.86	112.24	112.74	6352100.0
2014-07-08	AADR	ETF	38.97	38.99	38.84	38.95	8100.0
2014-07-08	AAXJ	ETF	63.69	64.0	63.59	63.73	540800.0
2014-07-08	ACWI	ETF	60.64	60.7	60.23	60.36	1163800.0
2014-07-08	ACWV	ETF	67.08	67.16	66.87	66.99	17600.0
2014-07-08	ACWX	ETF	48.22	48.22	47.88	47.99	421803.0
2014-07-08	ADRE	ETF	39.7	39.7	39.41	39.44	7578.0
2014-07-08	AFK	ETF	33.25	33.368	32.92	33.02	14838.0
2014-07-08	AGG	ETF	108.84	108.98	108.84	108.87	2024000.0
2014-07-08	AGQ	ETF	71.52	71.98	70.27	71.21	213100.0
2014-07-08	AGZ	ETF	112.25	112.38	112.231	112.3	15394.0
2014-07-08	AGZD	ETF	24.85	25.01	24.85	24.965	70000.0
2014-07-08	AIA	ETF	48.75	48.75	48.53	48.62	23685.0
2014-07-08	AIQ	ETF	27.9	28.35	27.35	27.96	29719.0
2014-07-08	AIRR	ETF	19.2	19.28	19.12	19.24	33700.0
2014-07-08	AIVI	ETF	50.84	50.84	50.3	50.48	18600.0
2014-07-08	ALTL	ETF	35.4877	35.506	35.4877	35.506	480.0
2014-07-08	AMJ	ETF	51.18	51.3783	50.88	50.99	425509.0
2014-07-08	AMLP	ETF	93.3	93.45	92.75	92.95	743280.0
2014-07-08	ANGL	ETF	28.32	28.32	28.07	28.07	3800.0
2014-07-08	AOA	ETF	46.91	46.93	46.59	46.69	23600.0
2014-07-08	AOK	ETF	32.85	32.92	32.81	32.82	55817.0
2014-07-08	AOM	ETF	35.51	35.51	35.36	35.41	31902.0
2014-07-08	AOR	ETF	40.25	40.25	40.02	40.09	43385.0
2014-07-08	ARGT	ETF	22.5	22.66	22.4	22.65	4700.0
2014-07-08	ASEA	ETF	17.07	17.23	17.07	17.09	8900.0
2014-07-08	ASHR	ETF	22.65	22.65	22.55	22.6	146600.0
2014-07-08	ASHS	ETF	27.05	27.05	26.97	27.01	2000.0
2014-07-08	ATMP	ETF	30.83	30.83	30.71	30.81	117800.0
2014-07-08	AVIV	ETF	27.93	28.042	27.77	27.85	291063.0
2014-07-08	AWAY	ETF	34.12	34.3	31.74	32.12	1526843.0
2014-07-08	BAB	ETF	29.23	29.33	29.19	29.24	283341.0
2014-07-08	BAL	ETF	47.99	48.28	47.22	47.4083	7675.0
2014-07-08	BALT	ETF	5.63	5.63	5.32	5.45	892602.0
2014-07-08	BBH	ETF	97.19	97.19	95.25	95.6	104000.0
2014-07-08	BCHP	ETF	20.7992	20.828	20.7992	20.828	1765.0
2014-07-08	BCM	ETF	41.18	41.19	41.07	41.075	15160.0
2014-07-08	BFOR	ETF	7.8775	7.8775	7.7975	7.8225	144800.0
2014-07-08	BIB	ETF	47.0	47.0	44.49	45.155	997730.0
2014-07-08	BIL	ETF	91.54	91.54	91.52	91.54	230900.0
2014-07-08	BIS	ETF	566.0	588.4	560.0	578.8	14424.5
2014-07-08	BIV	ETF	84.26	84.36	84.24	84.34	234100.0
2014-07-08	BIZD	ETF	20.7	20.7	20.4	20.45	103700.0
2014-07-08	BJK	ETF	51.17	51.17	50.14	50.3	23700.0
2014-07-08	BKF	ETF	39.51	39.51	39.08	39.18	55317.0

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

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