PREVIEW / etf_daily / 2019-11-01

all etf daily files

  file:    by_date/etf_daily/2019/2019-11-01.parquet
  size:    71 KB
  rows:    1,856

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
2019-11-01	SPY	ETF	304.92	306.19	304.74	306.14	71141500.0
2019-11-01	QQQ	ETF	197.93	198.88	197.63	198.87	22131875.0
2019-11-01	IWM	ETF	156.4	158.19	156.05	158.1	18421600.0
2019-11-01	DIA	ETF	271.86	273.34	271.69	273.34	2989400.0
2019-11-01	GLD	ETF	142.21	142.9	142.01	142.56	8090000.0
2019-11-01	TLT	ETF	140.73	141.27	139.79	140.56	11425500.0
2019-11-01	AAAU	ETF	15.07	15.13	15.05	15.09	38300.0
2019-11-01	AADR	ETF	50.78	50.98	50.51	50.61	28800.0
2019-11-01	AAXJ	ETF	70.03	70.38	70.03	70.27	479700.0
2019-11-01	ACES	ETF	31.43	31.43	31.219	31.302	4800.0
2019-11-01	ACIO	ETF	25.039	25.064	25.039	25.064	500.0
2019-11-01	ACSI	ETF	34.6192	34.72	34.6	34.6966	2604.0
2019-11-01	ACTX	ETF	11.2101	11.2101	9.9711	9.9711	230.0
2019-11-01	ACWF	ETF	29.89	30.07	29.89	30.07	14915.0
2019-11-01	ACWI	ETF	76.21	76.54	76.19	76.54	1985900.0
2019-11-01	ACWV	ETF	96.14	96.18	95.7	95.82	137100.0
2019-11-01	ACWX	ETF	47.86	47.99	47.84	47.99	2224743.0
2019-11-01	ADRE	ETF	40.85	41.11	40.7833	40.7833	126666.0
2019-11-01	AFIF	ETF	9.68	9.7046	9.68	9.7028	553.0
2019-11-01	AFK	ETF	20.32	20.53	20.32	20.53	2498.0
2019-11-01	AFTY	ETF	17.66	17.76	17.66	17.743	9100.0
2019-11-01	AGG	ETF	112.98	113.11	112.81	112.93	3988300.0
2019-11-01	AGGY	ETF	52.37	52.393	52.26	52.36	48400.0
2019-11-01	AGNG	ETF	22.874	23.0	22.874	23.0	1200.0
2019-11-01	AGQ	ETF	32.85	33.1	32.69	33.06	151700.0
2019-11-01	AGZ	ETF	116.23	116.2675	116.1031	116.13	14006.0
2019-11-01	AGZD	ETF	23.92	24.01	23.88	23.88	9400.0
2019-11-01	AIA	ETF	61.98	62.29	61.98	62.29	23909.0
2019-11-01	AIEQ	ETF	26.73	26.85	26.73	26.82	17100.0
2019-11-01	AIQ	ETF	16.46	16.5031	16.43	16.5	1680.0
2019-11-01	AIRR	ETF	28.03	28.484	28.03	28.484	3800.0
2019-11-01	AIVI	ETF	41.98	42.05	41.98	42.02	8400.0
2019-11-01	ALTY	ETF	14.86	14.96	14.86	14.92	17600.0
2019-11-01	AMJ	ETF	21.8	22.025	21.8	21.99	1735941.0
2019-11-01	AMLP	ETF	42.95	43.15	42.75	43.15	2738680.0
2019-11-01	AMUB	ETF	13.8614	13.8614	13.8614	13.8614	0.0
2019-11-01	AMZA	ETF	44.8	45.5	44.8	45.4	58380.0
2019-11-01	ANGL	ETF	29.27	29.3	28.96	29.14	1726900.0
2019-11-01	AOA	ETF	56.14	56.37	56.14	56.29	63400.0
2019-11-01	AOK	ETF	35.86	36.0	35.86	35.99	43077.0
2019-11-01	AOM	ETF	39.56	39.67	39.5579	39.67	195730.0
2019-11-01	AOR	ETF	46.71	46.87	46.6692	46.86	80791.0
2019-11-01	ARGT	ETF	22.1	22.1	21.76	21.91	359100.0
2019-11-01	ARKF	ETF	22.39	22.494	22.38	22.48	11000.0
2019-11-01	ARKG	ETF	30.24	30.74	30.08	30.7	110800.0
2019-11-01	ARKK	ETF	44.6	45.242	44.404	45.23	354000.0
2019-11-01	ARKQ	ETF	33.69	34.04	33.605	34.02	6600.0
2019-11-01	ARKW	ETF	51.6	51.94	51.47	51.92	1935300.0
2019-11-01	ASEA	ETF	15.99	15.99	15.91	15.97	500.0
2019-11-01	ASHR	ETF	28.48	28.56	28.41	28.55	4721900.0

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

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