anomoneWhat other activities are these top 20 wallets doing in the month of February
    Updated 2022-03-13
    WITH top20 as (
    SELECT
    INNER_INSTRUCTION:instructions[0]:parsed:info:authority as Wallet,
    sum((INNER_INSTRUCTION:instructions[0]:parsed:info:amount )/1e6) as Locked_Amount FROM solana.events
    WHERE ---TX_ID = '5m3cXquqMncfCgEArC5AHnoZMYUckPzJcJ3FFDhiEuDjBNRB9odCmVDygBk22C7AivGMF4yM157NaPbpR3ekkebH'
    PRETOKENBALANCES[0]:mint = 'Saber2gLauYim4Mvftnrasomsv6NvAuncvMEZwcLpD1'
    AND Instruction:programId = 'LocktDzaV1W2Bm9DeZeiyz4J9zs4fRqNiYqQyracRXw'
    AND INNER_INSTRUCTION:instructions[0]:programId = 'TokenkegQfeZyiNwAJbNbGKPFXCWuBvf9Ss623VQ5DA'
    AND SUCCEEDED = 'True'
    AND date_trunc('month', BLOCK_TIMESTAMP) like '2022-02-01 %' --Filtering for the month of Feb
    GROUP BY Wallet
    ORDER BY Locked_Amount DESC
    LIMIT 20)

    Select
    Instruction:programId as program,
    sum((INNER_INSTRUCTION:instructions[0]:parsed:info:amount )/1e6) as Amount FROM solana.events
    WHERE date_trunc('month', BLOCK_TIMESTAMP) like '2022-02-01 %'
    AND SUCCEEDED = 'True'
    AND INNER_INSTRUCTION is not null
    GROUP BY program
    ORDER BY Amount desc

    Run a query to Download Data