PREVIEW / etf_daily / 2017-02-17

all etf daily files

  file:    by_date/etf_daily/2017/2017-02-17.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-17	SPY	ETF	233.95	235.09	233.93	235.09	77204100.0
2017-02-17	QQQ	ETF	129.09	129.82	129.04	129.81	15563730.0
2017-02-17	IWM	ETF	138.45	139.16	138.25	139.11	26703200.0
2017-02-17	DIA	ETF	205.03	205.92	205.02	205.88	5747700.0
2017-02-17	GLD	ETF	118.19	118.4	117.62	117.68	7338100.0
2017-02-17	TLT	ETF	120.61	120.7	120.13	120.32	7886400.0
2017-02-17	AADR	ETF	45.7	45.7	45.24	45.43	13800.0
2017-02-17	AAXJ	ETF	60.41	60.59	60.34	60.59	721500.0
2017-02-17	ACSI	ETF	27.83	27.95	27.83	27.95	2850.0
2017-02-17	ACTX	ETF	135.7012	141.6013	125.0811	135.7012	2456.0
2017-02-17	ACWF	ETF	25.52	25.52	25.41	25.41	1500.0
2017-02-17	ACWI	ETF	62.19	62.42	62.17	62.42	2296100.0
2017-02-17	ACWV	ETF	75.28	75.55	75.23	75.52	122000.0
2017-02-17	ACWX	ETF	42.49	42.59	42.46	42.59	915186.0
2017-02-17	ADRE	ETF	36.2	36.27	36.0901	36.0901	4541.0
2017-02-17	AFK	ETF	21.65	21.7762	21.61	21.6407	2113.0
2017-02-17	AFTY	ETF	13.91	13.92	13.889	13.889	1100.0
2017-02-17	AGG	ETF	108.37	108.45	108.32	108.36	2228100.0
2017-02-17	AGGY	ETF	49.72	49.73	49.665	49.707	7900.0
2017-02-17	AGQ	ETF	40.69	41.0	40.59	40.67	93700.0
2017-02-17	AGZ	ETF	112.8	112.945	112.8	112.84	11085.0
2017-02-17	AGZD	ETF	23.995	23.995	23.995	23.995	1200.0
2017-02-17	AIA	ETF	50.79	50.9	50.67	50.9	26424.0
2017-02-17	AIQ	ETF	10.3	10.4	10.3	10.4	2821.0
2017-02-17	AIRR	ETF	24.23	24.49	24.034	24.25	53700.0
2017-02-17	AIVI	ETF	38.68	38.79	38.63	38.79	11300.0
2017-02-17	ALTY	ETF	15.549	15.55	15.44	15.505	13300.0
2017-02-17	AMJ	ETF	33.92	33.92	33.71	33.82	1837200.0
2017-02-17	AMLP	ETF	65.1	65.2	64.8	64.9	1156360.0
2017-02-17	AMZA	ETF	113.5	113.5	112.5	112.9	32050.0
2017-02-17	ANGL	ETF	29.42	29.48	29.41	29.48	180900.0
2017-02-17	AOA	ETF	49.17	49.3	49.09	49.3	217200.0
2017-02-17	AOK	ETF	33.05	33.1039	33.011	33.09	43742.0
2017-02-17	AOM	ETF	36.04	36.09	36.0	36.09	73226.0
2017-02-17	AOR	ETF	41.88	41.91	41.7868	41.91	52525.0
2017-02-17	ARGT	ETF	26.77	26.77	26.59	26.67	25800.0
2017-02-17	ARKG	ETF	19.2	19.2	19.2	19.2	200.0
2017-02-17	ARKK	ETF	22.973	23.15	22.973	23.14	2800.0
2017-02-17	ARKQ	ETF	24.25	24.43	24.16	24.42	9500.0
2017-02-17	ARKW	ETF	28.24	28.373	28.24	28.37	2400.0
2017-02-17	ASEA	ETF	13.55	13.55	13.54	13.54	1500.0
2017-02-17	ASET	ETF	26.1598	26.22	26.1405	26.219	1562.0
2017-02-17	ASHR	ETF	24.96	24.99	24.88	24.93	631400.0
2017-02-17	ASHS	ETF	33.39	33.39	33.35	33.35	2900.0
2017-02-17	ATMP	ETF	24.56	24.77	24.35	24.53	21400.0
2017-02-17	BAB	ETF	29.45	29.45	29.33	29.34	309302.0
2017-02-17	BAL	ETF	49.22	49.4728	48.7201	48.96	11700.0
2017-02-17	BBC	ETF	21.408	21.7512	21.37	21.695	7079.0
2017-02-17	BBH	ETF	118.67	119.53	118.67	119.45	50400.0
2017-02-17	BBP	ETF	37.78	37.985	37.38	37.93	71000.0

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

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