PREVIEW / etf_daily / 2016-01-07

all etf daily files

  file:    by_date/etf_daily/2016/2016-01-07.parquet
  size:    51 KB
  rows:    1,258

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-01-07	SPY	ETF	195.33	197.44	193.59	194.05	213436100.0
2016-01-07	QQQ	ETF	105.96	107.29	104.81	104.87	61386300.0
2016-01-07	IWM	ETF	106.72	107.5	105.49	105.67	52482000.0
2016-01-07	DIA	ETF	165.96	167.94	164.48	164.96	15400600.0
2016-01-07	GLD	ETF	105.83	106.24	105.19	106.15	11730400.0
2016-01-07	TLT	ETF	122.68	122.93	121.79	122.81	10202200.0
2016-01-07	AAXJ	ETF	49.68	50.46	49.52	49.52	964200.0
2016-01-07	ACTX	ETF	7.6701	8.8501	7.0801	8.2601	1047.0
2016-01-07	ACWF	ETF	22.15	22.15	22.15	22.15	1068.0
2016-01-07	ACWI	ETF	53.1	53.57	52.69	52.79	3396400.0
2016-01-07	ACWV	ETF	67.38	68.0	67.32	67.48	234900.0
2016-01-07	ACWX	ETF	37.32	37.71	37.2	37.23	1906293.0
2016-01-07	ADRE	ETF	27.0	27.2695	26.7417	26.8099	34862.0
2016-01-07	AFK	ETF	17.11	17.14	16.83	16.83	20247.0
2016-01-07	AFTY	ETF	12.72	13.04	12.59	12.62	13500.0
2016-01-07	AGG	ETF	108.4	108.47	108.21	108.42	2469000.0
2016-01-07	AGQ	ETF	28.18	29.26	27.96	28.97	379700.0
2016-01-07	AGZ	ETF	113.38	113.38	113.18	113.37	20090.0
2016-01-07	AGZD	ETF	23.865	23.985	23.865	23.92	89800.0
2016-01-07	AIA	ETF	39.35	39.82	39.21	39.33	72412.0
2016-01-07	AIQ	ETF	8.59	8.65	7.76	7.89	31679.0
2016-01-07	AIRR	ETF	15.674	15.675	15.38	15.38	11200.0
2016-01-07	AIVI	ETF	36.1	36.51	36.08	36.16	30000.0
2016-01-07	AMJ	ETF	27.15	27.53	26.31	26.41	7274641.0
2016-01-07	AMLP	ETF	55.25	56.85	53.75	53.9	4603360.0
2016-01-07	AMUB	ETF	17.03	17.03	16.94	16.94	300.0
2016-01-07	AMZA	ETF	100.0	100.0	93.2	93.2	5280.0
2016-01-07	ANGL	ETF	24.06	24.34	24.06	24.28	34700.0
2016-01-07	AOA	ETF	43.19	43.5	42.98	43.02	78100.0
2016-01-07	AOK	ETF	31.12	31.2899	31.12	31.2	85085.0
2016-01-07	AOM	ETF	33.47	33.56	33.405	33.44	154211.0
2016-01-07	AOR	ETF	37.79	37.95	37.66	37.71	352833.0
2016-01-07	ARGT	ETF	17.22	17.29	17.0	17.13	32600.0
2016-01-07	ARKG	ETF	19.05	19.05	19.05	19.05	100.0
2016-01-07	ARKK	ETF	19.48	19.48	19.0	19.05	900.0
2016-01-07	ARKQ	ETF	18.29	18.29	18.1	18.19	1300.0
2016-01-07	ARKW	ETF	22.12	22.12	21.442	21.48	2600.0
2016-01-07	ASEA	ETF	11.5	11.56	11.43	11.47	3600.0
2016-01-07	ASET	ETF	23.51	23.51	23.49	23.49	1302.0
2016-01-07	ASHR	ETF	24.06	24.92	23.9	24.13	4267600.0
2016-01-07	ASHS	ETF	33.81	35.38	33.76	34.82	141100.0
2016-01-07	ASHX	ETF	22.2	22.85	22.2	22.3401	10335.0
2016-01-07	ATMP	ETF	17.52	17.95	17.14	17.23	322700.0
2016-01-07	BAB	ETF	29.43	29.5	29.359	29.49	393083.0
2016-01-07	BAL	ETF	40.7801	40.7804	40.6	40.682	2505.0
2016-01-07	BBC	ETF	24.85	25.0	24.22	24.4294	10045.0
2016-01-07	BBH	ETF	119.36	120.54	117.67	117.84	218300.0
2016-01-07	BBP	ETF	27.83	28.13	27.6	27.6	16500.0
2016-01-07	BCM	ETF	23.01	23.19	23.0097	23.0097	2177.0
2016-01-07	BFOR	ETF	7.15	7.195	7.0675	7.0775	186000.0

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

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