PREVIEW / etf_daily / 2017-12-11

all etf daily files

  file:    by_date/etf_daily/2017/2017-12-11.parquet
  size:    59 KB
  rows:    1,518

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-12-11	SPY	ETF	266.31	266.38	265.48	266.31	83077500.0
2017-12-11	QQQ	ETF	154.76	155.95	154.76	155.9	20821528.0
2017-12-11	IWM	ETF	151.43	152.13	151.02	151.35	26654100.0
2017-12-11	DIA	ETF	243.77	244.24	243.5	244.17	1857800.0
2017-12-11	GLD	ETF	118.37	118.54	117.8	118.01	4522200.0
2017-12-11	TLT	ETF	126.86	127.09	126.41	126.43	3863800.0
2017-12-11	AADR	ETF	57.92	57.92	56.92	57.17	29900.0
2017-12-11	AAXJ	ETF	75.69	75.87	75.62	75.76	906400.0
2017-12-11	ACSI	ETF	31.0773	31.08	31.0773	31.079	1463.0
2017-12-11	ACTX	ETF	60.1805	67.8506	60.1805	64.3106	463.0
2017-12-11	ACWF	ETF	30.54	30.55	30.48	30.5461	4991.0
2017-12-11	ACWI	ETF	71.66	71.89	71.66	71.88	5803300.0
2017-12-11	ACWV	ETF	84.48	84.52	84.37	84.5	77500.0
2017-12-11	ACWX	ETF	49.4	49.515	49.4	49.48	857420.0
2017-12-11	ADRE	ETF	41.93	42.379	41.93	42.27	6990.0
2017-12-11	AFK	ETF	24.2	24.2	23.98	24.0	7381.0
2017-12-11	AFTY	ETF	18.7	18.7	18.619	18.62	2700.0
2017-12-11	AGG	ETF	109.14	109.32	109.13	109.15	2612400.0
2017-12-11	AGGY	ETF	50.73	50.758	50.65	50.65	95700.0
2017-12-11	AGNG	ETF	19.63	19.63	19.566	19.57	3300.0
2017-12-11	AGQ	ETF	29.43	29.6	29.17	29.26	176400.0
2017-12-11	AGZ	ETF	113.37	113.37	113.21	113.27	96494.0
2017-12-11	AGZD	ETF	24.14	24.145	24.125	24.125	4200.0
2017-12-11	AIA	ETF	65.21	65.3282	65.08	65.27	54733.0
2017-12-11	AIEQ	ETF	25.6	25.659	25.58	25.6	126400.0
2017-12-11	AIRR	ETF	27.0	27.0	26.7	26.72	22800.0
2017-12-11	AIVI	ETF	42.94	43.12	42.94	43.06	13400.0
2017-12-11	ALTY	ETF	15.39	15.39	15.345	15.345	8200.0
2017-12-11	AMJ	ETF	26.5	27.015	26.45	26.94	3182615.0
2017-12-11	AMLP	ETF	52.2	53.45	52.1	53.2	4156180.0
2017-12-11	AMZA	ETF	82.3	83.9	82.0	83.5	72850.0
2017-12-11	ANGL	ETF	29.95	30.01	29.93	29.96	174300.0
2017-12-11	AOA	ETF	55.21	55.31	55.17	55.26	81500.0
2017-12-11	AOK	ETF	34.62	34.62	34.48	34.51	273423.0
2017-12-11	AOM	ETF	38.49	38.5719	38.4676	38.55	429198.0
2017-12-11	AOR	ETF	45.86	45.9	45.82	45.82	261726.0
2017-12-11	ARGT	ETF	33.46	33.93	33.46	33.91	77600.0
2017-12-11	ARKG	ETF	25.53	25.62	24.63	24.72	58000.0
2017-12-11	ARKK	ETF	37.03	37.26	36.88	36.99	321900.0
2017-12-11	ARKQ	ETF	33.45	33.689	33.45	33.6	27100.0
2017-12-11	ARKW	ETF	45.27	46.04	45.226	46.03	249700.0
2017-12-11	ASEA	ETF	16.75	16.87	16.75	16.84	10200.0
2017-12-11	ASET	ETF	28.65	28.68	28.65	28.68	2716.0
2017-12-11	ASHR	ETF	30.99	31.11	30.95	31.1	856500.0
2017-12-11	ASHS	ETF	34.54	34.61	34.53	34.59	10300.0
2017-12-11	ATMP	ETF	19.98	20.35	19.98	20.23	680200.0
2017-12-11	BAB	ETF	30.68	30.7	30.54	30.59	89808.0
2017-12-11	BAL	ETF	48.571	48.571	48.3	48.3	13152.0
2017-12-11	BAR	ETF	12.438	12.438	12.438	12.438	2840.0
2017-12-11	BBC	ETF	28.73	28.73	27.89	27.97	7354.0

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

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