PREVIEW / etf_daily / 2016-05-25

all etf daily files

  file:    by_date/etf_daily/2016/2016-05-25.parquet
  size:    51 KB
  rows:    1,280

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-05-25	SPY	ETF	208.67	209.77	207.87	209.28	76621400.0
2016-05-25	QQQ	ETF	108.86	109.57	108.684	109.24	38464750.0
2016-05-25	IWM	ETF	113.3	113.9	113.08	113.6	26202900.0
2016-05-25	DIA	ETF	177.5	178.74	177.45	178.28	2711900.0
2016-05-25	GLD	ETF	116.59	117.06	116.32	116.98	10487300.0
2016-05-25	TLT	ETF	129.83	130.25	129.31	129.37	6367400.0
2016-05-25	AADR	ETF	38.15	38.64	38.15	38.64	500.0
2016-05-25	AAXJ	ETF	52.36	52.69	52.36	52.55	515500.0
2016-05-25	ACTX	ETF	5.605	5.9001	4.72	4.72	409.0
2016-05-25	ACWF	ETF	23.12	23.12	23.09	23.09	4800.0
2016-05-25	ACWI	ETF	56.75	57.1	56.75	56.97	1240200.0
2016-05-25	ACWV	ETF	73.51	73.7	73.35	73.57	108500.0
2016-05-25	ACWX	ETF	39.89	40.15	39.89	40.08	1125110.0
2016-05-25	ADRE	ETF	30.28	30.4267	30.09	30.13	8047.0
2016-05-25	AFK	ETF	19.8465	20.5201	19.7686	20.05	33563.0
2016-05-25	AFTY	ETF	12.22	12.26	12.12	12.12	20800.0
2016-05-25	AGG	ETF	110.54	110.55	110.39	110.48	2735700.0
2016-05-25	AGGY	ETF	50.55	50.68	50.55	50.65	800.0
2016-05-25	AGQ	ETF	36.11	36.5	35.99	36.24	111200.0
2016-05-25	AGZ	ETF	114.61	114.7699	114.57	114.57	21984.0
2016-05-25	AGZD	ETF	23.94	23.94	23.92	23.92	1200.0
2016-05-25	AIA	ETF	41.95	42.12	41.95	42.11	14656.0
2016-05-25	AIQ	ETF	7.57	7.57	7.28	7.41	17193.0
2016-05-25	AIRR	ETF	17.92	18.2	17.92	18.159	50600.0
2016-05-25	AIVI	ETF	38.64	38.77	38.54	38.71	29900.0
2016-05-25	ALTY	ETF	14.637	14.639	14.52	14.52	400.0
2016-05-25	AMJ	ETF	30.42	30.67	30.15	30.42	2248323.0
2016-05-25	AMLP	ETF	61.85	62.5	61.3	61.85	1666520.0
2016-05-25	AMZA	ETF	110.3	111.2	109.23	109.8	23190.0
2016-05-25	ANGL	ETF	26.9	26.96	26.88	26.91	54700.0
2016-05-25	AOA	ETF	45.68	45.87	45.68	45.81	32300.0
2016-05-25	AOK	ETF	32.37	32.49	32.32	32.4	89456.0
2016-05-25	AOM	ETF	34.93	34.9999	34.8636	34.97	55043.0
2016-05-25	AOR	ETF	39.76	39.7899	39.58	39.76	79738.0
2016-05-25	ARGT	ETF	20.69	20.71	20.55	20.66	38300.0
2016-05-25	ARKG	ETF	17.78	17.78	17.78	17.78	200.0
2016-05-25	ARKK	ETF	18.97	19.097	18.94	19.09	5000.0
2016-05-25	ARKQ	ETF	19.03	19.03	19.03	19.03	100.0
2016-05-25	ARKW	ETF	21.52	21.52	21.451	21.451	900.0
2016-05-25	ASEA	ETF	12.78	12.86	12.78	12.86	700.0
2016-05-25	ASHR	ETF	23.09	23.21	23.01	23.06	937300.0
2016-05-25	ASHS	ETF	31.57	31.64	31.55	31.61	11100.0
2016-05-25	ASHX	ETF	20.81	20.81	20.75	20.75	669.0
2016-05-25	ATMP	ETF	20.84	20.94	20.79	20.79	21000.0
2016-05-25	BAB	ETF	30.47	30.5197	30.42	30.43	110706.0
2016-05-25	BAL	ETF	41.86	41.86	41.36	41.611	941.0
2016-05-25	BBC	ETF	20.05	20.35	19.98	20.23	24925.0
2016-05-25	BBH	ETF	108.72	109.38	108.27	109.31	94600.0
2016-05-25	BBP	ETF	27.22	27.436	27.2	27.25	6600.0
2016-05-25	BCM	ETF	26.49	26.71	26.49	26.71	8226.0

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

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