PREVIEW / etf_daily / 2017-04-25

all etf daily files

  file:    by_date/etf_daily/2017/2017-04-25.parquet
  size:    55 KB
  rows:    1,387

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-04-25	SPY	ETF	237.91	238.95	237.81	238.55	76698300.0
2017-04-25	QQQ	ETF	134.58	135.3664	134.48	135.13	19384398.0
2017-04-25	IWM	ETF	140.24	140.88	140.09	140.27	32751700.0
2017-04-25	DIA	ETF	208.95	209.98	208.84	209.68	3483600.0
2017-04-25	GLD	ETF	120.53	120.87	120.05	120.25	10344800.0
2017-04-25	TLT	ETF	122.21	122.46	121.38	121.45	8122300.0
2017-04-25	AADR	ETF	47.59	48.71	47.59	47.9	44300.0
2017-04-25	AAXJ	ETF	64.08	64.28	64.08	64.16	1706800.0
2017-04-25	ACSI	ETF	28.5199	28.5199	28.4599	28.4599	314.0
2017-04-25	ACTX	ETF	90.5658	93.7518	87.9108	89.6808	404.0
2017-04-25	ACWF	ETF	26.3899	26.39	26.3546	26.3546	1839.0
2017-04-25	ACWI	ETF	64.23	64.49	64.22	64.41	2231600.0
2017-04-25	ACWV	ETF	78.25	78.39	78.17	78.25	972800.0
2017-04-25	ACWX	ETF	44.62	44.7699	44.59	44.72	1840543.0
2017-04-25	ADRE	ETF	36.92	37.25	36.92	37.25	20073.0
2017-04-25	AFK	ETF	21.38	21.38	21.15	21.15	11998.0
2017-04-25	AFTY	ETF	13.69	13.74	13.69	13.69	500.0
2017-04-25	AGG	ETF	108.99	109.05	108.77	108.82	1888500.0
2017-04-25	AGGY	ETF	50.1	50.12	49.99	49.99	20900.0
2017-04-25	AGNG	ETF	17.45	17.493	17.413	17.422	1400.0
2017-04-25	AGQ	ETF	38.68	38.99	38.14	38.48	167700.0
2017-04-25	AGZ	ETF	113.35	113.45	113.24	113.29	8398.0
2017-04-25	AGZD	ETF	23.97	23.98	23.97	23.98	800.0
2017-04-25	AIA	ETF	53.41	53.47	53.36	53.37	26363.0
2017-04-25	AIQ	ETF	13.1	13.2403	13.05	13.05	74923.0
2017-04-25	AIRR	ETF	24.62	24.91	24.62	24.77	35400.0
2017-04-25	AIVI	ETF	39.97	40.11	39.97	40.11	6400.0
2017-04-25	ALTY	ETF	15.74	15.74	15.655	15.74	2600.0
2017-04-25	AMJ	ETF	32.07	32.34	31.912	32.32	722815.0
2017-04-25	AMLP	ETF	63.25	63.65	63.0	63.65	1395840.0
2017-04-25	AMZA	ETF	105.3	106.7	105.1	106.7	46580.0
2017-04-25	ANGL	ETF	29.67	29.71	29.62	29.68	1050000.0
2017-04-25	AOA	ETF	50.55	50.69	50.47	50.66	38000.0
2017-04-25	AOK	ETF	33.62	33.625	33.5548	33.57	91116.0
2017-04-25	AOM	ETF	36.63	36.708	36.6201	36.66	174792.0
2017-04-25	AOR	ETF	42.82	42.85	42.7508	42.83	111546.0
2017-04-25	ARCM	ETF	100.0	100.0	100.0	100.0	3500.0
2017-04-25	ARGT	ETF	29.08	29.08	28.88	29.0	37500.0
2017-04-25	ARKG	ETF	20.58	20.61	20.57	20.57	2400.0
2017-04-25	ARKK	ETF	24.91	25.06	24.841	25.02	17500.0
2017-04-25	ARKQ	ETF	25.95	26.04	25.759	26.04	28100.0
2017-04-25	ARKW	ETF	30.31	30.33	30.065	30.33	6800.0
2017-04-25	ASEA	ETF	14.45	14.45	14.41	14.45	1200.0
2017-04-25	ASET	ETF	27.02	27.02	27.02	27.02	730.0
2017-04-25	ASHR	ETF	24.9	24.93	24.86	24.87	351100.0
2017-04-25	ASHS	ETF	32.28	32.39	32.28	32.34	25000.0
2017-04-25	ASHX	ETF	19.33	19.33	19.33	19.33	831.0
2017-04-25	ATMP	ETF	23.39	23.82	23.39	23.82	39600.0
2017-04-25	BAB	ETF	29.46	29.485	29.34	29.37	93951.0
2017-04-25	BAL	ETF	49.75	50.5779	49.75	50.5779	15079.0

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

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