PREVIEW / etf_daily / 2017-05-24

all etf daily files

  file:    by_date/etf_daily/2017/2017-05-24.parquet
  size:    55 KB
  rows:    1,385

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
2017-05-24	SPY	ETF	240.32	240.73	239.93	240.61	46927700.0
2017-05-24	QQQ	ETF	139.56	139.85	139.17	139.78	18323864.0
2017-05-24	IWM	ETF	137.51	138.03	136.83	137.49	21256000.0
2017-05-24	DIA	ETF	209.32	209.96	209.08	209.82	3479500.0
2017-05-24	GLD	ETF	119.07	119.74	118.92	119.61	7025000.0
2017-05-24	TLT	ETF	122.8	123.26	122.54	123.23	7355200.0
2017-05-24	AADR	ETF	47.19	47.89	47.19	47.58	24400.0
2017-05-24	AAXJ	ETF	66.43	66.55	66.33	66.48	1100500.0
2017-05-24	ACSI	ETF	28.3675	28.45	28.3675	28.44	11081.0
2017-05-24	ACTX	ETF	52.8055	54.2805	41.3004	46.6104	1320.0
2017-05-24	ACWF	ETF	26.75	26.92	26.75	26.92	4099.0
2017-05-24	ACWI	ETF	65.48	65.7	65.47	65.67	962700.0
2017-05-24	ACWV	ETF	79.23	79.52	79.17	79.52	168100.0
2017-05-24	ACWX	ETF	45.95	46.09	45.9	46.09	220128.0
2017-05-24	ADRE	ETF	38.22	38.22	38.0	38.22	8925.0
2017-05-24	AFK	ETF	21.81	21.89	21.6911	21.79	9155.0
2017-05-24	AFTY	ETF	14.14	14.18	14.14	14.18	5100.0
2017-05-24	AGG	ETF	109.25	109.5	109.21	109.43	2719200.0
2017-05-24	AGGY	ETF	50.24	50.41	50.24	50.382	17900.0
2017-05-24	AGNG	ETF	17.958	18.109	17.958	18.109	1700.0
2017-05-24	AGQ	ETF	35.79	36.46	35.69	36.39	133200.0
2017-05-24	AGZ	ETF	113.5	113.65	113.293	113.52	10858.0
2017-05-24	AGZD	ETF	24.015	24.05	23.915	23.945	72200.0
2017-05-24	AIA	ETF	56.07	56.2158	56.04	56.19	36697.0
2017-05-24	AIQ	ETF	13.25	13.25	13.15	13.15	41041.0
2017-05-24	AIRR	ETF	23.27	23.344	23.04	23.18	123600.0
2017-05-24	AIVI	ETF	41.93	42.04	41.87	42.04	17800.0
2017-05-24	ALTY	ETF	15.48	15.58	15.44	15.46	13700.0
2017-05-24	AMJ	ETF	31.27	31.4	31.03	31.09	1320263.0
2017-05-24	AMLP	ETF	61.75	61.9	61.35	61.55	1813580.0
2017-05-24	AMZA	ETF	105.5	105.52	104.6	104.7	59500.0
2017-05-24	ANGL	ETF	29.78	29.8	29.74	29.79	322900.0
2017-05-24	AOA	ETF	51.35	51.48	51.29	51.48	39500.0
2017-05-24	AOK	ETF	33.78	33.91	33.78	33.84	65777.0
2017-05-24	AOM	ETF	37.05	37.11	36.9701	37.04	71429.0
2017-05-24	AOR	ETF	43.31	43.42	43.2821	43.38	69191.0
2017-05-24	ARCM	ETF	100.05	100.05	100.05	100.05	20.0
2017-05-24	ARGT	ETF	30.26	30.49	30.2	30.43	47900.0
2017-05-24	ARKG	ETF	20.958	21.03	20.867	20.99	36000.0
2017-05-24	ARKK	ETF	27.55	28.26	27.55	28.26	99000.0
2017-05-24	ARKQ	ETF	28.47	28.5	28.37	28.47	56800.0
2017-05-24	ARKW	ETF	33.6	34.75	33.6	34.716	115000.0
2017-05-24	ASEA	ETF	15.07	15.07	14.92	15.0	24400.0
2017-05-24	ASET	ETF	27.3261	27.385	27.32	27.385	1341.0
2017-05-24	ASHR	ETF	24.78	24.87	24.72	24.82	482500.0
2017-05-24	ASHS	ETF	30.42	30.5	30.42	30.5	7300.0
2017-05-24	ASHX	ETF	19.19	19.27	19.19	19.27	2973.0
2017-05-24	ATMP	ETF	23.07	23.17	22.87	22.97	53800.0
2017-05-24	BAB	ETF	29.79	29.86	29.7	29.86	183124.0
2017-05-24	BAL	ETF	49.75	49.9	49.21	49.21	1915.0

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

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