freemartianBolide BLID Stake & Unstake



    -- stake BLID

    select
    tx_hash,
    decoded_log:from as Staker,
    decoded_log:value/pow(10,decimals) as withdraw_amount,
    symbol as token_symbol
    from bsc.core.ez_decoded_event_logs l
    inner join bsc.core.dim_contracts c on c.address = l.contract_address
    where event_name = 'Transfer'
    and contract_address = '0x766afcf83fd5eaf884b3d529b432ca27a6d84617'
    and origin_function_signature = '0x41441d3b'
    and decoded_log:to = '0x3782c47e62b13d579fe748946aef7142b45b2cf7'
    limit 1

    -- Unstake BLID

    select
    tx_hash,
    decoded_log:to as Unstaker,
    decoded_log:value/pow(10,18) as reward_amount,
    'BLID' as symbol
    from bsc.core.ez_decoded_event_logs
    where event_name = 'Transfer'
    and contract_address = '0x766afcf83fd5eaf884b3d529b432ca27a6d84617'
    and origin_function_signature = '0x1058d281'
    and decoded_log:from = '0x3782c47e62b13d579fe748946aef7142b45b2cf7'
    and decoded_log:value/pow(10,18) > 0
    limit 10


    Run a query to Download Data