PREVIEW / etf_daily / 2016-10-25

all etf daily files

  file:    by_date/etf_daily/2016/2016-10-25.parquet
  size:    51 KB
  rows:    1,295

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-25	SPY	ETF	214.68	214.98	213.98	214.17	66542300.0
2016-10-25	QQQ	ETF	119.62	119.66	119.01	119.19	20341835.0
2016-10-25	IWM	ETF	121.81	121.99	120.6	120.93	16459800.0
2016-10-25	DIA	ETF	181.82	182.17	181.25	181.48	3351100.0
2016-10-25	GLD	ETF	120.89	121.76	120.86	121.47	6141100.0
2016-10-25	TLT	ETF	132.53	133.56	132.49	133.08	5134700.0
2016-10-25	AADR	ETF	42.14	42.49	42.14	42.49	6600.0
2016-10-25	AAXJ	ETF	60.24	60.31	60.07	60.18	315000.0
2016-10-25	ACTX	ETF	17.1102	17.1102	11.8001	13.5701	4181.0
2016-10-25	ACWF	ETF	23.97	23.97	23.65	23.7161	506.0
2016-10-25	ACWI	ETF	58.53	58.64	58.39	58.53	1052000.0
2016-10-25	ACWV	ETF	74.01	74.23	73.92	74.11	331200.0
2016-10-25	ACWX	ETF	41.04	41.12	40.95	41.07	239508.0
2016-10-25	ADRE	ETF	36.14	36.18	36.016	36.05	4677.0
2016-10-25	AFK	ETF	20.7	20.79	20.35	20.74	9670.0
2016-10-25	AFTY	ETF	13.81	13.81	13.604	13.64	9100.0
2016-10-25	AGG	ETF	111.58	111.8	111.58	111.66	2344400.0
2016-10-25	AGGY	ETF	51.56	51.666	51.54	51.54	16700.0
2016-10-25	AGQ	ETF	40.64	41.21	40.53	41.05	136500.0
2016-10-25	AGZ	ETF	115.2	115.2	114.63	115.14	16416.0
2016-10-25	AGZD	ETF	23.945	23.945	23.93	23.93	800.0
2016-10-25	AIA	ETF	50.03	50.03	49.8512	50.0	11466.0
2016-10-25	AIQ	ETF	8.05	8.85	8.05	8.75	22961.0
2016-10-25	AIRR	ETF	19.91	19.91	19.55	19.58	9200.0
2016-10-25	AIVI	ETF	37.86	38.01	37.8	37.9	17400.0
2016-10-25	ALTY	ETF	15.311	15.311	15.311	15.311	2100.0
2016-10-25	AMJ	ETF	31.2	31.28	30.86	30.88	1037877.0
2016-10-25	AMLP	ETF	63.0	63.15	62.6	62.65	929300.0
2016-10-25	AMZA	ETF	110.0	110.1	108.1	108.4	6560.0
2016-10-25	ANGL	ETF	29.26	29.3	29.22	29.27	182700.0
2016-10-25	AOA	ETF	46.94	46.99	46.82	46.89	52200.0
2016-10-25	AOK	ETF	33.07	33.08	33.0238	33.05	34075.0
2016-10-25	AOM	ETF	35.65	35.69	35.56	35.65	134980.0
2016-10-25	AOR	ETF	40.75	40.75	40.53	40.62	70070.0
2016-10-25	ARGT	ETF	24.54	24.55	24.25	24.3	36000.0
2016-10-25	ARKG	ETF	17.5	17.5	17.42	17.42	1100.0
2016-10-25	ARKK	ETF	20.81	20.81	20.385	20.43	4000.0
2016-10-25	ARKQ	ETF	21.54	21.54	21.245	21.25	1800.0
2016-10-25	ARKW	ETF	25.43	25.43	24.96	24.977	700.0
2016-10-25	ASEA	ETF	13.73	13.74	13.73	13.74	400.0
2016-10-25	ASHR	ETF	24.99	25.0	24.87	24.9	947400.0
2016-10-25	ASHS	ETF	35.26	35.26	35.16	35.16	8500.0
2016-10-25	ATMP	ETF	23.07	23.07	22.81	22.81	66800.0
2016-10-25	BAB	ETF	30.83	30.97	30.8	30.91	154222.0
2016-10-25	BAL	ETF	45.111	45.49	45.11	45.35	1867.0
2016-10-25	BBH	ETF	106.05	106.42	105.33	105.6	42800.0
2016-10-25	BBP	ETF	30.33	30.63	29.977	29.977	1600.0
2016-10-25	BFOR	ETF	7.9625	7.9625	7.9	7.9	23200.0
2016-10-25	BIB	ETF	40.81	41.3436	40.3	40.57	436439.0
2016-10-25	BICK	ETF	23.988	23.988	23.85	23.8619	1031.0

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

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