PREVIEW / etf_daily / 2014-11-20

all etf daily files

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

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-20	SPY	ETF	204.26	205.71	204.18	205.58	72840300.0
2014-11-20	QQQ	ETF	102.77	103.76	102.69	103.67	22874018.0
2014-11-20	IWM	ETF	114.62	116.46	114.62	116.44	26555000.0
2014-11-20	DIA	ETF	176.11	177.28	176.03	177.25	2881700.0
2014-11-20	GLD	ETF	114.57	115.02	114.09	114.86	5607800.0
2014-11-20	TLT	ETF	119.9	119.95	119.06	119.38	5683600.0
2014-11-20	AADR	ETF	37.6	37.6	37.6	37.6	500.0
2014-11-20	AAXJ	ETF	61.61	61.8	61.58	61.69	232700.0
2014-11-20	ACWI	ETF	59.66	59.96	59.5	59.92	578200.0
2014-11-20	ACWV	ETF	69.44	69.64	69.4	69.56	47400.0
2014-11-20	ACWX	ETF	44.74	45.02	44.74	44.94	377345.0
2014-11-20	ADRE	ETF	38.62	38.665	38.3401	38.56	12842.0
2014-11-20	AFK	ETF	28.97	29.04	28.77	28.86	54724.0
2014-11-20	AGG	ETF	109.87	109.93	109.69	109.77	1155800.0
2014-11-20	AGQ	ETF	40.91	41.44	40.64	41.4	162800.0
2014-11-20	AGZ	ETF	113.005	113.15	112.778	112.88	10831.0
2014-11-20	AGZD	ETF	24.75	24.75	24.73	24.73	13800.0
2014-11-20	AIA	ETF	46.98	47.18	46.98	47.08	17893.0
2014-11-20	AIQ	ETF	22.54	22.88	22.54	22.7	9924.0
2014-11-20	AIRR	ETF	18.42	18.7	18.2	18.7	20800.0
2014-11-20	AIVI	ETF	45.51	45.75	45.43	45.62	110200.0
2014-11-20	ALTL	ETF	36.6798	36.6798	36.6798	36.6798	300.0
2014-11-20	AMJ	ETF	52.04	52.6	51.86	52.4	824652.0
2014-11-20	AMLP	ETF	94.0	94.55	93.75	94.3	811620.0
2014-11-20	AMZA	ETF	248.1	250.7	248.1	250.3	540.0
2014-11-20	ANGL	ETF	27.44	27.44	27.33	27.35	1700.0
2014-11-20	AOA	ETF	46.43	46.64	46.43	46.62	25200.0
2014-11-20	AOK	ETF	32.7	32.76	32.7	32.75	55390.0
2014-11-20	AOM	ETF	35.17	35.337	35.17	35.29	69863.0
2014-11-20	AOR	ETF	40.12	40.25	40.12	40.24	72778.0
2014-11-20	ARGT	ETF	20.85	20.98	20.82	20.93	2200.0
2014-11-20	ARKG	ETF	19.86	19.88	19.853	19.88	1200.0
2014-11-20	ARKK	ETF	20.12	20.28	20.1	20.28	1300.0
2014-11-20	ARKQ	ETF	20.12	20.12	20.12	20.12	300.0
2014-11-20	ARKW	ETF	20.34	20.34	20.34	20.34	300.0
2014-11-20	ASEA	ETF	16.81	16.81	16.72	16.72	2600.0
2014-11-20	ASHR	ETF	27.25	27.33	27.2	27.23	369300.0
2014-11-20	ASHS	ETF	34.03	34.06	34.02	34.04	6200.0
2014-11-20	ATMP	ETF	32.71	32.76	32.57	32.65	17300.0
2014-11-20	AVIV	ETF	32.25	32.79	32.25	32.71	464946.0
2014-11-20	AWAY	ETF	29.99	30.57	29.85	30.05	678715.0
2014-11-20	BAB	ETF	29.84	29.86	29.7201	29.801	101967.0
2014-11-20	BAL	ETF	40.46	40.46	40.12	40.2301	1736.0
2014-11-20	BALT	ETF	3.22	3.49	3.22	3.49	670506.0
2014-11-20	BAR	ETF	2.866	2.866	2.819	2.858	31250.0
2014-11-20	BBH	ETF	113.88	115.05	113.81	114.36	81200.0
2014-11-20	BCHP	ETF	18.66	18.66	18.65	18.65	2006.0
2014-11-20	BCM	ETF	35.201	35.201	35.201	35.201	344.0
2014-11-20	BFOR	ETF	7.845	7.93	7.8375	7.915	59200.0
2014-11-20	BIB	ETF	58.95	60.13	58.425	59.46	158038.0

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

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