maybeyonasmsol_march_2_sus
    Updated 2022-03-08
    with
    stakes as (
    select
    block_timestamp,
    tx_id,
    value:parsed:info:source::string as user,
    value:parsed:info:lamports/pow(10,9) as sol_staked,
    value:parsed:info:destination::string as destination
    -- value
    from solana.events e,
    lateral flatten(input => e.inner_instruction:instructions)
    where value:parsed:info:destination::string in (
    'UefNb6z6yvArqe4cJHTXCqStRsKmWhGxnZzuHbikP5Q',
    'Du3Ysj1wKbxPKkuPPnvzQLQh8oMSVifs3jGZjJWXFmHN'
    )
    and instruction:programId = 'MarBmsSgKXdrN1egZf5sqe1TMai9K1rChYNDJgjq7aD'
    and sol_staked is not null
    and succeeded = 'TRUE'
    )


    select * from stakes
    order by sol_staked desc
    limit 100
    Run a query to Download Data