PREVIEW / etf_daily / 2021-06-03

all etf daily files

  file:    by_date/etf_daily/2021/2021-06-03.parquet
  size:    88 KB
  rows:    2,349

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-06-03	SPY	ETF	417.85	419.99	416.28	418.77	58138800.0
2021-06-03	QQQ	ETF	330.55	331.86	328.28	330.0	37057825.0
2021-06-03	IWM	ETF	226.82	227.62	224.04	226.42	24811500.0
2021-06-03	DIA	ETF	344.61	346.96	343.56	346.02	4436400.0
2021-06-03	GLD	ETF	175.83	175.83	174.66	175.27	10153900.0
2021-06-03	TLT	ETF	138.51	138.51	137.85	138.01	10994000.0
2021-06-03	AAA	ETF	25.01	25.01	24.995	24.995	159.0
2021-06-03	AAAU	ETF	18.69	18.69	18.56	18.63	252900.0
2021-06-03	AADR	ETF	67.75	67.75	66.8	66.8	2000.0
2021-06-03	AAXJ	ETF	94.88	95.09	94.57	94.75	694500.0
2021-06-03	ABEQ	ETF	28.23	28.242	28.19	28.242	400.0
2021-06-03	ACES	ETF	68.97	69.74	68.42	68.52	64300.0
2021-06-03	ACIO	ETF	29.56	29.72	29.56	29.681	11600.0
2021-06-03	ACSI	ETF	48.9457	48.9457	48.9457	48.9457	713.0
2021-06-03	ACTV	ETF	39.08	39.43	39.08	39.3555	3003.0
2021-06-03	ACVF	ETF	31.19	31.36	31.12	31.35	4800.0
2021-06-03	ACWF	ETF	38.29	38.4	38.16	38.35	12833.0
2021-06-03	ACWI	ETF	100.54	100.84	100.12	100.56	1478000.0
2021-06-03	ACWV	ETF	102.8	103.32	102.8	103.3	97700.0
2021-06-03	ACWX	ETF	58.68	58.74	58.47	58.6	884252.0
2021-06-03	ADFI	ETF	9.67	9.7	9.66	9.67	5300.0
2021-06-03	ADIV	ETF	18.91	18.91	18.91	18.91	100.0
2021-06-03	ADME	ETF	38.78	38.78	38.46	38.65	14100.0
2021-06-03	ADRE	ETF	57.37	57.37	57.0	57.1379	8894.0
2021-06-03	AESR	ETF	13.19	13.29	13.19	13.238	14600.0
2021-06-03	AFIF	ETF	9.73	9.73	9.71	9.72	6559.0
2021-06-03	AFK	ETF	23.0	23.0	22.53	22.62	57124.0
2021-06-03	AFLG	ETF	25.034	25.034	25.034	25.034	100.0
2021-06-03	AFTY	ETF	23.94	24.019	23.94	23.97	6800.0
2021-06-03	AGG	ETF	114.31	114.46	114.21	114.21	3464300.0
2021-06-03	AGGY	ETF	51.7	51.73	51.66	51.66	68900.0
2021-06-03	AGNG	ETF	28.8	28.99	28.8	28.963	1200.0
2021-06-03	AGOX	ETF	25.87	25.87	25.725	25.758	7300.0
2021-06-03	AGQ	ETF	51.24	51.43	49.65	51.31	1767700.0
2021-06-03	AGZ	ETF	118.2	118.2	118.1258	118.19	16418.0
2021-06-03	AGZD	ETF	23.505	23.505	23.48	23.5	35000.0
2021-06-03	AIA	ETF	92.26	92.26	91.72	91.93	67036.0
2021-06-03	AIEQ	ETF	38.13	38.26	37.63	37.872	10800.0
2021-06-03	AIQ	ETF	29.07	29.08	28.75	28.9	23815.0
2021-06-03	AIRR	ETF	41.63	41.87	41.14	41.8	63700.0
2021-06-03	AIVI	ETF	44.55	44.59	44.52	44.58	2900.0
2021-06-03	ALTL	ETF	41.19	41.48	41.13	41.38	15071.0
2021-06-03	ALTY	ETF	13.59	13.59	13.52	13.57	17500.0
2021-06-03	AMJ	ETF	19.26	19.63	19.21	19.53	391403.0
2021-06-03	AMLP	ETF	35.62	36.19	35.4	35.88	2146000.0
2021-06-03	AMNA	ETF	34.1125	34.1125	34.1125	34.1125	0.0
2021-06-03	AMND	ETF	36.0286	36.0286	36.0286	36.0286	22.0
2021-06-03	AMOM	ETF	34.78	34.93	34.5	34.78	22800.0
2021-06-03	AMPS	ETF	9.8167	9.86	9.81	9.81	1048.0
2021-06-03	AMTR	ETF	39.92	40.0	39.86	39.92	2501.0

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

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