PREVIEW / etf_daily / 2017-01-18

all etf daily files

  file:    by_date/etf_daily/2017/2017-01-18.parquet
  size:    54 KB
  rows:    1,355

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-01-18	SPY	ETF	226.54	226.8	225.9	226.75	54793300.0
2017-01-18	QQQ	ETF	122.96	123.16	122.66	123.04	12499663.0
2017-01-18	IWM	ETF	134.76	134.94	133.95	134.85	21289700.0
2017-01-18	DIA	ETF	198.08	198.23	197.3	197.95	4634800.0
2017-01-18	GLD	ETF	115.74	115.92	114.56	114.87	6498100.0
2017-01-18	TLT	ETF	121.77	121.96	120.91	121.01	9064700.0
2017-01-18	AADR	ETF	43.66	43.66	43.27	43.45	3900.0
2017-01-18	AAXJ	ETF	57.85	57.93	57.52	57.57	473200.0
2017-01-18	ACSI	ETF	27.1125	27.13	27.09	27.13	4650.0
2017-01-18	ACTX	ETF	62.5406	74.3407	50.1505	53.6905	5490.0
2017-01-18	ACWF	ETF	24.7	24.75	24.7	24.75	600.0
2017-01-18	ACWI	ETF	60.47	60.48	60.3	60.41	2246200.0
2017-01-18	ACWV	ETF	73.87	73.87	73.58	73.65	86300.0
2017-01-18	ACWX	ETF	41.39	41.48	41.25	41.32	613579.0
2017-01-18	ADRE	ETF	34.47	34.47	34.2728	34.2728	1023.0
2017-01-18	AFK	ETF	21.14	21.8299	21.01	21.01	21506.0
2017-01-18	AFTY	ETF	13.68	13.71	13.66	13.66	2600.0
2017-01-18	AGG	ETF	108.6	108.67	108.24	108.32	3115600.0
2017-01-18	AGGY	ETF	49.92	49.921	49.65	49.734	11200.0
2017-01-18	AGQ	ETF	37.26	37.91	36.62	36.81	154600.0
2017-01-18	AGZ	ETF	112.93	113.21	112.791	112.93	40209.0
2017-01-18	AGZD	ETF	24.09	24.09	24.05	24.06	9400.0
2017-01-18	AIA	ETF	48.66	48.73	48.48	48.53	21830.0
2017-01-18	AIQ	ETF	9.65	9.7	9.65	9.65	13499.0
2017-01-18	AIRR	ETF	23.47	23.47	23.24	23.36	28700.0
2017-01-18	AIVI	ETF	38.47	38.53	38.34	38.38	8500.0
2017-01-18	ALTY	ETF	15.4	15.4	15.26	15.38	16100.0
2017-01-18	AMJ	ETF	32.14	32.16	31.91	32.0	913825.0
2017-01-18	AMLP	ETF	63.9	64.0	63.5	63.55	1212380.0
2017-01-18	AMZA	ETF	109.6	109.6	108.3	108.7	33440.0
2017-01-18	ANGL	ETF	29.2	29.23	29.17	29.19	210000.0
2017-01-18	AOA	ETF	48.02	48.02	47.86	47.94	78300.0
2017-01-18	AOK	ETF	32.8	32.8	32.66	32.7	94681.0
2017-01-18	AOM	ETF	35.6	35.6	35.4596	35.49	114830.0
2017-01-18	AOR	ETF	41.17	41.17	40.9395	40.99	86570.0
2017-01-18	ARGT	ETF	25.31	25.36	25.13	25.19	31800.0
2017-01-18	ARKG	ETF	17.78	17.806	17.749	17.806	600.0
2017-01-18	ARKK	ETF	21.87	21.87	21.687	21.8	8400.0
2017-01-18	ARKQ	ETF	23.05	23.05	22.95	22.99	7000.0
2017-01-18	ARKW	ETF	26.82	26.86	26.64	26.851	4000.0
2017-01-18	ASEA	ETF	13.3	13.34	13.22	13.23	2400.0
2017-01-18	ASET	ETF	25.96	25.96	25.96	25.96	100.0
2017-01-18	ASHR	ETF	24.61	24.61	24.41	24.43	836400.0
2017-01-18	ASHS	ETF	32.23	32.26	32.18	32.2	13100.0
2017-01-18	ASHX	ETF	18.9832	18.9832	18.9832	18.9832	315.0
2017-01-18	ATMP	ETF	23.63	23.75	23.48	23.56	124600.0
2017-01-18	BAB	ETF	29.29	29.333	29.17	29.1835	145048.0
2017-01-18	BAL	ETF	47.5201	47.6115	47.5	47.51	4953.0
2017-01-18	BBC	ETF	19.2576	19.4803	19.2576	19.4803	1331.0
2017-01-18	BBH	ETF	112.26	112.85	112.08	112.7	24500.0

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

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