PREVIEW / etf_daily / 2017-01-23

all etf daily files

  file:    by_date/etf_daily/2017/2017-01-23.parquet
  size:    54 KB
  rows:    1,359

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
2017-01-23	SPY	ETF	226.74	226.81	225.27	226.15	75061600.0
2017-01-23	QQQ	ETF	123.16	123.53	122.57	123.35	17434167.0
2017-01-23	IWM	ETF	134.03	134.68	133.12	133.88	20537000.0
2017-01-23	DIA	ETF	197.86	198.11	197.04	197.78	3249700.0
2017-01-23	GLD	ETF	115.51	116.17	115.2	115.79	6373100.0
2017-01-23	TLT	ETF	120.34	121.87	120.02	121.14	13118400.0
2017-01-23	AADR	ETF	43.94	44.51	43.85	44.47	16500.0
2017-01-23	AAXJ	ETF	57.74	58.13	57.74	58.07	619100.0
2017-01-23	ACSI	ETF	27.06	27.06	26.96	27.03	11000.0
2017-01-23	ACTX	ETF	65.7856	84.9608	59.5905	81.4207	6051.0
2017-01-23	ACWF	ETF	24.7001	25.1899	24.7001	25.1899	454.0
2017-01-23	ACWI	ETF	60.45	60.54	60.25	60.5	1991500.0
2017-01-23	ACWV	ETF	73.58	73.68	73.44	73.57	459100.0
2017-01-23	ACWX	ETF	41.41	41.605	41.38	41.6	4010228.0
2017-01-23	ADRE	ETF	34.63	34.98	34.63	34.97	4346.0
2017-01-23	AFK	ETF	21.13	21.3863	21.01	21.0931	4046.0
2017-01-23	AFTY	ETF	13.62	13.73	13.62	13.72	10900.0
2017-01-23	AGG	ETF	108.22	108.57	108.1	108.38	3063400.0
2017-01-23	AGGY	ETF	49.51	49.759	49.51	49.73	20900.0
2017-01-23	AGNG	ETF	15.78	15.78	15.78	15.78	600.0
2017-01-23	AGQ	ETF	37.02	37.3	36.87	37.25	109300.0
2017-01-23	AGZ	ETF	112.7	113.03	112.64	112.9	30127.0
2017-01-23	AGZD	ETF	24.015	24.015	23.975	23.975	13000.0
2017-01-23	AIA	ETF	48.69	49.0	48.69	49.0	29304.0
2017-01-23	AIQ	ETF	9.625	9.75	9.625	9.7	32632.0
2017-01-23	AIRR	ETF	23.3	23.55	23.078	23.27	165500.0
2017-01-23	AIVI	ETF	38.43	38.58	38.39	38.55	15900.0
2017-01-23	ALTY	ETF	15.3	15.36	15.21	15.36	5900.0
2017-01-23	AMJ	ETF	31.94	32.03	31.76	31.96	1866051.0
2017-01-23	AMLP	ETF	63.55	63.75	63.15	63.45	2560260.0
2017-01-23	AMZA	ETF	108.7	109.0	107.83	108.1	42790.0
2017-01-23	ANGL	ETF	29.2	29.2	29.13	29.19	211200.0
2017-01-23	AOA	ETF	47.97	48.05	47.84	48.05	271100.0
2017-01-23	AOK	ETF	32.7	32.7699	32.6747	32.75	187486.0
2017-01-23	AOM	ETF	35.52	35.57	35.44	35.57	763752.0
2017-01-23	AOR	ETF	41.0	41.0799	40.93	41.07	597241.0
2017-01-23	ARGT	ETF	25.52	25.73	25.34	25.67	110400.0
2017-01-23	ARKG	ETF	17.5	17.61	17.48	17.59	2400.0
2017-01-23	ARKK	ETF	21.95	21.99	21.761	21.898	6600.0
2017-01-23	ARKQ	ETF	23.27	23.27	22.947	23.08	11200.0
2017-01-23	ARKW	ETF	27.14	27.14	26.972	27.01	4900.0
2017-01-23	ASEA	ETF	13.43	13.43	13.37	13.41	800.0
2017-01-23	ASET	ETF	26.059	26.06	26.0519	26.0519	315.0
2017-01-23	ASHR	ETF	24.7	24.78	24.68	24.77	1134000.0
2017-01-23	ASHS	ETF	32.63	33.03	32.63	33.01	2600.0
2017-01-23	ATMP	ETF	23.4	23.53	23.25	23.42	99600.0
2017-01-23	BAB	ETF	29.16	29.29	29.0991	29.24	185366.0
2017-01-23	BAL	ETF	49.06	49.4	48.964	49.29	9858.0
2017-01-23	BBC	ETF	19.0313	19.0313	18.7405	18.885	5421.0
2017-01-23	BBH	ETF	111.24	111.85	110.61	110.85	75300.0

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

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