PREVIEW / etf_daily / 2017-04-03

all etf daily files

  file:    by_date/etf_daily/2017/2017-04-03.parquet
  size:    55 KB
  rows:    1,384

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-04-03	SPY	ETF	235.8	236.03	233.91	235.33	85546500.0
2017-04-03	QQQ	ETF	132.48	132.81	131.56	132.3	23700310.0
2017-04-03	IWM	ETF	137.97	138.1	135.6	136.03	38834900.0
2017-04-03	DIA	ETF	206.52	206.63	204.88	206.25	4436100.0
2017-04-03	GLD	ETF	118.69	119.37	118.67	119.35	6105700.0
2017-04-03	TLT	ETF	120.45	121.87	120.4	121.67	12996500.0
2017-04-03	AADR	ETF	46.75	46.75	46.46	46.7	5700.0
2017-04-03	AAXJ	ETF	63.27	63.43	62.99	63.4	1293700.0
2017-04-03	ACSI	ETF	27.7201	27.7201	27.7201	27.7201	1145.0
2017-04-03	ACTX	ETF	118.0011	132.7512	109.151	112.101	1362.0
2017-04-03	ACWF	ETF	25.75	25.75	25.75	25.75	140.0
2017-04-03	ACWI	ETF	63.31	63.36	62.83	63.25	2034700.0
2017-04-03	ACWV	ETF	77.2	77.32	77.01	77.27	92500.0
2017-04-03	ACWX	ETF	43.64	43.6808	43.34	43.65	591150.0
2017-04-03	ADRE	ETF	36.78	36.83	36.7	36.71	3475.0
2017-04-03	AFK	ETF	20.68	20.7	20.52	20.55	7284.0
2017-04-03	AFTY	ETF	13.83	13.86	13.83	13.84	1800.0
2017-04-03	AGG	ETF	108.31	108.68	108.3	108.67	5197800.0
2017-04-03	AGGY	ETF	49.82	49.98	49.8	49.922	35900.0
2017-04-03	AGNG	ETF	17.11	17.17	16.96	17.03	1700.0
2017-04-03	AGQ	ETF	41.06	41.45	41.06	41.3	99800.0
2017-04-03	AGZ	ETF	112.81	113.23	112.81	113.11	36429.0
2017-04-03	AGZD	ETF	24.035	24.035	24.01	24.015	6400.0
2017-04-03	AIA	ETF	52.57	53.16	52.52	53.11	2835721.0
2017-04-03	AIQ	ETF	10.2	10.25	9.9	9.95	4042.0
2017-04-03	AIRR	ETF	23.88	24.03	23.39	23.52	97500.0
2017-04-03	AIVI	ETF	39.71	39.71	39.36	39.56	15200.0
2017-04-03	ALTY	ETF	15.23	15.46	15.23	15.46	7400.0
2017-04-03	AMJ	ETF	32.28	32.46	31.91	32.27	1280211.0
2017-04-03	AMLP	ETF	63.75	64.0	63.1	63.55	3606860.0
2017-04-03	AMZA	ETF	112.4	112.4	110.61	111.6	115610.0
2017-04-03	ANGL	ETF	29.52	29.52	29.35	29.39	304600.0
2017-04-03	AOA	ETF	49.95	49.98	49.7	49.95	39900.0
2017-04-03	AOK	ETF	33.25	33.35	33.25	33.35	110649.0
2017-04-03	AOM	ETF	36.4	36.46	36.325	36.46	127800.0
2017-04-03	AOR	ETF	42.42	42.42	42.2203	42.39	96477.0
2017-04-03	ARCM	ETF	100.1	100.1	100.1	100.1	5000.0
2017-04-03	ARGT	ETF	28.37	28.71	28.26	28.7	79500.0
2017-04-03	ARKG	ETF	20.53	20.775	20.49	20.49	6400.0
2017-04-03	ARKK	ETF	24.11	24.13	23.95	24.03	6500.0
2017-04-03	ARKQ	ETF	24.89	24.89	24.605	24.74	10400.0
2017-04-03	ARKW	ETF	29.01	29.08	28.88	29.08	4100.0
2017-04-03	ASEA	ETF	14.23	14.27	14.19	14.2	1400.0
2017-04-03	ASET	ETF	26.4001	26.4075	26.4001	26.4075	687.0
2017-04-03	ASHR	ETF	25.32	25.32	25.16	25.22	329900.0
2017-04-03	ASHS	ETF	33.81	33.81	33.75	33.78	6800.0
2017-04-03	ASHX	ETF	19.5712	19.5712	19.5712	19.5712	126.0
2017-04-03	ATMP	ETF	23.86	23.86	23.59	23.85	30000.0
2017-04-03	BAB	ETF	29.3	29.48	29.26	29.44	279162.0
2017-04-03	BAL	ETF	50.34	50.39	48.94	48.95	9166.0

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

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