with tx as (select
date_trunc('day', block_timestamp) as date,
tx_status,
count(distinct(tx_hash)) as n_tx
from near.core.fact_transactions
group by date, tx_status),
ratios as (select *,
sum(n_tx) over (partition by date) as total_tx,
n_tx/total_tx as ratio
from tx )
select
date(date) as date,
ratio
from ratios
where tx_status = 'Success'