PREVIEW / etf_daily / 2014-11-17

all etf daily files

  file:    by_date/etf_daily/2014/2014-11-17.parquet
  size:    46 KB
  rows:    1,141

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-11-17	SPY	ETF	203.85	204.58	203.65	204.37	80441000.0
2014-11-17	QQQ	ETF	102.98	103.21	102.42	102.91	23361634.0
2014-11-17	IWM	ETF	116.59	116.93	115.68	115.72	29847300.0
2014-11-17	DIA	ETF	176.06	176.76	176.0	176.49	3668900.0
2014-11-17	GLD	ETF	113.97	114.27	113.56	114.05	5441000.0
2014-11-17	TLT	ETF	119.78	119.79	118.88	119.19	4726200.0
2014-11-17	AADR	ETF	37.8	37.8	37.65	37.73	1400.0
2014-11-17	AAXJ	ETF	62.23	62.23	62.03	62.17	1250000.0
2014-11-17	ACWI	ETF	59.49	59.66	59.39	59.62	367100.0
2014-11-17	ACWV	ETF	69.26	69.46	69.21	69.36	66600.0
2014-11-17	ACWX	ETF	44.69	44.84	44.64	44.77	288505.0
2014-11-17	ADRE	ETF	38.24	38.24	38.0	38.08	5331.0
2014-11-17	AFK	ETF	29.14	29.262	29.02	29.21	15873.0
2014-11-17	AGG	ETF	109.96	109.96	109.72	109.73	1403000.0
2014-11-17	AGQ	ETF	40.69	41.06	40.21	40.88	175300.0
2014-11-17	AGZ	ETF	112.66	112.8995	112.66	112.7772	11058.0
2014-11-17	AGZD	ETF	24.82	24.82	24.72	24.79	44200.0
2014-11-17	AIA	ETF	47.8	47.8	47.526	47.71	39049.0
2014-11-17	AIQ	ETF	22.0	22.29	21.955	22.21	22644.0
2014-11-17	AIRR	ETF	18.9	18.9	18.58	18.58	27700.0
2014-11-17	AIVI	ETF	45.47	45.67	45.47	45.65	18300.0
2014-11-17	AMJ	ETF	50.68	51.285	50.55	51.26	1503707.0
2014-11-17	AMLP	ETF	92.3	93.05	91.95	93.05	895120.0
2014-11-17	AMZA	ETF	244.0	246.7	244.0	246.7	530.0
2014-11-17	ANGL	ETF	27.63	27.79	27.6	27.79	3900.0
2014-11-17	AOA	ETF	46.44	46.49	46.37	46.44	58100.0
2014-11-17	AOK	ETF	32.75	32.75	32.6865	32.707	49258.0
2014-11-17	AOM	ETF	35.31	35.31	35.2	35.27	72517.0
2014-11-17	AOR	ETF	40.15	40.16	40.0647	40.101	57127.0
2014-11-17	ARGT	ETF	20.66	20.82	20.66	20.74	5200.0
2014-11-17	ARKG	ETF	19.79	19.79	19.76	19.76	3500.0
2014-11-17	ARKK	ETF	20.59	20.59	20.36	20.41	3400.0
2014-11-17	ARKQ	ETF	20.21	20.22	20.21	20.22	700.0
2014-11-17	ARKW	ETF	20.7	20.7	20.7	20.7	300.0
2014-11-17	ASEA	ETF	16.63	16.7	16.63	16.66	12000.0
2014-11-17	ASHR	ETF	27.54	27.54	27.26	27.43	1185100.0
2014-11-17	ASHS	ETF	34.21	34.21	34.0	34.0	14200.0
2014-11-17	ATMP	ETF	31.67	32.05	31.67	32.05	6800.0
2014-11-17	AVIV	ETF	33.01	33.44	32.86	33.07	561601.0
2014-11-17	AWAY	ETF	30.96	31.03	30.18	30.34	1053559.0
2014-11-17	BAB	ETF	29.82	29.84	29.71	29.78	36359.0
2014-11-17	BAL	ETF	40.37	40.52	40.1701	40.51	31740.0
2014-11-17	BALT	ETF	3.43	3.46	3.3	3.34	903610.0
2014-11-17	BAR	ETF	2.8049	2.8139	2.768	2.8	31710.0
2014-11-17	BBH	ETF	111.9	113.64	111.66	112.25	84100.0
2014-11-17	BCHP	ETF	18.6	18.66	18.6	18.66	736.0
2014-11-17	BCM	ETF	35.3	35.3201	35.3	35.3201	274.0
2014-11-17	BFOR	ETF	7.9075	7.9225	7.875	7.8775	47600.0
2014-11-17	BIB	ETF	56.895	58.815	56.775	57.5	332458.0
2014-11-17	BICK	ETF	24.57	24.5701	24.541	24.541	650.0

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

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