PREVIEW / etf_daily / 2021-09-03

all etf daily files

  file:    by_date/etf_daily/2021/2021-09-03.parquet
  size:    92 KB
  rows:    2,450

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-09-03	SPY	ETF	451.98	453.63	451.55	453.08	47170500.0
2021-09-03	QQQ	ETF	379.22	381.98	379.2003	381.57	24624937.0
2021-09-03	IWM	ETF	228.25	228.97	227.19	227.96	18213100.0
2021-09-03	DIA	ETF	353.68	354.65	353.09	354.14	2465400.0
2021-09-03	GLD	ETF	170.59	171.55	170.15	171.06	8353300.0
2021-09-03	TLT	ETF	148.27	148.51	147.94	148.18	12928000.0
2021-09-03	AAA	ETF	24.99	25.005	24.99	25.005	202.0
2021-09-03	AAAU	ETF	18.14	18.23	18.1	18.19	200600.0
2021-09-03	AADR	ETF	68.59	68.69	68.55	68.63	1500.0
2021-09-03	AAXJ	ETF	89.83	90.14	89.74	90.01	1011500.0
2021-09-03	ABEQ	ETF	27.93	27.96	27.921	27.921	400.0
2021-09-03	ACES	ETF	71.47	71.685	70.75	70.89	44500.0
2021-09-03	ACIO	ETF	31.17	31.225	31.135	31.2	102600.0
2021-09-03	ACSI	ETF	51.5347	51.5347	51.5347	51.5347	109.0
2021-09-03	ACTV	ETF	39.56	39.56	38.78	38.8623	15707.0
2021-09-03	ACTX	ETF	1.04	1.04	1.04	1.04	135.0
2021-09-03	ACVF	ETF	33.69	33.69	33.5	33.55	11100.0
2021-09-03	ACWF	ETF	39.335	39.45	39.335	39.387	6457.0
2021-09-03	ACWI	ETF	104.98	105.41	104.93	105.29	1299600.0
2021-09-03	ACWV	ETF	107.55	108.14	107.51	108.01	128400.0
2021-09-03	ACWX	ETF	58.21	58.415	58.105	58.36	470089.0
2021-09-03	ADFI	ETF	9.78	9.78	9.775	9.775	100.0
2021-09-03	ADIV	ETF	18.255	18.255	18.255	18.255	100.0
2021-09-03	ADME	ETF	41.49	41.61	41.49	41.516	49200.0
2021-09-03	ADRE	ETF	52.74	53.3711	52.74	53.1275	4447.0
2021-09-03	AESR	ETF	14.29	14.35	14.29	14.31	15800.0
2021-09-03	AFIF	ETF	9.7	9.72	9.69	9.705	36967.0
2021-09-03	AFK	ETF	22.03	22.03	21.87	21.91	7466.0
2021-09-03	AFLG	ETF	26.87	26.91	26.87	26.881	700.0
2021-09-03	AFMC	ETF	26.22	26.22	26.216	26.216	100.0
2021-09-03	AFSM	ETF	26.885	26.885	26.864	26.864	100.0
2021-09-03	AFTY	ETF	20.348	20.36	20.342	20.342	900.0
2021-09-03	AGG	ETF	115.84	115.89	115.77	115.85	5274300.0
2021-09-03	AGGY	ETF	52.62	52.63	52.56	52.6	73900.0
2021-09-03	AGNG	ETF	31.15	31.22	31.15	31.206	3000.0
2021-09-03	AGOX	ETF	27.06	27.06	26.68	26.87	52100.0
2021-09-03	AGQ	ETF	39.43	40.89	39.17	40.4	1190100.0
2021-09-03	AGZ	ETF	119.18	119.18	119.0907	119.18	17363.0
2021-09-03	AGZD	ETF	23.42	23.445	23.42	23.43	9800.0
2021-09-03	AIA	ETF	83.94	84.4399	83.92	84.31	32478.0
2021-09-03	AIEQ	ETF	43.53	43.666	43.36	43.612	11500.0
2021-09-03	AIQ	ETF	31.94	32.19	31.91	31.91	11086.0
2021-09-03	AIRR	ETF	42.97	43.032	42.43	42.637	10200.0
2021-09-03	AIVI	ETF	43.75	44.0	43.75	43.94	5200.0
2021-09-03	ALTL	ETF	44.53	44.53	43.59	43.73	29368.0
2021-09-03	ALTY	ETF	13.84	13.84	13.76	13.77	14600.0
2021-09-03	AMJ	ETF	18.25	18.36	18.115	18.12	311953.0
2021-09-03	AMLP	ETF	33.59	33.81	33.33	33.45	894300.0
2021-09-03	AMNA	ETF	32.4802	32.4802	32.4802	32.4802	0.0
2021-09-03	AMND	ETF	34.1342	34.1342	34.1342	34.1342	2.0

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

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