case

when block_timestamp < '2022-01-01' then '2021'

when block_timestamp >= '2022-01-01' and block_timestamp < '2023-01-01' then '2022'

when block_timestamp >= '2023-01-01' and block_timestamp < '2024-01-01' then '2023'

when block_timestamp >= '2024-01-01' and block_timestamp < '2025-01-01' then '2024'

when block_timestamp >= '2025-01-01' then '2025'

end as yearly,

count(DISTINCT from_address) as user_count,

count(DISTINCT tx_hash) as tx_count,

sum(value) as volume,

sum(tx_fee) as tx_fees

from boba.core.fact_transactions

group by 1