elsinaYearly activity
    Updated 2025-03-01
    SELECT
    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



    Last run: 17 days ago
    YEARLY
    USER_COUNT
    TX_COUNT
    VOLUME
    TX_FEES
    1
    202350301697833649.63170155636.119239788
    2
    202534592630046359.0598204821.934992664
    3
    202112203271549279967.726348247812.748074767
    4
    2024153491160423528977.02377877723.251786433
    5
    20221393465476469937.450236625233.9356565
    5
    254B
    4s