PREVIEW / etf_daily / 2017-06-08

all etf daily files

  file:    by_date/etf_daily/2017/2017-06-08.parquet
  size:    55 KB
  rows:    1,405

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-06-08	SPY	ETF	243.77	244.33	243.17	243.78	65950700.0
2017-06-08	QQQ	ETF	143.74	143.8	142.79	143.57	25417408.0
2017-06-08	IWM	ETF	138.98	141.46	138.74	140.88	33956400.0
2017-06-08	DIA	ETF	211.62	212.7	211.39	211.86	2030300.0
2017-06-08	GLD	ETF	122.07	122.08	120.95	121.65	8169800.0
2017-06-08	TLT	ETF	124.88	124.88	124.3	124.59	8758600.0
2017-06-08	AADR	ETF	48.52	48.52	47.62	48.03	19700.0
2017-06-08	AAXJ	ETF	68.47	68.47	68.1	68.41	360800.0
2017-06-08	ACSI	ETF	28.88	28.95	28.8653	28.89	9139.0
2017-06-08	ACTX	ETF	74.3407	79.6507	70.8006	73.7507	925.0
2017-06-08	ACWF	ETF	27.33	27.3999	27.314	27.33	8069.0
2017-06-08	ACWI	ETF	66.4	66.47	66.24	66.46	1655500.0
2017-06-08	ACWV	ETF	80.86	80.86	80.38	80.52	168900.0
2017-06-08	ACWX	ETF	46.33	46.4	46.25	46.38	294643.0
2017-06-08	ADRE	ETF	39.4	39.49	38.94	39.3612	7130.0
2017-06-08	AFK	ETF	21.7091	21.86	21.7091	21.86	2154.0
2017-06-08	AFTY	ETF	15.1	15.11	15.1	15.1	1900.0
2017-06-08	AGG	ETF	109.7	109.7	109.51	109.65	1532700.0
2017-06-08	AGGY	ETF	50.7	50.7	50.577	50.68	14700.0
2017-06-08	AGNG	ETF	18.25	18.369	18.25	18.343	2400.0
2017-06-08	AGQ	ETF	38.17	38.17	36.71	37.2	163100.0
2017-06-08	AGZ	ETF	113.6341	113.86	113.6341	113.85	7717.0
2017-06-08	AGZD	ETF	23.96	23.96	23.945	23.945	4400.0
2017-06-08	AIA	ETF	57.35	57.35	57.12	57.26	70691.0
2017-06-08	AIQ	ETF	13.2	13.25	13.2	13.2	5738.0
2017-06-08	AIRR	ETF	23.3	23.73	23.3	23.62	41500.0
2017-06-08	AIVI	ETF	42.04	42.06	41.9	41.96	13400.0
2017-06-08	ALTY	ETF	15.43	15.44	15.403	15.43	5200.0
2017-06-08	AMJ	ETF	29.4	29.58	29.25	29.32	2408501.0
2017-06-08	AMLP	ETF	58.9	59.3	58.6	58.65	2678040.0
2017-06-08	AMZA	ETF	98.5	98.8	97.5	97.5	97000.0
2017-06-08	ANGL	ETF	29.62	29.64	29.53	29.62	402800.0
2017-06-08	AOA	ETF	51.94	52.0	51.83	51.98	47100.0
2017-06-08	AOK	ETF	34.05	34.1199	34.0283	34.06	46050.0
2017-06-08	AOM	ETF	37.35	37.4136	37.31	37.39	100932.0
2017-06-08	AOR	ETF	43.87	43.87	43.6701	43.8	71275.0
2017-06-08	ARCM	ETF	100.175	100.175	100.05	100.05	2040.0
2017-06-08	ARGT	ETF	30.9	30.9	30.53	30.56	22500.0
2017-06-08	ARKG	ETF	21.24	21.5	21.12	21.421	6800.0
2017-06-08	ARKK	ETF	29.59	29.8	29.43	29.75	63700.0
2017-06-08	ARKQ	ETF	29.41	29.78	29.37	29.75	40800.0
2017-06-08	ARKW	ETF	36.45	36.682	36.21	36.61	92300.0
2017-06-08	ASEA	ETF	15.09	15.16	15.09	15.16	600.0
2017-06-08	ASET	ETF	27.61	27.6298	27.6077	27.625	1714.0
2017-06-08	ASHR	ETF	26.21	26.41	26.17	26.4	1317000.0
2017-06-08	ASHS	ETF	31.93	32.07	31.88	32.03	14100.0
2017-06-08	ASHX	ETF	20.04	20.04	20.04	20.04	100.0
2017-06-08	ATMP	ETF	21.91	21.91	21.7	21.75	63600.0
2017-06-08	BAB	ETF	30.09	30.09	30.0	30.06	75107.0
2017-06-08	BAL	ETF	48.09	48.6	48.0879	48.43	3468.0

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

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