purifexuberant-fuchsia
    Updated 2025-01-26
    select sender, sum(amount) as amount from (
    select concat('0x',substr(TOPICS[1], 27,64)) as sender, count(-1.0) as amount
    from sei.core_evm.fact_event_logs
    where contract_address = '0x7f51575f486e26f83e575a3fe77db71032e4d124'
    and topics[0]='0xddf252ad1be2c89b69c2b068fc378daa952ba7f163c4a11628f55a4df523b3ef'
    group by 1
    union all
    select concat('0x',substr(TOPICS[2], 27,64)) as sender, count(1.0) as amount
    from sei.core_evm.fact_event_logs
    where contract_address = '0x7f51575f486e26f83e575a3fe77db71032e4d124'
    and topics[0]='0xddf252ad1be2c89b69c2b068fc378daa952ba7f163c4a11628f55a4df523b3ef'
    group by 1
    )
    group by 1 having sum(amount)>0
    QueryRunArchived: QueryRun has been archived