PREVIEW / etf_daily / 2017-07-14

all etf daily files

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

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-14	SPY	ETF	244.42	245.97	244.31	245.56	60262700.0
2017-07-14	QQQ	ETF	141.57	142.3	141.19	142.12	34544847.0
2017-07-14	IWM	ETF	141.1	142.3	141.1	141.73	15465300.0
2017-07-14	DIA	ETF	215.3	216.68	215.11	216.26	2395500.0
2017-07-14	GLD	ETF	117.04	117.25	116.64	116.77	5788200.0
2017-07-14	TLT	ETF	124.1	124.16	123.12	123.33	6566800.0
2017-07-14	AADR	ETF	48.73	48.94	48.57	48.93	19400.0
2017-07-14	AAXJ	ETF	69.93	70.31	69.84	70.27	744400.0
2017-07-14	ACSI	ETF	28.7	28.78	28.7	28.78	19330.0
2017-07-14	ACTX	ETF	79.6507	87.9108	76.1107	77.2907	458.0
2017-07-14	ACWF	ETF	27.865	27.945	27.865	27.9	1939.0
2017-07-14	ACWI	ETF	66.4	66.83	66.4	66.72	774200.0
2017-07-14	ACWV	ETF	79.2	79.51	79.14	79.45	155500.0
2017-07-14	ACWX	ETF	46.5	46.75	46.49	46.72	230298.0
2017-07-14	ADRE	ETF	40.0	40.44	40.0	40.44	13179.0
2017-07-14	AFK	ETF	22.14	22.75	22.14	22.68	9090.0
2017-07-14	AFTY	ETF	15.97	15.99	15.966	15.99	4700.0
2017-07-14	AGG	ETF	109.54	109.56	109.29	109.37	1916600.0
2017-07-14	AGGY	ETF	50.65	50.65	50.512	50.58	12000.0
2017-07-14	AGNG	ETF	19.0	19.111	19.0	19.065	6200.0
2017-07-14	AGQ	ETF	31.36	31.53	30.7	31.05	121200.0
2017-07-14	AGZ	ETF	113.65	113.84	113.62	113.62	67470.0
2017-07-14	AGZD	ETF	24.045	24.045	23.995	24.005	5200.0
2017-07-14	AIA	ETF	59.32	59.64	59.29	59.58	37199.0
2017-07-14	AIQ	ETF	13.25	13.275	13.2	13.225	13911.0
2017-07-14	AIRR	ETF	23.9	24.044	23.87	23.93	17100.0
2017-07-14	AIVI	ETF	41.49	41.62	41.47	41.58	31900.0
2017-07-14	ALTY	ETF	15.32	15.6	15.32	15.535	14500.0
2017-07-14	AMJ	ETF	29.85	30.19	29.815	30.17	1068197.0
2017-07-14	AMLP	ETF	59.8	60.35	59.7	60.25	1356320.0
2017-07-14	AMZA	ETF	96.9	97.4	96.6	97.4	83840.0
2017-07-14	ANGL	ETF	29.51	29.64	29.51	29.63	1374700.0
2017-07-14	AOA	ETF	52.08	52.18	51.95	52.14	58900.0
2017-07-14	AOK	ETF	34.0	34.06	33.94	34.05	50784.0
2017-07-14	AOM	ETF	37.22	37.3351	37.198	37.31	69368.0
2017-07-14	AOR	ETF	43.77	43.8579	43.7	43.83	93496.0
2017-07-14	ARCM	ETF	100.09	100.09	100.09	100.09	20.0
2017-07-14	ARGT	ETF	30.1	30.1	29.91	30.07	47000.0
2017-07-14	ARKG	ETF	22.57	22.575	22.32	22.43	18900.0
2017-07-14	ARKK	ETF	29.47	29.47	29.209	29.315	30500.0
2017-07-14	ARKQ	ETF	29.02	29.2	28.92	29.192	22600.0
2017-07-14	ARKW	ETF	36.24	36.38	36.08	36.35	25800.0
2017-07-14	ASEA	ETF	15.31	15.32	15.31	15.32	500.0
2017-07-14	ASET	ETF	27.4256	27.435	27.4244	27.435	1432.0
2017-07-14	ASHR	ETF	27.74	27.86	27.73	27.86	812300.0
2017-07-14	ASHS	ETF	33.05	33.12	33.05	33.12	3800.0
2017-07-14	ASHX	ETF	21.1	21.1	21.0944	21.1	739.0
2017-07-14	ATMP	ETF	22.63	22.72	22.51	22.72	26000.0
2017-07-14	BAB	ETF	29.97	30.04	29.9	29.93	74627.0
2017-07-14	BAL	ETF	43.7	43.92	43.62	43.82	8933.0

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

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