PREVIEW / etf_daily / 2015-10-26

all etf daily files

  file:    by_date/etf_daily/2015/2015-10-26.parquet
  size:    49 KB
  rows:    1,218

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
2015-10-26	SPY	ETF	207.3	207.37	206.56	207.0	69033000.0
2015-10-26	QQQ	ETF	112.7	113.07	112.27	112.85	25918004.0
2015-10-26	IWM	ETF	115.6	115.87	114.93	115.06	19783300.0
2015-10-26	DIA	ETF	176.24	176.46	175.87	176.02	3795900.0
2015-10-26	GLD	ETF	111.73	111.98	111.33	111.43	2573500.0
2015-10-26	TLT	ETF	123.87	124.2	123.81	124.02	5859800.0
2015-10-26	AADR	ETF	38.63	38.84	38.55	38.84	3700.0
2015-10-26	AAXJ	ETF	58.14	58.28	58.04	58.13	445900.0
2015-10-26	ACTX	ETF	10.0301	10.0301	9.4401	9.4401	451.0
2015-10-26	ACWI	ETF	58.51	58.51	58.25	58.29	1013900.0
2015-10-26	ACWV	ETF	70.99	71.06	70.75	70.99	74000.0
2015-10-26	ACWX	ETF	42.34	42.38	42.21	42.21	182873.0
2015-10-26	ADRE	ETF	30.96	31.0383	30.83	30.83	19654.0
2015-10-26	AFK	ETF	21.03	21.0795	20.85	20.85	9495.0
2015-10-26	AFTY	ETF	16.33	16.33	16.12	16.15	3600.0
2015-10-26	AGG	ETF	109.85	109.9	109.74	109.8	1541300.0
2015-10-26	AGQ	ETF	36.43	36.49	35.96	36.01	93500.0
2015-10-26	AGZ	ETF	113.74	113.99	113.62	113.89	44249.0
2015-10-26	AGZD	ETF	23.97	23.97	23.97	23.97	800.0
2015-10-26	AIA	ETF	46.52	46.54	46.366	46.51	12804.0
2015-10-26	AIQ	ETF	9.39	9.42	8.6605	8.88	37780.0
2015-10-26	AIRR	ETF	16.64	16.665	16.506	16.506	2600.0
2015-10-26	AIVI	ETF	41.25	41.27	41.14	41.17	9100.0
2015-10-26	ALTY	ETF	14.96	14.96	14.66	14.66	1300.0
2015-10-26	AMJ	ETF	31.9	32.36	31.56	31.58	2128304.0
2015-10-26	AMLP	ETF	65.85	65.95	64.25	64.3	1231020.0
2015-10-26	AMUB	ETF	20.18	20.18	20.18	20.18	150.0
2015-10-26	AMZA	ETF	139.6	139.6	134.0	134.3	1880.0
2015-10-26	ANGL	ETF	26.16	26.17	26.07	26.09	26900.0
2015-10-26	AOA	ETF	46.39	46.39	46.16	46.27	46400.0
2015-10-26	AOK	ETF	32.36	32.387	32.2701	32.291	30547.0
2015-10-26	AOM	ETF	34.84	34.913	34.8	34.89	58109.0
2015-10-26	AOR	ETF	39.91	39.91	39.835	39.87	57478.0
2015-10-26	ARGT	ETF	20.0	20.0	18.85	18.92	60700.0
2015-10-26	ARKG	ETF	19.64	19.64	19.64	19.64	400.0
2015-10-26	ARKK	ETF	19.78	19.78	19.78	19.78	100.0
2015-10-26	ARKQ	ETF	18.57	18.57	18.57	18.57	200.0
2015-10-26	ARKW	ETF	22.87	22.87	22.71	22.72	1300.0
2015-10-26	ASEA	ETF	13.63	13.63	13.6	13.6	2300.0
2015-10-26	ASHR	ETF	36.09	36.11	35.88	35.92	2174700.0
2015-10-26	ASHS	ETF	43.97	43.97	43.12	43.24	146600.0
2015-10-26	ASHX	ETF	25.88	25.88	25.3	25.315	2228.0
2015-10-26	ATMP	ETF	21.95	21.95	21.55	21.55	19400.0
2015-10-26	AWAY	ETF	32.25	32.98	30.84	31.44	2024572.0
2015-10-26	BAB	ETF	29.2	29.32	29.2	29.25	144129.0
2015-10-26	BAL	ETF	41.5	41.694	41.231	41.64	9913.0
2015-10-26	BBC	ETF	26.85	27.59	26.85	26.98	5748.0
2015-10-26	BBH	ETF	120.56	123.15	119.59	121.85	109200.0
2015-10-26	BBP	ETF	29.37	30.151	29.35	29.601	7500.0
2015-10-26	BCM	ETF	26.694	26.71	26.622	26.6222	17100.0

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

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