PREVIEW / etf_daily / 2016-07-21

all etf daily files

  file:    by_date/etf_daily/2016/2016-07-21.parquet
  size:    51 KB
  rows:    1,287

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-07-21	SPY	ETF	216.96	217.22	215.75	216.27	67777300.0
2016-07-21	QQQ	ETF	113.52	113.74	112.87	113.18	18885367.0
2016-07-21	IWM	ETF	120.01	120.6	119.25	119.51	19018700.0
2016-07-21	DIA	ETF	185.54	185.73	184.54	184.98	2837700.0
2016-07-21	GLD	ETF	125.66	127.37	125.6	127.3	9399200.0
2016-07-21	TLT	ETF	137.04	138.62	136.99	138.56	10398400.0
2016-07-21	AADR	ETF	40.64	40.88	40.26	40.6	18100.0
2016-07-21	AAXJ	ETF	56.96	57.14	56.82	56.92	1433400.0
2016-07-21	ACTX	ETF	3.54	3.54	2.891	3.481	969.0
2016-07-21	ACWF	ETF	23.46	23.5	23.37	23.4	2700.0
2016-07-21	ACWI	ETF	57.87	58.01	57.65	57.78	872300.0
2016-07-21	ACWV	ETF	77.39	77.48	77.17	77.33	132700.0
2016-07-21	ACWX	ETF	39.96	40.13	39.885	39.96	334907.0
2016-07-21	ADRE	ETF	32.87	33.0	32.71	32.81	29261.0
2016-07-21	AFK	ETF	20.0	20.5999	20.0	20.04	10728.0
2016-07-21	AFTY	ETF	13.09	13.11	13.09	13.11	1300.0
2016-07-21	AGG	ETF	112.27	112.54	112.2	112.51	3043500.0
2016-07-21	AGGY	ETF	51.93	52.08	51.93	52.08	11000.0
2016-07-21	AGQ	ETF	50.01	52.75	49.93	52.73	283100.0
2016-07-21	AGZ	ETF	115.59	115.6401	115.4	115.5884	22362.0
2016-07-21	AGZD	ETF	23.99	23.99	23.86	23.935	4800.0
2016-07-21	AIA	ETF	46.7779	46.83	46.56	46.64	20520.0
2016-07-21	AIQ	ETF	6.25	6.28	6.06	6.09	15646.0
2016-07-21	AIRR	ETF	19.38	19.44	19.178	19.24	5600.0
2016-07-21	AIVI	ETF	38.22	38.43	38.17	38.27	44300.0
2016-07-21	ALTY	ETF	15.541	15.541	15.447	15.447	500.0
2016-07-21	AMJ	ETF	32.31	32.65	31.99	32.15	1720676.0
2016-07-21	AMLP	ETF	64.85	65.1	64.25	64.5	1103060.0
2016-07-21	AMZA	ETF	113.5	114.9	112.9	113.2	11580.0
2016-07-21	ANGL	ETF	28.36	28.36	28.27	28.3	105700.0
2016-07-21	AOA	ETF	46.66	46.73	46.43	46.57	28400.0
2016-07-21	AOK	ETF	33.03	33.14	33.03	33.09	40953.0
2016-07-21	AOM	ETF	35.67	35.71	35.541	35.58	81654.0
2016-07-21	AOR	ETF	40.41	40.5199	40.37	40.45	54571.0
2016-07-21	ARGT	ETF	22.66	22.88	22.62	22.71	80800.0
2016-07-21	ARKG	ETF	18.25	18.25	18.181	18.184	400.0
2016-07-21	ARKK	ETF	20.345	20.38	20.345	20.38	600.0
2016-07-21	ARKQ	ETF	20.52	20.53	20.4	20.4	400.0
2016-07-21	ARKW	ETF	23.731	23.731	23.731	23.731	200.0
2016-07-21	ASEA	ETF	13.96	13.96	13.87	13.88	8900.0
2016-07-21	ASET	ETF	27.12	27.12	27.12	27.12	200.0
2016-07-21	ASHR	ETF	24.53	24.55	24.44	24.45	384000.0
2016-07-21	ASHS	ETF	35.41	35.48	35.39	35.39	6300.0
2016-07-21	ASHX	ETF	22.3701	22.3922	22.3701	22.3922	380.0
2016-07-21	ATMP	ETF	22.86	23.07	22.72	22.74	16800.0
2016-07-21	BAB	ETF	31.31	31.4899	31.2896	31.48	165981.0
2016-07-21	BAL	ETF	48.65	49.1525	48.5775	48.65	170112.0
2016-07-21	BBC	ETF	19.23	19.4	19.23	19.382	2345.0
2016-07-21	BBH	ETF	111.28	111.88	110.76	111.47	380800.0
2016-07-21	BBP	ETF	29.48	30.17	29.48	29.8	20100.0

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

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