freemartianAll Stakes
    Updated 4 days ago
    WITH datas as (
    select
    block_timestamp, tx_hash, origin_from_address as user_address, amount, 'stake' as label
    from base.core.ez_token_transfers
    where origin_function_signature = '0x6e553f65'
    and contract_address = '0x98d0baa52b2d063e780de12f615f963fe8537553'
    and origin_to_address = '0x548d3b444da39686d1a6f1544781d154e7cd1ef7'
    -- and from_address = '0x0000000000000000000000000000000000000000'
    -- and tx_hash = '0xbbb7bd642c374163d57fb3edc9d776d3144c47db1456b7ca441abccc5061ccb4'

    union all

    select
    block_timestamp,tx_hash, origin_from_address as user_address, -amount as amount, 'unstake' as label
    from base.core.ez_token_transfers
    where origin_function_signature = '0x9343d9e1'
    and from_address = '0x548d3b444da39686d1a6f1544781d154e7cd1ef7'
    and contract_address = '0x98d0baa52b2d063e780de12f615f963fe8537553'

    order by 1 asc
    )

    select
    count(tx_hash) as transactions,
    count(distinct user_address) as users,
    sum(amount) as amounts
    from datas

    Last run: 4 days agoAuto-refreshes every 1 hour
    TRANSACTIONS
    USERS
    AMOUNTS
    1
    216841712314051534.3068111
    1
    32B
    6s