PREVIEW / etf_daily / 2017-10-11

all etf daily files

  file:    by_date/etf_daily/2017/2017-10-11.parquet
  size:    57 KB
  rows:    1,453

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-10-11	SPY	ETF	254.51	255.02	254.32	255.02	47674300.0
2017-10-11	QQQ	ETF	147.53	148.07	147.34	148.04	12439051.0
2017-10-11	IWM	ETF	149.94	150.19	149.46	149.75	15137100.0
2017-10-11	DIA	ETF	228.32	228.64	228.17	228.61	1423600.0
2017-10-11	GLD	ETF	122.57	122.88	122.03	122.79	5649400.0
2017-10-11	TLT	ETF	124.57	124.66	124.26	124.42	4385900.0
2017-10-11	AADR	ETF	56.95	57.18	56.72	56.76	69600.0
2017-10-11	AAXJ	ETF	74.29	74.65	74.21	74.61	1174400.0
2017-10-11	ACSI	ETF	29.4899	29.49	29.44	29.449	2521.0
2017-10-11	ACTX	ETF	59.0005	60.1805	55.4605	59.5905	250.0
2017-10-11	ACWF	ETF	29.58	29.58	29.5572	29.5572	295.0
2017-10-11	ACWI	ETF	69.7	69.84	69.65	69.84	1111900.0
2017-10-11	ACWV	ETF	82.24	82.44	82.24	82.44	180500.0
2017-10-11	ACWX	ETF	48.96	49.11	48.95	49.09	155871.0
2017-10-11	ADRE	ETF	43.19	43.3	43.07	43.29	8522.0
2017-10-11	AFK	ETF	23.8	23.96	23.13	23.69	12261.0
2017-10-11	AFTY	ETF	17.41	17.41	17.369	17.39	4900.0
2017-10-11	AGG	ETF	109.47	109.53	109.42	109.46	1866400.0
2017-10-11	AGGY	ETF	50.74	50.78	50.72	50.76	4800.0
2017-10-11	AGNG	ETF	19.557	19.578	19.52	19.52	2900.0
2017-10-11	AGQ	ETF	35.16	35.47	34.8	35.41	71100.0
2017-10-11	AGZ	ETF	113.53	113.54	113.4698	113.47	15507.0
2017-10-11	AGZD	ETF	24.01	24.055	24.005	24.05	6600.0
2017-10-11	AIA	ETF	63.44	63.77	63.3803	63.74	64318.0
2017-10-11	AIRR	ETF	26.22	26.22	26.0	26.04	18700.0
2017-10-11	AIVI	ETF	42.9	42.96	42.83	42.96	3700.0
2017-10-11	ALTY	ETF	15.81	15.81	15.7	15.746	4600.0
2017-10-11	AMJ	ETF	28.46	28.65	28.44	28.64	1983506.0
2017-10-11	AMLP	ETF	56.75	57.1	56.6	57.05	865380.0
2017-10-11	AMZA	ETF	89.7	90.1	89.3	90.0	55100.0
2017-10-11	ANGL	ETF	30.25	30.26	30.2	30.2	251700.0
2017-10-11	AOA	ETF	53.98	54.09	53.97	54.09	39900.0
2017-10-11	AOK	ETF	34.57	34.59	34.5001	34.59	38017.0
2017-10-11	AOM	ETF	38.04	38.1224	38.0014	38.07	119665.0
2017-10-11	AOR	ETF	45.07	45.11	45.0051	45.11	63656.0
2017-10-11	ARGT	ETF	32.45	32.57	32.37	32.44	29200.0
2017-10-11	ARKG	ETF	26.79	26.79	26.6	26.65	34300.0
2017-10-11	ARKK	ETF	34.86	34.9	34.69	34.81	93100.0
2017-10-11	ARKQ	ETF	32.66	32.73	32.501	32.63	76100.0
2017-10-11	ARKW	ETF	41.41	41.48	41.28	41.44	31500.0
2017-10-11	ASEA	ETF	15.83	15.89	15.77	15.89	2800.0
2017-10-11	ASET	ETF	28.3	28.325	28.3	28.325	478.0
2017-10-11	ASHR	ETF	30.06	30.18	30.0	30.17	996600.0
2017-10-11	ASHS	ETF	37.14	37.14	36.92	37.11	4500.0
2017-10-11	ATMP	ETF	21.5	21.7	21.5	21.69	149300.0
2017-10-11	BAB	ETF	30.44	30.44	30.3486	30.41	78581.0
2017-10-11	BAL	ETF	45.24	45.48	45.24	45.48	1556.0
2017-10-11	BAR	ETF	12.906	12.935	12.906	12.928	159550.0
2017-10-11	BBC	ETF	29.94	29.94	29.7	29.704	4519.0
2017-10-11	BBH	ETF	135.62	135.7	135.22	135.7	8400.0

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

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