PREVIEW / etf_daily / 2017-12-26

all etf daily files

  file:    by_date/etf_daily/2017/2017-12-26.parquet
  size:    59 KB
  rows:    1,518

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-12-26	SPY	ETF	267.05	267.44	266.89	267.19	45244400.0
2017-12-26	QQQ	ETF	156.53	156.72	155.95	156.52	21918720.0
2017-12-26	IWM	ETF	153.0	153.43	152.9	153.28	11949600.0
2017-12-26	DIA	ETF	246.94	247.59	246.88	247.25	2156700.0
2017-12-26	GLD	ETF	121.55	121.87	121.51	121.77	8224400.0
2017-12-26	TLT	ETF	124.98	125.53	124.97	125.14	3168400.0
2017-12-26	AADR	ETF	58.69	58.88	58.67	58.86	18600.0
2017-12-26	AAXJ	ETF	75.34	75.34	75.01	75.26	233100.0
2017-12-26	ACSI	ETF	31.44	31.44	31.399	31.399	1106.0
2017-12-26	ACTX	ETF	96.1709	114.461	86.1408	109.741	4025.0
2017-12-26	ACWF	ETF	30.47	30.47	30.4362	30.4362	2096.0
2017-12-26	ACWI	ETF	72.01	72.01	71.82	71.92	4644200.0
2017-12-26	ACWV	ETF	83.95	84.09	83.9	84.01	53400.0
2017-12-26	ACWX	ETF	49.57	49.69	49.57	49.67	493905.0
2017-12-26	ADRE	ETF	42.69	42.8358	42.59	42.8358	2480.0
2017-12-26	AFK	ETF	24.27	24.32	23.83	24.08	16078.0
2017-12-26	AFTY	ETF	17.75	17.75	17.74	17.74	800.0
2017-12-26	AGG	ETF	108.91	109.01	108.87	108.96	1873400.0
2017-12-26	AGGY	ETF	50.45	50.5	50.43	50.466	42400.0
2017-12-26	AGNG	ETF	19.53	19.53	19.48	19.48	2100.0
2017-12-26	AGQ	ETF	32.08	32.41	32.04	32.34	142600.0
2017-12-26	AGZ	ETF	112.82	112.87	112.77	112.82	20647.0
2017-12-26	AGZD	ETF	24.195	24.195	24.07	24.075	7600.0
2017-12-26	AIA	ETF	64.94	65.02	64.78	64.94	245267.0
2017-12-26	AIEQ	ETF	26.12	26.12	25.98	26.01	81500.0
2017-12-26	AIRR	ETF	27.51	27.619	27.5	27.559	5300.0
2017-12-26	AIVI	ETF	43.16	43.28	43.1	43.22	105400.0
2017-12-26	ALTY	ETF	15.306	15.332	15.304	15.329	4500.0
2017-12-26	AMJ	ETF	27.42	27.57	27.35	27.5	2657631.0
2017-12-26	AMLP	ETF	54.25	54.4	53.95	54.3	3608120.0
2017-12-26	AMZA	ETF	86.2	86.55	85.8	86.3	135210.0
2017-12-26	ANGL	ETF	29.98	30.08	29.95	30.06	1896900.0
2017-12-26	AOA	ETF	55.76	55.8	55.73	55.75	32400.0
2017-12-26	AOK	ETF	34.56	34.6	34.52	34.59	83369.0
2017-12-26	AOM	ETF	38.65	38.74	38.61	38.68	168086.0
2017-12-26	AOR	ETF	46.12	46.26	46.09	46.16	128715.0
2017-12-26	ARGT	ETF	35.6	35.72	35.45	35.5	65700.0
2017-12-26	ARKG	ETF	24.75	25.08	24.75	24.93	17800.0
2017-12-26	ARKK	ETF	37.9	38.329	37.88	38.26	190300.0
2017-12-26	ARKQ	ETF	34.12	34.12	33.65	33.84	23900.0
2017-12-26	ARKW	ETF	47.25	47.79	47.25	47.72	151500.0
2017-12-26	ASEA	ETF	17.05	17.05	16.91	17.0	2900.0
2017-12-26	ASET	ETF	28.8483	28.85	28.82	28.82	584.0
2017-12-26	ASHR	ETF	31.05	31.07	31.01	31.07	249000.0
2017-12-26	ASHS	ETF	34.52	34.56	34.52	34.56	3600.0
2017-12-26	ASHX	ETF	22.2282	22.2282	22.17	22.17	3005.0
2017-12-26	ATMP	ETF	20.73	20.78	20.69	20.73	311400.0
2017-12-26	BAB	ETF	30.42	30.49	30.42	30.46	38472.0
2017-12-26	BAL	ETF	51.49	51.49	51.43	51.43	757.0
2017-12-26	BAR	ETF	12.81	12.828	12.8046	12.828	8270.0

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

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