PREVIEW / etf_daily / 2017-11-09

all etf daily files

  file:    by_date/etf_daily/2017/2017-11-09.parquet
  size:    59 KB
  rows:    1,515

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-11-09	SPY	ETF	257.73	258.39	256.36	258.17	95085500.0
2017-11-09	QQQ	ETF	153.26	153.77	152.11	153.69	40594482.0
2017-11-09	IWM	ETF	146.27	147.39	145.28	146.68	40144400.0
2017-11-09	DIA	ETF	234.49	235.28	233.16	234.72	4225200.0
2017-11-09	GLD	ETF	121.85	122.41	121.73	122.13	6072400.0
2017-11-09	TLT	ETF	125.87	126.24	125.55	126.0	6280400.0
2017-11-09	AADR	ETF	57.23	57.23	56.71	56.93	53100.0
2017-11-09	AAXJ	ETF	76.04	76.2	75.58	76.11	1261600.0
2017-11-09	ACSI	ETF	29.389	29.55	29.3724	29.53	1931.0
2017-11-09	ACTX	ETF	50.1505	51.9205	41.3004	51.3305	309.0
2017-11-09	ACWF	ETF	30.01	30.01	29.87	29.8882	4034.0
2017-11-09	ACWI	ETF	70.39	70.53	70.05	70.5	1439900.0
2017-11-09	ACWV	ETF	82.73	82.94	82.51	82.92	117000.0
2017-11-09	ACWX	ETF	49.24	49.36	49.05	49.33	697188.0
2017-11-09	ADRE	ETF	43.12	43.12	42.681	43.05	8449.0
2017-11-09	AFK	ETF	23.91	24.06	23.7	23.89	14263.0
2017-11-09	AFTY	ETF	18.11	18.145	18.11	18.145	400.0
2017-11-09	AGG	ETF	109.39	109.46	109.3	109.43	2479800.0
2017-11-09	AGGY	ETF	50.68	50.74	50.646	50.691	23900.0
2017-11-09	AGNG	ETF	19.42	19.42	19.278	19.348	4200.0
2017-11-09	AGQ	ETF	34.12	34.55	34.08	34.41	63200.0
2017-11-09	AGZ	ETF	113.4852	113.55	113.38	113.46	12348.0
2017-11-09	AGZD	ETF	24.075	24.115	24.07	24.095	8800.0
2017-11-09	AIA	ETF	65.76	65.795	65.309	65.68	42063.0
2017-11-09	AIEQ	ETF	24.56	24.56	24.298	24.52	211700.0
2017-11-09	AIRR	ETF	25.91	26.101	25.84	25.98	10900.0
2017-11-09	AIVI	ETF	43.24	43.3	43.06	43.25	8800.0
2017-11-09	ALTY	ETF	15.56	15.56	15.397	15.397	1000.0
2017-11-09	AMJ	ETF	27.26	27.56	27.24	27.28	2300970.0
2017-11-09	AMLP	ETF	53.15	53.6	52.9	53.15	2252780.0
2017-11-09	AMZA	ETF	83.7	84.7	83.3	83.6	63740.0
2017-11-09	ANGL	ETF	29.95	29.97	29.74	29.81	1103700.0
2017-11-09	AOA	ETF	54.37	54.49	54.18	54.41	48600.0
2017-11-09	AOK	ETF	34.68	34.68	34.56	34.66	87823.0
2017-11-09	AOM	ETF	38.24	38.31	38.1277	38.18	115911.0
2017-11-09	AOR	ETF	45.32	45.38	45.18	45.38	82820.0
2017-11-09	ARGT	ETF	32.7	32.95	32.51	32.73	94200.0
2017-11-09	ARKG	ETF	24.66	24.66	23.98	24.295	115800.0
2017-11-09	ARKK	ETF	34.64	34.79	34.2	34.66	160800.0
2017-11-09	ARKQ	ETF	33.05	33.087	32.64	32.94	43100.0
2017-11-09	ARKW	ETF	43.15	43.15	42.48	42.96	102100.0
2017-11-09	ASEA	ETF	16.06	16.4	16.05	16.39	233700.0
2017-11-09	ASET	ETF	28.39	28.429	28.38	28.429	1894.0
2017-11-09	ASHR	ETF	30.98	31.04	30.9	30.98	792400.0
2017-11-09	ASHS	ETF	36.11	36.16	36.11	36.16	8100.0
2017-11-09	ATMP	ETF	20.63	20.8	20.57	20.6	68500.0
2017-11-09	BAB	ETF	30.55	30.61	30.511	30.57	169771.0
2017-11-09	BAL	ETF	45.75	45.82	45.14	45.14	2119.0
2017-11-09	BAR	ETF	12.888	12.888	12.877	12.883	21610.0
2017-11-09	BBC	ETF	27.0	27.42	26.8495	27.18	5002.0

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

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