PREVIEW / etf_daily / 2017-10-27

all etf daily files

  file:    by_date/etf_daily/2017/2017-10-27.parquet
  size:    58 KB
  rows:    1,482

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-10-27	SPY	ETF	256.47	257.89	255.63	257.71	85562500.0
2017-10-27	QQQ	ETF	149.33	151.52	149.2	151.24	60165127.0
2017-10-27	IWM	ETF	148.88	149.91	148.3	149.79	32744100.0
2017-10-27	DIA	ETF	233.95	234.33	233.36	234.17	2944200.0
2017-10-27	GLD	ETF	120.38	120.99	120.21	120.9	6664200.0
2017-10-27	TLT	ETF	122.94	123.33	122.75	123.24	10480900.0
2017-10-27	AADR	ETF	56.97	57.32	56.89	57.19	20000.0
2017-10-27	AAXJ	ETF	74.42	75.09	74.23	75.05	1030600.0
2017-10-27	ACSI	ETF	29.62	29.6725	29.62	29.6725	700.0
2017-10-27	ACTX	ETF	52.5105	57.8205	48.3804	48.7344	300.0
2017-10-27	ACWF	ETF	29.88	29.95	29.82	29.9344	4506.0
2017-10-27	ACWI	ETF	69.93	70.22	69.78	70.19	960100.0
2017-10-27	ACWV	ETF	82.41	82.76	82.37	82.74	71700.0
2017-10-27	ACWX	ETF	48.8	49.06	48.7492	49.04	332448.0
2017-10-27	ADRE	ETF	42.45	42.735	42.08	42.6	9552.0
2017-10-27	AFK	ETF	23.46	23.46	23.311	23.4	3691.0
2017-10-27	AFTY	ETF	17.84	18.01	17.84	17.96	17700.0
2017-10-27	AGG	ETF	109.07	109.26	109.04	109.24	1902500.0
2017-10-27	AGGY	ETF	50.43	50.56	50.43	50.531	21200.0
2017-10-27	AGNG	ETF	19.16	19.55	19.16	19.5	9300.0
2017-10-27	AGQ	ETF	33.1	33.85	32.92	33.75	63700.0
2017-10-27	AGZ	ETF	113.28	113.411	113.28	113.4099	7764.0
2017-10-27	AGZD	ETF	24.09	24.13	24.09	24.11	5600.0
2017-10-27	AIA	ETF	63.97	64.485	63.85	64.42	25329.0
2017-10-27	AIEQ	ETF	25.08	25.08	24.78	25.0	280400.0
2017-10-27	AIRR	ETF	26.68	26.89	26.602	26.78	173200.0
2017-10-27	AIVI	ETF	42.45	42.64	42.42	42.64	41800.0
2017-10-27	ALTY	ETF	15.495	15.55	15.495	15.55	3000.0
2017-10-27	AMJ	ETF	26.63	27.18	26.55	26.94	4641775.0
2017-10-27	AMLP	ETF	52.6	53.85	52.5	53.25	3235560.0
2017-10-27	AMZA	ETF	81.7	84.3	81.6	83.2	194950.0
2017-10-27	ANGL	ETF	30.31	30.32	30.3	30.32	324700.0
2017-10-27	AOA	ETF	54.17	54.32	54.07	54.31	30700.0
2017-10-27	AOK	ETF	34.64	34.64	34.498	34.63	113946.0
2017-10-27	AOM	ETF	37.99	38.149	37.99	38.14	81254.0
2017-10-27	AOR	ETF	45.12	45.25	45.0204	45.25	71390.0
2017-10-27	ARGT	ETF	31.97	31.97	31.75	31.86	61000.0
2017-10-27	ARKG	ETF	25.14	25.64	25.053	25.63	126400.0
2017-10-27	ARKK	ETF	34.34	34.85	34.34	34.85	152200.0
2017-10-27	ARKQ	ETF	32.86	33.07	32.76	33.03	47400.0
2017-10-27	ARKW	ETF	41.82	42.56	41.82	42.52	103700.0
2017-10-27	ASEA	ETF	15.7	16.0	15.7	15.99	5200.0
2017-10-27	ASET	ETF	27.939	28.12	27.9389	28.1083	5173.0
2017-10-27	ASHR	ETF	30.63	30.8	30.63	30.79	622500.0
2017-10-27	ASHS	ETF	36.54	36.54	36.4	36.46	5800.0
2017-10-27	ATMP	ETF	20.2	20.41	20.07	20.41	40200.0
2017-10-27	BAB	ETF	30.22	30.28	30.17	30.2	92894.0
2017-10-27	BAL	ETF	44.8863	45.01	44.88	44.88	1357.0
2017-10-27	BAR	ETF	12.667	12.684	12.667	12.683	21650.0
2017-10-27	BBC	ETF	26.7	27.7022	26.7	27.62	9032.0

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

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