PREVIEW / etf_daily / 2016-11-22

all etf daily files

  file:    by_date/etf_daily/2016/2016-11-22.parquet
  size:    54 KB
  rows:    1,346

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-11-22	SPY	ETF	220.51	220.79	219.73	220.58	67429000.0
2016-11-22	QQQ	ETF	118.97	119.19	118.61	118.9	18850641.0
2016-11-22	IWM	ETF	132.12	132.9	131.67	132.8	39681500.0
2016-11-22	DIA	ETF	189.92	190.25	189.42	190.02	2756300.0
2016-11-22	GLD	ETF	115.72	115.79	114.98	115.54	6391900.0
2016-11-22	TLT	ETF	121.66	121.76	120.88	121.11	9989900.0
2016-11-22	AADR	ETF	41.16	41.16	40.3	40.91	5500.0
2016-11-22	AAXJ	ETF	56.52	56.59	56.29	56.53	1004300.0
2016-11-22	ACSI	ETF	26.56	26.59	26.52	26.59	13234.0
2016-11-22	ACTX	ETF	33.6303	43.0704	33.0403	34.2203	7919.0
2016-11-22	ACWF	ETF	24.32	24.32	24.32	24.32	331.0
2016-11-22	ACWI	ETF	58.6	58.71	58.43	58.71	2149100.0
2016-11-22	ACWV	ETF	72.88	72.93	72.65	72.86	283400.0
2016-11-22	ACWX	ETF	39.95	39.95	39.76	39.93	996613.0
2016-11-22	ADRE	ETF	33.39	33.4	33.05	33.161	7544.0
2016-11-22	AFK	ETF	19.4975	19.9308	19.24	19.6488	4333.0
2016-11-22	AFTY	ETF	13.705	13.74	13.67	13.72	4600.0
2016-11-22	AGG	ETF	108.59	108.66	108.46	108.56	3465300.0
2016-11-22	AGGY	ETF	49.96	50.0	49.83	49.92	55800.0
2016-11-22	AGQ	ETF	35.84	35.93	35.02	35.49	140900.0
2016-11-22	AGZ	ETF	113.21	113.542	113.105	113.3343	7498.0
2016-11-22	AGZD	ETF	23.98	23.98	23.945	23.945	1000.0
2016-11-22	AIA	ETF	47.74	47.9174	47.68	47.9174	28918.0
2016-11-22	AIQ	ETF	7.6	7.7	7.35	7.45	15463.0
2016-11-22	AIRR	ETF	22.9	22.9	22.463	22.82	177300.0
2016-11-22	AIVI	ETF	36.29	36.42	36.22	36.38	35700.0
2016-11-22	ALTY	ETF	14.93	14.93	14.81	14.855	2200.0
2016-11-22	AMJ	ETF	30.99	31.2339	30.545	30.76	2652432.0
2016-11-22	AMLP	ETF	61.55	61.85	61.1	61.4	2253520.0
2016-11-22	AMZA	ETF	111.3	111.3	108.1	109.2	45930.0
2016-11-22	ANGL	ETF	28.6	28.72	28.5	28.68	115100.0
2016-11-22	AOA	ETF	46.87	46.87	46.66	46.87	61200.0
2016-11-22	AOK	ETF	32.37	32.4999	32.3501	32.41	215736.0
2016-11-22	AOM	ETF	35.13	35.1899	35.0301	35.18	72042.0
2016-11-22	AOR	ETF	40.28	40.34	40.17	40.34	157368.0
2016-11-22	ARGT	ETF	23.33	23.37	23.07	23.29	81200.0
2016-11-22	ARKG	ETF	18.602	18.73	18.602	18.66	600.0
2016-11-22	ARKK	ETF	21.07	21.07	20.931	20.931	1100.0
2016-11-22	ARKQ	ETF	21.89	21.946	21.875	21.946	2300.0
2016-11-22	ARKW	ETF	26.02	26.02	25.826	25.905	600.0
2016-11-22	ASEA	ETF	12.96	12.98	12.95	12.95	6900.0
2016-11-22	ASET	ETF	24.99	25.0	24.99	25.0	239.0
2016-11-22	ASHR	ETF	25.3	25.42	25.29	25.41	707400.0
2016-11-22	ASHS	ETF	35.07	35.12	35.03	35.12	7700.0
2016-11-22	ATMP	ETF	23.28	23.54	22.98	23.2	209100.0
2016-11-22	BAB	ETF	29.4	29.46	29.31	29.37	260423.0
2016-11-22	BAL	ETF	47.2	47.627	47.07	47.6	18444.0
2016-11-22	BBC	ETF	22.0436	22.0436	21.02	21.03	16049.0
2016-11-22	BBH	ETF	112.76	112.76	109.87	110.69	45400.0
2016-11-22	BBP	ETF	35.95	35.95	34.36	34.62	45500.0

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

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