PREVIEW / etf_daily / 2018-10-15

all etf daily files

  file:    by_date/etf_daily/2018/2018-10-15.parquet
  size:    63 KB
  rows:    1,639

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-15	SPY	ETF	275.55	277.04	274.3	274.4	102263700.0
2018-10-15	QQQ	ETF	173.69	174.04	171.56	172.21	64885255.0
2018-10-15	IWM	ETF	153.36	155.29	152.54	154.17	32747600.0
2018-10-15	DIA	ETF	252.87	254.74	252.34	252.34	5500900.0
2018-10-15	GLD	ETF	116.12	116.53	115.89	116.0	11828400.0
2018-10-15	TLT	ETF	114.66	114.82	114.29	114.42	7146300.0
2018-10-15	AAAU	ETF	12.27	12.3	12.26	12.27	6300.0
2018-10-15	AADR	ETF	48.6	48.93	48.39	48.68	16400.0
2018-10-15	AAXJ	ETF	64.33	64.57	64.11	64.11	964400.0
2018-10-15	ACES	ETF	24.12	24.12	24.12	24.12	200.0
2018-10-15	ACSI	ETF	32.5945	32.82	32.5945	32.8113	1378.0
2018-10-15	ACTX	ETF	157.5314	176.4116	147.5013	155.1714	11179.0
2018-10-15	ACWF	ETF	28.75	28.85	28.69	28.71	12930.0
2018-10-15	ACWI	ETF	70.01	70.37	69.76	69.85	3722100.0
2018-10-15	ACWV	ETF	84.03	84.6	84.03	84.14	162100.0
2018-10-15	ACWX	ETF	44.72	44.91	44.5526	44.7	1822269.0
2018-10-15	ADRE	ETF	38.4	38.5978	38.2576	38.505	4107.0
2018-10-15	AFIF	ETF	10.05	10.05	9.9501	10.0101	14790.0
2018-10-15	AFK	ETF	20.42	20.8538	20.3108	20.755	8075.0
2018-10-15	AFTY	ETF	14.15	14.28	14.15	14.26	5800.0
2018-10-15	AGG	ETF	104.73	104.78	104.62	104.68	3047700.0
2018-10-15	AGGY	ETF	47.85	47.877	47.8	47.849	27500.0
2018-10-15	AGNG	ETF	20.555	20.68	20.555	20.605	4200.0
2018-10-15	AGQ	ETF	24.28	24.48	24.11	24.19	103800.0
2018-10-15	AGZ	ETF	110.31	110.3899	110.281	110.34	9751.0
2018-10-15	AGZD	ETF	23.885	23.98	23.775	23.98	36800.0
2018-10-15	AIA	ETF	56.96	57.19	56.75	56.75	13096.0
2018-10-15	AIEQ	ETF	27.52	27.69	27.4	27.5	82800.0
2018-10-15	AIQ	ETF	14.55	14.55	14.322	14.455	4603.0
2018-10-15	AIRR	ETF	25.38	25.91	25.38	25.77	23900.0
2018-10-15	AIVI	ETF	40.29	40.52	40.29	40.44	5000.0
2018-10-15	ALTY	ETF	14.59	14.59	14.53	14.53	2300.0
2018-10-15	AMJ	ETF	27.25	27.28	27.02	27.02	1236453.0
2018-10-15	AMLP	ETF	52.9	53.15	52.6	52.75	1727720.0
2018-10-15	AMZA	ETF	73.3	73.8	72.5	73.1	81120.0
2018-10-15	ANGL	ETF	28.7	28.71	28.65	28.67	263400.0
2018-10-15	AOA	ETF	51.87	52.08	51.75	51.86	39700.0
2018-10-15	AOK	ETF	33.28	33.375	33.2704	33.33	30195.0
2018-10-15	AOM	ETF	36.61	36.74	36.6	36.6	140199.0
2018-10-15	AOR	ETF	43.14	43.3334	43.1161	43.14	126258.0
2018-10-15	ARGT	ETF	25.0	25.43	24.89	25.15	54400.0
2018-10-15	ARKG	ETF	29.24	29.24	28.305	28.78	85500.0
2018-10-15	ARKK	ETF	41.78	42.02	41.05	41.64	194000.0
2018-10-15	ARKQ	ETF	32.52	32.61	32.22	32.27	12000.0
2018-10-15	ARKW	ETF	51.88	52.13	51.05	51.6	114700.0
2018-10-15	ARVR	ETF	19.93	19.93	19.5501	19.5501	262.0
2018-10-15	ASEA	ETF	15.34	15.38	15.34	15.38	900.0
2018-10-15	ASET	ETF	26.57	26.74	26.461	26.63	6562.0
2018-10-15	ASHR	ETF	23.1	23.19	23.01	23.01	1970100.0
2018-10-15	ASHS	ETF	22.43	22.47	22.28	22.3	12800.0

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

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