PREVIEW / etf_daily / 2015-10-29

all etf daily files

  file:    by_date/etf_daily/2015/2015-10-29.parquet
  size:    49 KB
  rows:    1,220

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-10-29	SPY	ETF	208.35	209.27	208.21	208.83	90525500.0
2015-10-29	QQQ	ETF	113.5	114.03	113.38	113.84	24913340.0
2015-10-29	IWM	ETF	116.74	117.11	115.56	115.87	27252000.0
2015-10-29	DIA	ETF	177.03	177.71	176.68	177.38	4726900.0
2015-10-29	GLD	ETF	110.23	110.6	109.66	109.72	5150800.0
2015-10-29	TLT	ETF	123.18	123.22	121.7	121.86	12108000.0
2015-10-29	AADR	ETF	38.79	38.79	38.7	38.73	1400.0
2015-10-29	AAXJ	ETF	56.53	56.73	56.41	56.59	480800.0
2015-10-29	ACTX	ETF	8.8501	10.6201	8.7911	9.4401	876.0
2015-10-29	ACWI	ETF	58.09	58.37	58.05	58.3	1583400.0
2015-10-29	ACWV	ETF	70.72	70.87	70.51	70.81	53600.0
2015-10-29	ACWX	ETF	41.56	41.75	41.56	41.69	404586.0
2015-10-29	ADRE	ETF	30.74	30.74	30.5109	30.74	7776.0
2015-10-29	AFK	ETF	20.33	20.45	20.27	20.3	29644.0
2015-10-29	AFTY	ETF	15.99	16.02	15.9	15.9	5500.0
2015-10-29	AGG	ETF	109.34	109.42	109.13	109.16	2333200.0
2015-10-29	AGQ	ETF	35.27	35.68	34.63	34.76	199200.0
2015-10-29	AGZ	ETF	113.88	113.9299	113.58	113.85	174468.0
2015-10-29	AGZD	ETF	23.95	24.075	23.95	24.005	4800.0
2015-10-29	AIA	ETF	45.51	45.63	45.46	45.63	25139.0
2015-10-29	AIQ	ETF	8.0	8.2	7.58	7.83	45675.0
2015-10-29	AIRR	ETF	16.7	16.77	16.67	16.719	3300.0
2015-10-29	AIVI	ETF	40.19	40.35	40.17	40.32	19000.0
2015-10-29	AMJ	ETF	32.03	33.1	32.01	32.97	2096203.0
2015-10-29	AMLP	ETF	65.95	67.55	65.65	67.25	1394480.0
2015-10-29	AMZA	ETF	137.5	141.9	137.5	141.8	780.0
2015-10-29	ANGL	ETF	26.19	26.19	26.06	26.1	21500.0
2015-10-29	AOA	ETF	46.16	46.18	45.67	46.11	85700.0
2015-10-29	AOK	ETF	32.23	32.23	32.14	32.14	23556.0
2015-10-29	AOM	ETF	34.76	34.78	34.661	34.68	74724.0
2015-10-29	AOR	ETF	39.79	39.8	39.65	39.72	47600.0
2015-10-29	ARGT	ETF	19.89	20.1	19.61	19.62	31600.0
2015-10-29	ARKG	ETF	19.83	19.83	19.83	19.83	200.0
2015-10-29	ARKK	ETF	19.82	19.98	19.72	19.72	6300.0
2015-10-29	ARKQ	ETF	18.95	18.95	18.78	18.78	500.0
2015-10-29	ARKW	ETF	22.5	22.5	22.5	22.5	100.0
2015-10-29	ASEA	ETF	13.0	13.03	12.98	13.01	5500.0
2015-10-29	ASHR	ETF	35.3	35.47	35.2	35.4	1508300.0
2015-10-29	ASHS	ETF	42.78	43.14	42.73	42.84	115900.0
2015-10-29	ASHX	ETF	24.69	24.79	24.69	24.7699	3161.0
2015-10-29	ATMP	ETF	22.02	22.32	22.0	22.27	268600.0
2015-10-29	AWAY	ETF	31.52	31.73	31.1	31.22	657363.0
2015-10-29	BAB	ETF	29.18	29.18	29.03	29.07	152694.0
2015-10-29	BAL	ETF	41.58	41.58	41.38	41.5405	39199.0
2015-10-29	BBC	ETF	28.42	28.81	27.6301	27.7	4629.0
2015-10-29	BBH	ETF	126.34	127.64	124.8	125.09	161900.0
2015-10-29	BBP	ETF	31.25	31.47	30.48	30.48	7400.0
2015-10-29	BCHP	ETF	18.23	18.26	18.23	18.25	2200.0
2015-10-29	BCM	ETF	26.89	26.89	26.6501	26.72	3264.0
2015-10-29	BDCZ	ETF	20.22	20.24	20.22	20.22	900.0

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

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