PREVIEW / etf_daily / 2017-07-18

all etf daily files

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

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-18	SPY	ETF	245.06	245.72	244.67	245.66	42742500.0
2017-07-18	QQQ	ETF	142.06	143.17	141.64	143.14	25748527.0
2017-07-18	IWM	ETF	141.54	141.87	141.04	141.69	16653300.0
2017-07-18	DIA	ETF	215.66	215.81	214.63	215.7	2247500.0
2017-07-18	GLD	ETF	117.99	118.33	117.88	118.11	7158600.0
2017-07-18	TLT	ETF	124.43	124.77	124.23	124.75	9163000.0
2017-07-18	AADR	ETF	48.79	49.15	48.73	49.15	21400.0
2017-07-18	AAXJ	ETF	69.82	70.14	69.7	70.11	683200.0
2017-07-18	ACSI	ETF	28.7376	28.77	28.7376	28.77	15414.0
2017-07-18	ACTX	ETF	82.6007	82.6007	73.7507	75.5207	241.0
2017-07-18	ACWF	ETF	27.88	27.88	27.88	27.88	400.0
2017-07-18	ACWI	ETF	66.62	66.76	66.51	66.76	2261400.0
2017-07-18	ACWV	ETF	79.42	79.52	79.3	79.51	146400.0
2017-07-18	ACWX	ETF	46.6	46.69	46.54	46.69	192068.0
2017-07-18	ADRE	ETF	40.21	40.579	40.1721	40.53	15691.0
2017-07-18	AFK	ETF	22.6	22.79	22.6	22.7688	5632.0
2017-07-18	AFTY	ETF	15.988	15.99	15.97	15.97	1100.0
2017-07-18	AGG	ETF	109.64	109.71	109.58	109.67	2878400.0
2017-07-18	AGGY	ETF	50.73	50.77	50.67	50.77	26000.0
2017-07-18	AGNG	ETF	19.26	19.26	18.89	19.03	2800.0
2017-07-18	AGQ	ETF	32.19	32.48	31.99	32.23	135800.0
2017-07-18	AGZ	ETF	113.78	113.88	113.77	113.84	16869.0
2017-07-18	AGZD	ETF	24.035	24.05	24.0	24.0	10800.0
2017-07-18	AIA	ETF	59.35	59.52	59.2601	59.52	52092.0
2017-07-18	AIQ	ETF	13.25	13.3	13.2	13.25	141862.0
2017-07-18	AIRR	ETF	23.91	23.98	23.75	23.91	14200.0
2017-07-18	AIVI	ETF	41.66	41.66	41.56	41.63	3800.0
2017-07-18	ALTY	ETF	15.61	15.67	15.61	15.62	7600.0
2017-07-18	AMJ	ETF	30.37	30.37	30.095	30.3	839801.0
2017-07-18	AMLP	ETF	60.5	60.6	60.15	60.4	1480020.0
2017-07-18	AMZA	ETF	98.0	98.2	97.3	97.9	52210.0
2017-07-18	ANGL	ETF	29.71	29.77	29.67	29.73	145000.0
2017-07-18	AOA	ETF	52.05	52.19	52.03	52.19	77700.0
2017-07-18	AOK	ETF	34.05	34.1199	34.04	34.09	47197.0
2017-07-18	AOM	ETF	37.31	37.383	37.2564	37.38	76585.0
2017-07-18	AOR	ETF	43.77	43.89	43.75	43.89	60574.0
2017-07-18	ARCM	ETF	100.09	100.09	100.09	100.09	20.0
2017-07-18	ARGT	ETF	29.88	29.88	29.47	29.57	370800.0
2017-07-18	ARKG	ETF	22.37	22.37	22.041	22.11	20000.0
2017-07-18	ARKK	ETF	29.05	29.43	29.05	29.43	46800.0
2017-07-18	ARKQ	ETF	29.0	29.22	28.955	29.22	11700.0
2017-07-18	ARKW	ETF	36.2	36.937	36.2	36.92	28900.0
2017-07-18	ASEA	ETF	15.21	15.32	15.21	15.31	3400.0
2017-07-18	ASET	ETF	27.55	27.55	27.55	27.55	113.0
2017-07-18	ASHR	ETF	27.42	27.45	27.36	27.41	345200.0
2017-07-18	ASHS	ETF	31.88	32.06	31.88	31.98	3800.0
2017-07-18	ASHX	ETF	20.75	20.75	20.75	20.75	1686.0
2017-07-18	ATMP	ETF	22.83	22.84	22.69	22.81	76100.0
2017-07-18	BAB	ETF	30.04	30.06	30.0001	30.01	43555.0
2017-07-18	BAL	ETF	44.96	44.96	44.18	44.9	4958.0

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

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