PREVIEW / etf_daily / 2015-11-02

all etf daily files

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

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-11-02	SPY	ETF	208.32	210.62	208.17	210.39	86270800.0
2015-11-02	QQQ	ETF	113.63	114.745	113.39	114.61	22176916.0
2015-11-02	IWM	ETF	115.45	118.07	115.42	117.74	33836900.0
2015-11-02	DIA	ETF	176.87	178.29	176.73	178.12	4178300.0
2015-11-02	GLD	ETF	108.64	108.84	108.46	108.59	5843300.0
2015-11-02	TLT	ETF	121.78	122.18	121.68	121.95	8751000.0
2015-11-02	AADR	ETF	38.64	38.75	38.5	38.62	3900.0
2015-11-02	AAXJ	ETF	56.7	57.27	56.67	57.24	509000.0
2015-11-02	ACTX	ETF	11.2101	12.3901	10.6201	11.8001	2208.0
2015-11-02	ACWF	ETF	23.99	24.08	23.99	24.08	1300.0
2015-11-02	ACWI	ETF	58.34	58.75	58.21	58.73	1580500.0
2015-11-02	ACWV	ETF	70.6	70.98	70.56	70.98	51500.0
2015-11-02	ACWX	ETF	41.78	42.07	41.78	42.05	624450.0
2015-11-02	ADRE	ETF	30.88	31.31	30.88	31.2535	16138.0
2015-11-02	AFK	ETF	20.31	20.61	20.3	20.61	24042.0
2015-11-02	AFTY	ETF	15.87	15.91	15.85	15.91	3600.0
2015-11-02	AGG	ETF	109.08	109.19	108.98	109.02	8049400.0
2015-11-02	AGQ	ETF	33.85	34.18	33.33	34.05	197000.0
2015-11-02	AGZ	ETF	113.63	113.801	113.55	113.58	231046.0
2015-11-02	AGZD	ETF	24.0	24.075	23.99	23.99	1600.0
2015-11-02	AIA	ETF	45.661	45.9736	45.661	45.97	21263.0
2015-11-02	AIQ	ETF	8.83	9.78	8.714	9.2	185245.0
2015-11-02	AIRR	ETF	16.89	17.15	16.83	17.145	9100.0
2015-11-02	AIVI	ETF	40.48	40.62	40.48	40.6	15100.0
2015-11-02	ALTY	ETF	14.36	14.43	14.36	14.43	300.0
2015-11-02	AMJ	ETF	33.07	34.03	32.8285	33.64	2471743.0
2015-11-02	AMLP	ETF	67.75	69.65	67.55	68.8	1409100.0
2015-11-02	AMUB	ETF	21.19	21.19	21.19	21.19	250.0
2015-11-02	AMZA	ETF	143.8	148.04	142.4	146.0	1280.0
2015-11-02	ANGL	ETF	26.09	26.1	26.01	26.07	16400.0
2015-11-02	AOA	ETF	46.18	46.43	46.14	46.39	76500.0
2015-11-02	AOK	ETF	32.23	32.3	32.2	32.3	28858.0
2015-11-02	AOM	ETF	34.7	34.86	34.7	34.85	75769.0
2015-11-02	AOR	ETF	39.65	39.95	39.65	39.95	145301.0
2015-11-02	ARGT	ETF	19.89	20.12	19.31	19.56	34100.0
2015-11-02	ARKG	ETF	20.31	20.33	20.31	20.33	300.0
2015-11-02	ARKK	ETF	19.933	20.47	19.933	20.46	3500.0
2015-11-02	ARKQ	ETF	19.21	19.21	19.21	19.21	100.0
2015-11-02	ARKW	ETF	23.03	23.06	23.02	23.03	4600.0
2015-11-02	ASEA	ETF	13.06	13.11	13.06	13.09	1600.0
2015-11-02	ASHR	ETF	35.0	35.28	34.9	35.15	1652100.0
2015-11-02	ASHS	ETF	42.52	42.52	42.0	42.34	102200.0
2015-11-02	ASHX	ETF	24.44	24.61	24.44	24.61	970.0
2015-11-02	ATMP	ETF	22.24	22.84	22.19	22.61	139600.0
2015-11-02	AWAY	ETF	31.57	32.64	31.31	32.38	1753096.0
2015-11-02	BAB	ETF	29.16	29.212	29.06	29.17	89008.0
2015-11-02	BAL	ETF	42.14	42.3	41.69	42.3	3979.0
2015-11-02	BBC	ETF	27.27	29.34	27.27	29.3399	7529.0
2015-11-02	BBH	ETF	124.36	127.72	124.32	127.57	116200.0
2015-11-02	BBP	ETF	31.17	31.96	31.17	31.96	7900.0

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

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