PREVIEW / etf_daily / 2017-10-03

all etf daily files

  file:    by_date/etf_daily/2017/2017-10-03.parquet
  size:    57 KB
  rows:    1,465

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-03	SPY	ETF	252.32	252.89	252.23	252.86	66810200.0
2017-10-03	QQQ	ETF	145.74	146.06	145.45	145.89	19715152.0
2017-10-03	IWM	ETF	150.11	150.33	149.33	150.33	28372800.0
2017-10-03	DIA	ETF	225.74	226.28	225.61	226.24	2510000.0
2017-10-03	GLD	ETF	120.72	121.1	120.7	120.83	3728700.0
2017-10-03	TLT	ETF	123.92	124.51	123.92	124.4	6219800.0
2017-10-03	AADR	ETF	55.99	56.53	55.99	56.53	39500.0
2017-10-03	AAXJ	ETF	72.99	73.41	72.95	73.41	1687200.0
2017-10-03	ACSI	ETF	29.3199	29.359	29.247	29.3469	3600.0
2017-10-03	ACTX	ETF	63.1306	63.4256	59.0005	61.3016	655.0
2017-10-03	ACWF	ETF	29.24	29.35	29.19	29.35	3773.0
2017-10-03	ACWI	ETF	69.0	69.21	69.0	69.17	1349500.0
2017-10-03	ACWV	ETF	81.6	81.71	81.45	81.61	2818100.0
2017-10-03	ACWX	ETF	48.44	48.62	48.43	48.62	137767.0
2017-10-03	ADRE	ETF	42.32	42.839	42.32	42.839	7043.0
2017-10-03	AFK	ETF	23.228	23.335	23.228	23.3	2487.0
2017-10-03	AFTY	ETF	17.237	17.27	17.237	17.256	4300.0
2017-10-03	AGG	ETF	109.46	109.54	109.4	109.52	2462200.0
2017-10-03	AGGY	ETF	50.65	50.81	50.65	50.795	61800.0
2017-10-03	AGNG	ETF	19.52	19.52	19.42	19.455	1500.0
2017-10-03	AGQ	ETF	32.97	33.21	32.95	33.07	79800.0
2017-10-03	AGZ	ETF	113.44	113.6	113.44	113.59	7252.0
2017-10-03	AGZD	ETF	24.105	24.105	24.005	24.105	7000.0
2017-10-03	AIA	ETF	62.13	62.42	62.08	62.42	44253.0
2017-10-03	AIRR	ETF	26.49	26.49	26.21	26.34	21400.0
2017-10-03	AIVI	ETF	42.49	42.63	42.49	42.62	4200.0
2017-10-03	ALTY	ETF	15.75	15.75	15.68	15.715	8700.0
2017-10-03	AMJ	ETF	28.24	28.4765	28.24	28.43	1417949.0
2017-10-03	AMLP	ETF	56.45	56.65	56.3	56.55	1105080.0
2017-10-03	AMZA	ETF	89.1	89.1	88.3	89.1	242300.0
2017-10-03	ANGL	ETF	30.19	30.22	30.17	30.2	409000.0
2017-10-03	AOA	ETF	53.61	53.69	53.55	53.69	42500.0
2017-10-03	AOK	ETF	34.5	34.5	34.39	34.48	107055.0
2017-10-03	AOM	ETF	37.92	37.93	37.8144	37.93	88623.0
2017-10-03	AOR	ETF	44.82	44.85	44.75	44.85	166764.0
2017-10-03	ARCM	ETF	99.9	99.9	99.9	99.9	20.0
2017-10-03	ARGT	ETF	32.15	32.3	31.89	32.26	172300.0
2017-10-03	ARKG	ETF	26.57	26.69	26.17	26.69	37500.0
2017-10-03	ARKK	ETF	34.6	34.9	34.3	34.8	112100.0
2017-10-03	ARKQ	ETF	32.29	32.34	32.111	32.34	15500.0
2017-10-03	ARKW	ETF	40.84	41.108	40.7	40.98	55000.0
2017-10-03	ASEA	ETF	15.7	15.76	15.68	15.76	3300.0
2017-10-03	ASET	ETF	28.0549	28.09	28.0549	28.0883	4323.0
2017-10-03	ASHR	ETF	29.77	29.95	29.72	29.95	1203100.0
2017-10-03	ASHS	ETF	37.14	37.16	36.84	37.16	17800.0
2017-10-03	ASHX	ETF	22.257	22.2592	22.25	22.25	1150.0
2017-10-03	ATMP	ETF	21.73	21.73	21.38	21.45	46300.0
2017-10-03	BAB	ETF	30.36	30.39	30.2901	30.39	173202.0
2017-10-03	BAL	ETF	44.84	44.8475	44.5065	44.5065	945.0
2017-10-03	BAR	ETF	12.715	12.715	12.71	12.71	13770.0

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

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