PREVIEW / etf_daily / 2016-10-24

all etf daily files

  file:    by_date/etf_daily/2016/2016-10-24.parquet
  size:    52 KB
  rows:    1,305

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
2016-10-24	SPY	ETF	215.0	215.32	214.48	214.89	60146600.0
2016-10-24	QQQ	ETF	118.93	119.65	118.8918	119.57	19142985.0
2016-10-24	IWM	ETF	122.04	122.61	121.45	121.84	15421600.0
2016-10-24	DIA	ETF	182.36	182.5	181.65	181.96	1905700.0
2016-10-24	GLD	ETF	121.28	121.3	120.16	120.56	5481100.0
2016-10-24	TLT	ETF	133.41	133.45	132.29	132.73	6507500.0
2016-10-24	AADR	ETF	42.3	42.3	41.9	41.92	1000.0
2016-10-24	AAXJ	ETF	60.24	60.39	60.06	60.23	678700.0
2016-10-24	ACTX	ETF	13.5701	18.2902	12.3901	15.9301	11191.0
2016-10-24	ACWF	ETF	23.8914	23.9218	23.8914	23.9218	331.0
2016-10-24	ACWI	ETF	58.59	58.75	58.5	58.62	659100.0
2016-10-24	ACWV	ETF	74.28	74.4	74.05	74.17	102000.0
2016-10-24	ACWX	ETF	41.19	41.25	41.025	41.105	442673.0
2016-10-24	ADRE	ETF	36.17	36.29	36.0417	36.11	5661.0
2016-10-24	AFK	ETF	20.5	20.89	20.0	20.6953	13301.0
2016-10-24	AFTY	ETF	13.71	13.71	13.58	13.58	5400.0
2016-10-24	AGG	ETF	111.81	111.83	111.6	111.66	1385600.0
2016-10-24	AGGY	ETF	51.61	51.62	51.55	51.6	11200.0
2016-10-24	AGQ	ETF	41.67	41.85	39.95	40.24	149200.0
2016-10-24	AGZ	ETF	115.1738	115.1738	115.0204	115.11	7393.0
2016-10-24	AGZD	ETF	23.94	23.985	23.9	23.905	12000.0
2016-10-24	AIA	ETF	50.0	50.04	49.815	49.92	15260.0
2016-10-24	AIQ	ETF	7.9	8.1	7.9	8.1	13093.0
2016-10-24	AIRR	ETF	20.12	20.12	19.87	19.93	12100.0
2016-10-24	AIVI	ETF	37.98	38.07	37.82	37.89	14100.0
2016-10-24	ALTY	ETF	15.163	15.306	15.163	15.306	2100.0
2016-10-24	AMJ	ETF	31.18	31.55	31.09	31.34	999502.0
2016-10-24	AMLP	ETF	63.25	63.55	62.85	63.2	1126280.0
2016-10-24	AMZA	ETF	109.4	110.09	108.82	109.8	6300.0
2016-10-24	ANGL	ETF	29.25	29.3	29.23	29.29	151600.0
2016-10-24	AOA	ETF	47.06	47.1	46.9	46.98	39200.0
2016-10-24	AOK	ETF	32.85	33.13	32.85	33.06	38404.0
2016-10-24	AOM	ETF	35.6	35.7499	35.591	35.67	57666.0
2016-10-24	AOR	ETF	41.02	41.02	40.6	40.64	90354.0
2016-10-24	ARGT	ETF	24.41	24.66	24.36	24.52	73700.0
2016-10-24	ARKG	ETF	17.85	17.85	17.85	17.85	1000.0
2016-10-24	ARKK	ETF	20.668	20.668	20.668	20.668	400.0
2016-10-24	ARKQ	ETF	21.44	21.44	21.425	21.425	2800.0
2016-10-24	ARKW	ETF	25.34	25.34	25.17	25.25	4700.0
2016-10-24	ASEA	ETF	13.79	13.81	13.79	13.81	500.0
2016-10-24	ASHR	ETF	25.0	25.1	25.0	25.03	517200.0
2016-10-24	ASHS	ETF	35.35	35.35	35.21	35.23	2800.0
2016-10-24	ASHX	ETF	23.2053	23.23	23.2053	23.23	1201.0
2016-10-24	ATMP	ETF	23.37	23.37	23.02	23.19	9700.0
2016-10-24	BAB	ETF	30.98	30.98	30.8002	30.89	68423.0
2016-10-24	BAL	ETF	45.71	45.71	45.551	45.614	2670.0
2016-10-24	BBC	ETF	20.02	20.02	19.66	19.66	4528.0
2016-10-24	BBH	ETF	107.3	107.3	106.2	106.22	40600.0
2016-10-24	BBP	ETF	30.29	30.51	30.16	30.168	7200.0
2016-10-24	BFOR	ETF	7.9525	7.99	7.9525	7.9775	25200.0

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

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