PREVIEW / etf_daily / 2017-07-24

all etf daily files

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

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-24	SPY	ETF	246.79	246.98	246.28	246.82	46622300.0
2017-07-24	QQQ	ETF	144.07	144.87	143.92	144.77	26712732.0
2017-07-24	IWM	ETF	142.31	142.82	141.97	142.75	16694000.0
2017-07-24	DIA	ETF	215.51	215.51	214.68	215.09	1459600.0
2017-07-24	GLD	ETF	119.52	119.58	119.18	119.31	3654300.0
2017-07-24	TLT	ETF	125.45	125.66	125.16	125.2	5378500.0
2017-07-24	AADR	ETF	49.45	49.87	49.28	49.87	16600.0
2017-07-24	AAXJ	ETF	71.0	71.0	70.7	70.9	576100.0
2017-07-24	ACSI	ETF	28.96	28.96	28.902	28.91	7234.0
2017-07-24	ACTX	ETF	79.6507	80.8307	73.7507	76.1107	393.0
2017-07-24	ACWF	ETF	28.06	28.113	28.06	28.113	560.0
2017-07-24	ACWI	ETF	67.05	67.1	66.9	67.06	1580200.0
2017-07-24	ACWV	ETF	80.19	80.19	79.98	80.1	105800.0
2017-07-24	ACWX	ETF	46.83	46.91	46.73	46.91	381987.0
2017-07-24	ADRE	ETF	40.7	40.9	40.7	40.77	6100.0
2017-07-24	AFK	ETF	22.84	22.9316	22.79	22.85	8746.0
2017-07-24	AGG	ETF	109.84	109.92	109.76	109.82	1946000.0
2017-07-24	AGGY	ETF	50.75	50.76	50.67	50.75	8200.0
2017-07-24	AGNG	ETF	19.23	19.25	19.07	19.07	2800.0
2017-07-24	AGQ	ETF	33.28	33.5	32.9	33.03	82800.0
2017-07-24	AGZ	ETF	113.93	113.93	113.8774	113.91	8661.0
2017-07-24	AGZD	ETF	23.995	24.02	23.97	23.985	2800.0
2017-07-24	AIA	ETF	60.22	60.47	60.1909	60.28	38432.0
2017-07-24	AIQ	ETF	13.25	13.25	13.2	13.25	17304.0
2017-07-24	AIRR	ETF	23.84	23.96	23.79	23.95	20800.0
2017-07-24	AIVI	ETF	41.52	41.59	41.43	41.59	7600.0
2017-07-24	ALTY	ETF	15.82	15.82	15.712	15.735	1800.0
2017-07-24	AMJ	ETF	29.82	29.87	29.67	29.87	761181.0
2017-07-24	AMLP	ETF	59.8	59.95	59.55	59.8	1315220.0
2017-07-24	AMUB	ETF	18.73	18.7492	18.73	18.7492	275.0
2017-07-24	AMZA	ETF	96.9	97.0	96.2	96.7	64000.0
2017-07-24	ANGL	ETF	29.8	29.8	29.72	29.73	1056300.0
2017-07-24	AOA	ETF	52.41	52.42	52.26	52.41	35400.0
2017-07-24	AOK	ETF	34.19	34.21	34.132	34.19	28750.0
2017-07-24	AOM	ETF	37.48	37.4999	37.3801	37.49	76292.0
2017-07-24	AOR	ETF	44.01	44.0422	43.95	44.0	102611.0
2017-07-24	ARCM	ETF	100.05	100.05	100.05	100.05	4000.0
2017-07-24	ARGT	ETF	29.77	29.79	29.58	29.62	22300.0
2017-07-24	ARKG	ETF	22.54	22.86	22.467	22.856	11900.0
2017-07-24	ARKK	ETF	29.86	30.38	29.86	30.38	83900.0
2017-07-24	ARKQ	ETF	29.5	29.74	29.5	29.73	21200.0
2017-07-24	ARKW	ETF	37.21	37.57	37.21	37.57	59100.0
2017-07-24	ASEA	ETF	15.29	15.35	15.29	15.35	2400.0
2017-07-24	ASET	ETF	27.63	27.67	27.63	27.65	1352.0
2017-07-24	ASHR	ETF	28.09	28.14	28.04	28.12	305900.0
2017-07-24	ASHS	ETF	33.2	33.42	33.2	33.36	3900.0
2017-07-24	ATMP	ETF	22.6	22.66	22.5	22.65	34900.0
2017-07-24	BAB	ETF	30.1	30.16	30.0665	30.13	82185.0
2017-07-24	BAL	ETF	44.76	45.125	44.76	44.98	2087.0
2017-07-24	BBC	ETF	25.39	25.74	25.33	25.73	10722.0

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

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