PREVIEW / etf_daily / 2018-10-23

all etf daily files

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

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-23	SPY	ETF	270.95	274.87	268.61	273.61	146352700.0
2018-10-23	QQQ	ETF	170.79	174.13	168.82	173.27	77566972.0
2018-10-23	IWM	ETF	150.93	152.89	148.92	151.66	37228100.0
2018-10-23	DIA	ETF	249.04	252.93	247.52	251.67	7360500.0
2018-10-23	GLD	ETF	117.16	117.25	116.33	116.39	12704200.0
2018-10-23	TLT	ETF	114.76	115.02	113.84	113.92	10330700.0
2018-10-23	AAAU	ETF	12.39	12.39	12.3	12.3	13900.0
2018-10-23	AADR	ETF	47.75	48.53	47.3	47.72	13200.0
2018-10-23	AAXJ	ETF	62.92	64.17	62.72	63.81	913100.0
2018-10-23	ACES	ETF	23.898	24.059	23.898	24.059	1100.0
2018-10-23	ACSI	ETF	32.2301	32.3101	32.2301	32.3101	2811.0
2018-10-23	ACTX	ETF	109.151	112.101	89.6808	95.5809	5669.0
2018-10-23	ACWF	ETF	28.1	28.4031	27.78	28.4031	20812.0
2018-10-23	ACWI	ETF	68.7	69.67	68.23	69.35	4222700.0
2018-10-23	ACWV	ETF	83.91	84.74	83.67	84.45	218600.0
2018-10-23	ACWX	ETF	43.83	44.3599	43.56	44.18	1370113.0
2018-10-23	ADRE	ETF	37.76	38.0866	37.37	38.0866	1833.0
2018-10-23	AFIF	ETF	10.0497	10.06	9.98	9.985	16245.0
2018-10-23	AFK	ETF	20.72	21.25	20.3448	20.73	6791.0
2018-10-23	AFTY	ETF	14.41	14.579	14.287	14.579	9900.0
2018-10-23	AGG	ETF	104.67	104.74	104.48	104.48	3524300.0
2018-10-23	AGGY	ETF	47.66	47.69	47.6	47.6	121100.0
2018-10-23	AGNG	ETF	20.11	20.328	20.0	20.328	2100.0
2018-10-23	AGQ	ETF	24.48	24.57	24.28	24.3	193700.0
2018-10-23	AGZ	ETF	110.47	110.524	110.3696	110.3696	56237.0
2018-10-23	AGZD	ETF	23.845	23.895	23.84	23.855	6800.0
2018-10-23	AIA	ETF	55.65	56.75	55.5	56.49	27709.0
2018-10-23	AIEQ	ETF	27.0	27.175	26.542	27.09	143800.0
2018-10-23	AIQ	ETF	14.13	14.338	13.9911	14.338	6639.0
2018-10-23	AIRR	ETF	25.04	25.04	24.633	24.79	12400.0
2018-10-23	AIVI	ETF	39.87	40.11	39.62	40.11	12400.0
2018-10-23	ALTY	ETF	14.444	14.529	14.421	14.505	4300.0
2018-10-23	AMJ	ETF	26.5	26.6612	26.01	26.52	1702266.0
2018-10-23	AMLP	ETF	51.6	51.9	50.55	51.5	4846020.0
2018-10-23	AMZA	ETF	69.5	69.7	66.8	68.8	181660.0
2018-10-23	ANGL	ETF	28.51	28.54	28.42	28.54	150600.0
2018-10-23	AOA	ETF	51.16	51.6	50.83	51.46	95500.0
2018-10-23	AOK	ETF	33.12	33.26	33.0677	33.24	385991.0
2018-10-23	AOM	ETF	36.35	36.535	36.26	36.49	115389.0
2018-10-23	AOR	ETF	42.72	43.02	42.52	42.9	73400.0
2018-10-23	ARGT	ETF	24.43	24.43	24.0	24.31	33300.0
2018-10-23	ARKG	ETF	27.68	28.49	27.313	28.079	188500.0
2018-10-23	ARKK	ETF	40.48	42.108	40.19	41.76	406900.0
2018-10-23	ARKQ	ETF	31.79	32.412	31.35	32.27	17100.0
2018-10-23	ARKW	ETF	50.51	52.25	50.22	52.01	283800.0
2018-10-23	ARVR	ETF	19.25	19.5438	19.25	19.25	1166.0
2018-10-23	ASEA	ETF	15.0	15.29	15.0	15.29	800.0
2018-10-23	ASET	ETF	26.43	26.73	26.43	26.73	510.0
2018-10-23	ASHR	ETF	23.14	23.51	23.04	23.43	2404300.0
2018-10-23	ASHS	ETF	22.15	22.58	22.15	22.54	35700.0

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

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