flipside

    Num
    MasiNum
    Updated 2025-02-02
    with tb0 as ( select block_timestamp,
    from_address
    from thorchain.core.fact_transfers
    where block_timestamp::date >= current_date - 31
    UNION
    select block_timestamp,
    from_address
    from thorchain.defi.fact_swaps
    where block_timestamp::date >= current_date - 31
    UNION
    select block_timestamp,
    native_to_address as from_address
    from thorchain.defi.fact_swaps
    where block_timestamp::date >= current_date - 31)
    ,
    tb1 as (select
    'ethereum' as blockchain,
    count(DISTINCT from_address) as active_addresses
    from ethereum.core.fact_transactions
    where block_timestamp::date >= current_date - 31
    group by 1
    UNION all
    select
    'base' as blockchain,
    count(DISTINCT from_address) as active_addresses
    from base.core.fact_transactions
    where block_timestamp::date >= current_date - 31
    group by 1
    UNION all
    select
    'arbitrum' as blockchain,
    count(DISTINCT from_address) as active_addresses
    from arbitrum.core.fact_transactions
    where block_timestamp::date >= current_date - 31
    group by 1
    UNION all
    Last run: about 1 month ago
    CHAIN
    BLOCKCHAIN
    ACTIVE_ADDRESSES
    1
    		Other Chainsethereum7801130
    2
    		Other Chainsbase20060420
    3
    		Other Chainsarbitrum5234565
    4
    		Other Chainsavalanche706409
    5
    		Other Chainsoptimism1631644
    6
    		Other Chainspolygon5453687
    7
    		Other Chainsblast105581
    8
    		Other Chainskaia7946024
    9
    		Nearnear5707564
    10
    		Other ChainsAptos16172691
    11
    		Other Chainssei2598141
    12
    		Other Chainsthorchain72232
    13
    		Other Chainsaxelar11047
    14
    		Other Chainssolana77273355
    15
    		Other ChainsFlow3020949
    15
    500B
    373s