PREVIEW / etf_daily / 2021-09-21

all etf daily files

  file:    by_date/etf_daily/2021/2021-09-21.parquet
  size:    94 KB
  rows:    2,492

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-21	SPY	ETF	436.53	437.91	433.07	433.63	92526100.0
2021-09-21	QQQ	ETF	367.58	368.81	364.99	366.15	41927483.0
2021-09-21	IWM	ETF	218.77	219.29	215.82	217.52	26711200.0
2021-09-21	DIA	ETF	341.41	343.07	339.01	339.11	6071100.0
2021-09-21	GLD	ETF	165.81	166.63	165.49	166.04	7181500.0
2021-09-21	TLT	ETF	150.71	150.96	150.2	150.89	10035800.0
2021-09-21	AAA	ETF	25.01	25.01	25.005	25.005	105.0
2021-09-21	AAAU	ETF	17.62	17.72	17.61	17.66	112400.0
2021-09-21	AADR	ETF	63.83	63.83	63.83	63.83	400.0
2021-09-21	AAXJ	ETF	85.19	85.28	84.77	85.0	1279300.0
2021-09-21	ABEQ	ETF	26.826	26.826	26.826	26.826	200.0
2021-09-21	ACES	ETF	67.36	67.84	66.52	67.5	27600.0
2021-09-21	ACIO	ETF	30.34	30.42	30.18	30.18	41900.0
2021-09-21	ACSI	ETF	49.6587	49.6587	49.6587	49.6587	78.0
2021-09-21	ACT	ETF	20.24	20.7343	19.935	20.01	261108.0
2021-09-21	ACTV	ETF	37.0011	37.0228	36.735	36.9296	6169.0
2021-09-21	ACTX	ETF	0.97	1.0	0.89	1.0	2675.0
2021-09-21	ACVF	ETF	32.43	32.6	32.329	32.35	12700.0
2021-09-21	ACWF	ETF	37.86	37.88	37.634	37.6596	5379.0
2021-09-21	ACWI	ETF	101.73	101.97	101.05	101.19	2911300.0
2021-09-21	ACWV	ETF	105.05	105.52	104.79	104.86	267800.0
2021-09-21	ACWX	ETF	56.29	56.405	56.0346	56.14	2559499.0
2021-09-21	ADFI	ETF	9.78	9.78	9.765	9.765	3600.0
2021-09-21	ADIV	ETF	17.16	17.21	17.16	17.21	1300.0
2021-09-21	ADME	ETF	40.23	40.35	39.96	39.96	39500.0
2021-09-21	ADRE	ETF	48.91	48.91	48.5816	48.65	3780.0
2021-09-21	AESR	ETF	13.89	13.89	13.74	13.74	13000.0
2021-09-21	AFIF	ETF	9.68	9.69	9.67	9.68	10509.0
2021-09-21	AFK	ETF	20.45	20.728	20.35	20.43	20061.0
2021-09-21	AFLG	ETF	25.79	25.82	25.707	25.707	7800.0
2021-09-21	AFMC	ETF	25.014	25.014	25.014	25.014	1800.0
2021-09-21	AFSM	ETF	25.78	25.82	25.692	25.692	2200.0
2021-09-21	AFTY	ETF	19.67	19.67	19.64	19.64	700.0
2021-09-21	AGG	ETF	116.13	116.17	116.05	116.14	5225200.0
2021-09-21	AGGY	ETF	52.78	52.8	52.69	52.718	144400.0
2021-09-21	AGNG	ETF	30.3	30.3	30.12	30.194	1700.0
2021-09-21	AGOV	ETF	100.295	100.3	100.155	100.155	230.0
2021-09-21	AGOX	ETF	27.052	27.052	25.655	25.78	34300.0
2021-09-21	AGQ	ETF	33.23	33.78	32.78	33.17	920500.0
2021-09-21	AGZ	ETF	119.03	119.13	118.99	119.08	27083.0
2021-09-21	AGZD	ETF	23.42	23.435	23.41	23.42	10000.0
2021-09-21	AIA	ETF	78.08	78.405	77.89	78.17	65968.0
2021-09-21	AIEQ	ETF	42.0	42.299	41.883	42.16	43000.0
2021-09-21	AIQ	ETF	30.79	30.89	30.671	30.76	8335.0
2021-09-21	AIRR	ETF	40.46	40.46	39.73	39.9	13000.0
2021-09-21	AIVI	ETF	42.25	42.33	42.21	42.23	5000.0
2021-09-21	ALTL	ETF	42.22	42.33	42.0095	42.06	24935.0
2021-09-21	ALTY	ETF	13.37	13.49	13.37	13.409	6400.0
2021-09-21	AMJ	ETF	17.36	17.36	16.9701	17.23	627581.0
2021-09-21	AMLP	ETF	31.72	31.82	31.11	31.46	1786300.0

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

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