PREVIEW / etf_daily / 2020-01-06

all etf daily files

  file:    by_date/etf_daily/2020/2020-01-06.parquet
  size:    74 KB
  rows:    1,949

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
2020-01-06	SPY	ETF	320.49	323.73	320.36	323.64	55653900.0
2020-01-06	QQQ	ETF	212.49	215.59	212.24	215.56	21726989.0
2020-01-06	IWM	ETF	163.85	165.54	163.54	165.35	17150900.0
2020-01-06	DIA	ETF	284.29	287.03	284.16	286.98	1645100.0
2020-01-06	GLD	ETF	148.44	148.48	146.95	147.39	14403300.0
2020-01-06	TLT	ETF	139.69	139.71	138.15	138.33	11369800.0
2020-01-06	AAAU	ETF	15.76	15.77	15.59	15.62	84100.0
2020-01-06	AADR	ETF	54.11	54.43	53.75	54.35	74100.0
2020-01-06	AAXJ	ETF	73.14	73.48	73.06	73.42	413700.0
2020-01-06	ACES	ETF	34.39	34.567	34.15	34.565	15600.0
2020-01-06	ACIO	ETF	25.31	25.586	25.31	25.586	9400.0
2020-01-06	ACSI	ETF	35.29	35.4887	35.24	35.4887	3642.0
2020-01-06	ACTX	ETF	11.2101	13.5701	11.2101	12.3901	426.0
2020-01-06	ACWF	ETF	31.06	31.2	31.0481	31.1553	6616.0
2020-01-06	ACWI	ETF	78.93	79.58	78.91	79.56	2298000.0
2020-01-06	ACWV	ETF	95.41	95.94	95.41	95.93	369800.0
2020-01-06	ACWX	ETF	48.88	49.2	48.88	49.2	1947924.0
2020-01-06	ADME	ETF	30.31	30.47	30.31	30.47	14900.0
2020-01-06	ADRE	ETF	44.74	44.7644	44.5	44.7644	8665.0
2020-01-06	AFIF	ETF	9.7355	9.7355	9.7342	9.735	380.0
2020-01-06	AFK	ETF	20.18	20.27	20.11	20.2	15904.0
2020-01-06	AFLG	ETF	20.448	20.45	20.448	20.45	200.0
2020-01-06	AFMC	ETF	20.337	20.337	20.312	20.312	200.0
2020-01-06	AFSM	ETF	20.409	20.409	20.384	20.384	200.0
2020-01-06	AFTY	ETF	17.44	17.445	17.39	17.445	8100.0
2020-01-06	AGG	ETF	113.13	113.13	112.84	112.92	8131600.0
2020-01-06	AGGY	ETF	52.56	52.581	52.451	52.46	338100.0
2020-01-06	AGNG	ETF	23.242	23.61	23.242	23.565	1800.0
2020-01-06	AGQ	ETF	33.48	33.53	32.16	32.61	568200.0
2020-01-06	AGZ	ETF	116.2	116.2	116.005	116.02	32995.0
2020-01-06	AGZD	ETF	24.035	24.09	24.03	24.06	14600.0
2020-01-06	AIA	ETF	65.93	66.28	65.79	66.23	23800.0
2020-01-06	AIEQ	ETF	28.39	28.75	28.39	28.75	34300.0
2020-01-06	AIQ	ETF	18.0	18.2486	17.97	18.2297	20495.0
2020-01-06	AIRR	ETF	28.77	29.015	28.76	29.013	16600.0
2020-01-06	AIVI	ETF	42.54	42.8	42.54	42.8	5100.0
2020-01-06	ALTY	ETF	14.84	14.89	14.8	14.87	29200.0
2020-01-06	AMJ	ETF	22.56	22.63	22.25	22.57	4692668.0
2020-01-06	AMLP	ETF	43.75	44.2	43.65	44.1	5114060.0
2020-01-06	AMOM	ETF	26.015	26.015	26.015	26.015	100.0
2020-01-06	AMUB	ETF	14.26	14.26	14.2074	14.2074	500.0
2020-01-06	AMZA	ETF	46.3	47.0	46.2	46.8	72060.0
2020-01-06	ANGL	ETF	29.92	29.97	29.85	29.89	440600.0
2020-01-06	AOA	ETF	57.86	58.21	57.83	58.21	67000.0
2020-01-06	AOK	ETF	36.33	36.39	36.282	36.3799	70145.0
2020-01-06	AOM	ETF	40.2	40.26	40.16	40.25	159908.0
2020-01-06	AOR	ETF	47.8	48.0	47.7512	48.0	257720.0
2020-01-06	ARCM	ETF	100.015	100.015	100.015	100.015	100.0
2020-01-06	ARGT	ETF	26.1	26.46	26.04	26.34	53400.0
2020-01-06	ARKF	ETF	24.21	24.46	24.21	24.46	16900.0

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

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