PREVIEW / etf_daily / 2016-06-01

all etf daily files

  file:    by_date/etf_daily/2016/2016-06-01.parquet
  size:    50 KB
  rows:    1,266

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-06-01	SPY	ETF	209.12	210.48	208.89	210.27	69936200.0
2016-06-01	QQQ	ETF	110.0	110.6	109.91	110.35	19571528.0
2016-06-01	IWM	ETF	114.61	115.95	114.42	115.78	26806100.0
2016-06-01	DIA	ETF	176.98	177.98	176.55	177.73	2481200.0
2016-06-01	GLD	ETF	115.97	116.14	115.2	115.94	8399600.0
2016-06-01	TLT	ETF	130.63	131.27	130.11	130.42	9874900.0
2016-06-01	AADR	ETF	38.5	38.71	38.5	38.61	1800.0
2016-06-01	AAXJ	ETF	53.21	53.31	53.04	53.19	392300.0
2016-06-01	ACTX	ETF	4.248	4.248	4.13	4.13	821.0
2016-06-01	ACWI	ETF	56.82	57.12	56.69	57.08	1188100.0
2016-06-01	ACWV	ETF	73.58	73.9	73.58	73.87	269800.0
2016-06-01	ACWX	ETF	39.78	40.03	39.75	40.0	728578.0
2016-06-01	ADRE	ETF	30.27	30.4399	30.27	30.35	4957.0
2016-06-01	AFK	ETF	19.8	19.89	19.5	19.84	33360.0
2016-06-01	AGG	ETF	110.59	110.65	110.41	110.42	2941300.0
2016-06-01	AGGY	ETF	50.817	50.85	50.734	50.787	7300.0
2016-06-01	AGNG	ETF	15.7	15.78	15.7	15.78	300.0
2016-06-01	AGQ	ETF	34.79	35.01	34.07	34.75	209200.0
2016-06-01	AGZ	ETF	114.77	114.77	114.45	114.48	28315.0
2016-06-01	AIA	ETF	42.73	42.92	42.7	42.88	19665.0
2016-06-01	AIQ	ETF	7.19	7.23	6.96	7.06	20715.0
2016-06-01	AIRR	ETF	18.13	18.25	18.13	18.22	7900.0
2016-06-01	AIVI	ETF	38.14	38.32	38.07	38.28	8600.0
2016-06-01	ALTY	ETF	14.56	14.6	14.56	14.6	800.0
2016-06-01	AMJ	ETF	29.84	30.9	29.84	30.86	3979677.0
2016-06-01	AMLP	ETF	60.6	62.8	60.45	62.7	1640100.0
2016-06-01	AMZA	ETF	109.2	113.27	108.7	113.0	17120.0
2016-06-01	ANGL	ETF	26.96	26.96	26.78	26.81	76700.0
2016-06-01	AOA	ETF	45.72	45.91	45.58	45.88	30100.0
2016-06-01	AOK	ETF	32.48	32.5399	32.429	32.51	31591.0
2016-06-01	AOM	ETF	35.04	35.05	34.8901	35.01	117586.0
2016-06-01	AOR	ETF	39.63	39.85	39.63	39.82	126868.0
2016-06-01	ARGT	ETF	20.71	20.77	20.5	20.76	6900.0
2016-06-01	ARKG	ETF	17.93	17.93	17.93	17.93	100.0
2016-06-01	ARKK	ETF	19.52	19.52	19.52	19.52	200.0
2016-06-01	ARKQ	ETF	19.22	19.39	19.22	19.385	2900.0
2016-06-01	ARKW	ETF	21.9	22.06	21.88	22.01	3400.0
2016-06-01	ASHR	ETF	23.95	23.95	23.74	23.8	1173200.0
2016-06-01	ASHS	ETF	33.19	33.32	33.04	33.24	19400.0
2016-06-01	ASHX	ETF	21.91	21.91	21.91	21.91	272.0
2016-06-01	ATMP	ETF	20.37	21.24	20.37	21.23	61100.0
2016-06-01	BAB	ETF	30.69	30.7499	30.61	30.68	291712.0
2016-06-01	BAL	ETF	42.02	42.061	41.7	41.86	35618.0
2016-06-01	BBC	ETF	20.98	21.1999	20.91	21.0722	29903.0
2016-06-01	BBH	ETF	109.74	111.05	109.56	110.74	40000.0
2016-06-01	BBP	ETF	27.93	28.026	27.93	27.969	24700.0
2016-06-01	BCM	ETF	26.4	26.78	26.4	26.78	2199.0
2016-06-01	BDCZ	ETF	20.3099	20.3099	20.2601	20.2601	200.0
2016-06-01	BFOR	ETF	7.67	7.7425	7.67	7.7375	32400.0
2016-06-01	BIB	ETF	46.0	47.09	45.57	46.76	499473.0

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

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