PREVIEW / etf_daily / 2017-02-28

all etf daily files

  file:    by_date/etf_daily/2017/2017-02-28.parquet
  size:    55 KB
  rows:    1,381

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-28	SPY	ETF	236.67	236.95	236.02	236.47	96961900.0
2017-02-28	QQQ	ETF	130.39	130.45	129.66	130.02	16598581.0
2017-02-28	IWM	ETF	139.38	139.48	137.76	137.84	40184100.0
2017-02-28	DIA	ETF	208.11	208.31	207.68	207.98	2821900.0
2017-02-28	GLD	ETF	119.71	119.84	118.82	119.23	8727800.0
2017-02-28	TLT	ETF	121.5	122.08	121.32	121.74	8410500.0
2017-02-28	AADR	ETF	45.24	45.49	44.91	44.91	16100.0
2017-02-28	AAXJ	ETF	60.86	60.87	60.56	60.62	330900.0
2017-02-28	ACSI	ETF	28.06	28.06	27.9572	28.0	4628.0
2017-02-28	ACTX	ETF	122.4261	129.8012	106.201	117.4111	2579.0
2017-02-28	ACWF	ETF	25.44	25.47	25.43	25.47	5467.0
2017-02-28	ACWI	ETF	62.47	62.56	62.31	62.42	1733000.0
2017-02-28	ACWV	ETF	76.36	76.54	76.28	76.33	132800.0
2017-02-28	ACWX	ETF	42.42	42.485	42.2601	42.29	583510.0
2017-02-28	ADRE	ETF	36.16	36.16	35.9	35.91	8390.0
2017-02-28	AFK	ETF	21.0	21.05	20.9	20.9	7195.0
2017-02-28	AFTY	ETF	13.99	14.12	13.99	14.12	3000.0
2017-02-28	AGG	ETF	108.8	108.94	108.75	108.77	3840100.0
2017-02-28	AGGY	ETF	49.99	50.01	49.93	49.93	3800.0
2017-02-28	AGQ	ETF	42.31	42.65	42.0	42.09	178300.0
2017-02-28	AGZ	ETF	113.02	113.32	113.02	113.06	8862.0
2017-02-28	AGZD	ETF	24.04	24.04	24.04	24.04	800.0
2017-02-28	AIA	ETF	50.9	51.0	50.75	50.81	15076.0
2017-02-28	AIQ	ETF	10.35	10.4	10.3	10.35	5938.0
2017-02-28	AIRR	ETF	24.48	24.48	24.0	24.06	60100.0
2017-02-28	AIVI	ETF	38.81	38.88	38.68	38.7	6400.0
2017-02-28	ALTY	ETF	15.63	15.63	15.545	15.6	14400.0
2017-02-28	AMJ	ETF	32.48	32.89	32.445	32.77	1362032.0
2017-02-28	AMLP	ETF	64.05	64.5	63.9	64.3	2142420.0
2017-02-28	AMZA	ETF	111.8	112.59	111.4	112.0	58280.0
2017-02-28	ANGL	ETF	29.6	29.63	29.55	29.56	210400.0
2017-02-28	AOA	ETF	49.46	49.57	49.28	49.35	71500.0
2017-02-28	AOK	ETF	33.15	33.2343	33.1469	33.18	47051.0
2017-02-28	AOM	ETF	36.2	36.2386	36.12	36.2	39873.0
2017-02-28	AOR	ETF	42.01	42.07	41.9401	42.0	63607.0
2017-02-28	ARGT	ETF	26.51	26.51	26.25	26.28	57400.0
2017-02-28	ARKG	ETF	19.84	19.84	19.84	19.84	700.0
2017-02-28	ARKK	ETF	23.4	23.4	23.05	23.125	9700.0
2017-02-28	ARKQ	ETF	24.22	24.22	23.81	23.81	9200.0
2017-02-28	ARKW	ETF	28.46	28.46	28.221	28.25	7000.0
2017-02-28	ASEA	ETF	13.67	13.67	13.66	13.66	700.0
2017-02-28	ASET	ETF	26.4	26.4499	26.34	26.37	2292.0
2017-02-28	ASHR	ETF	25.14	25.22	25.14	25.16	394900.0
2017-02-28	ASHS	ETF	34.25	34.25	34.12	34.17	1400.0
2017-02-28	ATMP	ETF	24.0	24.49	23.88	23.97	28700.0
2017-02-28	BAB	ETF	29.47	29.497	29.4	29.42	106644.0
2017-02-28	BAL	ETF	49.51	49.7301	49.4985	49.4985	1733.0
2017-02-28	BBC	ETF	22.1	22.3492	21.1095	21.98	14797.0
2017-02-28	BBH	ETF	121.44	122.09	120.78	121.28	94600.0
2017-02-28	BBP	ETF	38.59	38.63	37.698	37.94	27900.0

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

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