PREVIEW / etf_daily / 2014-09-16

all etf daily files

  file:    by_date/etf_daily/2014/2014-09-16.parquet
  size:    45 KB
  rows:    1,120

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-09-16	SPY	ETF	198.61	200.84	198.5	200.48	116201000.0
2014-09-16	QQQ	ETF	98.16	99.57	98.05	99.38	38166920.0
2014-09-16	IWM	ETF	113.78	114.76	113.4	114.43	51365900.0
2014-09-16	DIA	ETF	169.96	171.71	169.89	171.38	5946400.0
2014-09-16	GLD	ETF	118.85	119.43	118.44	118.83	6544500.0
2014-09-16	TLT	ETF	113.61	113.86	113.08	113.09	9304700.0
2014-09-16	AADR	ETF	38.07	38.44	38.07	38.44	14000.0
2014-09-16	AAXJ	ETF	63.61	64.71	63.5	64.36	1288700.0
2014-09-16	ACWI	ETF	59.91	60.54	59.85	60.43	1052700.0
2014-09-16	ACWV	ETF	67.26	67.9	67.08	67.68	79300.0
2014-09-16	ACWX	ETF	46.76	47.34	46.76	47.24	419621.0
2014-09-16	ADRE	ETF	41.65	42.61	41.65	42.32	19642.0
2014-09-16	AFK	ETF	31.95	32.5324	31.93	32.42	33336.0
2014-09-16	AGG	ETF	108.7	108.77	108.61	108.61	851000.0
2014-09-16	AGQ	ETF	55.81	56.8	55.08	55.74	167000.0
2014-09-16	AGZ	ETF	112.19	112.42	112.19	112.32	11038.0
2014-09-16	AGZD	ETF	24.89	24.9	24.845	24.9	15600.0
2014-09-16	AIA	ETF	49.2	49.9233	49.2	49.67	116564.0
2014-09-16	AIQ	ETF	25.55	25.94	24.8	25.02	35507.0
2014-09-16	AIRR	ETF	19.31	19.31	19.054	19.21	17800.0
2014-09-16	AIVI	ETF	48.45	48.84	48.31	48.76	6500.0
2014-09-16	ALTL	ETF	36.14	36.14	36.14	36.14	177.0
2014-09-16	AMJ	ETF	52.36	53.13	52.25	52.87	974167.0
2014-09-16	AMLP	ETF	94.35	95.6	94.25	95.25	581980.0
2014-09-16	ANGL	ETF	27.89	28.06	27.81	27.83	1300.0
2014-09-16	AOA	ETF	46.29	46.78	46.29	46.67	21500.0
2014-09-16	AOK	ETF	32.58	32.7399	32.58	32.69	29358.0
2014-09-16	AOM	ETF	35.24	35.39	35.21	35.35	45979.0
2014-09-16	AOR	ETF	39.9	40.18	39.85	40.13	34088.0
2014-09-16	ARGT	ETF	21.63	22.06	21.5	22.06	18200.0
2014-09-16	ASEA	ETF	16.96	17.12	16.91	17.08	13200.0
2014-09-16	ASHR	ETF	25.01	25.5	25.0	25.42	1158500.0
2014-09-16	ASHS	ETF	31.77	32.11	31.43	32.09	30700.0
2014-09-16	ATMP	ETF	31.69	32.21	31.0	32.15	37500.0
2014-09-16	AVIV	ETF	27.28	27.57	27.18	27.55	115269.0
2014-09-16	AWAY	ETF	32.81	33.26	32.49	33.02	683342.0
2014-09-16	BAB	ETF	29.42	29.4722	29.3	29.3	189625.0
2014-09-16	BAL	ETF	43.99	44.1325	43.825	44.04	9567.0
2014-09-16	BALT	ETF	5.45	5.61	5.41	5.47	233206.0
2014-09-16	BAR	ETF	3.253	3.284	3.226	3.284	10660.0
2014-09-16	BBH	ETF	102.23	105.19	102.23	105.08	161300.0
2014-09-16	BCHP	ETF	19.901	19.92	19.901	19.92	400.0
2014-09-16	BCM	ETF	37.86	37.86	37.86	37.86	231.0
2014-09-16	BFOR	ETF	7.75	7.835	7.745	7.815	136800.0
2014-09-16	BIB	ETF	48.36	51.25	48.36	51.0	418034.0
2014-09-16	BIL	ETF	91.52	91.52	91.5	91.5	115400.0
2014-09-16	BIS	ETF	524.0	524.0	492.004	495.2	13299.5
2014-09-16	BIV	ETF	83.94	84.05	83.88	83.89	283200.0
2014-09-16	BIZD	ETF	20.25	20.28	20.21	20.25	11000.0
2014-09-16	BJK	ETF	44.44	44.84	43.98	44.84	28400.0

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

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