PREVIEW / etf_daily / 2022-10-24

all etf daily files

  file:    by_date/etf_daily/2022/2022-10-24.parquet
  size:    105 KB
  rows:    2,849

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
2022-10-24	SPY	ETF	375.89	380.06	373.11	378.87	85436900.0
2022-10-24	QQQ	ETF	275.69	279.4	271.97	278.45	63963569.0
2022-10-24	IWM	ETF	173.32	174.0	171.05	173.44	27284500.0
2022-10-24	DIA	ETF	312.53	316.0	311.6	315.05	4331700.0
2022-10-24	GLD	ETF	153.45	154.06	153.06	153.65	4673300.0
2022-10-24	TLT	ETF	92.82	93.55	91.85	92.4	31332600.0
2022-10-24	AAA	ETF	24.17	24.17	24.17	24.17	88.0
2022-10-24	AAAU	ETF	16.36	16.41	16.32	16.38	446300.0
2022-10-24	AADR	ETF	45.94	46.09	45.91	45.97	3100.0
2022-10-24	AAPB	ETF	19.98	20.4056	19.86	20.4056	7692.0
2022-10-24	AAPD	ETF	27.47	27.7	26.9435	27.05	76684.0
2022-10-24	AAPU	ETF	20.68	21.259	20.391	21.119	39746.0
2022-10-24	AAXJ	ETF	55.26	55.28	54.39	55.19	1055100.0
2022-10-24	ABEQ	ETF	26.35	26.38	26.18	26.365	8500.0
2022-10-24	ACES	ETF	49.98	49.98	48.43	49.82	46800.0
2022-10-24	ACIO	ETF	29.02	29.31	29.0	29.174	26500.0
2022-10-24	ACSI	ETF	42.6772	42.6772	42.6772	42.6772	13.0
2022-10-24	ACT	ETF	24.44	24.655	24.21	24.47	149578.0
2022-10-24	ACTV	ETF	27.7899	28.06	27.7899	27.92	6194.0
2022-10-24	ACTX	ETF	0.498	0.498	0.425	0.425	594.0
2022-10-24	ACVF	ETF	28.2	28.467	28.2	28.467	500.0
2022-10-24	ACWF	ETF	30.62	30.76	30.47	30.7242	4058.0
2022-10-24	ACWI	ETF	80.65	81.31	80.02	81.07	2362600.0
2022-10-24	ACWV	ETF	89.87	90.49	89.6	90.29	76300.0
2022-10-24	ACWX	ETF	40.59	40.76	40.27	40.61	4979315.0
2022-10-24	ADFI	ETF	8.12	8.15	8.12	8.135	11000.0
2022-10-24	ADIV	ETF	11.24	11.24	11.22	11.232	1200.0
2022-10-24	ADME	ETF	34.14	34.52	34.14	34.36	12000.0
2022-10-24	ADRE	ETF	32.0713	32.15	31.4696	32.15	9365.0
2022-10-24	AEMB	ETF	34.8	34.8	34.788	34.788	200.0
2022-10-24	AESR	ETF	11.19	11.3	11.15	11.28	46200.0
2022-10-24	AFIF	ETF	8.64	8.67	8.6315	8.645	179796.0
2022-10-24	AFK	ETF	15.34	15.45	14.97	15.01	24281.0
2022-10-24	AFLG	ETF	22.86	22.937	22.86	22.937	400.0
2022-10-24	AFSM	ETF	22.33	22.33	22.324	22.324	1500.0
2022-10-24	AFTY	ETF	14.02	14.02	13.85	13.921	4500.0
2022-10-24	AGG	ETF	93.77	94.03	93.45	93.64	6090400.0
2022-10-24	AGGY	ETF	41.04	41.135	40.91	41.0	214600.0
2022-10-24	AGNG	ETF	24.11	24.242	24.11	24.242	1100.0
2022-10-24	AGOV	ETF	77.2073	77.2073	77.2073	77.2073	1.0
2022-10-24	AGOX	ETF	19.77	20.09	19.77	20.025	15100.0
2022-10-24	AGQ	ETF	20.87	21.04	20.46	20.86	934300.0
2022-10-24	AGZ	ETF	105.0	105.3834	105.0	105.21	12556.0
2022-10-24	AGZD	ETF	22.715	22.775	22.67	22.675	165600.0
2022-10-24	AHHX	ETF	8.3155	8.32	8.26	8.3155	4051.0
2022-10-24	AHYB	ETF	42.17	42.27	42.17	42.27	400.0
2022-10-24	AIA	ETF	45.53	45.53	44.42	45.3	200554.0
2022-10-24	AIEQ	ETF	29.9	30.09	29.485	29.97	5200.0
2022-10-24	AIQ	ETF	19.42	19.432	19.0859	19.37	9525.0
2022-10-24	AIRR	ETF	41.76	42.42	41.662	42.22	19000.0

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

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