maybeyonassol_total_sabel_lock
    Updated 2022-03-02
    with locks as (
    select
    block_timestamp,
    tx_id,
    inner_instruction:instructions[0]:parsed:info:authority::string as user,
    inner_instruction:instructions[0]:parsed:info:amount/pow(10,9) as amount
    from solana.events
    -- where tx_id = '5m3cXquqMncfCgEArC5AHnoZMYUckPzJcJ3FFDhiEuDjBNRB9odCmVDygBk22C7AivGMF4yM157NaPbpR3ekkebH'
    where instruction:programId::string = 'LocktDzaV1W2Bm9DeZeiyz4J9zs4fRqNiYqQyracRXw'
    and pretokenbalances[0]:mint::string = 'Saber2gLauYim4Mvftnrasomsv6NvAuncvMEZwcLpD1'
    and amount is not null
    )

    select
    'epoch 4' as epoch,
    sum(amount) as amount_locked
    from locks
    where block_timestamp < current_date - interval '9 days'
    group by 1

    union all

    select
    'epoch 5' as epoch,
    sum(amount) as amount_locked
    from locks
    -- where block_timestamp < current_date - interval '7 days'
    group by 1


    Run a query to Download Data