PREVIEW / etf_daily / 2018-06-22

all etf daily files

  file:    by_date/etf_daily/2018/2018-06-22.parquet
  size:    61 KB
  rows:    1,573

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-06-22	SPY	ETF	275.66	275.79	274.49	274.74	54898500.0
2018-06-22	QQQ	ETF	176.31	176.369	174.69	175.32	30073187.0
2018-06-22	IWM	ETF	169.01	169.2	167.31	167.82	33638200.0
2018-06-22	DIA	ETF	245.92	246.51	245.44	245.69	3584900.0
2018-06-22	GLD	ETF	120.21	120.4	120.1	120.34	4489400.0
2018-06-22	TLT	ETF	120.09	120.62	120.06	120.53	4082500.0
2018-06-22	AADR	ETF	56.76	56.76	55.79	55.89	11800.0
2018-06-22	AAXJ	ETF	73.45	73.45	73.03	73.12	679200.0
2018-06-22	ACSI	ETF	32.5687	32.5687	32.5687	32.5687	691.0
2018-06-22	ACTX	ETF	82.6007	85.5508	70.2106	73.7507	2067.0
2018-06-22	ACWF	ETF	30.7	30.76	30.57	30.57	16127.0
2018-06-22	ACWI	ETF	72.22	72.29	71.94	72.02	1135400.0
2018-06-22	ACWV	ETF	83.52	83.61	83.32	83.46	58500.0
2018-06-22	ACWX	ETF	47.9	47.98	47.71	47.82	236502.0
2018-06-22	ADRE	ETF	42.07	42.07	41.8952	41.94	9587.0
2018-06-22	AFK	ETF	23.5	23.54	23.38	23.54	5690.0
2018-06-22	AFTY	ETF	16.21	16.21	16.18	16.208	2000.0
2018-06-22	AGG	ETF	105.82	105.94	105.8	105.94	1846000.0
2018-06-22	AGGY	ETF	48.44	48.47	48.41	48.455	20900.0
2018-06-22	AGNG	ETF	21.19	21.19	20.97	21.035	2700.0
2018-06-22	AGQ	ETF	30.69	31.13	30.61	31.01	90000.0
2018-06-22	AGZ	ETF	111.32	111.32	111.2	111.32	7569.0
2018-06-22	AGZD	ETF	23.945	23.945	23.9	23.9	3600.0
2018-06-22	AIA	ETF	63.83	63.83	63.42	63.46	210845.0
2018-06-22	AIEQ	ETF	28.81	28.83	28.6	28.6	88100.0
2018-06-22	AIQ	ETF	15.61	15.61	15.3547	15.41	14542.0
2018-06-22	AIRR	ETF	26.9	27.105	26.865	26.96	8900.0
2018-06-22	AIVI	ETF	42.89	42.96	42.73	42.86	19800.0
2018-06-22	ALTY	ETF	14.958	14.96	14.92	14.92	600.0
2018-06-22	AMJ	ETF	26.76	26.96	26.59	26.64	3396146.0
2018-06-22	AMLP	ETF	52.15	52.55	51.65	51.85	1898260.0
2018-06-22	AMUB	ETF	16.89	16.89	16.89	16.89	200.0
2018-06-22	AMZA	ETF	75.1	76.1	74.6	74.9	73470.0
2018-06-22	ANGL	ETF	28.98	28.99	28.94	28.97	119800.0
2018-06-22	AOA	ETF	53.94	54.01	53.9	53.94	50900.0
2018-06-22	AOK	ETF	34.06	34.0999	34.02	34.02	24708.0
2018-06-22	AOM	ETF	37.67	37.73	37.6241	37.7	50680.0
2018-06-22	AOR	ETF	44.66	44.749	44.6	44.67	58721.0
2018-06-22	ARGT	ETF	29.42	29.49	29.1	29.13	166400.0
2018-06-22	ARKG	ETF	31.19	31.22	30.47	30.69	96400.0
2018-06-22	ARKK	ETF	47.45	47.45	46.47	46.61	431000.0
2018-06-22	ARKQ	ETF	35.66	35.66	35.16	35.253	17200.0
2018-06-22	ARKW	ETF	58.13	58.19	57.141	57.25	192400.0
2018-06-22	ASHR	ETF	27.72	27.73	27.61	27.63	1331400.0
2018-06-22	ASHS	ETF	28.69	28.76	28.68	28.7	10000.0
2018-06-22	ASHX	ETF	19.92	19.93	19.87	19.87	1075.0
2018-06-22	ATMP	ETF	20.4	20.4	20.33	20.33	700.0
2018-06-22	BAB	ETF	29.43	29.44	29.39	29.43	107871.0
2018-06-22	BAL	ETF	52.76	52.93	52.75	52.75	658.0
2018-06-22	BAR	ETF	12.677	12.6834	12.662	12.683	87730.0

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

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