PREVIEW / etf_daily / 2014-10-24

all etf daily files

  file:    by_date/etf_daily/2014/2014-10-24.parquet
  size:    46 KB
  rows:    1,137

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-24	SPY	ETF	195.25	196.49	194.49	196.43	117927000.0
2014-10-24	QQQ	ETF	97.965	98.69	97.64	98.62	43161724.0
2014-10-24	IWM	ETF	110.92	111.32	110.44	111.07	41927400.0
2014-10-24	DIA	ETF	166.6	167.79	166.17	167.74	5733500.0
2014-10-24	GLD	ETF	118.62	118.63	118.12	118.35	3610600.0
2014-10-24	TLT	ETF	119.93	120.41	119.47	119.72	5704900.0
2014-10-24	AAXJ	ETF	61.15	61.63	61.15	61.49	2054500.0
2014-10-24	ACWI	ETF	57.72	58.1	57.66	58.08	929000.0
2014-10-24	ACWV	ETF	67.25	67.59	67.1	67.54	36400.0
2014-10-24	ACWX	ETF	44.09	44.23	43.96	44.23	299572.0
2014-10-24	ADRE	ETF	37.91	38.7532	37.91	38.64	6688.0
2014-10-24	AFK	ETF	29.5	29.61	29.4	29.6	15453.0
2014-10-24	AGG	ETF	110.27	110.35	110.15	110.27	1188900.0
2014-10-24	AGQ	ETF	47.47	47.49	46.39	46.56	158200.0
2014-10-24	AGZ	ETF	113.31	113.47	113.03	113.18	12382.0
2014-10-24	AGZD	ETF	24.895	24.895	24.68	24.68	6800.0
2014-10-24	AIA	ETF	46.57	46.7895	46.54	46.69	10446.0
2014-10-24	AIQ	ETF	22.75	22.93	22.2	22.37	22095.0
2014-10-24	AIRR	ETF	18.18	18.31	18.18	18.31	17200.0
2014-10-24	AIVI	ETF	45.2	45.2	44.87	44.99	26700.0
2014-10-24	AMJ	ETF	51.12	51.47	50.79	51.2	893613.0
2014-10-24	AMLP	ETF	93.4	94.1	93.2	93.8	759880.0
2014-10-24	AMZA	ETF	241.9	244.7	241.9	243.9	1080.0
2014-10-24	ANGL	ETF	27.46	27.86	27.46	27.82	2300.0
2014-10-24	AOA	ETF	45.13	45.35	45.13	45.35	27700.0
2014-10-24	AOK	ETF	32.45	32.45	32.393	32.44	24816.0
2014-10-24	AOM	ETF	34.82	34.86	34.72	34.85	61431.0
2014-10-24	AOR	ETF	39.28	39.39	39.21	39.39	39295.0
2014-10-24	ARGT	ETF	19.83	19.94	19.83	19.94	2200.0
2014-10-24	ARKQ	ETF	19.4	19.4	19.38	19.4	2800.0
2014-10-24	ARKW	ETF	19.72	19.73	19.72	19.73	3600.0
2014-10-24	ASEA	ETF	16.5	16.55	16.5	16.55	4100.0
2014-10-24	ASHR	ETF	25.25	25.28	25.2	25.24	273800.0
2014-10-24	ASHS	ETF	32.78	32.82	32.76	32.76	7500.0
2014-10-24	ATMP	ETF	31.2	31.41	31.14	31.37	34100.0
2014-10-24	AVIV	ETF	29.2	29.33	28.63	29.06	151365.0
2014-10-24	AWAY	ETF	33.39	33.8	33.0	33.76	643125.0
2014-10-24	BAB	ETF	29.88	29.96	29.8101	29.92	70087.0
2014-10-24	BAL	ETF	42.45	43.25	42.379	42.74	7760.0
2014-10-24	BALT	ETF	3.79	3.8	3.62	3.79	718645.0
2014-10-24	BAR	ETF	3.193	3.1933	3.17	3.1933	4030.0
2014-10-24	BBH	ETF	109.61	111.86	109.5	111.82	254000.0
2014-10-24	BFOR	ETF	7.53	7.5575	7.4875	7.555	105600.0
2014-10-24	BIB	ETF	55.795	57.565	55.225	57.535	701076.0
2014-10-24	BICK	ETF	24.3801	24.44	24.3801	24.44	699.0
2014-10-24	BIL	ETF	91.48	91.5	91.48	91.48	197200.0
2014-10-24	BIS	ETF	437.6	438.804	423.28	424.0	14510.5
2014-10-24	BIV	ETF	85.37	85.51	85.28	85.34	409000.0
2014-10-24	BIZD	ETF	18.99	19.07	18.97	19.03	8300.0
2014-10-24	BJK	ETF	44.11	44.31	44.11	44.25	2000.0

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

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