PREVIEW / etf_daily / 2017-06-06

all etf daily files

  file:    by_date/etf_daily/2017/2017-06-06.parquet
  size:    56 KB
  rows:    1,412

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-06	SPY	ETF	243.34	243.98	243.12	243.21	50375400.0
2017-06-06	QQQ	ETF	143.28	143.73	142.65	142.86	22393024.0
2017-06-06	IWM	ETF	138.11	139.66	137.81	138.85	25460900.0
2017-06-06	DIA	ETF	211.33	211.78	211.17	211.37	2094800.0
2017-06-06	GLD	ETF	123.09	123.31	122.77	123.1	10798500.0
2017-06-06	TLT	ETF	125.69	125.87	125.4	125.52	12841500.0
2017-06-06	AADR	ETF	48.0	48.11	47.87	47.95	22900.0
2017-06-06	AAXJ	ETF	67.69	67.98	67.69	67.84	362000.0
2017-06-06	ACSI	ETF	28.86	28.86	28.76	28.76	2591.0
2017-06-06	ACTX	ETF	53.1005	56.0505	53.1005	54.5755	295.0
2017-06-06	ACWF	ETF	27.37	27.37	27.2699	27.27	2290.0
2017-06-06	ACWI	ETF	66.3	66.47	66.29	66.37	1270500.0
2017-06-06	ACWV	ETF	80.99	81.11	80.87	80.94	167200.0
2017-06-06	ACWX	ETF	46.32	46.435	46.31	46.4	160899.0
2017-06-06	ADRE	ETF	38.4	38.63	38.3735	38.62	7328.0
2017-06-06	AFK	ETF	21.82	22.7	21.81	22.1	22338.0
2017-06-06	AFTY	ETF	14.84	14.84	14.82	14.82	2200.0
2017-06-06	AGG	ETF	109.87	109.95	109.81	109.89	1607700.0
2017-06-06	AGGY	ETF	50.73	50.826	50.73	50.82	10700.0
2017-06-06	AGNG	ETF	18.38	18.41	18.22	18.22	5100.0
2017-06-06	AGQ	ETF	38.42	38.7	38.3	38.5	160300.0
2017-06-06	AGZ	ETF	113.85	114.009	113.85	113.96	9572.0
2017-06-06	AGZD	ETF	23.95	23.96	23.95	23.96	10000.0
2017-06-06	AIA	ETF	57.28	57.37	57.16	57.31	39535.0
2017-06-06	AIQ	ETF	13.25	13.25	13.2	13.2	43786.0
2017-06-06	AIRR	ETF	23.17	23.42	23.16	23.32	36400.0
2017-06-06	AIVI	ETF	42.07	42.21	42.07	42.11	6800.0
2017-06-06	ALTY	ETF	15.394	15.419	15.361	15.361	2700.0
2017-06-06	AMJ	ETF	29.78	30.16	29.711	30.06	1206608.0
2017-06-06	AMLP	ETF	59.65	60.15	59.6	59.95	1935920.0
2017-06-06	AMZA	ETF	100.7	101.9	100.2	101.6	46960.0
2017-06-06	ANGL	ETF	29.67	29.72	29.65	29.67	251800.0
2017-06-06	AOA	ETF	51.92	52.0	51.89	51.93	32000.0
2017-06-06	AOK	ETF	34.08	34.13	34.031	34.11	39036.0
2017-06-06	AOM	ETF	37.4	37.43	37.33	37.4	76824.0
2017-06-06	AOR	ETF	43.74	43.82	43.7	43.75	53116.0
2017-06-06	ARCM	ETF	100.175	100.175	100.175	100.175	40.0
2017-06-06	ARGT	ETF	30.76	30.98	30.76	30.85	30600.0
2017-06-06	ARKG	ETF	20.86	21.029	20.84	20.92	5500.0
2017-06-06	ARKK	ETF	29.14	29.53	29.06	29.41	127000.0
2017-06-06	ARKQ	ETF	29.26	29.445	29.2	29.28	37600.0
2017-06-06	ARKW	ETF	36.25	36.55	36.2	36.3	160600.0
2017-06-06	ASEA	ETF	15.12	15.17	15.1	15.16	7200.0
2017-06-06	ASET	ETF	27.696	27.696	27.696	27.696	152.0
2017-06-06	ASHR	ETF	25.68	25.81	25.68	25.79	733500.0
2017-06-06	ASHS	ETF	31.2	31.28	31.2	31.28	8400.0
2017-06-06	ATMP	ETF	22.12	22.31	21.97	22.24	61000.0
2017-06-06	BAB	ETF	30.15	30.18	30.12	30.15	99411.0
2017-06-06	BAL	ETF	48.55	48.55	48.29	48.35	2476.0
2017-06-06	BBC	ETF	22.2086	22.47	22.16	22.22	4732.0

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

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