PREVIEW / etf_daily / 2015-12-02

all etf daily files

  file:    by_date/etf_daily/2015/2015-12-02.parquet
  size:    50 KB
  rows:    1,235

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
2015-12-02	SPY	ETF	210.62	211.0	208.23	208.53	108441300.0
2015-12-02	QQQ	ETF	115.23	115.75	114.28	114.45	22395483.0
2015-12-02	IWM	ETF	119.73	120.04	118.45	118.6	22238300.0
2015-12-02	DIA	ETF	178.64	179.04	177.08	177.29	7427100.0
2015-12-02	GLD	ETF	101.35	101.35	100.53	100.69	10223500.0
2015-12-02	TLT	ETF	122.66	123.04	122.19	122.87	7345800.0
2015-12-02	AADR	ETF	39.41	39.54	38.95	38.95	4600.0
2015-12-02	AAXJ	ETF	55.7	55.81	55.26	55.43	1395300.0
2015-12-02	ACTX	ETF	8.2601	8.9681	8.0241	8.2601	3073.0
2015-12-02	ACWI	ETF	58.15	58.29	57.63	57.74	2081500.0
2015-12-02	ACWV	ETF	70.49	70.49	69.89	69.98	118300.0
2015-12-02	ACWX	ETF	41.31	41.42	40.985	41.09	1110539.0
2015-12-02	ADRE	ETF	30.81	30.882	30.57	30.5994	4904.0
2015-12-02	AFK	ETF	19.06	19.06	18.845	18.92	21480.0
2015-12-02	AFTY	ETF	16.93	17.12	16.9	16.91	47800.0
2015-12-02	AGG	ETF	108.73	108.78	108.61	108.69	2462800.0
2015-12-02	AGGY	ETF	49.55	49.63	49.54	49.62	5900.0
2015-12-02	AGQ	ETF	28.28	28.35	27.67	28.07	245100.0
2015-12-02	AGZ	ETF	113.3	113.4	113.1401	113.3198	11867.0
2015-12-02	AGZD	ETF	24.075	24.075	24.075	24.075	200.0
2015-12-02	AIA	ETF	44.72	44.74	44.371	44.44	13492.0
2015-12-02	AIQ	ETF	9.47	9.67	9.41	9.48	10973.0
2015-12-02	AIRR	ETF	18.145	18.186	17.88	17.911	5900.0
2015-12-02	AIVI	ETF	39.63	39.66	39.31	39.39	181200.0
2015-12-02	AMJ	ETF	29.38	29.59	28.54	28.73	6296557.0
2015-12-02	AMLP	ETF	59.8	60.25	58.2	58.8	3879120.0
2015-12-02	AMUB	ETF	18.25	18.25	18.2	18.2	300.0
2015-12-02	AMZA	ETF	121.5	121.5	116.6	118.3	2030.0
2015-12-02	ANGL	ETF	25.47	25.47	25.42	25.45	19300.0
2015-12-02	AOA	ETF	46.34	46.35	45.92	46.0	350700.0
2015-12-02	AOK	ETF	32.22	32.22	32.11	32.11	75345.0
2015-12-02	AOM	ETF	34.87	34.87	34.69	34.7	211467.0
2015-12-02	AOR	ETF	39.95	39.95	39.63	39.67	683478.0
2015-12-02	ARGT	ETF	18.7	18.72	18.44	18.47	17000.0
2015-12-02	ARKG	ETF	20.42	20.42	20.21	20.21	500.0
2015-12-02	ARKK	ETF	21.4	21.4	21.35	21.36	2300.0
2015-12-02	ARKQ	ETF	19.85	19.85	19.85	19.85	100.0
2015-12-02	ARKW	ETF	24.25	24.26	24.2	24.2	2300.0
2015-12-02	ASEA	ETF	12.82	12.82	12.7	12.7	6900.0
2015-12-02	ASET	ETF	24.98	25.0	24.86	24.86	2870.0
2015-12-02	ASHR	ETF	37.0	37.13	36.7	36.87	1537000.0
2015-12-02	ASHS	ETF	45.47	45.47	44.52	44.6	59900.0
2015-12-02	ASHX	ETF	26.31	26.31	26.19	26.2	509.0
2015-12-02	ATMP	ETF	19.75	19.75	18.89	18.96	520900.0
2015-12-02	AWAY	ETF	35.77	35.92	35.34	35.42	1142713.0
2015-12-02	BAB	ETF	29.4	29.447	29.3401	29.41	41310.0
2015-12-02	BAL	ETF	42.43	42.43	42.19	42.2099	1370.0
2015-12-02	BBC	ETF	31.65	31.95	31.24	31.24	5912.0
2015-12-02	BBH	ETF	124.97	125.82	124.05	124.37	51800.0
2015-12-02	BBP	ETF	31.77	32.007	31.45	31.45	3800.0

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

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