PREVIEW / etf_daily / 2017-10-26

all etf daily files

  file:    by_date/etf_daily/2017/2017-10-26.parquet
  size:    58 KB
  rows:    1,478

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-26	SPY	ETF	255.99	256.3	255.48	255.62	69798000.0
2017-10-26	QQQ	ETF	147.36	147.705	146.92	146.96	28230199.0
2017-10-26	IWM	ETF	148.94	149.34	148.51	148.76	15205900.0
2017-10-26	DIA	ETF	233.91	234.42	233.75	233.85	2581500.0
2017-10-26	GLD	ETF	121.16	121.16	120.22	120.33	6438800.0
2017-10-26	TLT	ETF	123.06	123.06	122.43	122.43	8179400.0
2017-10-26	AADR	ETF	57.58	57.77	57.02	57.05	31200.0
2017-10-26	AAXJ	ETF	74.48	74.61	74.08	74.08	811100.0
2017-10-26	ACSI	ETF	29.5718	29.58	29.5545	29.58	3102.0
2017-10-26	ACTX	ETF	48.3804	53.0415	48.3804	48.9704	98.0
2017-10-26	ACWF	ETF	29.85	29.88	29.8132	29.8132	8286.0
2017-10-26	ACWI	ETF	69.87	69.97	69.75	69.75	1039300.0
2017-10-26	ACWV	ETF	82.51	82.6	82.4	82.44	619000.0
2017-10-26	ACWX	ETF	49.04	49.04	48.81	48.81	494481.0
2017-10-26	ADRE	ETF	42.3932	42.55	42.359	42.359	4072.0
2017-10-26	AFK	ETF	23.76	23.76	23.3	23.3	5730.0
2017-10-26	AFTY	ETF	17.69	17.69	17.69	17.69	900.0
2017-10-26	AGG	ETF	109.2	109.23	108.98	109.0	2163500.0
2017-10-26	AGGY	ETF	50.48	50.51	50.386	50.424	73200.0
2017-10-26	AGNG	ETF	19.15	19.22	19.05	19.2	4900.0
2017-10-26	AGQ	ETF	34.1	34.18	33.4	33.54	70200.0
2017-10-26	AGZ	ETF	113.31	113.31	113.19	113.26	10233.0
2017-10-26	AGZD	ETF	24.065	24.13	24.02	24.085	26000.0
2017-10-26	AIA	ETF	63.58	63.62	63.29	63.29	22166.0
2017-10-26	AIEQ	ETF	25.04	25.05	24.91	24.97	429500.0
2017-10-26	AIRR	ETF	26.33	26.66	26.33	26.64	21800.0
2017-10-26	AIVI	ETF	42.59	42.67	42.59	42.6	9700.0
2017-10-26	ALTY	ETF	15.526	15.526	15.414	15.436	5400.0
2017-10-26	AMJ	ETF	26.11	26.625	25.9	26.52	4641355.0
2017-10-26	AMLP	ETF	51.6	52.7	51.15	52.45	4666300.0
2017-10-26	AMZA	ETF	80.1	81.75	78.94	81.4	208100.0
2017-10-26	ANGL	ETF	30.24	30.31	30.24	30.27	316500.0
2017-10-26	AOA	ETF	54.1	54.15	54.0	54.06	62700.0
2017-10-26	AOK	ETF	34.58	34.58	34.5078	34.5362	71410.0
2017-10-26	AOM	ETF	38.07	38.07	37.95	37.99	85344.0
2017-10-26	AOR	ETF	45.11	45.11	45.02	45.03	71524.0
2017-10-26	ARGT	ETF	32.17	32.17	31.78	31.79	86200.0
2017-10-26	ARKG	ETF	25.23	25.23	24.874	25.004	74500.0
2017-10-26	ARKK	ETF	34.15	34.3	33.91	34.21	124800.0
2017-10-26	ARKQ	ETF	32.66	32.749	32.554	32.73	18200.0
2017-10-26	ARKW	ETF	41.31	41.709	41.2	41.55	45700.0
2017-10-26	ASEA	ETF	15.67	15.72	15.67	15.7	9500.0
2017-10-26	ASET	ETF	28.0567	28.0567	28.019	28.04	4761.0
2017-10-26	ASHR	ETF	30.5	30.56	30.45	30.47	352700.0
2017-10-26	ASHS	ETF	36.74	36.79	36.67	36.67	5300.0
2017-10-26	ATMP	ETF	19.89	20.05	19.67	20.04	16200.0
2017-10-26	BAB	ETF	30.25	30.3067	30.16	30.18	81951.0
2017-10-26	BAL	ETF	45.54	45.54	45.0286	45.03	10119.0
2017-10-26	BAR	ETF	12.706	12.706	12.701	12.701	33320.0
2017-10-26	BBC	ETF	26.82	27.2	26.611	26.73	33269.0

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

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