PREVIEW / etf_daily / 2016-02-25

all etf daily files

  file:    by_date/etf_daily/2016/2016-02-25.parquet
  size:    50 KB
  rows:    1,244

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-02-25	SPY	ETF	193.73	195.55	192.83	195.54	110728300.0
2016-02-25	QQQ	ETF	102.76	103.56	101.84	103.56	29389315.0
2016-02-25	IWM	ETF	101.79	102.6	101.39	102.54	22612600.0
2016-02-25	DIA	ETF	165.03	166.84	164.4	166.84	5266900.0
2016-02-25	GLD	ETF	117.62	118.91	117.54	117.92	12500300.0
2016-02-25	TLT	ETF	131.48	132.56	131.32	131.68	6097200.0
2016-02-25	AADR	ETF	37.0	37.0	35.78	35.78	700.0
2016-02-25	AAXJ	ETF	48.89	49.3	48.67	49.28	521200.0
2016-02-25	ACTX	ETF	4.72	4.72	4.13	4.72	271.0
2016-02-25	ACWI	ETF	52.2	52.62	51.97	52.61	1272200.0
2016-02-25	ACWV	ETF	69.85	70.31	69.73	70.31	382400.0
2016-02-25	ACWX	ETF	36.48	36.78	36.345	36.78	1028555.0
2016-02-25	ADRE	ETF	27.02	27.0599	26.7015	26.9401	4875.0
2016-02-25	AFK	ETF	16.78	16.9	16.6	16.82	9791.0
2016-02-25	AFTY	ETF	11.66	11.66	11.57	11.61	7200.0
2016-02-25	AGG	ETF	110.09	110.31	110.0	110.16	2335700.0
2016-02-25	AGGY	ETF	49.8	49.87	49.76	49.836	2100.0
2016-02-25	AGQ	ETF	31.84	32.23	31.6	31.97	113000.0
2016-02-25	AGZ	ETF	114.59	114.75	114.59	114.63	10843.0
2016-02-25	AGZD	ETF	23.575	23.575	23.455	23.55	5000.0
2016-02-25	AIA	ETF	38.84	39.11	38.71	39.11	7149.0
2016-02-25	AIQ	ETF	7.23	7.4017	7.19	7.35	7711.0
2016-02-25	AIRR	ETF	15.34	15.44	15.25	15.44	59300.0
2016-02-25	AIVI	ETF	36.04	36.28	35.93	36.28	25400.0
2016-02-25	ALTY	ETF	13.09	13.15	13.09	13.15	700.0
2016-02-25	AMJ	ETF	24.39	24.68	23.89	24.43	6191706.0
2016-02-25	AMLP	ETF	48.75	49.55	47.95	49.1	3801120.0
2016-02-25	AMUB	ETF	15.18	15.18	15.13	15.13	300.0
2016-02-25	AMZA	ETF	82.5	82.5	78.73	82.1	3570.0
2016-02-25	ANGL	ETF	23.91	24.13	23.91	23.98	45400.0
2016-02-25	AOA	ETF	42.68	42.94	42.5	42.94	35200.0
2016-02-25	AOK	ETF	31.56	31.56	31.3	31.44	53934.0
2016-02-25	AOM	ETF	33.65	33.65	33.4701	33.63	105194.0
2016-02-25	AOR	ETF	37.57	37.73	37.47	37.73	277080.0
2016-02-25	ARGT	ETF	18.14	18.49	18.05	18.49	127700.0
2016-02-25	ARKG	ETF	16.26	16.26	16.26	16.26	100.0
2016-02-25	ARKK	ETF	16.53	16.53	16.53	16.53	200.0
2016-02-25	ARKQ	ETF	16.23	16.23	16.21	16.23	1000.0
2016-02-25	ARKW	ETF	18.58	18.58	18.357	18.357	400.0
2016-02-25	ASEA	ETF	12.08	12.19	12.07	12.19	3700.0
2016-02-25	ASHR	ETF	22.08	22.25	21.95	22.16	2248400.0
2016-02-25	ASHS	ETF	31.84	31.84	30.35	30.91	66400.0
2016-02-25	ASHX	ETF	19.73	19.8	19.72	19.76	1000.0
2016-02-25	ATMP	ETF	16.16	16.54	15.92	16.35	47700.0
2016-02-25	BAB	ETF	30.2	30.2499	30.1675	30.18	203454.0
2016-02-25	BAL	ETF	37.68	37.79	37.61	37.69	10456.0
2016-02-25	BBC	ETF	17.84	17.84	17.31	17.5	4890.0
2016-02-25	BBH	ETF	101.5	102.67	100.39	101.37	75700.0
2016-02-25	BBP	ETF	22.766	22.855	22.764	22.781	800.0
2016-02-25	BCM	ETF	23.38	23.38	23.34	23.37	2757.0

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

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