PREVIEW / etf_daily / 2017-02-10

all etf daily files

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

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-10	SPY	ETF	231.0	231.77	230.62	231.51	66015900.0
2017-02-10	QQQ	ETF	127.2	127.56	127.02	127.38	13915697.0
2017-02-10	IWM	ETF	137.79	138.37	137.2	137.94	27287600.0
2017-02-10	DIA	ETF	202.3	203.0	202.07	202.74	2880300.0
2017-02-10	GLD	ETF	116.68	117.86	116.67	117.6	9072100.0
2017-02-10	TLT	ETF	120.11	120.95	120.11	120.76	7978500.0
2017-02-10	AADR	ETF	44.92	45.27	44.77	45.07	9200.0
2017-02-10	AAXJ	ETF	60.04	60.28	59.94	60.22	374100.0
2017-02-10	ACSI	ETF	27.59	27.67	27.5899	27.64	4112.0
2017-02-10	ACTX	ETF	130.3912	143.9613	118.0011	139.2413	5503.0
2017-02-10	ACWI	ETF	61.58	61.82	61.57	61.73	1650000.0
2017-02-10	ACWV	ETF	74.85	75.01	74.69	74.99	144000.0
2017-02-10	ACWX	ETF	42.16	42.36	42.15	42.32	405029.0
2017-02-10	ADRE	ETF	35.74	36.0	35.74	35.974	9666.0
2017-02-10	AFK	ETF	21.36	21.724	21.36	21.4509	12196.0
2017-02-10	AFTY	ETF	13.864	13.91	13.864	13.91	1600.0
2017-02-10	AGG	ETF	108.26	108.47	108.26	108.46	2365300.0
2017-02-10	AGGY	ETF	49.69	49.802	49.69	49.791	2200.0
2017-02-10	AGQ	ETF	39.2	40.75	39.2	40.49	314600.0
2017-02-10	AGZ	ETF	112.95	113.0	112.5	112.873	15616.0
2017-02-10	AGZD	ETF	24.09	24.11	24.0	24.01	5200.0
2017-02-10	AIA	ETF	50.12	50.2799	50.0288	50.23	7266.0
2017-02-10	AIQ	ETF	10.35	10.4	10.25	10.4	6943.0
2017-02-10	AIRR	ETF	24.24	24.31	24.113	24.269	65100.0
2017-02-10	AIVI	ETF	38.34	38.59	38.34	38.55	45000.0
2017-02-10	ALTY	ETF	15.515	15.515	15.515	15.515	200.0
2017-02-10	AMJ	ETF	34.16	34.2	33.825	33.96	2061054.0
2017-02-10	AMLP	ETF	65.35	65.5	64.95	65.2	1225100.0
2017-02-10	AMZA	ETF	114.5	114.5	112.96	113.1	46530.0
2017-02-10	ANGL	ETF	29.37	29.4	29.3	29.39	293900.0
2017-02-10	AOA	ETF	48.75	48.86	48.71	48.85	48400.0
2017-02-10	AOK	ETF	32.96	33.0	32.8904	33.0	33122.0
2017-02-10	AOM	ETF	35.86	35.93	35.8	35.93	76722.0
2017-02-10	AOR	ETF	41.5	41.6228	41.5	41.61	67015.0
2017-02-10	ARGT	ETF	26.73	26.93	26.69	26.87	94500.0
2017-02-10	ARKG	ETF	18.85	18.989	18.85	18.989	3100.0
2017-02-10	ARKK	ETF	22.99	23.02	22.94	22.97	4000.0
2017-02-10	ARKQ	ETF	24.51	24.51	24.34	24.409	14100.0
2017-02-10	ARKW	ETF	28.5	28.5	28.17	28.25	8700.0
2017-02-10	ASEA	ETF	13.7	13.7	13.7	13.7	3500.0
2017-02-10	ASET	ETF	26.09	26.24	26.085	26.23	9935.0
2017-02-10	ASHR	ETF	24.86	24.91	24.84	24.9	486600.0
2017-02-10	ASHS	ETF	33.57	33.66	33.56	33.56	11400.0
2017-02-10	ASHX	ETF	19.38	19.42	19.38	19.41	1501.0
2017-02-10	ATMP	ETF	25.2	25.2	24.58	24.6	44800.0
2017-02-10	BAB	ETF	29.19	29.35	29.19	29.31	204491.0
2017-02-10	BAL	ETF	50.17	50.32	50.04	50.1208	12059.0
2017-02-10	BBC	ETF	20.7934	21.048	20.7311	20.82	7232.0
2017-02-10	BBH	ETF	117.0	117.1	116.43	116.64	28900.0
2017-02-10	BBP	ETF	37.35	37.55	37.1	37.11	24400.0

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

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