maybeyonassbr_lock_week_dist
    Updated 2022-03-26
    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

    Run a query to Download Data