PREVIEW / etf_daily / 2018-11-09

all etf daily files

  file:    by_date/etf_daily/2018/2018-11-09.parquet
  size:    64 KB
  rows:    1,668

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-11-09	SPY	ETF	279.03	279.24	276.18	277.76	98812600.0
2018-11-09	QQQ	ETF	172.83	173.25	170.16	171.52	50602710.0
2018-11-09	IWM	ETF	156.0	156.03	152.95	154.08	20654400.0
2018-11-09	DIA	ETF	261.16	261.45	259.04	260.09	4386500.0
2018-11-09	GLD	ETF	114.6	114.75	114.14	114.48	14159200.0
2018-11-09	TLT	ETF	112.75	113.5	112.72	113.35	6465300.0
2018-11-09	AAAU	ETF	12.12	12.12	12.08	12.08	7100.0
2018-11-09	AADR	ETF	47.01	47.01	46.18	46.43	21000.0
2018-11-09	AAXJ	ETF	64.26	64.45	63.58	63.91	1468900.0
2018-11-09	ACES	ETF	24.9	24.9	24.9	24.9	100.0
2018-11-09	ACSI	ETF	33.55	33.55	33.4472	33.4472	2183.0
2018-11-09	ACTX	ETF	85.5508	85.5508	80.2407	84.9608	382.0
2018-11-09	ACWF	ETF	29.11	29.11	28.68	28.9068	24864.0
2018-11-09	ACWI	ETF	70.35	70.37	69.75	70.18	2925900.0
2018-11-09	ACWV	ETF	85.78	86.02	85.52	85.8	271700.0
2018-11-09	ACWX	ETF	44.6	44.63	44.31	44.56	1696551.0
2018-11-09	ADRE	ETF	37.75	37.75	37.1901	37.5	1771.0
2018-11-09	AFIF	ETF	10.04	10.07	10.04	10.07	11334.0
2018-11-09	AFK	ETF	20.7363	20.7363	20.412	20.4475	2016.0
2018-11-09	AFTY	ETF	14.025	14.048	13.952	14.048	3100.0
2018-11-09	AGG	ETF	104.07	104.25	104.07	104.14	2901900.0
2018-11-09	AGGY	ETF	47.4	47.539	47.4	47.46	79000.0
2018-11-09	AGNG	ETF	20.83	20.83	20.401	20.49	16200.0
2018-11-09	AGQ	ETF	22.61	22.63	22.2	22.41	155200.0
2018-11-09	AGZ	ETF	110.09	110.126	110.02	110.04	33672.0
2018-11-09	AGZD	ETF	23.825	23.91	23.81	23.885	35800.0
2018-11-09	AIA	ETF	56.26	56.26	55.69	56.02	56838.0
2018-11-09	AIEQ	ETF	27.21	27.235	26.8	26.93	24500.0
2018-11-09	AIQ	ETF	14.25	14.25	13.97	14.1	8056.0
2018-11-09	AIRR	ETF	25.92	25.92	25.479	25.61	25200.0
2018-11-09	AIVI	ETF	40.29	40.29	40.1	40.19	1600.0
2018-11-09	ALTY	ETF	14.7	14.7	14.644	14.652	2900.0
2018-11-09	AMJ	ETF	26.01	26.08	25.65	25.96	1521957.0
2018-11-09	AMLP	ETF	49.65	49.85	48.95	49.65	4481500.0
2018-11-09	AMZA	ETF	65.5	66.13	64.3	65.5	64150.0
2018-11-09	ANGL	ETF	28.15	28.19	27.96	28.02	385200.0
2018-11-09	AOA	ETF	52.18	52.18	51.73	51.97	256000.0
2018-11-09	AOK	ETF	33.35	33.35	33.21	33.28	92924.0
2018-11-09	AOM	ETF	36.72	36.8175	36.5764	36.67	277216.0
2018-11-09	AOR	ETF	43.41	43.41	43.1301	43.29	173735.0
2018-11-09	ARGT	ETF	25.85	25.95	25.52	25.78	78300.0
2018-11-09	ARKG	ETF	30.05	30.34	29.7	29.87	149100.0
2018-11-09	ARKK	ETF	44.68	44.91	43.91	44.376	373800.0
2018-11-09	ARKQ	ETF	34.51	34.51	33.59	33.96	92300.0
2018-11-09	ARKW	ETF	53.96	54.23	52.92	53.55	160100.0
2018-11-09	ARVR	ETF	18.3591	18.47	18.3591	18.47	488.0
2018-11-09	ASEA	ETF	15.79	15.79	15.79	15.79	100.0
2018-11-09	ASET	ETF	27.0	27.0	27.0	27.0	321.0
2018-11-09	ASHR	ETF	23.0	23.01	22.79	22.87	3529100.0
2018-11-09	ASHS	ETF	22.77	23.0	22.77	22.99	11800.0

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

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