PREVIEW / etf_daily / 2016-10-04

all etf daily files

  file:    by_date/etf_daily/2016/2016-10-04.parquet
  size:    52 KB
  rows:    1,293

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-10-04	SPY	ETF	215.91	216.17	213.99	214.68	119948100.0
2016-10-04	QQQ	ETF	118.86	119.16	117.92	118.37	21239742.0
2016-10-04	IWM	ETF	124.02	124.31	122.65	123.21	26057300.0
2016-10-04	DIA	ETF	182.62	182.93	180.94	181.48	2811200.0
2016-10-04	GLD	ETF	123.16	123.18	120.86	120.97	24372700.0
2016-10-04	TLT	ETF	136.62	136.84	135.16	135.21	12048700.0
2016-10-04	AADR	ETF	40.4	40.4	40.12	40.12	36200.0
2016-10-04	AAXJ	ETF	60.83	60.95	60.09	60.19	1349900.0
2016-10-04	ACTX	ETF	5.31	7.6701	5.015	5.9001	4540.0
2016-10-04	ACWI	ETF	59.17	59.21	58.58	58.74	1866900.0
2016-10-04	ACWV	ETF	75.84	75.84	74.87	75.03	176100.0
2016-10-04	ACWX	ETF	41.55	41.655	41.18	41.3	234644.0
2016-10-04	ADRE	ETF	35.13	35.2728	34.91	34.91	11010.0
2016-10-04	AFK	ETF	20.79	20.79	20.2701	20.5795	3310.0
2016-10-04	AFTY	ETF	13.47	13.47	13.42	13.42	700.0
2016-10-04	AGG	ETF	112.09	112.09	111.7	111.71	5022400.0
2016-10-04	AGGY	ETF	51.91	51.91	51.66	51.722	17900.0
2016-10-04	AGQ	ETF	44.82	44.97	40.98	41.56	469700.0
2016-10-04	AGZ	ETF	115.45	115.51	115.17	115.26	31652.0
2016-10-04	AGZD	ETF	23.94	23.94	23.84	23.84	16000.0
2016-10-04	AIA	ETF	50.17	50.23	49.6088	49.74	58147.0
2016-10-04	AIQ	ETF	7.01	7.3799	6.8816	6.94	51394.0
2016-10-04	AIRR	ETF	20.43	20.6	20.3	20.417	5400.0
2016-10-04	AIVI	ETF	39.02	39.02	38.68	38.77	56100.0
2016-10-04	ALTY	ETF	15.44	15.44	15.212	15.245	5400.0
2016-10-04	AMJ	ETF	31.35	31.44	30.65	30.78	1486729.0
2016-10-04	AMLP	ETF	63.25	63.25	62.3	62.45	1480960.0
2016-10-04	AMZA	ETF	109.2	110.2	106.8	107.8	49130.0
2016-10-04	ANGL	ETF	28.79	28.86	28.72	28.72	78000.0
2016-10-04	AOA	ETF	47.32	47.37	46.98	47.1	30100.0
2016-10-04	AOK	ETF	33.29	33.32	33.09	33.19	84182.0
2016-10-04	AOM	ETF	35.91	35.992	35.6701	35.8	95633.0
2016-10-04	AOR	ETF	40.98	41.0	40.6872	40.79	61428.0
2016-10-04	ARGT	ETF	24.06	24.18	23.82	24.0	47500.0
2016-10-04	ARKG	ETF	20.01	20.01	19.77	19.77	600.0
2016-10-04	ARKK	ETF	22.32	22.32	22.08	22.08	5400.0
2016-10-04	ARKQ	ETF	22.38	22.4	22.3	22.3	2300.0
2016-10-04	ARKW	ETF	25.97	25.97	25.55	25.64	6500.0
2016-10-04	ASEA	ETF	14.09	14.11	13.93	13.93	1200.0
2016-10-04	ASHR	ETF	24.47	24.58	24.42	24.44	401100.0
2016-10-04	ASHS	ETF	34.63	34.63	34.39	34.43	9200.0
2016-10-04	ATMP	ETF	23.13	23.13	22.73	22.81	60100.0
2016-10-04	BAB	ETF	31.32	31.34	31.13	31.17	126875.0
2016-10-04	BAL	ETF	45.6	46.24	45.6	46.19	10027.0
2016-10-04	BBC	ETF	22.5494	22.782	22.4468	22.4468	1316.0
2016-10-04	BBH	ETF	115.21	115.6	114.21	114.5	38200.0
2016-10-04	BBP	ETF	33.63	33.63	32.97	33.08	7200.0
2016-10-04	BFOR	ETF	8.0625	8.0825	8.0175	8.0275	21200.0
2016-10-04	BIB	ETF	48.63	49.09	47.62	48.09	438392.0
2016-10-04	BICK	ETF	23.01	23.01	22.849	22.849	610.0

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

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