PREVIEW / etf_daily / 2016-05-18

all etf daily files

  file:    by_date/etf_daily/2016/2016-05-18.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-05-18	SPY	ETF	204.44	206.3	203.63	204.91	120062100.0
2016-05-18	QQQ	ETF	105.29	106.43	105.04	105.86	28177911.0
2016-05-18	IWM	ETF	108.81	110.66	108.79	109.84	35734400.0
2016-05-18	DIA	ETF	175.08	176.73	174.53	175.63	4097800.0
2016-05-18	GLD	ETF	121.22	121.92	119.88	120.1	13381700.0
2016-05-18	TLT	ETF	130.81	130.85	128.91	129.49	12681000.0
2016-05-18	AADR	ETF	38.1	38.1	38.0	38.0	900.0
2016-05-18	AAXJ	ETF	51.49	51.92	51.09	51.36	661500.0
2016-05-18	ACTX	ETF	4.72	5.31	4.13	5.31	609.0
2016-05-18	ACWF	ETF	22.62	22.68	22.53	22.68	876.0
2016-05-18	ACWI	ETF	55.76	56.24	55.47	55.77	2208100.0
2016-05-18	ACWV	ETF	73.27	73.57	72.67	72.86	127300.0
2016-05-18	ACWX	ETF	39.27	39.67	39.11	39.23	784509.0
2016-05-18	ADRE	ETF	30.04	30.1199	29.7	29.78	2083.0
2016-05-18	AFK	ETF	20.13	20.4	19.96	19.9601	17531.0
2016-05-18	AFTY	ETF	12.23	12.23	12.14	12.14	1000.0
2016-05-18	AGG	ETF	110.78	110.8	110.32	110.4	1900800.0
2016-05-18	AGGY	ETF	50.874	50.874	50.655	50.655	2900.0
2016-05-18	AGNG	ETF	15.18	15.18	15.18	15.18	200.0
2016-05-18	AGQ	ETF	39.54	40.15	38.0	38.69	239400.0
2016-05-18	AGZ	ETF	114.659	114.794	114.425	114.5416	12069.0
2016-05-18	AGZD	ETF	23.95	23.965	23.925	23.965	2800.0
2016-05-18	AIA	ETF	40.72	41.04	40.4989	40.69	43485.0
2016-05-18	AIQ	ETF	7.4	7.85	7.35	7.47	18979.0
2016-05-18	AIRR	ETF	17.51	17.51	17.36	17.36	800.0
2016-05-18	AIVI	ETF	38.27	38.62	38.12	38.14	11000.0
2016-05-18	ALTY	ETF	14.492	14.492	14.492	14.492	100.0
2016-05-18	AMJ	ETF	30.86	30.91	29.98	30.1	2762290.0
2016-05-18	AMLP	ETF	62.05	62.25	59.95	60.25	2402460.0
2016-05-18	AMZA	ETF	109.4	109.9	105.38	105.9	8510.0
2016-05-18	ANGL	ETF	26.83	26.85	26.73	26.76	122200.0
2016-05-18	AOA	ETF	45.03	45.33	44.89	45.0	25000.0
2016-05-18	AOK	ETF	32.34	32.45	32.13	32.13	71249.0
2016-05-18	AOM	ETF	34.75	34.84	34.573	34.62	59343.0
2016-05-18	AOR	ETF	39.34	39.4099	39.08	39.13	68915.0
2016-05-18	ARGT	ETF	20.52	20.57	20.24	20.42	18800.0
2016-05-18	ARKG	ETF	16.7	16.817	16.7	16.817	600.0
2016-05-18	ARKK	ETF	18.28	18.28	18.28	18.28	100.0
2016-05-18	ARKQ	ETF	18.19	18.23	18.19	18.23	200.0
2016-05-18	ARKW	ETF	20.7	20.763	20.7	20.763	300.0
2016-05-18	ASEA	ETF	12.75	12.9	12.74	12.87	2600.0
2016-05-18	ASET	ETF	25.82	25.82	25.82	25.82	100.0
2016-05-18	ASHR	ETF	22.88	22.92	22.61	22.75	1470000.0
2016-05-18	ASHS	ETF	31.0	31.14	30.8	30.93	41800.0
2016-05-18	ASHX	ETF	20.19	20.64	20.19	20.49	4355.0
2016-05-18	ATMP	ETF	21.11	21.21	20.73	20.73	48900.0
2016-05-18	BAB	ETF	30.68	30.68	30.3	30.34	179507.0
2016-05-18	BAL	ETF	41.0899	41.2	40.768	41.06	16732.0
2016-05-18	BBC	ETF	17.97	18.5036	17.97	18.39	19513.0
2016-05-18	BBH	ETF	103.27	105.11	103.1	104.64	122700.0

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

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