PREVIEW / etf_daily / 2018-05-17

all etf daily files

  file:    by_date/etf_daily/2018/2018-05-17.parquet
  size:    61 KB
  rows:    1,566

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
2018-05-17	SPY	ETF	271.94	273.23	271.13	272.01	56536400.0
2018-05-17	QQQ	ETF	168.4	169.61	167.51	168.33	27480164.0
2018-05-17	IWM	ETF	161.0	162.0	160.75	161.66	18639700.0
2018-05-17	DIA	ETF	247.8	248.89	246.88	247.74	2058200.0
2018-05-17	GLD	ETF	122.23	122.43	122.04	122.36	7781300.0
2018-05-17	TLT	ETF	116.63	116.82	116.09	116.21	7330300.0
2018-05-17	AADR	ETF	59.13	59.49	59.09	59.27	10300.0
2018-05-17	AAXJ	ETF	76.61	76.8	76.18	76.4	791600.0
2018-05-17	ACSI	ETF	31.3927	31.3927	31.3822	31.3822	683.0
2018-05-17	ACTX	ETF	61.3606	63.1306	57.8205	63.1306	93.0
2018-05-17	ACWF	ETF	31.3	31.3958	31.2748	31.3487	4782.0
2018-05-17	ACWI	ETF	73.35	73.65	73.2	73.4	834200.0
2018-05-17	ACWV	ETF	83.62	83.71	83.38	83.53	35600.0
2018-05-17	ACWX	ETF	50.39	50.52	50.28	50.405	339259.0
2018-05-17	ADRE	ETF	44.59	44.67	44.11	44.11	9118.0
2018-05-17	AFK	ETF	25.31	25.65	25.31	25.5613	4124.0
2018-05-17	AFTY	ETF	17.21	17.21	17.12	17.14	1900.0
2018-05-17	AGG	ETF	105.19	105.21	105.0	105.03	2789000.0
2018-05-17	AGGY	ETF	48.23	48.249	48.18	48.21	41900.0
2018-05-17	AGNG	ETF	20.04	20.204	20.04	20.142	2100.0
2018-05-17	AGQ	ETF	31.28	31.37	31.07	31.11	97600.0
2018-05-17	AGZ	ETF	110.49	110.5578	110.49	110.5116	8737.0
2018-05-17	AGZD	ETF	24.03	24.045	23.965	24.045	2600.0
2018-05-17	AIA	ETF	67.11	67.32	66.79	67.08	100362.0
2018-05-17	AIEQ	ETF	27.68	27.86	27.6	27.76	64200.0
2018-05-17	AIQ	ETF	15.02	15.18	15.0102	15.1	57119.0
2018-05-17	AIRR	ETF	26.22	26.62	26.22	26.51	22600.0
2018-05-17	AIVI	ETF	44.53	44.69	44.53	44.57	4100.0
2018-05-17	ALTY	ETF	14.94	14.94	14.753	14.753	3000.0
2018-05-17	AMJ	ETF	27.07	27.545	27.04	27.33	1083511.0
2018-05-17	AMLP	ETF	51.95	52.6	51.7	52.1	2595920.0
2018-05-17	AMZA	ETF	76.5	77.79	76.5	77.3	147970.0
2018-05-17	ANGL	ETF	29.09	29.11	29.03	29.05	215300.0
2018-05-17	AOA	ETF	54.16	54.29	54.03	54.1	29700.0
2018-05-17	AOK	ETF	34.02	34.02	33.94	34.01	39652.0
2018-05-17	AOM	ETF	37.61	37.6518	37.55	37.57	80026.0
2018-05-17	AOR	ETF	44.71	44.819	44.6701	44.76	49603.0
2018-05-17	ARGT	ETF	31.63	31.79	31.39	31.67	157600.0
2018-05-17	ARKG	ETF	28.12	28.5	28.0	28.47	72400.0
2018-05-17	ARKK	ETF	42.97	43.46	42.801	43.13	276500.0
2018-05-17	ARKQ	ETF	34.4	34.73	34.4	34.53	8100.0
2018-05-17	ARKW	ETF	52.96	53.329	52.58	52.89	85700.0
2018-05-17	ASEA	ETF	17.13	17.22	17.11	17.11	1100.0
2018-05-17	ASET	ETF	27.9181	27.9181	27.8951	27.8951	430.0
2018-05-17	ASHR	ETF	30.4	30.45	30.27	30.3	1419800.0
2018-05-17	ASHS	ETF	34.21	34.28	34.21	34.22	3100.0
2018-05-17	ASHX	ETF	21.09	21.09	21.09	21.09	200.0
2018-05-17	ATMP	ETF	20.63	20.81	20.59	20.74	107400.0
2018-05-17	BAB	ETF	29.42	29.42	29.32	29.32	45749.0
2018-05-17	BAL	ETF	51.41	51.41	51.41	51.41	500.0

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

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