flipside

    IBC 5
    Pine AnalyticsIBC 5
    Updated 2024-01-30
    WITH current_week_data AS (
    SELECT
    'Axelar' as chain,
    count(*) as transactions,
    count(DISTINCT
    CASE when transfer_type LIKE 'IBC_TRANDFER_OUT' then sender else RECEIVER end
    ) as users
    FROM axelar.core.fact_transfers
    WHERE transfer_type LIKE '%IBC%'
    AND block_timestamp > current_date - 7
    GROUP BY 1

    UNION

    SELECT
    'Osmosis' as chain,
    count(*) as transactions,
    count(DISTINCT
    CASE when transfer_type LIKE 'IBC_TRANDFER_OUT' then sender else RECEIVER end
    ) as users
    FROM osmosis.core.fact_transfers
    WHERE transfer_type LIKE '%IBC%'
    AND block_timestamp > current_date - 7
    GROUP BY 1

    UNION

    SELECT
    'Cosmos' as chain,
    count(*) as transactions,
    count(DISTINCT
    CASE when transfer_type LIKE 'IBC_TRANDFER_OUT' then sender else RECEIVER end
    ) as users
    FROM cosmos.core.fact_transfers
    WHERE transfer_type LIKE '%IBC%'
    AND block_timestamp > current_date - 7
    Last run: over 1 year agoAuto-refreshes every 6 hours
    CHAIN
    CURRENT_WEEK_TRANSACTIONS
    NOMINAL_CHANGE_IN_TRANSACTIONS
    PERCENTAGE_CHANGE_IN_TRANSACTIONS
    CURRENT_WEEK_USERS
    NOMINAL_CHANGE_IN_USERS
    PERCENTAGE_CHANGE_IN_USERS
    1
    		Cosmos110599-11647-9.53% 🔴42025-12138-22.41% 🔴
    2
    		Osmosis324029-74722-18.74% 🔴116326-22526-16.22% 🔴
    3
    		Terra9230-2644-22.27% 🔴2226-871-28.12% 🔴
    4
    		Sei6360-1537-19.46% 🔴2927-805-21.57% 🔴
    5
    		Axelar40404-3214-7.37% 🔴5116-479-8.56% 🔴
    5
    319B
    9s