PREVIEW / etf_daily / 2018-11-02

all etf daily files

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

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-02	SPY	ETF	274.75	275.23	269.59	271.89	122634100.0
2018-11-02	QQQ	ETF	171.53	172.55	168.22	169.38	75966781.0
2018-11-02	IWM	ETF	154.06	154.89	152.44	154.0	26671600.0
2018-11-02	DIA	ETF	255.38	255.6	250.58	252.46	6413400.0
2018-11-02	GLD	ETF	116.61	116.98	116.39	116.65	8796900.0
2018-11-02	TLT	ETF	113.17	113.26	111.9	112.0	11314800.0
2018-11-02	AAAU	ETF	12.33	12.35	12.31	12.34	13100.0
2018-11-02	AADR	ETF	47.89	48.13	47.15	47.31	12700.0
2018-11-02	AAXJ	ETF	66.27	66.58	65.06	65.64	1103200.0
2018-11-02	ACES	ETF	24.352	24.352	24.352	24.352	200.0
2018-11-02	ACSI	ETF	32.75	32.75	32.43	32.43	2300.0
2018-11-02	ACTX	ETF	79.9457	85.5508	79.6507	84.9608	1777.0
2018-11-02	ACWF	ETF	28.75	28.99	28.51	28.782	40939.0
2018-11-02	ACWI	ETF	70.19	70.31	69.02	69.57	4146100.0
2018-11-02	ACWV	ETF	84.61	84.84	83.59	84.11	84500.0
2018-11-02	ACWX	ETF	45.08	45.24	44.495	44.79	1976954.0
2018-11-02	ADRE	ETF	39.2	39.2	38.3282	38.46	2107.0
2018-11-02	AFIF	ETF	10.06	10.07	10.04	10.0699	4168.0
2018-11-02	AFK	ETF	20.7855	20.9436	20.4	20.7082	5407.0
2018-11-02	AFTY	ETF	15.07	15.07	14.76	14.88	22500.0
2018-11-02	AGG	ETF	104.25	104.29	103.94	104.03	4491500.0
2018-11-02	AGGY	ETF	47.48	47.512	47.345	47.367	21400.0
2018-11-02	AGNG	ETF	20.13	20.173	20.108	20.108	700.0
2018-11-02	AGQ	ETF	24.48	24.84	24.22	24.3	122500.0
2018-11-02	AGZ	ETF	110.19	110.269	110.0801	110.11	7358.0
2018-11-02	AGZD	ETF	23.8	23.8	23.785	23.785	1600.0
2018-11-02	AIA	ETF	58.23	58.45	57.1568	57.75	51245.0
2018-11-02	AIEQ	ETF	27.06	27.29	26.72	26.91	48400.0
2018-11-02	AIQ	ETF	14.22	14.29	14.0121	14.06	15619.0
2018-11-02	AIRR	ETF	25.19	25.39	25.06	25.195	39100.0
2018-11-02	AIVI	ETF	40.3	40.3	39.84	40.07	3800.0
2018-11-02	ALTY	ETF	14.53	14.53	14.51	14.51	1000.0
2018-11-02	AMJ	ETF	25.5	25.87	25.16	25.27	1356261.0
2018-11-02	AMLP	ETF	49.45	49.85	48.8	49.05	5210920.0
2018-11-02	AMZA	ETF	65.0	65.5	63.1	63.8	160690.0
2018-11-02	ANGL	ETF	28.14	28.23	28.08	28.14	547700.0
2018-11-02	AOA	ETF	51.91	52.01	51.3	51.51	60800.0
2018-11-02	AOK	ETF	33.26	33.34	33.09	33.155	50845.0
2018-11-02	AOM	ETF	36.65	36.6989	36.4113	36.49	287367.0
2018-11-02	AOR	ETF	43.26	43.2799	42.83	43.04	125732.0
2018-11-02	ARGT	ETF	26.93	27.24	26.8	27.13	103500.0
2018-11-02	ARKG	ETF	29.79	30.2	29.34	30.0	340100.0
2018-11-02	ARKK	ETF	45.39	45.92	44.895	45.48	528500.0
2018-11-02	ARKQ	ETF	34.57	34.72	33.97	34.25	27100.0
2018-11-02	ARKW	ETF	55.51	56.276	54.67	55.17	164300.0
2018-11-02	ARVR	ETF	18.7634	18.7634	18.7634	18.7634	104.0
2018-11-02	ASEA	ETF	15.69	15.69	15.69	15.69	1000.0
2018-11-02	ASET	ETF	26.7401	26.7401	26.43	26.56	2246.0
2018-11-02	ASHR	ETF	24.42	24.54	23.9	24.12	7178600.0
2018-11-02	ASHS	ETF	24.0	24.0	23.38	23.42	32300.0

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

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