PREVIEW / etf_daily / 2020-06-24

all etf daily files

  file:    by_date/etf_daily/2020/2020-06-24.parquet
  size:    76 KB
  rows:    2,038

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-06-24	SPY	ETF	309.84	310.51	302.1	304.09	132813500.0
2020-06-24	QQQ	ETF	247.99	249.325	242.16	243.71	46032376.0
2020-06-24	IWM	ETF	141.1	141.6	136.31	138.36	42998700.0
2020-06-24	DIA	ETF	259.22	259.52	252.94	254.63	5903500.0
2020-06-24	GLD	ETF	166.01	166.99	165.45	165.9	10901400.0
2020-06-24	TLT	ETF	161.53	163.09	161.52	163.03	11436500.0
2020-06-24	AAAU	ETF	17.61	17.71	17.56	17.61	329200.0
2020-06-24	AADR	ETF	53.18	53.18	52.15	52.28	6300.0
2020-06-24	AAXJ	ETF	70.08	70.33	69.17	69.62	953300.0
2020-06-24	ABEQ	ETF	22.19	22.19	22.01	22.088	2100.0
2020-06-24	ACES	ETF	38.31	38.31	37.275	37.62	26800.0
2020-06-24	ACIO	ETF	25.065	25.065	24.9	24.98	12300.0
2020-06-24	ACSI	ETF	33.29	33.29	32.8638	32.8638	612.0
2020-06-24	ACTX	ETF	2.9559	3.481	2.9559	3.481	526.0
2020-06-24	ACWF	ETF	27.6999	27.6999	27.23	27.386	37642.0
2020-06-24	ACWI	ETF	74.24	74.39	72.64	73.06	2167300.0
2020-06-24	ACWV	ETF	87.51	87.85	86.37	86.83	214100.0
2020-06-24	ACWX	ETF	43.61	43.73	42.91	43.12	1775967.0
2020-06-24	ADME	ETF	31.97	31.97	31.672	31.734	11700.0
2020-06-24	ADRE	ETF	40.23	40.385	39.63	39.8528	3515.0
2020-06-24	AESR	ETF	9.895	9.9	9.75	9.794	2300.0
2020-06-24	AFIF	ETF	9.78	9.82	9.78	9.805	9427.0
2020-06-24	AFK	ETF	16.49	16.49	16.0	16.002	10550.0
2020-06-24	AFLG	ETF	18.517	18.541	18.517	18.541	1100.0
2020-06-24	AFMC	ETF	16.68	16.68	16.542	16.542	100.0
2020-06-24	AFSM	ETF	16.44	16.44	16.317	16.317	100.0
2020-06-24	AFTY	ETF	16.71	16.71	16.62	16.626	1400.0
2020-06-24	AGG	ETF	117.7	117.84	117.61	117.73	5040100.0
2020-06-24	AGGY	ETF	53.58	53.64	53.54	53.64	173900.0
2020-06-24	AGNG	ETF	24.695	24.695	24.048	24.048	3000.0
2020-06-24	AGQ	ETF	27.05	27.86	26.62	26.7	1033400.0
2020-06-24	AGZ	ETF	120.97	121.09	120.8	121.06	42180.0
2020-06-24	AGZD	ETF	23.445	23.555	23.435	23.49	13400.0
2020-06-24	AIA	ETF	65.53	65.59	64.63	64.92	25401.0
2020-06-24	AIEQ	ETF	28.01	28.096	27.5	27.62	12600.0
2020-06-24	AIQ	ETF	20.9	20.9	20.32	20.5151	23968.0
2020-06-24	AIRR	ETF	23.04	23.04	22.845	22.845	6800.0
2020-06-24	AIVI	ETF	35.92	35.92	35.34	35.37	3900.0
2020-06-24	ALTY	ETF	11.0	11.0	10.577	10.77	24300.0
2020-06-24	AMJ	ETF	14.29	14.29	13.45	13.7	1360849.0
2020-06-24	AMLP	ETF	26.75	26.75	25.0	25.46	3828200.0
2020-06-24	AMNA	ETF	23.8454	23.8454	23.8454	23.8454	0.0
2020-06-24	AMOM	ETF	29.65	29.65	29.051	29.051	200.0
2020-06-24	AMUB	ETF	8.77	8.77	8.4805	8.6354	36410.0
2020-06-24	AMZA	ETF	19.55	19.55	17.94	18.51	230400.0
2020-06-24	ANGL	ETF	29.12	29.15	28.64	28.78	1030200.0
2020-06-24	AOA	ETF	55.02	55.14	54.1	54.37	62300.0
2020-06-24	AOK	ETF	36.39	36.41	36.04	36.21	201096.0
2020-06-24	AOM	ETF	39.97	40.01	39.45	39.61	169136.0
2020-06-24	AOR	ETF	46.5	46.5467	45.801	46.05	313394.0

> showing 50 of 2,038 rows — these rows as CSV

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