PREVIEW / etf_daily / 2017-02-07

all etf daily files

  file:    by_date/etf_daily/2017/2017-02-07.parquet
  size:    54 KB
  rows:    1,370

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-02-07	SPY	ETF	229.38	229.66	228.72	228.94	57931200.0
2017-02-07	QQQ	ETF	126.06	126.55	125.97	126.29	17541101.0
2017-02-07	IWM	ETF	135.82	136.47	134.77	135.24	30342200.0
2017-02-07	DIA	ETF	200.89	201.3	200.43	200.58	2606300.0
2017-02-07	GLD	ETF	117.31	117.74	117.2	117.46	8621000.0
2017-02-07	TLT	ETF	119.78	121.01	119.47	120.6	8418400.0
2017-02-07	AADR	ETF	45.0	45.0	44.19	44.22	7400.0
2017-02-07	AAXJ	ETF	59.54	59.54	59.27	59.37	383200.0
2017-02-07	ACSI	ETF	27.13	27.13	27.0274	27.06	5655.0
2017-02-07	ACTX	ETF	179.6566	182.9016	125.6711	136.2912	9644.0
2017-02-07	ACWF	ETF	25.9999	25.9999	25.5	25.5196	13437.0
2017-02-07	ACWI	ETF	61.12	61.21	61.01	61.07	1062400.0
2017-02-07	ACWV	ETF	74.3	74.34	74.17	74.3	156900.0
2017-02-07	ACWX	ETF	41.85	41.87	41.78	41.83	554510.0
2017-02-07	ADRE	ETF	35.38	35.38	35.14	35.21	22644.0
2017-02-07	AFK	ETF	21.3	21.59	21.05	21.59	13756.0
2017-02-07	AFTY	ETF	13.74	13.74	13.737	13.74	3900.0
2017-02-07	AGG	ETF	108.3	108.58	108.25	108.43	2659100.0
2017-02-07	AGGY	ETF	49.77	49.85	49.741	49.8	25700.0
2017-02-07	AGQ	ETF	39.31	39.78	39.27	39.47	147000.0
2017-02-07	AGZ	ETF	112.96	113.19	112.9407	112.99	12075.0
2017-02-07	AGZD	ETF	23.965	23.995	23.965	23.975	6000.0
2017-02-07	AIA	ETF	50.01	50.01	49.75	49.76	16533.0
2017-02-07	AIQ	ETF	10.3	10.4	10.2	10.25	14350.0
2017-02-07	AIRR	ETF	24.29	24.29	23.906	24.06	53700.0
2017-02-07	AIVI	ETF	38.11	38.14	38.04	38.13	11300.0
2017-02-07	ALTY	ETF	15.57	15.57	15.344	15.416	5600.0
2017-02-07	AMJ	ETF	33.98	34.1	33.535	33.76	2187477.0
2017-02-07	AMLP	ETF	66.35	66.45	65.75	66.1	2233360.0
2017-02-07	AMZA	ETF	113.9	113.9	111.8	112.9	40670.0
2017-02-07	ANGL	ETF	29.38	29.38	29.33	29.36	921400.0
2017-02-07	AOA	ETF	48.46	48.46	48.35	48.39	50400.0
2017-02-07	AOK	ETF	32.82	32.85	32.7701	32.81	33394.0
2017-02-07	AOM	ETF	35.65	35.72	35.65	35.7	49772.0
2017-02-07	AOR	ETF	41.35	41.35	41.26	41.3	49737.0
2017-02-07	ARGT	ETF	26.57	26.68	26.25	26.39	36200.0
2017-02-07	ARKG	ETF	18.53	18.83	18.209	18.27	2400.0
2017-02-07	ARKK	ETF	22.47	22.556	22.28	22.28	1400.0
2017-02-07	ARKQ	ETF	23.812	23.812	23.69	23.72	3300.0
2017-02-07	ARKW	ETF	27.62	27.81	27.62	27.7	5800.0
2017-02-07	ASET	ETF	25.84	25.86	25.8083	25.8122	3322.0
2017-02-07	ASHR	ETF	24.62	24.7	24.51	24.53	549400.0
2017-02-07	ASHS	ETF	33.36	33.36	33.27	33.32	7600.0
2017-02-07	ATMP	ETF	24.61	24.8	24.34	24.44	69200.0
2017-02-07	BAB	ETF	29.14	29.2667	29.11	29.23	116471.0
2017-02-07	BAL	ETF	49.87	50.14	49.521	49.521	3201.0
2017-02-07	BBC	ETF	20.48	20.5	20.23	20.23	3716.0
2017-02-07	BBH	ETF	116.56	116.88	115.64	116.13	43700.0
2017-02-07	BBP	ETF	36.87	36.87	36.32	36.33	7600.0
2017-02-07	BCM	ETF	27.6	27.65	27.5799	27.65	3292.0

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

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