PREVIEW / etf_daily / 2021-04-23

all etf daily files

  file:    by_date/etf_daily/2021/2021-04-23.parquet
  size:    88 KB
  rows:    2,323

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
2021-04-23	SPY	ETF	412.87	418.25	412.79	416.74	73209200.0
2021-04-23	QQQ	ETF	335.85	340.767	335.85	339.42	36414916.0
2021-04-23	IWM	ETF	222.82	226.65	222.02	225.76	27999500.0
2021-04-23	DIA	ETF	337.75	341.59	337.13	340.43	3613900.0
2021-04-23	GLD	ETF	167.37	167.53	165.78	166.4	7106400.0
2021-04-23	TLT	ETF	140.38	140.47	139.49	140.06	12302200.0
2021-04-23	AAA	ETF	25.05	25.05	25.0427	25.045	242.0
2021-04-23	AAAU	ETF	17.79	17.8	17.62	17.68	301100.0
2021-04-23	AADR	ETF	65.6	65.79	65.6	65.79	900.0
2021-04-23	AAXJ	ETF	94.22	94.73	94.21	94.66	1032800.0
2021-04-23	ABEQ	ETF	27.37	27.4	27.37	27.37	4100.0
2021-04-23	ACES	ETF	74.49	76.18	74.49	76.06	78900.0
2021-04-23	ACIO	ETF	29.6	29.75	29.505	29.7	19100.0
2021-04-23	ACSI	ETF	48.5916	48.5916	48.5916	48.5916	432.0
2021-04-23	ACTV	ETF	36.725	36.98	36.725	36.9284	1161.0
2021-04-23	ACVF	ETF	30.926	31.15	30.926	31.066	9700.0
2021-04-23	ACWF	ETF	38.08	38.086	38.045	38.05	1960.0
2021-04-23	ACWI	ETF	98.74	99.85	98.74	99.55	1241100.0
2021-04-23	ACWV	ETF	101.85	102.35	101.74	102.11	101400.0
2021-04-23	ACWX	ETF	56.82	57.25	56.81	57.16	815957.0
2021-04-23	ADFI	ETF	9.72	9.72	9.695	9.695	800.0
2021-04-23	ADIV	ETF	19.09	19.17	19.09	19.119	800.0
2021-04-23	ADME	ETF	38.52	38.76	38.475	38.66	4500.0
2021-04-23	ADRE	ETF	56.86	57.2399	56.86	57.2399	28853.0
2021-04-23	AESR	ETF	13.23	13.26	13.22	13.23	2700.0
2021-04-23	AFIF	ETF	9.7029	9.7199	9.7029	9.71	6683.0
2021-04-23	AFK	ETF	21.8	21.9	21.74	21.79	8711.0
2021-04-23	AFLG	ETF	24.85	25.018	24.85	25.018	300.0
2021-04-23	AFMC	ETF	25.32	25.41	25.32	25.41	700.0
2021-04-23	AFTY	ETF	22.965	23.04	22.965	23.038	2000.0
2021-04-23	AGG	ETF	114.81	115.09	114.64	114.75	3620700.0
2021-04-23	AGGY	ETF	51.96	51.96	51.861	51.92	161700.0
2021-04-23	AGNG	ETF	29.5	29.51	29.22	29.449	4600.0
2021-04-23	AGQ	ETF	47.21	47.41	45.86	46.42	968000.0
2021-04-23	AGZ	ETF	118.39	118.39	118.2	118.24	33497.0
2021-04-23	AGZD	ETF	23.57	23.58	23.52	23.555	37400.0
2021-04-23	AIA	ETF	93.5	94.25	93.5	94.1	71450.0
2021-04-23	AIEQ	ETF	39.0	39.709	39.0	39.577	22600.0
2021-04-23	AIQ	ETF	29.42	29.7899	29.42	29.705	39240.0
2021-04-23	AIRR	ETF	40.98	41.91	40.824	41.77	50000.0
2021-04-23	AIVI	ETF	43.5	43.66	43.5	43.66	3500.0
2021-04-23	ALTL	ETF	39.42	39.9799	39.4199	39.8156	11071.0
2021-04-23	ALTY	ETF	13.15	13.21	13.13	13.176	13900.0
2021-04-23	AMJ	ETF	17.08	17.43	17.04	17.43	734546.0
2021-04-23	AMLP	ETF	31.62	32.19	31.53	32.19	2231100.0
2021-04-23	AMNA	ETF	30.1986	30.1986	30.1986	30.1986	0.0
2021-04-23	AMND	ETF	32.1931	32.1931	32.1931	32.1931	0.0
2021-04-23	AMOM	ETF	35.31	35.71	35.21	35.591	20400.0
2021-04-23	AMPS	ETF	9.99	10.0	9.9	9.95	521615.0
2021-04-23	AMTR	ETF	35.3115	35.3115	35.3115	35.3115	0.0

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

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