PREVIEW / etf_daily / 2017-10-18

all etf daily files

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

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-18	SPY	ETF	255.9	255.95	255.5	255.72	40888300.0
2017-10-18	QQQ	ETF	149.21	149.21	148.64	148.86	17218243.0
2017-10-18	IWM	ETF	149.5	149.91	149.08	149.52	20541700.0
2017-10-18	DIA	ETF	231.0	231.68	230.91	231.46	2720500.0
2017-10-18	GLD	ETF	121.71	121.94	121.55	121.67	3666400.0
2017-10-18	TLT	ETF	125.05	125.18	124.68	125.09	5943800.0
2017-10-18	AADR	ETF	57.38	57.42	57.08	57.2	46300.0
2017-10-18	AAXJ	ETF	75.33	75.47	75.07	75.29	494900.0
2017-10-18	ACSI	ETF	29.4815	29.518	29.4815	29.49	2693.0
2017-10-18	ACTX	ETF	53.1005	56.0505	52.9825	53.6905	363.0
2017-10-18	ACWF	ETF	29.64	29.779	29.64	29.77	5216.0
2017-10-18	ACWI	ETF	70.14	70.17	70.01	70.11	2027400.0
2017-10-18	ACWV	ETF	82.7	82.72	82.51	82.62	58000.0
2017-10-18	ACWX	ETF	49.31	49.365	49.21	49.33	324175.0
2017-10-18	ADRE	ETF	43.54	43.54	43.23	43.4735	6293.0
2017-10-18	AFK	ETF	23.63	23.8375	23.56	23.67	3629.0
2017-10-18	AFTY	ETF	17.6	17.61	17.57	17.58	8000.0
2017-10-18	AGG	ETF	109.51	109.56	109.46	109.54	1663800.0
2017-10-18	AGGY	ETF	50.81	50.83	50.76	50.76	9900.0
2017-10-18	AGNG	ETF	19.8	19.9	19.8	19.9	10000.0
2017-10-18	AGQ	ETF	34.4	34.58	34.28	34.42	73400.0
2017-10-18	AGZ	ETF	113.45	113.528	113.4249	113.51	12223.0
2017-10-18	AGZD	ETF	24.065	24.125	24.065	24.065	3600.0
2017-10-18	AIA	ETF	64.35	64.465	64.136	64.35	28087.0
2017-10-18	AIEQ	ETF	25.12	25.258	25.102	25.23	150130.0
2017-10-18	AIRR	ETF	26.12	26.21	26.06	26.13	24500.0
2017-10-18	AIVI	ETF	42.98	43.05	42.9	43.02	11500.0
2017-10-18	ALTY	ETF	15.708	15.715	15.7	15.701	3100.0
2017-10-18	AMJ	ETF	27.84	27.91	27.23	27.35	2100853.0
2017-10-18	AMLP	ETF	55.25	55.3	53.95	54.2	2273660.0
2017-10-18	AMZA	ETF	86.7	87.0	84.6	85.1	180040.0
2017-10-18	ANGL	ETF	30.34	30.37	30.3	30.36	653400.0
2017-10-18	AOA	ETF	54.2	54.29	54.18	54.26	40400.0
2017-10-18	AOK	ETF	34.61	34.66	34.6095	34.65	38267.0
2017-10-18	AOM	ETF	38.18	38.18	38.1	38.1	125460.0
2017-10-18	AOR	ETF	45.21	45.239	45.14	45.21	162758.0
2017-10-18	ARGT	ETF	31.56	31.76	31.52	31.58	55200.0
2017-10-18	ARKG	ETF	26.69	26.73	26.295	26.38	35800.0
2017-10-18	ARKK	ETF	34.85	34.85	34.5	34.69	85200.0
2017-10-18	ARKQ	ETF	32.85	32.955	32.607	32.88	30100.0
2017-10-18	ARKW	ETF	41.74	41.749	41.44	41.65	32200.0
2017-10-18	ASEA	ETF	15.86	15.86	15.82	15.86	2400.0
2017-10-18	ASET	ETF	28.42	28.42	28.3999	28.415	1251.0
2017-10-18	ASHR	ETF	30.27	30.31	30.17	30.3	660700.0
2017-10-18	ASHS	ETF	36.2	36.3	36.2	36.3	8400.0
2017-10-18	ASHX	ETF	22.37	22.38	22.37	22.38	601.0
2017-10-18	ATMP	ETF	21.11	21.11	20.76	20.84	22200.0
2017-10-18	BAB	ETF	30.55	30.56	30.47	30.53	59744.0
2017-10-18	BAL	ETF	44.5751	44.5751	44.5751	44.5751	315.0
2017-10-18	BBC	ETF	29.1	29.1	28.4	28.55	20514.0

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

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