PREVIEW / etf_daily / 2017-03-01

all etf daily files

  file:    by_date/etf_daily/2017/2017-03-01.parquet
  size:    55 KB
  rows:    1,382

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-03-01	SPY	ETF	238.39	240.32	238.37	239.78	149158200.0
2017-03-01	QQQ	ETF	130.81	131.68	130.6	131.44	25813827.0
2017-03-01	IWM	ETF	139.65	140.86	139.52	140.36	35719800.0
2017-03-01	DIA	ETF	209.92	211.59	209.88	211.02	7846100.0
2017-03-01	GLD	ETF	117.98	119.12	117.95	119.06	8679600.0
2017-03-01	TLT	ETF	119.44	119.55	118.95	119.47	10717100.0
2017-03-01	AADR	ETF	45.8	46.05	45.58	46.02	5800.0
2017-03-01	AAXJ	ETF	60.96	61.28	60.9	61.2	574800.0
2017-03-01	ACSI	ETF	28.3599	28.36	28.3	28.3	2380.0
2017-03-01	ACTX	ETF	120.6561	123.9011	100.3009	103.8409	1890.0
2017-03-01	ACWF	ETF	25.58	25.6568	25.57	25.6568	3250.0
2017-03-01	ACWI	ETF	62.83	63.31	62.83	63.19	2769600.0
2017-03-01	ACWV	ETF	76.63	76.89	76.41	76.74	144300.0
2017-03-01	ACWX	ETF	42.61	42.88	42.61	42.82	382433.0
2017-03-01	ADRE	ETF	36.09	36.36	36.09	36.33	8967.0
2017-03-01	AFK	ETF	21.05	21.1052	20.63	20.85	14838.0
2017-03-01	AFTY	ETF	14.014	14.018	14.01	14.01	400.0
2017-03-01	AGG	ETF	108.12	108.14	107.98	108.04	3280200.0
2017-03-01	AGGY	ETF	49.67	49.709	49.6	49.68	32800.0
2017-03-01	AGNG	ETF	16.94	16.94	16.94	16.94	600.0
2017-03-01	AGQ	ETF	41.9	42.64	41.9	42.39	209300.0
2017-03-01	AGZ	ETF	113.0	113.0	112.49	112.73	28352.0
2017-03-01	AGZD	ETF	24.07	24.1	24.02	24.1	14800.0
2017-03-01	AIA	ETF	51.08	51.2173	50.9521	51.17	31534.0
2017-03-01	AIQ	ETF	10.2	10.4	10.05	10.05	17356.0
2017-03-01	AIRR	ETF	24.53	24.94	24.42	24.853	399500.0
2017-03-01	AIVI	ETF	38.84	39.14	38.84	39.06	40900.0
2017-03-01	ALTY	ETF	15.556	15.59	15.35	15.533	5300.0
2017-03-01	AMJ	ETF	33.0	33.19	32.87	33.12	3102460.0
2017-03-01	AMLP	ETF	64.65	65.0	64.4	64.85	2314620.0
2017-03-01	AMUB	ETF	20.87	20.87	20.845	20.845	512.0
2017-03-01	AMZA	ETF	113.0	113.2	112.6	112.9	45880.0
2017-03-01	ANGL	ETF	29.58	29.58	29.51	29.58	141200.0
2017-03-01	AOA	ETF	49.71	49.88	49.64	49.8	45400.0
2017-03-01	AOK	ETF	33.24	33.25	33.17	33.23	39238.0
2017-03-01	AOM	ETF	36.2	36.3	36.14	36.27	71541.0
2017-03-01	AOR	ETF	42.19	42.29	42.0906	42.28	54358.0
2017-03-01	ARGT	ETF	26.57	26.82	26.54	26.79	30700.0
2017-03-01	ARKG	ETF	20.06	20.306	20.059	20.306	3700.0
2017-03-01	ARKK	ETF	23.296	23.51	23.296	23.495	2300.0
2017-03-01	ARKQ	ETF	24.09	24.224	24.05	24.21	4500.0
2017-03-01	ARKW	ETF	28.441	28.52	28.37	28.52	8800.0
2017-03-01	ASEA	ETF	13.65	13.74	13.65	13.72	400.0
2017-03-01	ASET	ETF	26.4177	26.57	26.39	26.57	4460.0
2017-03-01	ASHR	ETF	25.22	25.3	25.16	25.29	333300.0
2017-03-01	ASHS	ETF	34.17	34.33	34.17	34.33	8300.0
2017-03-01	ATMP	ETF	24.13	24.37	24.12	24.25	58200.0
2017-03-01	BAB	ETF	29.29	29.305	29.17	29.24	198185.0
2017-03-01	BAL	ETF	49.6684	50.67	49.6684	50.67	14832.0
2017-03-01	BBC	ETF	22.4	22.9259	22.3236	22.83	35986.0

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

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