PREVIEW / etf_daily / 2016-02-11

all etf daily files

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

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-11	SPY	ETF	182.34	184.1	181.09	182.86	219058900.0
2016-02-11	QQQ	ETF	95.45	97.32	95.19	96.55	76839183.0
2016-02-11	IWM	ETF	94.08	95.4	93.64	94.79	57923200.0
2016-02-11	DIA	ETF	156.8	158.02	155.26	156.8	14806700.0
2016-02-11	GLD	ETF	118.59	120.84	117.77	119.06	49139000.0
2016-02-11	TLT	ETF	134.44	135.25	133.01	133.72	21620200.0
2016-02-11	AADR	ETF	34.32	34.35	34.31	34.35	1300.0
2016-02-11	AAXJ	ETF	46.96	47.36	46.74	47.06	957400.0
2016-02-11	ACTX	ETF	4.779	4.779	4.72	4.72	154.0
2016-02-11	ACWF	ETF	20.59	20.607	20.25	20.25	7838.0
2016-02-11	ACWI	ETF	49.51	49.75	49.04	49.52	3646900.0
2016-02-11	ACWV	ETF	66.55	67.02	66.41	66.81	224800.0
2016-02-11	ACWX	ETF	34.82	35.01	34.54	34.87	1648770.0
2016-02-11	ADRE	ETF	25.21	25.354	24.9706	25.21	13621.0
2016-02-11	AFK	ETF	16.2	16.3499	16.17	16.23	10440.0
2016-02-11	AFTY	ETF	11.22	11.22	11.09	11.15	7300.0
2016-02-11	AGG	ETF	110.41	110.5	110.01	110.07	2928000.0
2016-02-11	AGGY	ETF	50.02	50.179	49.927	49.98	4300.0
2016-02-11	AGQ	ETF	34.49	35.55	33.72	34.45	529500.0
2016-02-11	AGZ	ETF	114.984	115.655	114.8901	115.04	98435.0
2016-02-11	AGZD	ETF	23.455	23.47	23.445	23.455	5000.0
2016-02-11	AIA	ETF	36.79	37.1536	36.72	37.05	65519.0
2016-02-11	AIQ	ETF	6.45	6.86	6.32	6.51	9596.0
2016-02-11	AIRR	ETF	13.86	14.16	13.86	14.16	21900.0
2016-02-11	AIVI	ETF	34.81	34.92	34.62	34.83	91900.0
2016-02-11	ALTY	ETF	12.51	12.55	12.51	12.538	1600.0
2016-02-11	AMJ	ETF	21.47	22.09	20.42	20.88	5227987.0
2016-02-11	AMLP	ETF	40.45	42.65	38.85	39.85	5012500.0
2016-02-11	AMUB	ETF	13.02	13.07	13.02	13.05	6000.0
2016-02-11	AMZA	ETF	65.0	67.55	63.1	64.8	3510.0
2016-02-11	ANGL	ETF	23.36	23.5	23.35	23.45	54500.0
2016-02-11	AOA	ETF	40.83	41.29	40.66	40.91	77400.0
2016-02-11	AOK	ETF	30.77	30.91	30.77	30.87	32578.0
2016-02-11	AOM	ETF	32.75	32.8999	32.71	32.85	62015.0
2016-02-11	AOR	ETF	36.24	36.4763	36.185	36.41	70174.0
2016-02-11	ARGT	ETF	16.51	16.52	16.25	16.5	10400.0
2016-02-11	ARKG	ETF	15.3	15.3	15.001	15.02	900.0
2016-02-11	ARKK	ETF	14.68	14.78	14.68	14.78	2200.0
2016-02-11	ARKQ	ETF	14.52	14.52	14.516	14.516	1000.0
2016-02-11	ARKW	ETF	16.52	16.578	16.25	16.578	2400.0
2016-02-11	ASEA	ETF	11.95	12.02	11.9	12.0	2400.0
2016-02-11	ASHR	ETF	21.08	21.24	20.9	21.08	1987600.0
2016-02-11	ASHS	ETF	29.39	29.55	29.04	29.38	35200.0
2016-02-11	ATMP	ETF	14.17	14.59	13.56	13.81	35500.0
2016-02-11	BAB	ETF	30.6	30.66	30.415	30.51	390367.0
2016-02-11	BAL	ETF	38.32	38.45	38.32	38.36	13441.0
2016-02-11	BBC	ETF	16.12	16.84	16.12	16.84	3089.0
2016-02-11	BBH	ETF	94.49	96.33	94.42	95.74	147300.0
2016-02-11	BBP	ETF	21.67	22.06	21.67	22.05	5400.0
2016-02-11	BCM	ETF	22.55	22.65	22.52	22.65	2675.0

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

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