PREVIEW / etf_daily / 2016-06-03

all etf daily files

  file:    by_date/etf_daily/2016/2016-06-03.parquet
  size:    51 KB
  rows:    1,283

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-03	SPY	ETF	210.25	210.69	208.86	210.28	101757100.0
2016-06-03	QQQ	ETF	110.37	110.42	109.34	110.06	20269923.0
2016-06-03	IWM	ETF	116.47	116.47	115.0	115.97	28733200.0
2016-06-03	DIA	ETF	177.87	178.29	176.84	178.06	4367200.0
2016-06-03	GLD	ETF	118.25	118.89	118.23	118.88	14605100.0
2016-06-03	TLT	ETF	132.86	133.23	132.6	133.23	11077200.0
2016-06-03	AAXJ	ETF	54.06	54.16	53.71	54.08	566400.0
2016-06-03	ACTX	ETF	4.72	5.31	4.13	4.13	1683.0
2016-06-03	ACWF	ETF	23.29	23.29	23.29	23.29	1114.0
2016-06-03	ACWI	ETF	57.21	57.42	56.95	57.34	910000.0
2016-06-03	ACWV	ETF	74.24	74.74	74.24	74.66	70800.0
2016-06-03	ACWX	ETF	40.25	40.44	40.09	40.4	320666.0
2016-06-03	ADRE	ETF	30.77	30.79	30.541	30.7255	8232.0
2016-06-03	AFK	ETF	20.42	20.95	20.4099	20.85	76374.0
2016-06-03	AGG	ETF	111.15	111.3	111.12	111.3	2210500.0
2016-06-03	AGGY	ETF	51.09	51.18	51.07	51.18	4200.0
2016-06-03	AGNG	ETF	15.93	15.94	15.93	15.94	600.0
2016-06-03	AGQ	ETF	36.53	36.79	36.21	36.61	321700.0
2016-06-03	AGZ	ETF	115.03	115.1599	114.7399	115.02	19445.0
2016-06-03	AIA	ETF	43.59	43.76	43.44	43.66	48097.0
2016-06-03	AIQ	ETF	6.95	6.97	6.785	6.82	26315.0
2016-06-03	AIRR	ETF	18.33	18.33	18.11	18.253	12300.0
2016-06-03	AIVI	ETF	38.53	38.72	38.43	38.68	38100.0
2016-06-03	ALTY	ETF	14.78	14.78	14.779	14.779	500.0
2016-06-03	AMJ	ETF	31.03	31.31	30.79	30.98	2040883.0
2016-06-03	AMLP	ETF	62.9	63.4	62.4	62.95	1185460.0
2016-06-03	AMZA	ETF	113.8	114.98	112.2	113.2	17070.0
2016-06-03	ANGL	ETF	26.9	27.03	26.86	27.02	58100.0
2016-06-03	AOA	ETF	45.95	46.17	45.87	46.09	32400.0
2016-06-03	AOK	ETF	32.6	32.72	32.525	32.66	379031.0
2016-06-03	AOM	ETF	35.18	35.2799	35.1	35.27	172383.0
2016-06-03	AOR	ETF	39.92	40.1873	39.87	40.04	151554.0
2016-06-03	ARGT	ETF	21.18	21.22	21.05	21.22	55900.0
2016-06-03	ARKG	ETF	18.035	18.035	18.035	18.035	100.0
2016-06-03	ARKK	ETF	19.587	19.62	19.52	19.57	3400.0
2016-06-03	ARKQ	ETF	19.385	19.385	19.385	19.385	100.0
2016-06-03	ARKW	ETF	22.02	22.02	22.02	22.02	500.0
2016-06-03	ASEA	ETF	13.04	13.16	12.99	13.05	5400.0
2016-06-03	ASHR	ETF	24.1	24.3	24.1	24.29	1312900.0
2016-06-03	ASHS	ETF	33.73	33.95	33.69	33.94	26800.0
2016-06-03	ASHX	ETF	21.7201	21.7201	21.7201	21.7201	250.0
2016-06-03	ATMP	ETF	21.35	21.72	21.26	21.41	26300.0
2016-06-03	BAB	ETF	30.87	30.97	29.65	30.97	145665.0
2016-06-03	BAL	ETF	42.27	42.4644	42.12	42.13	6558.0
2016-06-03	BBC	ETF	21.62	21.681	20.9272	21.13	11467.0
2016-06-03	BBH	ETF	111.84	111.84	109.55	110.99	122200.0
2016-06-03	BBP	ETF	28.91	28.91	27.918	28.25	7200.0
2016-06-03	BCM	ETF	26.9284	26.98	26.864	26.98	8065.0
2016-06-03	BDCZ	ETF	20.3099	20.35	20.25	20.3101	1200.0
2016-06-03	BFOR	ETF	7.76	7.76	7.6775	7.725	32000.0

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

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