PREVIEW / etf_daily / 2014-10-15

all etf daily files

  file:    by_date/etf_daily/2014/2014-10-15.parquet
  size:    47 KB
  rows:    1,146

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-10-15	SPY	ETF	185.16	187.69	181.92	186.43	380715000.0
2014-10-15	QQQ	ETF	91.55	92.76	90.24	92.37	108847755.0
2014-10-15	IWM	ETF	104.19	107.0	103.54	106.6	117497300.0
2014-10-15	DIA	ETF	161.19	161.85	158.27	161.28	24966700.0
2014-10-15	GLD	ETF	119.23	120.18	118.59	118.99	9453800.0
2014-10-15	TLT	ETF	124.58	127.68	121.84	122.53	37407500.0
2014-10-15	AADR	ETF	34.76	34.77	34.21	34.21	1800.0
2014-10-15	AAXJ	ETF	60.16	60.46	59.21	60.31	537300.0
2014-10-15	ACWI	ETF	55.49	55.84	54.55	55.69	6117400.0
2014-10-15	ACWV	ETF	65.24	65.45	64.24	65.42	175900.0
2014-10-15	ACWX	ETF	42.93	42.99	42.11	42.93	358612.0
2014-10-15	ADRE	ETF	38.84	38.84	37.9601	38.72	16962.0
2014-10-15	AFK	ETF	29.03	29.25	28.5	28.93	68737.0
2014-10-15	AGG	ETF	111.2	112.08	110.63	110.76	2275400.0
2014-10-15	AGQ	ETF	48.07	50.18	47.77	48.18	334400.0
2014-10-15	AGZ	ETF	113.61	114.17	113.33	113.49	21620.0
2014-10-15	AGZD	ETF	24.68	24.785	24.66	24.66	9600.0
2014-10-15	AIA	ETF	45.84	46.07	45.16	45.95	53913.0
2014-10-15	AIQ	ETF	22.44	22.92	21.19	22.55	32804.0
2014-10-15	AIRR	ETF	17.0	17.4	16.62	17.4	91600.0
2014-10-15	AIVI	ETF	43.83	43.94	43.02	43.9	54800.0
2014-10-15	ALTL	ETF	33.3581	33.3581	33.3581	33.3581	228.0
2014-10-15	AMJ	ETF	45.15	47.75	43.8394	47.61	4029638.0
2014-10-15	AMLP	ETF	85.45	89.35	83.75	89.15	3086900.0
2014-10-15	AMZA	ETF	219.4	228.5	219.4	227.4	320.0
2014-10-15	ANGL	ETF	27.29	27.45	27.11	27.16	21800.0
2014-10-15	AOA	ETF	43.52	43.75	42.91	43.66	62400.0
2014-10-15	AOK	ETF	32.01	32.08	31.832	32.02	40315.0
2014-10-15	AOM	ETF	34.15	34.2	33.88	34.15	144839.0
2014-10-15	AOR	ETF	38.22	38.32	37.81	38.29	61367.0
2014-10-15	ARGT	ETF	18.78	18.97	18.4	18.96	29000.0
2014-10-15	ARKQ	ETF	18.59	18.59	18.414	18.414	2900.0
2014-10-15	ARKW	ETF	18.46	18.65	18.441	18.441	3500.0
2014-10-15	ASEA	ETF	16.19	16.22	16.01	16.19	19800.0
2014-10-15	ASHR	ETF	25.59	25.86	25.37	25.8	896700.0
2014-10-15	ASHS	ETF	33.93	33.93	33.5	33.8	7700.0
2014-10-15	ATMP	ETF	27.57	29.07	26.9	29.07	154800.0
2014-10-15	AVIV	ETF	28.42	28.97	28.28	28.63	290882.0
2014-10-15	AWAY	ETF	31.18	31.3664	29.7	30.62	2632185.0
2014-10-15	BAB	ETF	30.33	30.92	30.01	30.27	469013.0
2014-10-15	BAL	ETF	42.64	42.64	42.5201	42.6101	1336.0
2014-10-15	BALT	ETF	3.15	3.52	3.0	3.52	3043508.0
2014-10-15	BAR	ETF	3.25	3.3075	3.223	3.2232	129260.0
2014-10-15	BBH	ETF	97.0	98.67	95.0	98.14	114000.0
2014-10-15	BCHP	ETF	17.54	17.54	17.452	17.452	328.0
2014-10-15	BCM	ETF	35.75	35.751	35.73	35.74	3802.0
2014-10-15	BFOR	ETF	7.0425	7.185	6.9575	7.1475	818400.0
2014-10-15	BIB	ETF	43.095	45.989	42.5	45.47	792510.0
2014-10-15	BICK	ETF	24.2307	24.36	24.2307	24.36	1924.0
2014-10-15	BIL	ETF	91.48	91.5	91.48	91.48	369600.0

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

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