PREVIEW / etf_daily / 2017-03-06

all etf daily files

  file:    by_date/etf_daily/2017/2017-03-06.parquet
  size:    54 KB
  rows:    1,381

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-06	SPY	ETF	237.5	238.12	237.01	237.71	55391500.0
2017-03-06	QQQ	ETF	130.56	130.95	130.21	130.73	12026151.0
2017-03-06	IWM	ETF	137.78	137.97	136.99	137.7	23892100.0
2017-03-06	DIA	ETF	209.26	209.77	209.02	209.48	2524700.0
2017-03-06	GLD	ETF	117.35	117.35	116.63	116.72	4883500.0
2017-03-06	TLT	ETF	119.12	119.12	118.52	118.78	4489200.0
2017-03-06	AADR	ETF	46.0	46.0	45.43	45.54	20800.0
2017-03-06	AAXJ	ETF	60.36	60.43	60.2	60.38	659100.0
2017-03-06	ACSI	ETF	28.09	28.09	27.891	27.96	1527.0
2017-03-06	ACTX	ETF	100.3009	101.4809	94.4008	95.2269	1550.0
2017-03-06	ACWF	ETF	25.4021	25.4021	25.4021	25.4021	399.0
2017-03-06	ACWI	ETF	62.75	62.83	62.6	62.76	930800.0
2017-03-06	ACWV	ETF	76.21	76.31	76.13	76.29	98100.0
2017-03-06	ACWX	ETF	42.59	42.59	42.48	42.58	344836.0
2017-03-06	ADRE	ETF	35.81	35.81	35.6689	35.673	2664.0
2017-03-06	AFK	ETF	20.74	20.74	20.5179	20.5411	9286.0
2017-03-06	AFTY	ETF	13.84	13.84	13.79	13.79	4400.0
2017-03-06	AGG	ETF	107.94	107.99	107.82	107.87	3678300.0
2017-03-06	AGGY	ETF	49.59	49.62	49.53	49.62	49700.0
2017-03-06	AGNG	ETF	16.607	16.607	16.607	16.607	500.0
2017-03-06	AGQ	ETF	39.85	39.9	39.24	39.5	124100.0
2017-03-06	AGZ	ETF	112.4	112.655	112.39	112.39	32895.0
2017-03-06	AGZD	ETF	24.1	24.115	24.01	24.035	17400.0
2017-03-06	AIA	ETF	50.45	50.5396	50.38	50.51	21469.0
2017-03-06	AIQ	ETF	9.7	10.4	9.7	10.05	40607.0
2017-03-06	AIRR	ETF	24.2	24.27	23.977	24.09	43700.0
2017-03-06	AIVI	ETF	38.95	39.07	38.92	39.06	53300.0
2017-03-06	ALTY	ETF	15.48	15.48	15.26	15.29	9500.0
2017-03-06	AMJ	ETF	32.99	33.05	32.66	33.04	1102202.0
2017-03-06	AMLP	ETF	64.9	64.9	64.4	64.85	1238040.0
2017-03-06	AMZA	ETF	113.6	113.6	112.3	113.3	82130.0
2017-03-06	ANGL	ETF	29.51	29.51	29.39	29.41	216500.0
2017-03-06	AOA	ETF	49.58	49.58	49.36	49.49	35900.0
2017-03-06	AOK	ETF	33.11	33.11	33.02	33.09	48376.0
2017-03-06	AOM	ETF	36.14	36.15	36.0778	36.15	44982.0
2017-03-06	AOR	ETF	42.06	42.06	41.94	42.05	57851.0
2017-03-06	ARGT	ETF	26.56	26.61	26.46	26.56	43800.0
2017-03-06	ARKG	ETF	19.824	20.09	19.824	20.09	3900.0
2017-03-06	ARKK	ETF	23.19	23.27	23.04	23.27	2300.0
2017-03-06	ARKQ	ETF	23.81	23.81	23.55	23.63	3700.0
2017-03-06	ARKW	ETF	28.2	28.36	28.119	28.36	3500.0
2017-03-06	ASEA	ETF	13.66	13.66	13.66	13.66	200.0
2017-03-06	ASET	ETF	26.19	26.19	26.1698	26.1698	674.0
2017-03-06	ASHR	ETF	24.9	24.96	24.89	24.93	315900.0
2017-03-06	ASHS	ETF	34.26	34.32	34.2	34.2	8900.0
2017-03-06	ATMP	ETF	23.93	24.37	23.93	24.15	153200.0
2017-03-06	BAB	ETF	29.18	29.18	29.05	29.0999	138500.0
2017-03-06	BAL	ETF	51.4818	51.5718	51.17	51.4947	4032.0
2017-03-06	BBC	ETF	22.93	23.07	22.755	22.8743	12268.0
2017-03-06	BBH	ETF	123.04	123.04	121.25	121.77	92900.0

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

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