PREVIEW / etf_daily / 2021-09-29

all etf daily files

  file:    by_date/etf_daily/2021/2021-09-29.parquet
  size:    93 KB
  rows:    2,491

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-29	SPY	ETF	435.19	437.04	433.85	434.45	82329200.0
2021-09-29	QQQ	ETF	361.17	363.37	358.635	359.28	58076621.0
2021-09-29	IWM	ETF	222.27	222.66	220.17	220.82	23628900.0
2021-09-29	DIA	ETF	343.87	345.67	342.88	343.77	4116600.0
2021-09-29	GLD	ETF	162.35	162.74	160.97	161.32	8360700.0
2021-09-29	TLT	ETF	144.8	145.43	143.69	144.34	23569400.0
2021-09-29	AAA	ETF	25.025	25.025	25.025	25.025	100.0
2021-09-29	AAAU	ETF	17.27	17.3	17.13	17.17	280900.0
2021-09-29	AADR	ETF	63.72	63.72	63.28	63.47	5100.0
2021-09-29	AAXJ	ETF	84.96	85.2	84.36	84.38	1036900.0
2021-09-29	ABEQ	ETF	27.13	27.14	27.056	27.056	3000.0
2021-09-29	ACES	ETF	66.99	67.15	65.56	65.61	57800.0
2021-09-29	ACIO	ETF	30.17	30.31	30.17	30.18	32800.0
2021-09-29	ACSI	ETF	50.0001	50.0001	49.7852	49.7852	134.0
2021-09-29	ACT	ETF	21.86	22.06	21.6101	21.98	92763.0
2021-09-29	ACTV	ETF	38.27	38.345	38.11	38.2022	4711.0
2021-09-29	ACTX	ETF	1.05	1.1	1.0	1.09	5088.0
2021-09-29	ACVF	ETF	32.51	32.515	32.28	32.3	9300.0
2021-09-29	ACWF	ETF	37.4	37.44	37.1758	37.1758	5383.0
2021-09-29	ACWI	ETF	101.06	101.31	100.57	100.64	2917400.0
2021-09-29	ACWV	ETF	103.1	103.7	103.1	103.32	63900.0
2021-09-29	ACWX	ETF	55.73	55.81	55.385	55.43	1401135.0
2021-09-29	ADFI	ETF	9.685	9.7	9.67	9.67	5200.0
2021-09-29	ADIV	ETF	16.989	16.989	16.84	16.84	800.0
2021-09-29	ADME	ETF	39.906	40.05	39.82	39.82	31300.0
2021-09-29	ADRE	ETF	48.26	48.4562	47.949	48.1	5329.0
2021-09-29	AEMB	ETF	49.355	49.355	49.2	49.2	1700.0
2021-09-29	AESR	ETF	13.81	13.86	13.79	13.8	14500.0
2021-09-29	AFIF	ETF	9.71	9.71	9.62	9.635	22692.0
2021-09-29	AFK	ETF	20.59	20.64	20.38	20.41	14481.0
2021-09-29	AFLG	ETF	25.709	25.709	25.709	25.709	200.0
2021-09-29	AFTY	ETF	20.49	20.49	20.49	20.49	1500.0
2021-09-29	AGG	ETF	114.97	115.06	114.72	114.85	6161300.0
2021-09-29	AGGY	ETF	52.04	52.055	51.871	51.94	103600.0
2021-09-29	AGNG	ETF	29.366	29.471	29.24	29.24	3000.0
2021-09-29	AGOV	ETF	99.17	99.17	98.99	98.99	733.0
2021-09-29	AGOX	ETF	26.29	26.29	25.89	25.89	23500.0
2021-09-29	AGQ	ETF	30.9	31.13	29.92	30.21	2576500.0
2021-09-29	AGZ	ETF	118.31	118.41	118.25	118.31	26101.0
2021-09-29	AGZD	ETF	23.5	23.5	23.425	23.465	14400.0
2021-09-29	AIA	ETF	78.51	78.67	77.655	77.66	33783.0
2021-09-29	AIEQ	ETF	41.55	41.72	41.12	41.12	46100.0
2021-09-29	AIQ	ETF	30.43	30.47	30.05	30.06	10461.0
2021-09-29	AIRR	ETF	41.57	41.766	41.298	41.67	18400.0
2021-09-29	AIVI	ETF	41.17	41.17	40.98	40.98	6400.0
2021-09-29	ALTL	ETF	41.47	41.91	41.44	41.7567	29380.0
2021-09-29	ALTY	ETF	13.44	13.44	13.34	13.42	3800.0
2021-09-29	AMJ	ETF	18.18	18.37	18.07	18.37	283902.0
2021-09-29	AMLP	ETF	33.49	33.69	33.12	33.6	1334400.0
2021-09-29	AMNA	ETF	33.2406	33.2406	33.2406	33.2406	1.0

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

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