BaseTotal holders
    Updated 2025-02-01

    with database AS
    (with general as (
    with tbl3 as (
    with tbl as (
    select
    to_address as "Address",
    sum(amount) as "Input"
    from
    base.core.ez_token_transfers
    where
    contract_address = lower ('0x833589fcd6edb6e08f4c7c32d4f71b54bda02913')
    group by
    1
    ),
    tbl2 as (
    select
    from_address as "Address",
    sum(amount) as "Output"
    from
    base.core.ez_token_transfers
    where
    contract_address = lower ('0x833589fcd6edb6e08f4c7c32d4f71b54bda02913')
    group by 1
    )
    select
    tbl."Address",
    case
    when "Input" is null then 0
    else "Input"
    end as "Input tokens",
    case
    when "Output" is null then 0
    else "Output"
    end as "Output tokens"
    from
    QueryRunArchived: QueryRun has been archived