PREVIEW / etf_daily / 2016-10-12

all etf daily files

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

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-12	SPY	ETF	213.59	214.32	213.01	213.71	73866100.0
2016-10-12	QQQ	ETF	117.575	117.82	117.06	117.42	14267824.0
2016-10-12	IWM	ETF	122.09	122.61	121.53	121.93	20210400.0
2016-10-12	DIA	ETF	181.0	181.8	180.66	181.37	1920200.0
2016-10-12	GLD	ETF	119.72	120.07	119.29	119.74	4848600.0
2016-10-12	TLT	ETF	132.67	133.02	132.24	132.96	7582400.0
2016-10-12	AADR	ETF	39.88	40.21	39.88	40.14	1700.0
2016-10-12	AAXJ	ETF	59.51	59.77	59.4	59.63	698300.0
2016-10-12	ACTX	ETF	8.2601	10.6201	7.0801	8.8501	4600.0
2016-10-12	ACWI	ETF	58.18	58.35	58.04	58.22	989400.0
2016-10-12	ACWV	ETF	73.95	74.3	73.92	74.17	180200.0
2016-10-12	ACWX	ETF	40.7	40.81	40.6	40.71	260298.0
2016-10-12	ADRE	ETF	35.36	35.3699	35.14	35.3	6958.0
2016-10-12	AFK	ETF	20.26	20.33	20.25	20.28	7013.0
2016-10-12	AFTY	ETF	13.478	13.478	13.46	13.46	600.0
2016-10-12	AGG	ETF	111.39	111.43	111.26	111.4	1668500.0
2016-10-12	AGGY	ETF	51.55	51.59	51.518	51.59	19900.0
2016-10-12	AGQ	ETF	39.86	40.27	39.44	40.03	123500.0
2016-10-12	AGZ	ETF	114.86	114.9944	114.8544	114.93	9852.0
2016-10-12	AGZD	ETF	24.02	24.02	23.96	23.96	1600.0
2016-10-12	AIA	ETF	49.23	49.475	49.185	49.39	26358.0
2016-10-12	AIQ	ETF	7.45	7.45	7.14	7.32	6199.0
2016-10-12	AIRR	ETF	20.03	20.1	20.03	20.05	6900.0
2016-10-12	AIVI	ETF	37.9	37.96	37.78	37.87	18200.0
2016-10-12	ALTY	ETF	15.237	15.261	15.237	15.25	1000.0
2016-10-12	AMJ	ETF	30.92	31.16	30.827	31.05	750169.0
2016-10-12	AMLP	ETF	62.55	63.0	62.5	62.9	960820.0
2016-10-12	AMZA	ETF	107.7	108.3	107.55	107.9	7060.0
2016-10-12	ANGL	ETF	29.04	29.07	28.89	29.0	131700.0
2016-10-12	AOA	ETF	46.68	46.75	46.56	46.72	45300.0
2016-10-12	AOK	ETF	33.06	33.06	32.88	32.99	69320.0
2016-10-12	AOM	ETF	35.58	35.58	35.434	35.52	113900.0
2016-10-12	AOR	ETF	40.55	40.55	40.3564	40.48	85094.0
2016-10-12	ARGT	ETF	23.94	24.24	23.94	24.16	8000.0
2016-10-12	ARKG	ETF	18.57	18.57	17.981	18.0	3700.0
2016-10-12	ARKK	ETF	20.99	20.99	20.85	20.85	1900.0
2016-10-12	ARKQ	ETF	21.644	21.644	21.574	21.574	1000.0
2016-10-12	ARKW	ETF	25.01	25.01	24.91	24.939	3100.0
2016-10-12	ASEA	ETF	13.52	13.52	13.52	13.52	100.0
2016-10-12	ASET	ETF	25.56	25.63	25.56	25.63	200.0
2016-10-12	ASHR	ETF	24.63	24.68	24.58	24.65	142500.0
2016-10-12	ASHS	ETF	35.1	35.14	35.07	35.11	3400.0
2016-10-12	ASHX	ETF	22.66	22.66	22.66	22.66	1100.0
2016-10-12	ATMP	ETF	22.88	22.92	22.8	22.87	21200.0
2016-10-12	BAB	ETF	30.94	31.0	30.8701	30.9701	88439.0
2016-10-12	BAL	ETF	44.21	46.15	44.19	45.69	33387.0
2016-10-12	BBC	ETF	21.59	21.59	20.745	20.7785	6513.0
2016-10-12	BBH	ETF	109.64	110.01	107.42	107.43	236800.0
2016-10-12	BBP	ETF	33.05	33.05	31.57	31.59	10900.0
2016-10-12	BFOR	ETF	7.965	8.0025	7.965	7.9825	24000.0

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

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