PREVIEW / etf_daily / 2016-03-14

all etf daily files

  file:    by_date/etf_daily/2016/2016-03-14.parquet
  size:    50 KB
  rows:    1,245

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-03-14	SPY	ETF	202.16	203.04	201.77	202.5	73612000.0
2016-03-14	QQQ	ETF	106.08	106.92	106.06	106.67	25374912.0
2016-03-14	IWM	ETF	107.87	108.34	107.4	107.92	24422700.0
2016-03-14	DIA	ETF	171.7	172.89	171.7	172.41	2658400.0
2016-03-14	GLD	ETF	120.27	120.31	117.5	117.87	14236200.0
2016-03-14	TLT	ETF	127.82	128.39	127.66	127.76	5177000.0
2016-03-14	AADR	ETF	37.75	37.75	37.6	37.61	8000.0
2016-03-14	AAXJ	ETF	52.88	53.09	52.77	52.92	441800.0
2016-03-14	ACTX	ETF	4.72	4.72	3.54	4.72	123.0
2016-03-14	ACWI	ETF	55.14	55.37	55.07	55.24	1429600.0
2016-03-14	ACWV	ETF	71.8	71.83	71.57	71.75	116900.0
2016-03-14	ACWX	ETF	39.18	39.277	39.08	39.19	577090.0
2016-03-14	ADRE	ETF	29.97	30.02	29.895	29.895	1900.0
2016-03-14	AFK	ETF	18.94	18.94	18.6402	18.94	25874.0
2016-03-14	AFTY	ETF	12.45	12.5	12.33	12.35	19800.0
2016-03-14	AGG	ETF	109.49	109.6	109.45	109.48	2186900.0
2016-03-14	AGGY	ETF	49.86	49.94	49.81	49.91	9500.0
2016-03-14	AGQ	ETF	34.45	34.58	32.38	32.53	313000.0
2016-03-14	AGZ	ETF	113.78	114.0	113.6601	113.94	62501.0
2016-03-14	AGZD	ETF	24.1	24.1	23.8	23.8	10600.0
2016-03-14	AIA	ETF	41.98	42.09	41.88	41.96	10770.0
2016-03-14	AIQ	ETF	7.71	7.71	7.21	7.26	13153.0
2016-03-14	AIRR	ETF	16.906	16.92	16.895	16.895	2600.0
2016-03-14	AIVI	ETF	38.12	38.19	38.02	38.15	14600.0
2016-03-14	AMJ	ETF	25.97	26.369	25.65	26.12	1658629.0
2016-03-14	AMLP	ETF	52.5	53.3	51.8	52.85	1817020.0
2016-03-14	AMUB	ETF	16.58	16.58	16.54	16.54	202.0
2016-03-14	AMZA	ETF	86.3	87.4	84.4	86.8	5900.0
2016-03-14	ANGL	ETF	25.38	25.54	25.37	25.5	23300.0
2016-03-14	AOA	ETF	44.56	44.72	44.55	44.64	26300.0
2016-03-14	AOK	ETF	31.77	31.9	31.77	31.88	210133.0
2016-03-14	AOM	ETF	34.26	34.35	34.2	34.3	43383.0
2016-03-14	AOR	ETF	38.83	38.9385	38.807	38.88	69733.0
2016-03-14	ARGT	ETF	19.0	19.05	18.81	18.92	68900.0
2016-03-14	ARKG	ETF	17.19	17.19	17.15	17.15	1100.0
2016-03-14	ARKK	ETF	18.43	18.43	18.4	18.4	200.0
2016-03-14	ARKQ	ETF	18.17	18.17	18.11	18.11	200.0
2016-03-14	ARKW	ETF	19.928	19.95	19.928	19.95	800.0
2016-03-14	ASEA	ETF	13.09	13.09	13.09	13.09	1400.0
2016-03-14	ASET	ETF	25.11	25.11	25.11	25.11	200.0
2016-03-14	ASHR	ETF	23.25	23.42	23.19	23.37	1203400.0
2016-03-14	ASHS	ETF	31.59	31.63	31.39	31.45	67200.0
2016-03-14	ASHX	ETF	20.84	20.8437	20.84	20.8437	500.0
2016-03-14	ATMP	ETF	17.61	17.69	17.42	17.66	15200.0
2016-03-14	BAB	ETF	29.8	29.882	29.78	29.83	103381.0
2016-03-14	BAL	ETF	37.6	38.1399	37.56	38.1	7630.0
2016-03-14	BBC	ETF	17.96	19.0999	17.96	18.94	20692.0
2016-03-14	BBH	ETF	102.92	103.45	102.45	102.76	47800.0
2016-03-14	BBP	ETF	24.675	24.93	24.64	24.64	1700.0
2016-03-14	BCM	ETF	24.53	24.558	24.47	24.558	9312.0

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

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