PREVIEW / etf_daily / 2016-09-01

all etf daily files

  file:    by_date/etf_daily/2016/2016-09-01.parquet
  size:    51 KB
  rows:    1,282

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-09-01	SPY	ETF	217.37	217.73	216.03	217.39	97844200.0
2016-09-01	QQQ	ETF	116.48	116.88	115.91	116.74	20944727.0
2016-09-01	IWM	ETF	123.34	123.63	122.02	123.32	22964700.0
2016-09-01	DIA	ETF	183.73	184.28	182.9	184.1	3003500.0
2016-09-01	GLD	ETF	124.67	125.51	124.55	125.29	12877700.0
2016-09-01	TLT	ETF	138.62	140.1	138.57	139.77	9149100.0
2016-09-01	AADR	ETF	40.23	40.4	40.06	40.33	18500.0
2016-09-01	AAXJ	ETF	58.95	59.06	58.69	59.04	645400.0
2016-09-01	ACTX	ETF	2.95	2.95	2.95	2.95	677.0
2016-09-01	ACWF	ETF	24.0199	24.0199	24.0199	24.0199	834.0
2016-09-01	ACWI	ETF	58.71	58.77	58.39	58.76	5279300.0
2016-09-01	ACWV	ETF	75.8	76.06	75.71	76.01	156600.0
2016-09-01	ACWX	ETF	41.0	41.15	40.89	41.15	714910.0
2016-09-01	ADRE	ETF	33.94	34.294	33.94	34.1801	2542.0
2016-09-01	AFK	ETF	20.0	20.5899	20.0	20.11	15663.0
2016-09-01	AFTY	ETF	13.5	13.52	13.5	13.52	1100.0
2016-09-01	AGG	ETF	112.1	112.5	112.05	112.46	3777100.0
2016-09-01	AGGY	ETF	52.03	52.17	52.03	52.094	33000.0
2016-09-01	AGNG	ETF	16.43	16.43	16.43	16.43	200.0
2016-09-01	AGQ	ETF	45.93	47.29	45.82	47.03	139200.0
2016-09-01	AGZ	ETF	115.55	115.637	115.4901	115.51	15457.0
2016-09-01	AGZD	ETF	23.9	24.04	23.9	24.04	1200.0
2016-09-01	AIA	ETF	48.29	48.46	48.25	48.42	8711.0
2016-09-01	AIQ	ETF	6.6	6.6	6.198	6.24	12993.0
2016-09-01	AIRR	ETF	19.72	19.72	19.45	19.613	9100.0
2016-09-01	AIVI	ETF	38.75	38.82	38.63	38.8	12900.0
2016-09-01	ALTY	ETF	15.74	15.74	15.58	15.59	1700.0
2016-09-01	AMJ	ETF	30.85	31.155	30.656	30.95	1483473.0
2016-09-01	AMLP	ETF	62.45	62.85	62.15	62.85	911400.0
2016-09-01	AMZA	ETF	114.0	114.45	113.3	114.3	4870.0
2016-09-01	ANGL	ETF	28.55	28.62	28.53	28.6	339900.0
2016-09-01	AOA	ETF	47.26	47.34	47.09	47.32	32000.0
2016-09-01	AOK	ETF	33.26	33.4399	33.25	33.35	43475.0
2016-09-01	AOM	ETF	36.17	36.21	35.8301	36.02	160828.0
2016-09-01	AOR	ETF	40.96	40.9899	40.7964	40.98	30586.0
2016-09-01	ARGT	ETF	22.47	22.66	22.32	22.66	22700.0
2016-09-01	ARKG	ETF	18.0	18.015	18.0	18.0	20200.0
2016-09-01	ARKK	ETF	20.47	20.47	20.47	20.47	100.0
2016-09-01	ARKQ	ETF	21.18	21.18	20.94	21.0	2100.0
2016-09-01	ARKW	ETF	24.436	24.436	24.406	24.406	300.0
2016-09-01	ASEA	ETF	13.89	13.89	13.88	13.88	1400.0
2016-09-01	ASET	ETF	26.66	26.6601	26.66	26.6601	400.0
2016-09-01	ASHR	ETF	24.95	25.01	24.89	24.96	703400.0
2016-09-01	ASHS	ETF	35.03	35.03	34.82	34.93	7700.0
2016-09-01	ASHX	ETF	22.772	22.772	22.772	22.772	366.0
2016-09-01	ATMP	ETF	22.31	22.5	22.25	22.44	18800.0
2016-09-01	BAB	ETF	31.6	31.7399	31.4901	31.73	597998.0
2016-09-01	BAL	ETF	43.7361	45.31	43.71	45.24	34770.0
2016-09-01	BBC	ETF	19.97	19.97	19.86	19.918	42165.0
2016-09-01	BBH	ETF	113.59	113.94	112.9	113.79	56500.0

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

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