freemartianBolide USDT V2

    -- deposit USDT

    select
    tx_hash,
    decoded_log:from as Depositor,
    decoded_log:value/pow(10,decimals) as deposit_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 = '0x55d398326f99059ff775485246999027b3197955'
    and origin_function_signature = '0x6e553f65'
    and decoded_log:to = '0x881a0faa347e610c0b0f5abaf89dc23bbd6dd702'
    limit 5

    -- withdraw USDT

    select
    tx_hash,
    decoded_log:to as Withdrawer,
    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 = '0x55d398326f99059ff775485246999027b3197955'
    and origin_function_signature = '0x00f714ce'
    and decoded_log:from = '0x881a0faa347e610c0b0f5abaf89dc23bbd6dd702'
    --and tx_hash = '0x606652d4ce38289e54b239b6f97596763a8579f69febb25a2d7c02885b29e19c'
    limit 10

    -- deposit BLID into ETH vault for boost

    select
    Run a query to Download Data