freemartianBolide Workspace
    Updated 2023-09-11
    -- select * from bsc.core.ez_decoded_event_logs
    -- where origin_to_address = '0xac4a30d5343fd28afea2ea70b1dea93f35183b18'
    -- and origin_function_signature = '0x00f714ce'

    with BNB_table as (
    select
    tx_hash,
    block_timestamp,
    decoded_log:depositor as actor,
    decoded_log:amount / pow(10, 18) as amount,
    'Deposit' as action
    from
    bsc.core.ez_decoded_event_logs
    where
    event_name = 'Deposit'
    and contract_address = '0xac4a30d5343fd28afea2ea70b1dea93f35183b18'
    and origin_function_signature = '0x6e553f65'
    and decoded_log:token = '0x0000000000000000000000000000000000000000'
    and tx_status = 'SUCCESS'
    and block_timestamp > '2023-07-10'
    UNION
    select
    tx_hash,
    block_timestamp,
    decoded_log:depositor as actor,
    decoded_log:amount / pow(10, 18) as amount,
    'Withdraw' as action
    from
    bsc.core.ez_decoded_event_logs
    where
    event_name = 'Withdraw'
    and contract_address = '0xac4a30d5343fd28afea2ea70b1dea93f35183b18'
    and origin_function_signature = '0x00f714ce'
    and decoded_log:token = '0x0000000000000000000000000000000000000000'
    and tx_status = 'SUCCESS'
    and block_timestamp > '2023-07-10'
    Run a query to Download Data