PREVIEW / etf_daily / 2016-06-02

all etf daily files

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

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-06-02	SPY	ETF	209.8	210.93	209.24	210.91	63044700.0
2016-06-02	QQQ	ETF	110.13	110.59	109.53	110.58	15696618.0
2016-06-02	IWM	ETF	115.49	116.67	115.37	116.67	23303300.0
2016-06-02	DIA	ETF	177.3	178.31	176.98	178.28	1965900.0
2016-06-02	GLD	ETF	115.78	115.97	115.58	115.67	4591600.0
2016-06-02	TLT	ETF	130.9	131.69	130.87	131.36	5835400.0
2016-06-02	AADR	ETF	38.76	38.76	38.6	38.64	2200.0
2016-06-02	AAXJ	ETF	53.24	53.64	53.22	53.62	507100.0
2016-06-02	ACTX	ETF	4.13	4.13	4.13	4.13	339.0
2016-06-02	ACWI	ETF	56.85	57.19	56.78	57.18	1222500.0
2016-06-02	ACWV	ETF	73.78	74.06	73.66	74.04	255000.0
2016-06-02	ACWX	ETF	39.829	40.08	39.76	40.06	413227.0
2016-06-02	ADRE	ETF	30.35	30.47	30.27	30.444	5109.0
2016-06-02	AFK	ETF	19.79	20.05	19.6299	20.04	48099.0
2016-06-02	AFTY	ETF	12.55	12.59	12.55	12.59	1600.0
2016-06-02	AGG	ETF	110.56	110.74	110.56	110.7	2013900.0
2016-06-02	AGGY	ETF	50.933	50.94	50.933	50.94	1100.0
2016-06-02	AGQ	ETF	34.58	35.01	34.58	34.88	111800.0
2016-06-02	AGZ	ETF	114.5	114.768	114.5	114.6724	47436.0
2016-06-02	AGZD	ETF	23.97	23.98	23.955	23.98	800.0
2016-06-02	AIA	ETF	43.04	43.3223	42.99	43.26	18717.0
2016-06-02	AIQ	ETF	7.22	7.22	6.95	6.97	24801.0
2016-06-02	AIRR	ETF	18.227	18.288	18.227	18.288	1200.0
2016-06-02	AIVI	ETF	38.18	38.34	38.11	38.24	9300.0
2016-06-02	ALTY	ETF	14.71	14.73	14.71	14.73	700.0
2016-06-02	AMJ	ETF	30.58	31.14	30.46	31.06	1737718.0
2016-06-02	AMLP	ETF	62.2	63.15	61.95	63.05	2500160.0
2016-06-02	AMZA	ETF	113.0	114.0	111.36	113.7	15140.0
2016-06-02	ANGL	ETF	26.84	26.91	26.77	26.83	32100.0
2016-06-02	AOA	ETF	45.76	46.0	45.76	45.99	22500.0
2016-06-02	AOK	ETF	32.42	32.5505	32.41	32.54	25973.0
2016-06-02	AOM	ETF	35.0	35.125	34.9418	35.11	61621.0
2016-06-02	AOR	ETF	39.84	40.49	39.7201	39.93	193897.0
2016-06-02	ARGT	ETF	20.84	21.08	20.65	21.05	47400.0
2016-06-02	ARKG	ETF	18.37	18.37	18.37	18.37	100.0
2016-06-02	ARKK	ETF	19.65	19.76	19.65	19.742	2000.0
2016-06-02	ARKQ	ETF	19.48	19.48	19.48	19.48	100.0
2016-06-02	ARKW	ETF	22.02	22.02	22.02	22.02	100.0
2016-06-02	ASEA	ETF	12.85	12.85	12.82	12.82	1700.0
2016-06-02	ASET	ETF	25.9286	25.9424	25.9286	25.9424	484.0
2016-06-02	ASHR	ETF	23.86	24.04	23.81	24.02	1403600.0
2016-06-02	ASHS	ETF	33.49	33.67	33.4	33.67	9400.0
2016-06-02	ATMP	ETF	20.84	21.42	20.84	21.42	29000.0
2016-06-02	BAB	ETF	30.78	30.79	30.72	30.77	111444.0
2016-06-02	BAL	ETF	41.99	42.1728	41.62	41.88	16930.0
2016-06-02	BBC	ETF	21.3899	21.82	21.32	21.82	8922.0
2016-06-02	BBH	ETF	110.32	112.49	110.32	112.47	47000.0
2016-06-02	BBP	ETF	28.258	28.76	28.258	28.76	10400.0
2016-06-02	BCM	ETF	26.57	26.78	26.57	26.7246	16039.0
2016-06-02	BDCZ	ETF	20.3399	20.3401	20.3399	20.3401	200.0

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

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