PREVIEW / etf_daily / 2017-10-02

all etf daily files

  file:    by_date/etf_daily/2017/2017-10-02.parquet
  size:    58 KB
  rows:    1,475

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-10-02	SPY	ETF	251.49	252.32	251.29	252.32	59023000.0
2017-10-02	QQQ	ETF	145.67	146.17	144.93	145.58	27351260.0
2017-10-02	IWM	ETF	148.31	150.0	148.08	150.0	29772400.0
2017-10-02	DIA	ETF	224.19	225.39	224.02	225.24	2611200.0
2017-10-02	GLD	ETF	121.17	121.34	120.74	120.77	11755400.0
2017-10-02	TLT	ETF	124.81	125.0	124.24	124.28	7860700.0
2017-10-02	AADR	ETF	55.68	55.9	55.53	55.75	42700.0
2017-10-02	AAXJ	ETF	72.4	72.76	72.38	72.48	1554600.0
2017-10-02	ACSI	ETF	29.2187	29.25	29.2187	29.25	706.0
2017-10-02	ACTX	ETF	66.6706	66.6706	60.1805	62.5406	376.0
2017-10-02	ACWF	ETF	28.99	29.159	28.99	29.159	693.0
2017-10-02	ACWI	ETF	68.77	68.95	68.77	68.9	3559100.0
2017-10-02	ACWV	ETF	81.16	81.51	81.16	81.39	205400.0
2017-10-02	ACWX	ETF	48.21	48.38	48.2	48.31	259916.0
2017-10-02	ADRE	ETF	42.21	42.337	42.13	42.16	4791.0
2017-10-02	AFK	ETF	23.2	23.2534	23.18	23.2012	9338.0
2017-10-02	AFTY	ETF	17.08	17.08	16.91	16.93	5800.0
2017-10-02	AGG	ETF	109.43	109.51	109.33	109.43	5692200.0
2017-10-02	AGGY	ETF	50.76	50.77	50.665	50.706	80600.0
2017-10-02	AGNG	ETF	19.52	19.54	19.465	19.54	5900.0
2017-10-02	AGQ	ETF	33.23	33.43	32.86	32.86	80700.0
2017-10-02	AGZ	ETF	113.57	113.59	113.5098	113.56	9713.0
2017-10-02	AGZD	ETF	24.0	24.02	23.975	24.02	2000.0
2017-10-02	AIA	ETF	61.6	61.79	61.54	61.66	85985.0
2017-10-02	AIRR	ETF	26.15	26.4	26.09	26.4	9900.0
2017-10-02	AIVI	ETF	42.49	42.57	42.4	42.55	13900.0
2017-10-02	ALTY	ETF	15.68	15.712	15.68	15.71	13400.0
2017-10-02	AMJ	ETF	27.89	28.36	27.89	28.34	1687921.0
2017-10-02	AMLP	ETF	55.85	56.45	55.75	56.45	1134200.0
2017-10-02	AMZA	ETF	93.0	94.1	92.6	94.1	146300.0
2017-10-02	ANGL	ETF	30.2	30.23	30.15	30.18	360100.0
2017-10-02	AOA	ETF	53.59	53.67	53.54	53.67	46400.0
2017-10-02	AOK	ETF	34.44	34.5013	34.42	34.49	73514.0
2017-10-02	AOM	ETF	37.99	38.01	37.93	38.0	72675.0
2017-10-02	AOR	ETF	44.87	44.89	44.8	44.89	71601.0
2017-10-02	ARGT	ETF	31.84	32.2	31.76	32.11	114400.0
2017-10-02	ARKG	ETF	26.35	26.48	26.0	26.406	35600.0
2017-10-02	ARKK	ETF	34.44	34.525	34.225	34.47	100500.0
2017-10-02	ARKQ	ETF	32.01	32.2	31.85	32.19	38600.0
2017-10-02	ARKW	ETF	40.8	41.04	40.59	40.9	44000.0
2017-10-02	ASEA	ETF	15.67	15.79	15.67	15.76	5500.0
2017-10-02	ASET	ETF	28.07	28.1	28.07	28.1	1253.0
2017-10-02	ASHR	ETF	29.36	29.4	29.24	29.26	1335100.0
2017-10-02	ASHS	ETF	36.3	36.58	36.3	36.51	6900.0
2017-10-02	ASHX	ETF	21.839	21.839	21.83	21.83	453.0
2017-10-02	ATMP	ETF	21.32	21.44	21.32	21.42	12400.0
2017-10-02	BAB	ETF	30.42	30.42	30.3	30.34	258938.0
2017-10-02	BAL	ETF	45.0	45.0	44.58	44.58	3956.0
2017-10-02	BAR	ETF	12.734	12.734	12.713	12.715	17330.0
2017-10-02	BBC	ETF	29.2699	29.74	29.2634	29.71	13377.0

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

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