PREVIEW / etf_daily / 2017-06-09

all etf daily files

  file:    by_date/etf_daily/2017/2017-06-09.parquet
  size:    55 KB
  rows:    1,408

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
2017-06-09	SPY	ETF	244.09	245.01	241.95	243.41	132256400.0
2017-06-09	QQQ	ETF	143.73	143.9	138.11	139.98	109783737.0
2017-06-09	IWM	ETF	141.46	142.9	140.7	141.61	56979400.0
2017-06-09	DIA	ETF	212.15	213.07	211.59	212.67	4271100.0
2017-06-09	GLD	ETF	120.46	120.91	120.4	120.54	7054700.0
2017-06-09	TLT	ETF	124.08	124.64	123.98	124.4	5130500.0
2017-06-09	AADR	ETF	48.42	48.42	47.2	47.49	14800.0
2017-06-09	AAXJ	ETF	68.43	68.48	67.49	67.85	4041400.0
2017-06-09	ACSI	ETF	28.98	28.99	28.79	28.89	5201.0
2017-06-09	ACTX	ETF	75.5207	88.5008	73.7507	73.7507	913.0
2017-06-09	ACWF	ETF	27.33	27.445	27.15	27.22	13643.0
2017-06-09	ACWI	ETF	66.42	66.6	65.91	66.23	1555600.0
2017-06-09	ACWV	ETF	80.37	80.44	80.05	80.3	176000.0
2017-06-09	ACWX	ETF	46.29	46.385	46.03	46.18	272627.0
2017-06-09	ADRE	ETF	39.35	39.362	38.34	38.72	5599.0
2017-06-09	AFK	ETF	22.04	22.1	21.7936	21.94	5762.0
2017-06-09	AFTY	ETF	15.25	15.25	15.17	15.18	6300.0
2017-06-09	AGG	ETF	109.51	109.63	109.46	109.56	1616800.0
2017-06-09	AGGY	ETF	50.58	50.65	50.558	50.62	5600.0
2017-06-09	AGNG	ETF	18.43	18.43	18.344	18.344	1700.0
2017-06-09	AGQ	ETF	36.44	36.63	36.24	36.42	154600.0
2017-06-09	AGZ	ETF	113.7619	113.815	113.7	113.73	6065.0
2017-06-09	AGZD	ETF	23.96	23.96	23.96	23.96	8200.0
2017-06-09	AIA	ETF	57.29	57.58	56.79	56.94	77203.0
2017-06-09	AIQ	ETF	13.2489	13.25	13.2128	13.25	3102.0
2017-06-09	AIRR	ETF	23.65	24.25	23.65	24.14	45700.0
2017-06-09	AIVI	ETF	41.57	41.91	41.57	41.76	10000.0
2017-06-09	ALTY	ETF	15.4	15.475	15.397	15.436	3700.0
2017-06-09	AMJ	ETF	29.34	29.65	29.26	29.48	2677501.0
2017-06-09	AMLP	ETF	58.85	59.4	58.7	59.2	1554200.0
2017-06-09	AMZA	ETF	97.8	99.0	97.5	98.5	80220.0
2017-06-09	ANGL	ETF	29.53	29.63	29.53	29.56	239000.0
2017-06-09	AOA	ETF	51.89	52.07	51.6	51.87	39300.0
2017-06-09	AOK	ETF	34.05	34.0927	33.96	34.04	47058.0
2017-06-09	AOM	ETF	37.31	37.4301	37.21	37.31	70692.0
2017-06-09	AOR	ETF	43.83	43.83	43.5934	43.72	52359.0
2017-06-09	ARCM	ETF	100.05	100.05	100.05	100.05	20.0
2017-06-09	ARGT	ETF	30.65	30.8	30.06	30.22	52200.0
2017-06-09	ARKG	ETF	21.63	21.681	21.139	21.139	8500.0
2017-06-09	ARKK	ETF	29.92	29.94	28.38	28.826	126700.0
2017-06-09	ARKQ	ETF	29.93	30.01	28.35	28.77	99200.0
2017-06-09	ARKW	ETF	36.92	36.92	34.59	35.23	177400.0
2017-06-09	ASEA	ETF	15.07	15.07	15.07	15.07	700.0
2017-06-09	ASET	ETF	27.58	27.58	27.5598	27.5598	358.0
2017-06-09	ASHR	ETF	26.42	26.49	26.41	26.46	514700.0
2017-06-09	ASHS	ETF	31.98	32.05	31.97	32.01	23500.0
2017-06-09	ASHX	ETF	20.09	20.09	20.09	20.09	200.0
2017-06-09	ATMP	ETF	21.85	22.0	21.77	21.95	50500.0
2017-06-09	BAB	ETF	29.97	30.03	29.96	30.0	135765.0
2017-06-09	BAL	ETF	48.38	48.38	48.01	48.04	11722.0

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

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