with
sbr_exits as (
select
date(block_timestamp) as date,
count(distinct signer) as txs
from solana.fact_gov_actions
where action = 'EXIT'
group by 1
)
select
mod(datediff(days, '2022-01-01', date),7) as weekday,
sum(txs) as txs
from sbr_exits
group by 1
-- limit 10