Flipside TeamDaily Active Autonomous Services
    Updated 3 hours ago
    with base_services as (select
    distinct MULTISIG_ADDRESS as service

    from crosschain.olas.ez_service_registrations
    where BLOCKCHAIN = 'base'
    ),

    daily_transactions AS (
    SELECT
    DATE_TRUNC('day', BLOCK_TIMESTAMP) AS day,
    MULTISIG_ADDRESS AS service_multisig_address,
    'ethereum' AS chain
    FROM
    crosschain.olas.fact_service_events
    where
    BLOCKCHAIN = 'ethereum'
    UNION
    ALL
    SELECT
    DATE_TRUNC('day', BLOCK_TIMESTAMP) AS day,
    MULTISIG_ADDRESS AS service_multisig_address,
    'polygon' AS chain
    FROM
    crosschain.olas.fact_service_events
    where
    BLOCKCHAIN = 'polygon'
    UNION
    ALL
    SELECT
    DATE_TRUNC('day', BLOCK_TIMESTAMP) AS day,
    MULTISIG_ADDRESS AS service_multisig_address,
    'gnosis' AS chain
    FROM
    crosschain.olas.fact_service_events
    where
    BLOCKCHAIN = 'gnosis'
    Last run: about 3 hours agoAuto-refreshes every 12 hours
    DAY
    ETHEREUM_ACTIVE_MULTISIGS
    POLYGON_ACTIVE_MULTISIGS
    GNOSIS_ACTIVE_MULTISIGS
    SOLANA_ACTIVE_MULTISIGS
    ARBITRUM_ACTIVE_MULTISIGS
    OPTIMISM_ACTIVE_MULTISIGS
    BASE_ACTIVE_MULTISIGS
    CELO_ACTIVE_MULTISIGS
    Total active multisigs
    7-day trailing avg
    1
    2025-05-31 00:00:00.00000267000100277347.142
    2
    2025-05-30 00:00:00.00000298000120310356.571
    3
    2025-05-29 00:00:00.00000318001140333356.714
    4
    2025-05-28 00:00:00.00000342000150357353.285
    5
    2025-05-27 00:00:00.00000345000160361363.714
    6
    2025-05-26 00:00:00.00000354000140368358
    7
    2025-05-25 00:00:00.0000034100080349353.857
    8
    2025-05-24 00:00:00.00000342000100352350.428
    9
    2025-05-23 00:00:00.00001362000130376345.714
    10
    2025-05-22 00:00:00.00001323000100334349
    11
    2025-05-21 00:00:00.00000321000120333352.714
    12
    2025-05-20 00:00:00.00000423000110434340.857
    13
    2025-05-19 00:00:00.00000316000120328342.142
    14
    2025-05-18 00:00:00.0000031100090320344.571
    15
    2025-05-17 00:00:00.0000032200060328351
    16
    2025-05-16 00:00:00.00000332000110343357.428
    17
    2025-05-15 00:00:00.00000346000110357364.428
    18
    2025-05-14 00:00:00.00000348000110359372.428
    19
    2025-05-13 00:00:00.00000340000110351383.571
    20
    2025-05-12 00:00:00.00000327000100337398.857
    ...
    1052
    55KB
    59s