freemartianBolide USDT v2 Table
    Updated 2023-09-11
    -- forked from Bolide ETH Table @ https://flipsidecrypto.xyz/edit/queries/bd0fba9d-1896-45d5-9d94-8385fce051fa

    with eth_table as (
    select
    tx_hash,
    block_timestamp,
    decoded_log:from as actor,
    decoded_log:value/pow(10,decimals) as amount,
    symbol as token_symbol,
    'Deposit' as action
    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'
    and tx_status = 'SUCCESS'
    and block_timestamp > '2022-08-01'

    UNION

    select
    tx_hash,
    block_timestamp,
    decoded_log:to as actor,
    decoded_log:value/pow(10,decimals) as amount,
    symbol as token_symbol,
    'withdraw' as action
    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 in ('0x881a0faa347e610c0b0f5abaf89dc23bbd6dd702')
    and tx_status = 'SUCCESS'
    Run a query to Download Data