PREVIEW / etf_daily / 2017-06-15

all etf daily files

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

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-15	SPY	ETF	242.68	243.91	242.36	243.77	66464900.0
2017-06-15	QQQ	ETF	138.35	139.28	137.49	139.13	55145160.0
2017-06-15	IWM	ETF	139.69	140.98	139.69	140.54	27376800.0
2017-06-15	DIA	ETF	212.89	213.8	212.75	213.69	2571800.0
2017-06-15	GLD	ETF	119.22	119.5	119.13	119.32	6796700.0
2017-06-15	TLT	ETF	126.09	126.33	125.83	126.1	5863700.0
2017-06-15	AADR	ETF	46.22	46.25	45.83	46.25	22700.0
2017-06-15	AAXJ	ETF	66.95	67.14	66.76	67.1	660300.0
2017-06-15	ACSI	ETF	28.89	28.906	28.81	28.9	3374.0
2017-06-15	ACTX	ETF	97.3509	100.3009	76.7007	79.6507	1114.0
2017-06-15	ACWF	ETF	27.14	27.14	27.06	27.075	1449.0
2017-06-15	ACWI	ETF	65.72	66.04	65.66	66.03	1871000.0
2017-06-15	ACWV	ETF	80.28	80.66	80.22	80.66	112500.0
2017-06-15	ACWX	ETF	45.66	45.84	45.59	45.83	358574.0
2017-06-15	ADRE	ETF	38.0	38.0001	37.75	38.0001	8917.0
2017-06-15	AFK	ETF	21.83	21.83	21.65	21.65	4734.0
2017-06-15	AFTY	ETF	14.78	14.78	14.78	14.78	2000.0
2017-06-15	AGG	ETF	109.9	109.9	109.78	109.87	2233900.0
2017-06-15	AGGY	ETF	50.8	50.8	50.69	50.76	25800.0
2017-06-15	AGNG	ETF	18.339	18.339	18.339	18.339	100.0
2017-06-15	AGQ	ETF	34.35	34.84	34.18	34.62	145600.0
2017-06-15	AGZ	ETF	113.87	114.0999	113.69	113.97	55575.0
2017-06-15	AGZD	ETF	23.965	23.97	23.965	23.965	9400.0
2017-06-15	AIA	ETF	56.2	56.48	56.13	56.48	44099.0
2017-06-15	AIQ	ETF	13.2	13.25	13.2	13.25	36138.0
2017-06-15	AIRR	ETF	23.768	23.79	23.609	23.76	11300.0
2017-06-15	AIVI	ETF	41.14	41.38	41.14	41.38	8500.0
2017-06-15	ALTY	ETF	15.4	15.465	15.4	15.448	2900.0
2017-06-15	AMJ	ETF	28.65	28.91	28.36	28.44	1914189.0
2017-06-15	AMLP	ETF	57.65	58.05	56.95	57.1	2202860.0
2017-06-15	AMZA	ETF	95.0	95.69	93.1	93.4	113010.0
2017-06-15	ANGL	ETF	29.69	29.69	29.57	29.61	745500.0
2017-06-15	AOA	ETF	51.54	51.76	51.51	51.75	84800.0
2017-06-15	AOK	ETF	34.07	34.07	33.94	34.02	71186.0
2017-06-15	AOM	ETF	37.4	37.4	37.1701	37.27	175362.0
2017-06-15	AOR	ETF	43.62	43.66	43.5	43.66	54246.0
2017-06-15	ARCM	ETF	100.245	100.245	100.245	100.245	40.0
2017-06-15	ARGT	ETF	29.21	29.32	29.04	29.1	127700.0
2017-06-15	ARKG	ETF	21.11	21.17	20.94	21.09	16400.0
2017-06-15	ARKK	ETF	28.04	28.393	27.7	28.36	51800.0
2017-06-15	ARKQ	ETF	28.35	28.683	28.26	28.63	36400.0
2017-06-15	ARKW	ETF	34.2	34.769	33.9	34.73	80400.0
2017-06-15	ASEA	ETF	15.04	15.14	15.04	15.13	700.0
2017-06-15	ASET	ETF	27.695	27.7098	27.695	27.7098	313.0
2017-06-15	ASHR	ETF	25.96	26.04	25.96	26.02	376500.0
2017-06-15	ASHS	ETF	32.07	32.18	32.06	32.13	8100.0
2017-06-15	ASHX	ETF	19.87	19.87	19.8015	19.82	741.0
2017-06-15	ATMP	ETF	21.36	21.56	21.24	21.33	63900.0
2017-06-15	BAB	ETF	30.03	30.05	29.995	30.04	124260.0
2017-06-15	BAL	ETF	46.6599	46.6599	45.5	45.95	33191.0

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

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