PREVIEW / etf_daily / 2015-09-17

all etf daily files

  file:    by_date/etf_daily/2015/2015-09-17.parquet
  size:    48 KB
  rows:    1,202

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-09-17	SPY	ETF	200.02	202.89	199.28	199.73	276046600.0
2015-09-17	QQQ	ETF	106.98	108.725	106.64	107.13	56139806.0
2015-09-17	IWM	ETF	116.92	118.89	116.68	117.34	50405400.0
2015-09-17	DIA	ETF	167.42	169.44	166.48	166.81	14270000.0
2015-09-17	GLD	ETF	107.07	108.58	106.96	108.41	8403800.0
2015-09-17	TLT	ETF	118.88	120.37	118.73	120.25	19843600.0
2015-09-17	AADR	ETF	36.27	36.27	36.27	36.27	300.0
2015-09-17	AAXJ	ETF	54.52	56.03	54.52	54.94	716800.0
2015-09-17	ACTX	ETF	4.13	4.13	2.95	4.13	1698.0
2015-09-17	ACWI	ETF	56.31	57.18	56.22	56.4	1704700.0
2015-09-17	ACWV	ETF	68.0	68.99	67.94	68.19	66400.0
2015-09-17	ACWX	ETF	40.84	41.5732	40.83	41.14	753322.0
2015-09-17	ADRE	ETF	29.93	30.12	29.88	29.973	4084.0
2015-09-17	AFK	ETF	20.66	21.03	20.64	20.86	14306.0
2015-09-17	AFTY	ETF	15.25	15.71	15.13	15.42	55200.0
2015-09-17	AGG	ETF	108.48	109.19	108.4	109.19	1955400.0
2015-09-17	AGGY	ETF	49.64	49.83	49.6	49.73	4600.0
2015-09-17	AGQ	ETF	32.28	33.85	32.18	33.17	382600.0
2015-09-17	AGZ	ETF	113.15	113.46	113.03	113.46	18521.0
2015-09-17	AGZD	ETF	24.05	24.075	24.015	24.07	2800.0
2015-09-17	AIA	ETF	43.36	44.27	43.2866	43.56	59442.0
2015-09-17	AIQ	ETF	16.75	16.7674	12.25	12.78	476962.0
2015-09-17	AIRR	ETF	16.696	16.82	16.59	16.59	3000.0
2015-09-17	AIVI	ETF	40.25	40.9	40.25	40.54	14400.0
2015-09-17	ALTY	ETF	14.538	14.538	14.538	14.538	400.0
2015-09-17	AMJ	ETF	33.44	34.25	33.3	33.73	2224288.0
2015-09-17	AMLP	ETF	69.35	70.35	68.9	69.45	1204880.0
2015-09-17	AMZA	ETF	154.2	160.2	154.2	157.65	1060.0
2015-09-17	ANGL	ETF	26.39	26.53	26.34	26.4	30100.0
2015-09-17	AOA	ETF	45.16	45.55	44.99	45.21	59000.0
2015-09-17	AOK	ETF	31.73	31.9799	31.73	31.95	29245.0
2015-09-17	AOM	ETF	34.24	34.5699	34.172	34.45	84208.0
2015-09-17	AOR	ETF	39.09	39.3918	38.96	39.17	279817.0
2015-09-17	ARGT	ETF	17.82	18.15	17.82	18.03	10700.0
2015-09-17	ARKG	ETF	22.23	22.23	22.23	22.23	200.0
2015-09-17	ARKK	ETF	20.75	20.75	20.75	20.75	100.0
2015-09-17	ARKQ	ETF	18.61	18.61	18.61	18.61	100.0
2015-09-17	ARKW	ETF	22.5	22.821	22.49	22.57	1700.0
2015-09-17	ASEA	ETF	13.03	13.1	13.03	13.09	1100.0
2015-09-17	ASHR	ETF	31.9	33.03	31.9	32.33	2109200.0
2015-09-17	ASHS	ETF	34.51	36.12	34.5	35.25	50300.0
2015-09-17	ATMP	ETF	22.63	23.49	22.63	22.87	77100.0
2015-09-17	AWAY	ETF	29.45	29.91	28.86	29.25	758595.0
2015-09-17	BAB	ETF	28.5	28.702	28.4051	28.7	52665.0
2015-09-17	BAL	ETF	41.8	41.8	41.61	41.61	6732.0
2015-09-17	BBC	ETF	33.25	35.3299	33.25	35.06	15055.0
2015-09-17	BBH	ETF	132.21	135.69	131.9	134.0	151400.0
2015-09-17	BBP	ETF	32.87	33.91	32.87	33.7	19000.0
2015-09-17	BCM	ETF	27.117	27.117	27.117	27.117	1078.0
2015-09-17	BFOR	ETF	7.8575	7.9775	7.835	7.8625	121200.0

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

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