PREVIEW / etf_daily / 2017-07-13

all etf daily files

  file:    by_date/etf_daily/2017/2017-07-13.parquet
  size:    56 KB
  rows:    1,427

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-07-13	SPY	ETF	244.02	244.55	243.76	244.42	39471600.0
2017-07-13	QQQ	ETF	140.85	141.35	140.6	141.01	31073595.0
2017-07-13	IWM	ETF	141.2	141.56	140.38	141.49	16559300.0
2017-07-13	DIA	ETF	215.3	215.56	215.0	215.46	1587400.0
2017-07-13	GLD	ETF	116.04	116.04	115.67	115.82	4148900.0
2017-07-13	TLT	ETF	123.6	123.65	122.81	123.18	7449300.0
2017-07-13	AADR	ETF	48.55	48.55	47.73	48.38	25900.0
2017-07-13	AAXJ	ETF	69.37	69.56	69.3	69.53	2400700.0
2017-07-13	ACSI	ETF	28.65	28.7	28.65	28.7	12200.0
2017-07-13	ACTX	ETF	76.1107	90.8608	76.1107	82.6007	124.0
2017-07-13	ACWF	ETF	27.7686	27.819	27.72	27.72	2000.0
2017-07-13	ACWI	ETF	66.24	66.36	66.14	66.33	1474700.0
2017-07-13	ACWV	ETF	79.09	79.09	78.84	79.05	185600.0
2017-07-13	ACWX	ETF	46.23	46.3699	46.1956	46.34	516985.0
2017-07-13	ADRE	ETF	39.85	40.0	39.7501	39.995	6737.0
2017-07-13	AFK	ETF	22.23	22.42	22.08	22.42	33511.0
2017-07-13	AFTY	ETF	15.77	15.81	15.77	15.81	1000.0
2017-07-13	AGG	ETF	109.29	109.31	109.13	109.26	1568300.0
2017-07-13	AGGY	ETF	50.52	50.52	50.428	50.5	14400.0
2017-07-13	AGNG	ETF	18.815	18.852	18.794	18.852	2300.0
2017-07-13	AGQ	ETF	30.89	30.89	30.03	30.14	227200.0
2017-07-13	AGZ	ETF	113.6	113.74	113.515	113.57	13219.0
2017-07-13	AGZD	ETF	23.99	24.01	23.99	24.01	1400.0
2017-07-13	AIA	ETF	58.89	59.0401	58.795	59.01	39163.0
2017-07-13	AIQ	ETF	13.25	13.275	13.2	13.25	20592.0
2017-07-13	AIRR	ETF	23.77	23.91	23.77	23.91	21600.0
2017-07-13	AIVI	ETF	41.28	41.31	41.14	41.28	6000.0
2017-07-13	ALTY	ETF	15.52	15.52	15.36	15.44	2600.0
2017-07-13	AMJ	ETF	29.88	29.88	29.65	29.78	1452420.0
2017-07-13	AMLP	ETF	59.7	59.8	59.45	59.75	1039520.0
2017-07-13	AMZA	ETF	96.4	96.5	95.7	96.4	38570.0
2017-07-13	ANGL	ETF	29.43	29.54	29.4	29.53	124300.0
2017-07-13	AOA	ETF	51.77	51.9	51.74	51.87	51900.0
2017-07-13	AOK	ETF	33.98	33.98	33.88	33.96	91652.0
2017-07-13	AOM	ETF	37.2	37.28	37.08	37.17	72325.0
2017-07-13	AOR	ETF	43.69	43.69	43.55	43.66	107220.0
2017-07-13	ARCM	ETF	100.09	100.09	100.09	100.09	20.0
2017-07-13	ARGT	ETF	30.14	30.15	29.78	30.0	34600.0
2017-07-13	ARKG	ETF	22.52	22.52	22.07	22.445	20100.0
2017-07-13	ARKK	ETF	29.44	29.5	29.062	29.26	58300.0
2017-07-13	ARKQ	ETF	29.12	29.15	28.854	28.96	76000.0
2017-07-13	ARKW	ETF	36.35	36.35	35.97	36.13	27900.0
2017-07-13	ASEA	ETF	15.18	15.24	15.18	15.22	13800.0
2017-07-13	ASET	ETF	27.205	27.2098	27.205	27.2098	688.0
2017-07-13	ASHR	ETF	27.58	27.63	27.45	27.58	643400.0
2017-07-13	ASHS	ETF	33.05	33.08	33.03	33.04	5200.0
2017-07-13	ASHX	ETF	20.935	20.935	20.9	20.9199	1070.0
2017-07-13	ATMP	ETF	22.51	22.51	22.33	22.48	24500.0
2017-07-13	BAB	ETF	29.99	30.07	29.94	29.97	86133.0
2017-07-13	BAL	ETF	44.28	44.28	43.64	43.674	24462.0

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

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