PREVIEW / etf_daily / 2016-04-22

all etf daily files

  file:    by_date/etf_daily/2016/2016-04-22.parquet
  size:    50 KB
  rows:    1,260

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
2016-04-22	SPY	ETF	208.55	209.29	207.91	208.97	99251700.0
2016-04-22	QQQ	ETF	109.21	109.72	108.12	108.98	39073996.0
2016-04-22	IWM	ETF	112.98	114.19	112.98	114.11	29094500.0
2016-04-22	DIA	ETF	179.61	180.08	178.87	179.9	2410500.0
2016-04-22	GLD	ETF	118.71	119.02	117.28	117.89	10047000.0
2016-04-22	TLT	ETF	128.85	128.91	128.24	128.36	5826400.0
2016-04-22	AADR	ETF	39.05	39.05	38.89	39.0	1700.0
2016-04-22	AAXJ	ETF	55.03	55.37	54.84	54.95	602800.0
2016-04-22	ACTX	ETF	4.72	4.72	4.071	4.661	2283.0
2016-04-22	ACWI	ETF	57.4	57.62	57.27	57.51	831200.0
2016-04-22	ACWV	ETF	73.82	73.97	73.6	73.89	88400.0
2016-04-22	ACWX	ETF	40.95	41.0699	40.79	40.93	960106.0
2016-04-22	ADRE	ETF	32.13	32.13	31.8301	31.92	1361.0
2016-04-22	AFK	ETF	20.2	20.325	19.79	20.06	78315.0
2016-04-22	AFTY	ETF	12.92	12.93	12.8	12.81	30800.0
2016-04-22	AGG	ETF	110.65	110.72	110.52	110.52	3795600.0
2016-04-22	AGGY	ETF	50.797	50.85	50.76	50.84	7300.0
2016-04-22	AGQ	ETF	40.87	41.38	39.01	39.5	483100.0
2016-04-22	AGZ	ETF	114.46	114.56	114.32	114.5	14204.0
2016-04-22	AIA	ETF	43.97	44.041	43.77	43.9095	12354.0
2016-04-22	AIQ	ETF	7.0	7.09	6.95	7.0	13256.0
2016-04-22	AIRR	ETF	18.15	18.15	18.07	18.07	4000.0
2016-04-22	AIVI	ETF	39.4	39.54	39.27	39.46	13400.0
2016-04-22	ALTY	ETF	14.55	14.63	14.497	14.62	15400.0
2016-04-22	AMJ	ETF	29.82	30.0	29.66	29.94	3749986.0
2016-04-22	AMLP	ETF	60.85	61.35	60.55	61.05	3200320.0
2016-04-22	AMZA	ETF	102.8	104.9	102.1	103.7	11050.0
2016-04-22	ANGL	ETF	27.03	27.09	26.91	27.07	50500.0
2016-04-22	AOA	ETF	46.08	46.13	45.91	46.08	28800.0
2016-04-22	AOK	ETF	32.55	32.55	32.417	32.54	28186.0
2016-04-22	AOM	ETF	35.1	35.1	34.9201	35.04	126573.0
2016-04-22	AOR	ETF	39.97	39.97	39.779	39.94	191566.0
2016-04-22	ARGT	ETF	21.07	21.18	20.9	20.9	91100.0
2016-04-22	ARKG	ETF	18.535	18.535	18.535	18.535	400.0
2016-04-22	ARKK	ETF	19.73	19.73	19.71	19.71	1100.0
2016-04-22	ARKQ	ETF	19.74	19.74	19.53	19.57	1500.0
2016-04-22	ARKW	ETF	21.31	21.31	21.3	21.3	400.0
2016-04-22	ASEA	ETF	13.7	13.7	13.68	13.68	4900.0
2016-04-22	ASET	ETF	25.9399	25.9399	25.9399	25.9399	116.0
2016-04-22	ASHR	ETF	23.98	24.07	23.87	23.98	1644800.0
2016-04-22	ASHS	ETF	33.52	33.64	33.43	33.53	22600.0
2016-04-22	ATMP	ETF	20.49	20.57	20.39	20.43	141700.0
2016-04-22	BAB	ETF	30.03	30.069	29.98	30.04	236796.0
2016-04-22	BAL	ETF	42.3081	42.3309	41.9301	42.155	4734.0
2016-04-22	BBC	ETF	21.49	21.63	20.95	21.53	7519.0
2016-04-22	BBH	ETF	112.99	113.37	111.37	113.02	84600.0
2016-04-22	BBP	ETF	27.33	27.364	26.92	27.33	4400.0
2016-04-22	BCM	ETF	25.9	25.9	25.755	25.77	2533.0
2016-04-22	BFOR	ETF	7.695	7.755	7.6925	7.745	59200.0
2016-04-22	BIB	ETF	49.51	50.13	47.95	49.65	771714.0

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

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