PREVIEW / etf_daily / 2015-07-20

all etf daily files

  file:    by_date/etf_daily/2015/2015-07-20.parquet
  size:    48 KB
  rows:    1,205

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-07-20	SPY	ETF	212.75	213.18	212.21	212.59	70446800.0
2015-07-20	QQQ	ETF	113.83	114.39	113.48	113.98	26539045.0
2015-07-20	IWM	ETF	125.78	125.86	124.76	125.08	23271100.0
2015-07-20	DIA	ETF	180.95	181.1	180.36	180.69	2961600.0
2015-07-20	GLD	ETF	106.6	106.65	105.62	105.7	15751700.0
2015-07-20	TLT	ETF	118.29	118.65	117.9	118.22	5941000.0
2015-07-20	AAXJ	ETF	61.21	61.43	60.98	61.24	597400.0
2015-07-20	ACTX	ETF	1.77	1.77	1.18	1.18	232.0
2015-07-20	ACWI	ETF	60.85	60.97	60.67	60.8	538000.0
2015-07-20	ACWV	ETF	71.19	71.19	70.79	71.07	110200.0
2015-07-20	ACWX	ETF	44.81	44.85	44.66	44.75	172464.0
2015-07-20	ADRE	ETF	34.06	34.14	33.89	34.0472	6193.0
2015-07-20	AFK	ETF	23.45	23.574	23.18	23.18	10497.0
2015-07-20	AFTY	ETF	20.099	20.28	20.02	20.03	33300.0
2015-07-20	AGG	ETF	108.67	108.72	108.55	108.6	1245100.0
2015-07-20	AGQ	ETF	32.29	33.12	31.72	31.8	329600.0
2015-07-20	AGZ	ETF	113.28	113.28	112.91	113.12	10671.0
2015-07-20	AGZD	ETF	24.345	24.375	24.31	24.35	11400.0
2015-07-20	AIA	ETF	48.66	48.7787	48.479	48.6965	39125.0
2015-07-20	AIQ	ETF	16.82	16.82	16.35	16.36	21451.0
2015-07-20	AIRR	ETF	18.02	18.02	17.81	17.85	6200.0
2015-07-20	AIVI	ETF	43.77	43.77	43.53	43.67	15200.0
2015-07-20	ALTY	ETF	15.11	15.11	15.06	15.06	6600.0
2015-07-20	AMJ	ETF	38.88	38.94	37.88	37.89	2792874.0
2015-07-20	AMLP	ETF	77.25	77.4	76.2	76.2	1225400.0
2015-07-20	AMZA	ETF	187.4	187.4	180.9	181.7	2560.0
2015-07-20	ANGL	ETF	27.02	27.09	27.02	27.07	14200.0
2015-07-20	AOA	ETF	47.84	47.89	47.66	47.83	20900.0
2015-07-20	AOK	ETF	32.48	32.5796	32.43	32.5236	117654.0
2015-07-20	AOM	ETF	35.32	35.34	35.18	35.31	83498.0
2015-07-20	AOR	ETF	40.84	40.84	40.67	40.7735	25620.0
2015-07-20	ARGT	ETF	19.55	19.55	19.24	19.24	1400.0
2015-07-20	ARKG	ETF	23.96	23.98	23.825	23.92	4400.0
2015-07-20	ARKK	ETF	21.95	21.95	21.92	21.95	1500.0
2015-07-20	ARKQ	ETF	19.92	19.97	19.92	19.97	300.0
2015-07-20	ARKW	ETF	23.99	23.99	23.85	23.91	2600.0
2015-07-20	ASEA	ETF	14.9	14.9	14.9	14.9	500.0
2015-07-20	ASHR	ETF	42.75	42.98	42.56	42.57	2735900.0
2015-07-20	ASHS	ETF	50.28	50.7	49.87	50.18	96400.0
2015-07-20	ATMP	ETF	26.57	26.57	26.02	26.04	15200.0
2015-07-20	AWAY	ETF	32.05	32.08	31.0	31.06	1335393.0
2015-07-20	BAB	ETF	28.78	28.85	28.63	28.69	53789.0
2015-07-20	BAL	ETF	43.7319	43.7717	42.9301	43.4568	9291.0
2015-07-20	BBC	ETF	40.13	40.13	38.7001	39.07	78110.0
2015-07-20	BBH	ETF	145.41	145.52	144.28	144.66	120500.0
2015-07-20	BBP	ETF	38.12	38.12	37.21	37.54	63400.0
2015-07-20	BCHP	ETF	19.42	19.42	19.42	19.42	591.0
2015-07-20	BCM	ETF	29.25	29.355	29.25	29.355	17243.0
2015-07-20	BFOR	ETF	8.335	8.335	8.3125	8.315	30800.0
2015-07-20	BIB	ETF	105.16	106.1	103.9	104.69	504505.0

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

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