PREVIEW / etf_daily / 2016-07-06

all etf daily files

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

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-07-06	SPY	ETF	207.83	209.8	207.06	209.66	96021500.0
2016-07-06	QQQ	ETF	106.92	108.35	106.57	108.3	24579270.0
2016-07-06	IWM	ETF	112.54	114.01	112.31	113.89	24678300.0
2016-07-06	DIA	ETF	177.61	179.1	176.96	178.98	5395400.0
2016-07-06	GLD	ETF	130.5	131.15	129.82	130.23	17376700.0
2016-07-06	TLT	ETF	142.79	143.0	141.96	142.56	14352800.0
2016-07-06	AADR	ETF	38.93	38.93	38.93	38.93	100.0
2016-07-06	AAXJ	ETF	53.65	54.23	53.42	54.23	660400.0
2016-07-06	ACTX	ETF	3.54	4.13	3.54	4.13	34.0
2016-07-06	ACWF	ETF	22.3	22.3	22.265	22.265	395.0
2016-07-06	ACWI	ETF	55.25	55.75	55.0	55.74	2042600.0
2016-07-06	ACWV	ETF	76.45	76.93	76.27	76.89	335900.0
2016-07-06	ACWX	ETF	37.98	38.33	37.75	38.33	778946.0
2016-07-06	ADRE	ETF	30.7	30.8101	30.5504	30.81	13587.0
2016-07-06	AFK	ETF	20.45	20.45	20.01	20.01	19168.0
2016-07-06	AFTY	ETF	12.75	12.8	12.65	12.8	73400.0
2016-07-06	AGG	ETF	113.09	113.17	112.94	113.16	3150500.0
2016-07-06	AGGY	ETF	52.143	52.301	52.12	52.257	4100.0
2016-07-06	AGQ	ETF	53.63	55.02	52.99	54.39	624300.0
2016-07-06	AGZ	ETF	115.76	116.1099	115.7401	116.1	16159.0
2016-07-06	AGZD	ETF	23.935	23.935	23.92	23.92	2000.0
2016-07-06	AIA	ETF	43.67	44.01	43.43	44.01	39871.0
2016-07-06	AIQ	ETF	6.22	6.3	5.91	6.01	35173.0
2016-07-06	AIRR	ETF	18.06	18.225	18.03	18.225	900.0
2016-07-06	AIVI	ETF	36.65	37.07	36.49	37.02	25300.0
2016-07-06	ALTY	ETF	15.03	15.11	15.02	15.02	3400.0
2016-07-06	AMJ	ETF	31.12	31.33	30.9	31.21	1420585.0
2016-07-06	AMLP	ETF	62.8	63.25	62.35	63.1	2248280.0
2016-07-06	AMZA	ETF	107.3	107.8	105.7	107.8	19170.0
2016-07-06	ANGL	ETF	27.53	27.7	27.5	27.7	222500.0
2016-07-06	AOA	ETF	44.95	45.29	44.76	45.27	25400.0
2016-07-06	AOK	ETF	32.73	32.8599	32.6	32.84	64422.0
2016-07-06	AOM	ETF	35.08	35.228	34.9	35.17	115791.0
2016-07-06	AOR	ETF	39.42	39.66	39.29	39.66	68699.0
2016-07-06	ARGT	ETF	22.17	22.28	21.99	22.28	37800.0
2016-07-06	ARKG	ETF	17.04	17.04	17.04	17.04	200.0
2016-07-06	ARKK	ETF	19.42	19.42	19.19	19.19	1400.0
2016-07-06	ARKQ	ETF	19.07	19.07	18.98	18.98	400.0
2016-07-06	ARKW	ETF	22.093	22.283	22.093	22.283	500.0
2016-07-06	ASEA	ETF	13.43	13.53	13.37	13.53	8600.0
2016-07-06	ASHR	ETF	23.9	24.09	23.86	24.09	1066900.0
2016-07-06	ASHS	ETF	34.47	34.67	34.41	34.64	33400.0
2016-07-06	ASHX	ETF	22.045	22.05	22.045	22.05	400.0
2016-07-06	ATMP	ETF	21.76	21.88	21.6	21.88	45100.0
2016-07-06	BAB	ETF	31.95	31.95	31.8001	31.86	217926.0
2016-07-06	BAL	ETF	42.76	43.39	42.76	43.39	3035.0
2016-07-06	BBC	ETF	18.2	18.915	18.2	18.79	7460.0
2016-07-06	BBH	ETF	103.09	106.07	103.09	105.89	85300.0
2016-07-06	BBP	ETF	27.72	28.11	27.72	28.11	18300.0
2016-07-06	BCM	ETF	26.9588	27.31	26.9588	27.302	58828.0

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

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