KaskoazulSBR locked wallets Top 20 wallets by tx number
    Updated 2022-03-09
    WITH LOCKER_TX AS (
    SELECT
    block_timestamp::date as fecha,
    tx_id
    FROM
    solana.events
    WHERE
    instruction:programId ='LocktDzaV1W2Bm9DeZeiyz4J9zs4fRqNiYqQyracRXw'
    AND fecha >= '2022-02-01'
    AND succeeded = 'TRUE'
    ),

    SBR_LOCKER as (
    SELECT
    tx_id,
    tx_from_address,
    pre_mint,
    post_mint
    FROM solana.transactions
    WHERE tx_id in (SELECT tx_id FROM LOCKER_TX)
    AND pre_mint = 'Saber2gLauYim4Mvftnrasomsv6NvAuncvMEZwcLpD1'
    )

    SELECT
    tx_from_address, count(tx_id)
    FROM SBR_LOCKER
    GROUP BY 1
    ORDER BY 2 desc, 1
    LIMIT 20

    Run a query to Download Data