PREVIEW / etf_daily / 2017-10-10

all etf daily files

  file:    by_date/etf_daily/2017/2017-10-10.parquet
  size:    57 KB
  rows:    1,468

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-10-10	SPY	ETF	254.6	255.05	253.98	254.62	43057400.0
2017-10-10	QQQ	ETF	147.98	148.14	146.95	147.6	19223092.0
2017-10-10	IWM	ETF	149.93	150.29	149.41	149.86	21951900.0
2017-10-10	DIA	ETF	228.21	228.43	227.64	228.26	1417700.0
2017-10-10	GLD	ETF	122.62	122.97	122.36	122.4	9315500.0
2017-10-10	TLT	ETF	124.14	124.87	124.02	124.18	6666800.0
2017-10-10	AADR	ETF	57.01	57.09	56.74	56.94	31800.0
2017-10-10	AAXJ	ETF	74.15	74.49	74.15	74.48	1897700.0
2017-10-10	ACSI	ETF	29.4882	29.4882	29.4044	29.4044	2624.0
2017-10-10	ACTX	ETF	53.1005	59.0005	53.1005	58.4105	124.0
2017-10-10	ACWF	ETF	29.5	29.5	29.5	29.5	378.0
2017-10-10	ACWI	ETF	69.57	69.69	69.48	69.66	1088800.0
2017-10-10	ACWV	ETF	82.02	82.16	81.99	82.13	299600.0
2017-10-10	ACWX	ETF	48.78	48.95	48.7666	48.95	255466.0
2017-10-10	ADRE	ETF	43.05	43.17	42.9636	43.13	14911.0
2017-10-10	AFK	ETF	23.7	23.8	23.6855	23.75	5872.0
2017-10-10	AFTY	ETF	17.33	17.33	17.33	17.33	400.0
2017-10-10	AGG	ETF	109.47	109.61	109.4	109.44	1635800.0
2017-10-10	AGGY	ETF	50.74	50.82	50.691	50.74	11400.0
2017-10-10	AGNG	ETF	19.52	19.53	19.42	19.528	2000.0
2017-10-10	AGQ	ETF	35.25	35.53	34.95	34.98	207600.0
2017-10-10	AGZ	ETF	113.46	113.61	113.46	113.51	7387.0
2017-10-10	AGZD	ETF	24.055	24.085	24.01	24.03	2400.0
2017-10-10	AIA	ETF	63.06	63.3175	63.06	63.29	77366.0
2017-10-10	AIRR	ETF	26.34	26.34	26.08	26.16	14200.0
2017-10-10	AIVI	ETF	42.54	42.77	42.54	42.72	5100.0
2017-10-10	ALTY	ETF	15.755	15.76	15.752	15.76	2800.0
2017-10-10	AMJ	ETF	28.51	28.7	28.43	28.51	2480425.0
2017-10-10	AMLP	ETF	57.0	57.2	56.6	56.75	1051140.0
2017-10-10	AMZA	ETF	89.9	90.29	89.2	89.5	86470.0
2017-10-10	ANGL	ETF	30.26	30.28	30.25	30.27	258200.0
2017-10-10	AOA	ETF	53.88	53.99	53.83	53.99	40100.0
2017-10-10	AOK	ETF	34.53	34.58	34.5001	34.56	64767.0
2017-10-10	AOM	ETF	38.02	38.04	37.957	38.04	215322.0
2017-10-10	AOR	ETF	44.98	45.03	44.95	45.03	55771.0
2017-10-10	ARGT	ETF	32.42	32.44	32.29	32.35	26000.0
2017-10-10	ARKG	ETF	26.81	26.89	26.4	26.74	47700.0
2017-10-10	ARKK	ETF	35.24	35.24	34.54	34.79	103900.0
2017-10-10	ARKQ	ETF	32.8	32.8	32.51	32.55	86900.0
2017-10-10	ARKW	ETF	41.74	41.82	41.17	41.371	29800.0
2017-10-10	ASEA	ETF	15.89	15.91	15.85	15.85	1900.0
2017-10-10	ASET	ETF	28.24	28.25	28.24	28.25	1955.0
2017-10-10	ASHR	ETF	29.96	30.11	29.96	30.07	1235000.0
2017-10-10	ASHS	ETF	37.28	37.47	37.21	37.39	15000.0
2017-10-10	ASHX	ETF	21.9517	21.96	21.95	21.95	2008.0
2017-10-10	ATMP	ETF	21.66	21.66	21.52	21.58	23700.0
2017-10-10	BAB	ETF	30.35	30.4628	30.35	30.38	114854.0
2017-10-10	BAL	ETF	45.89	46.02	45.54	45.55	2119.0
2017-10-10	BAR	ETF	12.903	12.917	12.881	12.8819	39180.0
2017-10-10	BBC	ETF	29.77	29.88	29.49	29.88	6191.0

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

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