PREVIEW / etf_daily / 2017-02-02

all etf daily files

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

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-02	SPY	ETF	227.62	228.1	226.82	227.77	69657600.0
2017-02-02	QQQ	ETF	125.21	125.7	124.86	125.32	15101363.0
2017-02-02	IWM	ETF	135.3	135.67	134.49	134.81	19935700.0
2017-02-02	DIA	ETF	198.16	198.97	198.02	198.61	2640600.0
2017-02-02	GLD	ETF	116.26	116.57	115.63	115.84	7189500.0
2017-02-02	TLT	ETF	119.93	120.14	119.0	119.05	6978600.0
2017-02-02	AADR	ETF	44.69	45.08	44.58	45.0	13300.0
2017-02-02	AAXJ	ETF	59.12	59.29	59.09	59.24	582900.0
2017-02-02	ACSI	ETF	27.0457	27.05	27.02	27.02	2353.0
2017-02-02	ACTX	ETF	293.5276	295.0027	184.6717	200.0118	15868.0
2017-02-02	ACWF	ETF	25.3	25.55	25.2	25.55	2101.0
2017-02-02	ACWI	ETF	60.85	61.1	60.85	61.0	1657200.0
2017-02-02	ACWV	ETF	73.67	74.01	73.67	74.01	112300.0
2017-02-02	ACWX	ETF	42.03	42.05	41.89	41.99	642034.0
2017-02-02	ADRE	ETF	35.101	35.31	35.101	35.2381	19164.0
2017-02-02	AFK	ETF	21.35	21.7199	21.35	21.4286	7487.0
2017-02-02	AGG	ETF	108.06	108.18	107.95	107.98	3490700.0
2017-02-02	AGGY	ETF	49.6	49.7	49.515	49.57	35500.0
2017-02-02	AGQ	ETF	39.25	39.37	38.17	38.41	166400.0
2017-02-02	AGZ	ETF	112.6	112.8376	112.48	112.72	25300.0
2017-02-02	AGZD	ETF	24.045	24.065	24.035	24.065	6400.0
2017-02-02	AIA	ETF	49.76	49.88	49.71	49.81	17970.0
2017-02-02	AIQ	ETF	9.75	9.9	9.75	9.9	38100.0
2017-02-02	AIRR	ETF	24.15	24.15	23.85	23.975	362700.0
2017-02-02	AIVI	ETF	38.49	38.58	38.38	38.49	9200.0
2017-02-02	ALTY	ETF	15.4	15.4	15.16	15.18	2100.0
2017-02-02	AMJ	ETF	33.55	33.76	33.34	33.73	1449336.0
2017-02-02	AMLP	ETF	66.1	66.2	65.55	66.05	1793380.0
2017-02-02	AMZA	ETF	112.0	112.5	111.3	112.4	25660.0
2017-02-02	ANGL	ETF	29.3	29.32	29.28	29.31	242400.0
2017-02-02	AOA	ETF	48.31	48.39	48.22	48.27	44500.0
2017-02-02	AOK	ETF	32.8	32.8	32.6754	32.69	29267.0
2017-02-02	AOM	ETF	35.64	35.6572	35.55	35.56	95925.0
2017-02-02	AOR	ETF	41.14	41.2498	41.14	41.21	92948.0
2017-02-02	ARGT	ETF	25.86	26.34	25.86	26.19	69300.0
2017-02-02	ARKG	ETF	18.28	18.32	18.28	18.294	1300.0
2017-02-02	ARKK	ETF	22.24	22.449	22.2	22.41	4900.0
2017-02-02	ARKQ	ETF	23.4	23.6	23.4	23.514	15200.0
2017-02-02	ARKW	ETF	27.71	27.71	27.56	27.572	11100.0
2017-02-02	ASEA	ETF	13.59	13.59	13.59	13.59	700.0
2017-02-02	ASET	ETF	25.8	25.88	25.77	25.86	3346.0
2017-02-02	ASHR	ETF	24.98	25.01	24.92	24.98	356200.0
2017-02-02	ASHS	ETF	33.4	33.45	33.33	33.45	7200.0
2017-02-02	ATMP	ETF	25.01	25.01	24.24	24.61	71200.0
2017-02-02	BAB	ETF	29.17	29.2	29.06	29.07	133711.0
2017-02-02	BAL	ETF	51.06	51.16	50.4	50.8561	23180.0
2017-02-02	BBC	ETF	19.73	19.9692	19.7	19.9157	7716.0
2017-02-02	BBH	ETF	114.86	115.15	114.29	114.87	51500.0
2017-02-02	BBP	ETF	35.49	35.685	35.375	35.67	8700.0
2017-02-02	BCM	ETF	27.7881	27.8	27.787	27.787	472.0

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

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