Flipside TeamDaily Active Autonomous Services
    Updated 6 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 6 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-02-15 00:00:00.0000033100010332476.285
    2
    2025-02-14 00:00:00.0000048500040489476.714
    3
    2025-02-13 00:00:00.0000048700030490479
    4
    2025-02-12 00:00:00.0000047800040482480.142
    5
    2025-02-11 00:00:00.0000148300000484479.142
    6
    2025-02-10 00:00:00.0000047500010476482.714
    7
    2025-02-09 00:00:00.0000045300000453484.857
    8
    2025-02-08 00:00:00.0000045600040460488.285
    9
    2025-02-07 00:00:00.0000048500070492487.714
    10
    2025-02-06 00:00:00.0000050000060506485.857
    11
    2025-02-05 00:00:00.0000048300070490485.714
    12
    2025-02-04 00:00:00.0000047300040477489.714
    13
    2025-02-03 00:00:00.0000049400070501488.571
    14
    2025-02-02 00:00:00.0000046600020468490.857
    15
    2025-02-01 00:00:00.0000048200020484491.857
    16
    2025-01-31 00:00:00.0000048300050488494.857
    17
    2025-01-30 00:00:00.0000048800050493497.285
    18
    2025-01-29 00:00:00.00000476000130489498.571
    19
    2025-01-28 00:00:00.00000494000110505497
    20
    2025-01-27 00:00:00.0000048400090493496.571
    ...
    947
    49KB
    632s