PREVIEW / etf_daily / 2016-02-22

all etf daily files

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

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-22	SPY	ETF	193.87	194.95	193.79	194.78	103640300.0
2016-02-22	QQQ	ETF	102.54	103.38	102.48	103.28	23979113.0
2016-02-22	IWM	ETF	101.34	102.01	101.24	101.57	28867400.0
2016-02-22	DIA	ETF	165.35	166.46	165.13	165.94	3450700.0
2016-02-22	GLD	ETF	115.44	116.19	115.41	115.49	10677800.0
2016-02-22	TLT	ETF	131.1	131.11	130.7	130.94	5054300.0
2016-02-22	AADR	ETF	36.32	36.32	36.32	36.32	200.0
2016-02-22	AAXJ	ETF	49.86	50.23	49.74	50.21	890800.0
2016-02-22	ACTX	ETF	5.31	5.31	5.074	5.31	395.0
2016-02-22	ACWF	ETF	21.73	21.76	21.7299	21.74	3266.0
2016-02-22	ACWI	ETF	52.38	52.77	52.38	52.75	2283800.0
2016-02-22	ACWV	ETF	69.77	69.9	69.63	69.82	238600.0
2016-02-22	ACWX	ETF	36.93	37.11	36.93	37.08	751018.0
2016-02-22	ADRE	ETF	27.46	27.87	27.46	27.87	16563.0
2016-02-22	AFK	ETF	16.98	17.179	16.98	17.02	31256.0
2016-02-22	AFTY	ETF	12.29	12.368	12.275	12.368	1700.0
2016-02-22	AGG	ETF	109.77	109.88	109.72	109.82	2421800.0
2016-02-22	AGGY	ETF	49.599	49.65	49.599	49.649	6400.0
2016-02-22	AGQ	ETF	31.68	32.4	31.52	32.09	182400.0
2016-02-22	AGZ	ETF	114.56	114.61	114.5	114.53	16452.0
2016-02-22	AGZD	ETF	23.51	23.53	23.445	23.445	10000.0
2016-02-22	AIA	ETF	39.36	39.75	39.36	39.71	16610.0
2016-02-22	AIQ	ETF	7.13	7.21	6.91	7.13	21788.0
2016-02-22	AIRR	ETF	15.14	15.2	15.14	15.19	4300.0
2016-02-22	AIVI	ETF	36.72	36.94	36.72	36.92	20800.0
2016-02-22	ALTY	ETF	13.158	13.16	13.158	13.16	300.0
2016-02-22	AMJ	ETF	24.94	25.67	24.82	25.53	3788737.0
2016-02-22	AMLP	ETF	49.5	50.6	49.1	50.5	2516220.0
2016-02-22	AMZA	ETF	82.5	83.48	80.9	82.7	6230.0
2016-02-22	ANGL	ETF	23.94	23.94	23.72	23.89	53000.0
2016-02-22	AOA	ETF	42.76	42.99	42.76	42.98	40600.0
2016-02-22	AOK	ETF	31.29	31.41	31.29	31.41	70255.0
2016-02-22	AOM	ETF	33.49	33.62	33.49	33.6	52327.0
2016-02-22	AOR	ETF	37.68	37.74	37.66	37.73	758056.0
2016-02-22	ARGT	ETF	17.79	18.33	17.79	18.12	21700.0
2016-02-22	ARKG	ETF	16.46	16.74	16.46	16.74	200.0
2016-02-22	ARKK	ETF	16.48	16.48	16.47	16.47	2400.0
2016-02-22	ARKQ	ETF	16.2	16.26	16.2	16.26	800.0
2016-02-22	ARKW	ETF	18.337	18.46	18.337	18.424	1300.0
2016-02-22	ASEA	ETF	12.28	12.35	12.28	12.35	2700.0
2016-02-22	ASET	ETF	24.14	24.14	24.1006	24.1006	1160.0
2016-02-22	ASHR	ETF	23.68	23.86	23.59	23.81	1868800.0
2016-02-22	ASHS	ETF	33.57	33.82	33.49	33.63	147200.0
2016-02-22	ATMP	ETF	16.66	16.95	16.64	16.92	175600.0
2016-02-22	BAB	ETF	30.03	30.1	30.01	30.08	116474.0
2016-02-22	BAL	ETF	39.25	39.3552	38.37	38.55	7281.0
2016-02-22	BBC	ETF	18.8201	19.1	18.674	18.78	4840.0
2016-02-22	BBH	ETF	103.61	103.68	102.14	102.76	53800.0
2016-02-22	BBP	ETF	23.758	23.758	23.44	23.52	9300.0
2016-02-22	BCM	ETF	23.43	23.43	23.415	23.415	1376.0

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

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