PREVIEW / etf_daily / 2017-12-06

all etf daily files

  file:    by_date/etf_daily/2017/2017-12-06.parquet
  size:    58 KB
  rows:    1,504

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-06	SPY	ETF	263.3	263.73	262.71	263.24	75898600.0
2017-12-06	QQQ	ETF	152.26	153.735	152.06	153.5	28647769.0
2017-12-06	IWM	ETF	150.37	151.19	149.95	150.22	21273800.0
2017-12-06	DIA	ETF	241.72	242.51	241.55	241.62	3976100.0
2017-12-06	GLD	ETF	120.04	120.44	119.87	120.07	6643000.0
2017-12-06	TLT	ETF	127.87	128.23	127.66	127.68	11834200.0
2017-12-06	AADR	ETF	54.79	55.67	54.37	55.59	27600.0
2017-12-06	AAXJ	ETF	73.8	74.04	73.56	73.86	2058700.0
2017-12-06	ACSI	ETF	30.8899	30.8899	30.8199	30.82	1401.0
2017-12-06	ACTX	ETF	67.8506	67.8506	59.0005	59.0005	482.0
2017-12-06	ACWF	ETF	30.12	30.14	30.12	30.14	2113.0
2017-12-06	ACWI	ETF	71.01	71.12	70.9	71.01	1169700.0
2017-12-06	ACWV	ETF	83.99	84.15	83.96	84.06	61100.0
2017-12-06	ACWX	ETF	48.89	48.9907	48.83	48.915	859800.0
2017-12-06	ADRE	ETF	41.56	41.71	41.45	41.71	38779.0
2017-12-06	AFK	ETF	24.11	24.3489	24.0	24.0	21047.0
2017-12-06	AFTY	ETF	18.47	18.47	18.22	18.33	12900.0
2017-12-06	AGG	ETF	109.44	109.52	109.37	109.37	2965800.0
2017-12-06	AGGY	ETF	50.85	50.87	50.77	50.815	187200.0
2017-12-06	AGNG	ETF	19.258	19.34	19.258	19.285	1200.0
2017-12-06	AGQ	ETF	30.34	30.55	30.0	30.29	283100.0
2017-12-06	AGZ	ETF	113.375	113.44	113.32	113.375	13594.0
2017-12-06	AGZD	ETF	24.1	24.15	24.065	24.105	2400.0
2017-12-06	AIA	ETF	63.6	63.65	63.26	63.61	149840.0
2017-12-06	AIEQ	ETF	25.32	25.365	25.23	25.24	93200.0
2017-12-06	AIRR	ETF	26.91	27.13	26.91	27.053	19000.0
2017-12-06	AIVI	ETF	42.96	43.05	42.92	42.93	18200.0
2017-12-06	AMJ	ETF	26.25	26.34	25.79	25.92	4316490.0
2017-12-06	AMLP	ETF	51.35	51.95	50.9	51.0	3289220.0
2017-12-06	AMZA	ETF	81.6	81.6	79.6	80.1	114100.0
2017-12-06	ANGL	ETF	29.94	30.02	29.91	29.94	222700.0
2017-12-06	AOA	ETF	54.81	54.88	54.78	54.79	39600.0
2017-12-06	AOK	ETF	34.54	34.54	34.43	34.43	71322.0
2017-12-06	AOM	ETF	38.44	38.47	38.32	38.44	155396.0
2017-12-06	AOR	ETF	45.6	45.65	45.5585	45.56	126283.0
2017-12-06	ARGT	ETF	32.15	32.53	32.09	32.37	29100.0
2017-12-06	ARKG	ETF	24.58	24.62	24.02	24.42	26800.0
2017-12-06	ARKK	ETF	36.22	36.6	36.06	36.52	230800.0
2017-12-06	ARKQ	ETF	33.32	33.33	33.05	33.18	42700.0
2017-12-06	ARKW	ETF	44.35	44.856	44.2	44.81	115600.0
2017-12-06	ASEA	ETF	16.41	16.62	16.41	16.56	2900.0
2017-12-06	ASET	ETF	28.4553	28.48	28.3999	28.4683	2175.0
2017-12-06	ASHR	ETF	30.52	30.61	30.32	30.4	1928700.0
2017-12-06	ASHS	ETF	33.58	33.74	33.58	33.64	15900.0
2017-12-06	ASHX	ETF	22.51	22.51	22.4693	22.4693	710.0
2017-12-06	ATMP	ETF	19.93	19.93	19.53	19.62	91500.0
2017-12-06	BAB	ETF	30.74	30.79	30.65	30.75	120523.0
2017-12-06	BAL	ETF	48.12	48.25	48.06	48.06	8422.0
2017-12-06	BBC	ETF	27.18	27.18	26.4061	26.84	11057.0
2017-12-06	BBH	ETF	123.03	123.73	121.82	122.84	25100.0

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

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