PREVIEW / etf_daily / 2020-01-28

all etf daily files

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

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-28	SPY	ETF	325.06	327.85	323.6	326.89	63834000.0
2020-01-28	QQQ	ETF	219.6	221.96	219.06	221.45	26731876.0
2020-01-28	IWM	ETF	164.5	165.4	163.49	164.87	16690400.0
2020-01-28	DIA	ETF	286.22	288.19	285.75	287.29	2999200.0
2020-01-28	GLD	ETF	148.36	148.56	147.53	147.66	7543100.0
2020-01-28	TLT	ETF	143.93	144.09	142.82	143.16	10612900.0
2020-01-28	AAAU	ETF	15.72	15.73	15.65	15.65	37700.0
2020-01-28	AADR	ETF	54.37	54.62	54.22	54.62	6300.0
2020-01-28	AAXJ	ETF	70.84	71.31	70.53	71.1	1202700.0
2020-01-28	ABEQ	ETF	24.7	24.8	24.65	24.7	55500.0
2020-01-28	ACES	ETF	36.37	36.66	36.062	36.63	26300.0
2020-01-28	ACIO	ETF	25.37	25.47	25.37	25.45	38800.0
2020-01-28	ACSI	ETF	35.97	36.1655	35.97	36.1305	1215.0
2020-01-28	ACTX	ETF	11.0626	11.0626	10.6201	10.7823	362.0
2020-01-28	ACWF	ETF	31.03	31.27	31.03	31.25	6367.0
2020-01-28	ACWI	ETF	79.08	79.7	79.0	79.52	1828200.0
2020-01-28	ACWV	ETF	97.74	98.02	97.64	97.83	277100.0
2020-01-28	ACWX	ETF	48.19	48.43	48.065	48.39	2567969.0
2020-01-28	ADME	ETF	30.85	31.03	30.85	30.94	36500.0
2020-01-28	ADRE	ETF	42.76	43.2	42.605	43.1942	9061.0
2020-01-28	AESR	ETF	10.15	10.24	10.15	10.228	53200.0
2020-01-28	AFIF	ETF	9.7304	9.7304	9.71	9.72	12373.0
2020-01-28	AFK	ETF	19.53	19.69	19.53	19.59	13680.0
2020-01-28	AFLG	ETF	20.79	20.79	20.774	20.774	300.0
2020-01-28	AFTY	ETF	15.84	15.981	15.77	15.953	23000.0
2020-01-28	AGG	ETF	114.1	114.16	113.95	114.04	4463800.0
2020-01-28	AGGY	ETF	53.03	53.15	52.95	52.99	344500.0
2020-01-28	AGNG	ETF	23.65	23.82	23.633	23.82	6400.0
2020-01-28	AGQ	ETF	31.02	31.08	29.88	30.0	541500.0
2020-01-28	AGZ	ETF	117.07	117.07	116.85	116.9	32204.0
2020-01-28	AGZD	ETF	24.005	24.055	24.005	24.045	9200.0
2020-01-28	AIA	ETF	64.18	64.75	64.03	64.7018	116252.0
2020-01-28	AIEQ	ETF	28.93	29.185	28.899	29.12	10600.0
2020-01-28	AIQ	ETF	18.66	18.88	18.65	18.8524	43441.0
2020-01-28	AIRR	ETF	28.46	28.642	28.46	28.605	8300.0
2020-01-28	AIVI	ETF	41.68	41.97	41.68	41.96	6000.0
2020-01-28	ALTY	ETF	14.84	14.929	14.84	14.925	8500.0
2020-01-28	AMJ	ETF	21.09	21.22	20.99	21.12	3748573.0
2020-01-28	AMLP	ETF	41.15	41.35	40.85	41.05	5528380.0
2020-01-28	AMOM	ETF	26.792	26.792	26.792	26.792	100.0
2020-01-28	AMUB	ETF	13.2713	13.2849	13.2713	13.2849	685.0
2020-01-28	AMZA	ETF	41.3	41.75	41.1	41.3	54460.0
2020-01-28	ANGL	ETF	29.89	30.0	29.78	29.99	1351300.0
2020-01-28	AOA	ETF	57.88	58.22	57.83	58.11	55400.0
2020-01-28	AOK	ETF	36.57	36.66	36.53	36.61	200210.0
2020-01-28	AOM	ETF	40.33	40.49	40.33	40.4	109115.0
2020-01-28	AOR	ETF	47.86	48.13	47.83	48.04	93288.0
2020-01-28	ARCM	ETF	100.165	100.165	100.165	100.165	100.0
2020-01-28	ARGT	ETF	25.3	26.15	25.3	26.03	35300.0
2020-01-28	ARKF	ETF	25.18	25.51	25.095	25.494	31500.0

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

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