select

count(distinct(contract_address)) as tokens

from arbitrum.core.fact_token_transfers

),

active as (

select

concat('Active') as category,

count(distinct(contract_address)) as tokens

from arbitrum.core.fact_token_transfers

where block_timestamp >= current_date - 30

),

dormant as (

select

concat('Dormant') as category,

total.tokens - active.tokens as tokens

from total

join active

select *

from active

union

select *

from dormant