PREVIEW / etf_daily / 2016-09-23

all etf daily files

  file:    by_date/etf_daily/2016/2016-09-23.parquet
  size:    52 KB
  rows:    1,297

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-09-23	SPY	ETF	216.72	216.88	215.88	215.99	73630900.0
2016-09-23	QQQ	ETF	118.92	119.0	118.16	118.33	22213394.0
2016-09-23	IWM	ETF	125.56	125.88	124.81	124.81	26118000.0
2016-09-23	DIA	ETF	183.41	183.52	182.29	182.42	1741500.0
2016-09-23	GLD	ETF	127.6	127.86	127.43	127.65	7702300.0
2016-09-23	TLT	ETF	137.03	137.34	136.71	136.82	5928800.0
2016-09-23	AADR	ETF	40.75	40.75	40.67	40.67	1200.0
2016-09-23	AAXJ	ETF	60.92	61.0	60.61	60.61	920400.0
2016-09-23	ACTX	ETF	5.9001	5.9001	5.7821	5.9001	79.0
2016-09-23	ACWI	ETF	59.3	59.34	59.08	59.13	1086100.0
2016-09-23	ACWV	ETF	76.76	76.76	76.45	76.45	268200.0
2016-09-23	ACWX	ETF	41.68	41.76	41.57	41.58	226496.0
2016-09-23	ADRE	ETF	35.25	35.25	34.89	34.95	3803.0
2016-09-23	AFK	ETF	20.38	20.645	20.38	20.42	16318.0
2016-09-23	AFTY	ETF	13.462	13.488	13.462	13.488	800.0
2016-09-23	AGG	ETF	112.31	112.35	112.21	112.23	3415700.0
2016-09-23	AGGY	ETF	51.986	52.05	51.943	52.02	11500.0
2016-09-23	AGQ	ETF	51.58	51.61	50.27	50.66	136400.0
2016-09-23	AGZ	ETF	115.49	115.54	115.2501	115.455	12398.0
2016-09-23	AGZD	ETF	23.99	24.0	23.99	24.0	5000.0
2016-09-23	AIA	ETF	50.12	50.12	49.82	49.82	18498.0
2016-09-23	AIQ	ETF	6.75	6.92	6.72	6.73	10937.0
2016-09-23	AIRR	ETF	20.174	20.174	20.0	20.0	1700.0
2016-09-23	AIVI	ETF	38.77	38.97	38.77	38.86	8800.0
2016-09-23	ALTY	ETF	15.94	15.94	15.715	15.77	4200.0
2016-09-23	AMJ	ETF	31.42	31.56	31.14	31.27	1868741.0
2016-09-23	AMLP	ETF	62.85	63.35	62.75	62.9	834800.0
2016-09-23	AMZA	ETF	114.7	116.2	114.5	115.0	19420.0
2016-09-23	ANGL	ETF	28.67	28.74	28.65	28.72	689800.0
2016-09-23	AOA	ETF	47.55	47.63	47.44	47.48	42800.0
2016-09-23	AOK	ETF	33.37	33.3967	33.3	33.3456	36215.0
2016-09-23	AOM	ETF	36.07	36.1604	35.99	36.01	48687.0
2016-09-23	AOR	ETF	41.16	41.19	41.03	41.04	62644.0
2016-09-23	ARGT	ETF	23.56	23.56	23.12	23.28	107900.0
2016-09-23	ARKG	ETF	20.14	20.14	20.14	20.14	200.0
2016-09-23	ARKK	ETF	21.91	21.91	21.859	21.859	300.0
2016-09-23	ARKQ	ETF	21.66	21.66	21.6	21.62	500.0
2016-09-23	ARKW	ETF	25.26	25.34	25.21	25.21	1600.0
2016-09-23	ASEA	ETF	14.13	14.13	14.04	14.04	6100.0
2016-09-23	ASET	ETF	27.01	27.02	26.99	27.02	2436.0
2016-09-23	ASHR	ETF	24.71	24.72	24.58	24.6	626200.0
2016-09-23	ASHS	ETF	34.63	34.78	34.63	34.72	9000.0
2016-09-23	ATMP	ETF	23.29	23.29	23.03	23.07	133400.0
2016-09-23	BAB	ETF	31.31	31.317	31.21	31.26	129298.0
2016-09-23	BAL	ETF	46.85	46.85	46.21	46.47	5658.0
2016-09-23	BBC	ETF	23.25	23.25	22.7901	23.0499	3451.0
2016-09-23	BBH	ETF	118.93	119.76	118.57	118.57	26600.0
2016-09-23	BBP	ETF	34.77	34.77	34.3	34.38	6400.0
2016-09-23	BCM	ETF	25.9025	25.903	25.9025	25.903	421.0
2016-09-23	BFOR	ETF	8.105	8.105	8.0775	8.0775	12400.0

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

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