PREVIEW / etf_daily / 2018-10-25

all etf daily files

  file:    by_date/etf_daily/2018/2018-10-25.parquet
  size:    64 KB
  rows:    1,653

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-10-25	SPY	ETF	267.38	271.81	266.23	270.08	138061500.0
2018-10-25	QQQ	ETF	167.99	172.08	167.16	171.06	83481070.0
2018-10-25	IWM	ETF	146.73	149.82	146.41	149.11	32311300.0
2018-10-25	DIA	ETF	247.33	250.93	246.25	249.77	5920200.0
2018-10-25	GLD	ETF	116.58	116.73	116.19	116.4	8303500.0
2018-10-25	TLT	ETF	114.54	114.74	114.23	114.3	12613200.0
2018-10-25	AAAU	ETF	12.32	12.32	12.28	12.29	9700.0
2018-10-25	AADR	ETF	46.36	46.64	46.16	46.4	96900.0
2018-10-25	AAXJ	ETF	62.42	63.3	62.28	62.94	771200.0
2018-10-25	ACES	ETF	23.56	23.96	23.56	23.96	1900.0
2018-10-25	ACSI	ETF	31.9401	32.1437	31.9401	32.1437	2402.0
2018-10-25	ACTX	ETF	97.3509	103.2509	90.2708	96.1709	1131.0
2018-10-25	ACWF	ETF	27.63	27.84	27.575	27.71	195124.0
2018-10-25	ACWI	ETF	67.78	68.76	67.58	68.39	4275400.0
2018-10-25	ACWV	ETF	83.56	83.92	83.14	83.51	138300.0
2018-10-25	ACWX	ETF	43.31	43.75	43.17	43.54	1517659.0
2018-10-25	ADRE	ETF	36.9646	37.5151	36.9283	37.415	27164.0
2018-10-25	AFIF	ETF	10.05	10.06	9.9601	10.05	154611.0
2018-10-25	AFK	ETF	20.26	21.19	20.15	20.21	3481.0
2018-10-25	AFTY	ETF	14.45	14.72	14.45	14.7	5300.0
2018-10-25	AGG	ETF	104.71	104.77	104.61	104.66	8290200.0
2018-10-25	AGGY	ETF	47.69	47.7	47.624	47.69	74000.0
2018-10-25	AGNG	ETF	19.428	19.608	19.428	19.577	2300.0
2018-10-25	AGQ	ETF	24.11	24.12	23.86	23.99	88400.0
2018-10-25	AGZ	ETF	110.52	110.61	110.49	110.49	32719.0
2018-10-25	AGZD	ETF	23.835	23.835	23.815	23.815	4800.0
2018-10-25	AIA	ETF	54.69	55.5007	54.6	55.11	33027.0
2018-10-25	AIEQ	ETF	26.18	26.66	26.15	26.5	78600.0
2018-10-25	AIQ	ETF	13.68	13.94	13.68	13.91	16730.0
2018-10-25	AIRR	ETF	24.05	24.46	24.05	24.38	16700.0
2018-10-25	AIVI	ETF	39.19	39.46	39.19	39.28	7200.0
2018-10-25	ALTY	ETF	14.38	14.49	14.38	14.44	6200.0
2018-10-25	AMJ	ETF	25.92	26.1	25.61	25.8	2811978.0
2018-10-25	AMLP	ETF	50.3	50.6	49.75	50.15	4024700.0
2018-10-25	AMZA	ETF	65.5	66.1	65.0	65.5	118930.0
2018-10-25	ANGL	ETF	28.48	28.51	28.36	28.43	332300.0
2018-10-25	AOA	ETF	50.43	51.05	50.42	50.91	36700.0
2018-10-25	AOK	ETF	32.98	33.1199	32.95	33.11	57918.0
2018-10-25	AOM	ETF	36.1	36.39	36.1	36.26	94887.0
2018-10-25	AOR	ETF	42.4	42.7241	42.31	42.64	64605.0
2018-10-25	ARCM	ETF	100.27	100.27	100.27	100.27	30000.0
2018-10-25	ARGT	ETF	23.85	24.49	23.72	24.24	97100.0
2018-10-25	ARKG	ETF	26.44	27.242	26.24	26.91	229100.0
2018-10-25	ARKK	ETF	40.53	41.67	40.35	41.23	484500.0
2018-10-25	ARKQ	ETF	31.34	32.084	31.334	31.92	12700.0
2018-10-25	ARKW	ETF	50.2	51.78	50.2	51.63	119300.0
2018-10-25	ARVR	ETF	18.496	18.496	18.496	18.496	219.0
2018-10-25	ASEA	ETF	14.89	15.02	14.89	15.02	1200.0
2018-10-25	ASET	ETF	26.5427	26.5801	26.5427	26.5801	376.0
2018-10-25	ASHR	ETF	23.38	23.7	23.32	23.6	3647700.0

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

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