PREVIEW / etf_daily / 2015-09-16

all etf daily files

  file:    by_date/etf_daily/2015/2015-09-16.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-16	SPY	ETF	198.82	200.41	198.41	200.18	99581600.0
2015-09-16	QQQ	ETF	106.51	107.19	106.14	107.09	31329146.0
2015-09-16	IWM	ETF	115.95	117.02	115.79	116.94	27127800.0
2015-09-16	DIA	ETF	166.46	167.65	166.0	167.51	5511700.0
2015-09-16	GLD	ETF	106.6	107.71	106.56	107.31	5315600.0
2015-09-16	TLT	ETF	118.96	119.44	118.55	118.8	6949800.0
2015-09-16	AADR	ETF	36.39	36.75	36.39	36.75	300.0
2015-09-16	AAXJ	ETF	54.73	55.2	54.61	55.09	804100.0
2015-09-16	ACTX	ETF	4.13	5.31	2.95	4.13	5632.0
2015-09-16	ACWF	ETF	23.2	23.2	23.2	23.2	296.0
2015-09-16	ACWI	ETF	56.0	56.51	55.93	56.48	2820800.0
2015-09-16	ACWV	ETF	67.53	68.21	67.53	68.07	131100.0
2015-09-16	ACWX	ETF	40.71	41.09	40.71	41.05	677241.0
2015-09-16	ADRE	ETF	29.62	30.18	29.62	30.18	10856.0
2015-09-16	AFK	ETF	20.41	20.73	20.35	20.6	60149.0
2015-09-16	AFTY	ETF	15.62	15.8	15.6	15.75	20800.0
2015-09-16	AGG	ETF	108.59	108.66	108.41	108.51	1810100.0
2015-09-16	AGQ	ETF	31.46	32.54	31.43	32.19	265800.0
2015-09-16	AGZ	ETF	113.11	113.4067	113.0701	113.17	15557.0
2015-09-16	AGZD	ETF	24.09	24.11	24.01	24.1	3000.0
2015-09-16	AIA	ETF	43.53	44.01	43.53	43.96	15811.0
2015-09-16	AIQ	ETF	16.51	17.21	16.51	16.93	21240.0
2015-09-16	AIRR	ETF	16.582	16.7	16.582	16.68	24000.0
2015-09-16	AIVI	ETF	40.09	40.48	40.09	40.42	17500.0
2015-09-16	AMJ	ETF	33.2	33.63	33.2	33.51	2344885.0
2015-09-16	AMLP	ETF	69.1	69.55	68.85	69.35	1349600.0
2015-09-16	AMZA	ETF	153.0	154.9	153.0	154.5	860.0
2015-09-16	ANGL	ETF	26.43	26.48	26.42	26.48	14300.0
2015-09-16	AOA	ETF	44.8	45.13	44.76	45.12	43800.0
2015-09-16	AOK	ETF	31.7399	31.7847	31.676	31.75	22092.0
2015-09-16	AOM	ETF	34.11	34.33	34.11	34.29	36340.0
2015-09-16	AOR	ETF	38.85	39.05	38.8201	39.04	161214.0
2015-09-16	ARGT	ETF	17.95	18.01	17.76	17.76	27600.0
2015-09-16	ARKG	ETF	21.85	21.85	21.67	21.71	700.0
2015-09-16	ARKK	ETF	20.57	20.57	20.57	20.57	200.0
2015-09-16	ARKQ	ETF	18.71	18.71	18.71	18.71	100.0
2015-09-16	ARKW	ETF	22.29	22.29	22.29	22.29	500.0
2015-09-16	ASEA	ETF	12.67	12.82	12.67	12.79	2600.0
2015-09-16	ASHR	ETF	32.56	33.25	32.55	33.14	2592900.0
2015-09-16	ASHS	ETF	35.01	36.4	35.01	36.06	116600.0
2015-09-16	ATMP	ETF	22.77	22.84	22.62	22.78	153600.0
2015-09-16	AWAY	ETF	29.09	29.7	28.92	29.55	1009814.0
2015-09-16	BAB	ETF	28.52	28.5299	28.4	28.44	43906.0
2015-09-16	BAL	ETF	42.0	42.0	41.73	41.8	8339.0
2015-09-16	BBC	ETF	33.98	34.062	33.31	33.56	6488.0
2015-09-16	BBH	ETF	132.83	133.51	130.9	132.23	90200.0
2015-09-16	BBP	ETF	33.16	33.18	32.52	32.88	28800.0
2015-09-16	BCM	ETF	27.3195	27.32	27.257	27.29	6049.0
2015-09-16	BFOR	ETF	7.775	7.8625	7.775	7.8525	50400.0
2015-09-16	BIB	ETF	82.8	83.6799	79.97	81.66	641917.0

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

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