PREVIEW / etf_daily / 2017-02-15

all etf daily files

  file:    by_date/etf_daily/2017/2017-02-15.parquet
  size:    54 KB
  rows:    1,377

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-02-15	SPY	ETF	233.45	235.14	233.39	234.92	86785800.0
2017-02-15	QQQ	ETF	128.44	129.35	128.37	129.29	17891355.0
2017-02-15	IWM	ETF	138.19	139.77	138.07	139.59	20253500.0
2017-02-15	DIA	ETF	205.39	206.49	205.29	206.38	3646000.0
2017-02-15	GLD	ETF	116.33	117.48	116.25	117.45	7088400.0
2017-02-15	TLT	ETF	118.76	119.22	118.65	118.96	8481000.0
2017-02-15	AADR	ETF	45.58	45.8	45.58	45.78	7800.0
2017-02-15	AAXJ	ETF	60.49	60.88	60.38	60.81	601700.0
2017-02-15	ACSI	ETF	27.84	27.9725	27.84	27.9391	7006.0
2017-02-15	ACTX	ETF	150.4514	151.6314	126.2611	132.6332	3307.0
2017-02-15	ACWF	ETF	25.5727	25.5799	25.5727	25.5799	978.0
2017-02-15	ACWI	ETF	62.08	62.51	62.04	62.45	2227500.0
2017-02-15	ACWV	ETF	74.8	75.33	74.75	75.28	448600.0
2017-02-15	ACWX	ETF	42.33	42.68	42.33	42.66	594193.0
2017-02-15	ADRE	ETF	36.3115	36.3946	36.2503	36.3946	3496.0
2017-02-15	AFK	ETF	21.62	21.8693	21.5233	21.82	14696.0
2017-02-15	AFTY	ETF	13.93	13.95	13.93	13.95	1200.0
2017-02-15	AGG	ETF	107.92	108.0	107.86	107.89	2138900.0
2017-02-15	AGGY	ETF	49.55	49.61	49.49	49.61	11900.0
2017-02-15	AGNG	ETF	16.34	16.42	16.323	16.42	1100.0
2017-02-15	AGQ	ETF	40.01	40.61	39.81	40.6	98500.0
2017-02-15	AGZ	ETF	112.49	112.93	112.15	112.47	27188.0
2017-02-15	AGZD	ETF	24.1	24.17	24.045	24.14	5800.0
2017-02-15	AIA	ETF	50.67	51.04	50.67	50.98	30943.0
2017-02-15	AIQ	ETF	10.2501	10.35	10.2501	10.35	7099.0
2017-02-15	AIRR	ETF	24.08	24.42	24.08	24.38	78500.0
2017-02-15	AIVI	ETF	38.7	38.81	38.69	38.79	10900.0
2017-02-15	ALTY	ETF	15.478	15.58	15.44	15.58	12000.0
2017-02-15	AMJ	ETF	34.05	34.34	34.05	34.18	2029523.0
2017-02-15	AMLP	ETF	65.5	65.7	65.35	65.5	2751040.0
2017-02-15	AMZA	ETF	114.6	114.6	114.0	114.35	41400.0
2017-02-15	ANGL	ETF	29.46	29.48	29.44	29.47	234100.0
2017-02-15	AOA	ETF	49.05	49.31	48.96	49.31	108500.0
2017-02-15	AOK	ETF	32.95	33.0	32.91	32.97	80477.0
2017-02-15	AOM	ETF	35.87	36.0	35.8504	35.96	104335.0
2017-02-15	AOR	ETF	41.73	41.87	41.6599	41.87	88990.0
2017-02-15	ARGT	ETF	27.0	27.15	26.87	27.12	85000.0
2017-02-15	ARKG	ETF	19.01	20.5	18.93	19.1	11600.0
2017-02-15	ARKK	ETF	23.15	23.17	23.085	23.168	9400.0
2017-02-15	ARKQ	ETF	24.62	24.62	24.53	24.595	6100.0
2017-02-15	ARKW	ETF	28.42	28.54	28.301	28.49	5700.0
2017-02-15	ASEA	ETF	13.63	13.63	13.55	13.55	1000.0
2017-02-15	ASET	ETF	26.1	26.19	26.08	26.19	2864.0
2017-02-15	ASHR	ETF	24.95	25.0	24.86	24.93	519600.0
2017-02-15	ASHS	ETF	33.65	33.65	33.34	33.45	20000.0
2017-02-15	ASHX	ETF	19.51	19.52	19.5	19.5	950.0
2017-02-15	ATMP	ETF	25.03	25.1	24.79	24.87	14200.0
2017-02-15	BAB	ETF	29.21	29.36	29.17	29.22	280020.0
2017-02-15	BAL	ETF	50.32	50.4	50.22	50.22	3053.0
2017-02-15	BBC	ETF	21.25	21.4712	21.2115	21.44	9441.0

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

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