PREVIEW / etf_daily / 2021-05-25

all etf daily files

  file:    by_date/etf_daily/2021/2021-05-25.parquet
  size:    88 KB
  rows:    2,342

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-05-25	SPY	ETF	420.33	420.71	417.62	418.24	57451400.0
2021-05-25	QQQ	ETF	334.07	334.81	331.755	332.97	31280314.0
2021-05-25	IWM	ETF	222.23	223.71	219.19	219.26	20514900.0
2021-05-25	DIA	ETF	344.68	345.0	342.66	343.18	2623200.0
2021-05-25	GLD	ETF	176.15	177.95	176.04	177.95	8986900.0
2021-05-25	TLT	ETF	138.63	139.5	138.62	139.46	12346900.0
2021-05-25	AAA	ETF	25.001	25.02	25.0	25.02	9286.0
2021-05-25	AAAU	ETF	18.73	18.91	18.71	18.91	505700.0
2021-05-25	AADR	ETF	65.29	65.29	64.41	64.42	1500.0
2021-05-25	AAXJ	ETF	93.49	93.49	92.98	93.3	1101300.0
2021-05-25	ABEQ	ETF	28.31	28.35	28.21	28.21	8000.0
2021-05-25	ACES	ETF	67.87	68.0	66.79	67.06	73800.0
2021-05-25	ACIO	ETF	29.8	29.88	29.76	29.76	23300.0
2021-05-25	ACSI	ETF	48.9839	48.9839	48.9839	48.9839	199.0
2021-05-25	ACTV	ETF	38.43	38.45	37.9955	37.9955	20309.0
2021-05-25	ACTX	ETF	3.37	3.38	3.35	3.38	840.0
2021-05-25	ACVF	ETF	31.51	31.51	31.18	31.183	3200.0
2021-05-25	ACWF	ETF	38.17	38.17	38.0	38.0012	5694.0
2021-05-25	ACWI	ETF	100.51	100.52	99.89	100.0	2236800.0
2021-05-25	ACWV	ETF	103.26	103.27	102.9	103.14	507400.0
2021-05-25	ACWX	ETF	58.07	58.16	57.85	57.95	734392.0
2021-05-25	ADFI	ETF	9.69	9.73	9.68	9.703	7800.0
2021-05-25	ADIV	ETF	18.69	18.74	18.65	18.74	7800.0
2021-05-25	ADME	ETF	38.73	38.96	38.72	38.736	14300.0
2021-05-25	ADRE	ETF	55.98	55.98	55.2001	55.35	7869.0
2021-05-25	AESR	ETF	13.3	13.3	13.23	13.231	23800.0
2021-05-25	AFIF	ETF	9.74	9.74	9.71	9.732	23701.0
2021-05-25	AFK	ETF	22.35	22.35	22.011	22.13	12746.0
2021-05-25	AFLG	ETF	25.01	25.01	24.95	24.953	900.0
2021-05-25	AFMC	ETF	25.007	25.007	25.007	25.007	300.0
2021-05-25	AFSM	ETF	25.73	25.73	25.467	25.467	100.0
2021-05-25	AFTY	ETF	24.53	24.53	24.4	24.464	22200.0
2021-05-25	AGG	ETF	114.58	114.75	114.03	114.73	6351700.0
2021-05-25	AGGY	ETF	51.71	51.84	51.68	51.76	196700.0
2021-05-25	AGNG	ETF	29.221	29.29	29.19	29.2	3000.0
2021-05-25	AGOX	ETF	25.62	25.63	25.39	25.406	21500.0
2021-05-25	AGQ	ETF	51.67	53.7	51.65	53.56	689700.0
2021-05-25	AGZ	ETF	118.21	118.35	118.21	118.335	53704.0
2021-05-25	AGZD	ETF	23.48	23.49	23.465	23.49	26200.0
2021-05-25	AIA	ETF	90.73	90.7957	90.38	90.42	52911.0
2021-05-25	AIEQ	ETF	37.33	37.48	37.13	37.13	39800.0
2021-05-25	AIQ	ETF	28.83	28.83	28.63	28.7	6202.0
2021-05-25	AIRR	ETF	41.3	41.5	40.515	40.535	89900.0
2021-05-25	AIVI	ETF	44.22	44.23	44.09	44.09	7900.0
2021-05-25	ALTL	ETF	41.65	41.65	41.29	41.3683	16296.0
2021-05-25	ALTY	ETF	13.62	13.62	13.41	13.41	30000.0
2021-05-25	AMJ	ETF	19.19	19.3611	18.96	18.96	261065.0
2021-05-25	AMLP	ETF	35.05	35.05	34.35	34.39	1257300.0
2021-05-25	AMNA	ETF	32.8966	32.8966	32.8966	32.8966	0.0
2021-05-25	AMND	ETF	34.9525	34.9525	34.9525	34.9525	5.0

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

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