flipside

    The most popular actions after bridging to Near through Rainbow bridge according to the number of transactions
    nsa2000The most popular actions after bridging to Near through Rainbow bridge according to the number of transactions
    Updated 2022-10-19
    WITH bridge_to_near_or_aurora as (
    SELECT
    *,
    CASE
    WHEN LEN(account_id) = 64 then 'Near'
    WHEN contains(account_id,'near') then 'Near'
    WHEN contains(account_id,'aurora:') then 'Aurora'
    ELSE account_id
    END as label
    FROM (
    SELECT
    CASE
    WHEN TX_JSON:receipt:logs[1]:decoded:inputs:accountId IS NOT NULL THEN TX_JSON:receipt:logs[1]:decoded:inputs:accountId
    WHEN TX_JSON:receipt:logs[2]:decoded:inputs:accountId IS NOT NULL THEN TX_JSON:receipt:logs[2]:decoded:inputs:accountId
    WHEN TX_JSON:receipt:logs[3]:decoded:inputs:accountId IS NOT NULL THEN TX_JSON:receipt:logs[3]:decoded:inputs:accountId
    WHEN TX_JSON:receipt:logs[4]:decoded:inputs:accountId IS NOT NULL THEN TX_JSON:receipt:logs[4]:decoded:inputs:accountId
    WHEN TX_JSON:receipt:logs[5]:decoded:inputs:accountId IS NOT NULL THEN TX_JSON:receipt:logs[5]:decoded:inputs:accountId
    WHEN TX_JSON:receipt:logs[6]:decoded:inputs:accountId IS NOT NULL THEN TX_JSON:receipt:logs[6]:decoded:inputs:accountId
    ELSE NULL
    END as account_id,
    CASE
    WHEN TX_JSON:receipt:logs[1]:decoded:inputs:amount IS NOT NULL THEN TX_JSON:receipt:logs[1]:decoded:inputs:amount
    WHEN TX_JSON:receipt:logs[2]:decoded:inputs:amount IS NOT NULL THEN TX_JSON:receipt:logs[2]:decoded:inputs:amount
    WHEN TX_JSON:receipt:logs[3]:decoded:inputs:amount IS NOT NULL THEN TX_JSON:receipt:logs[3]:decoded:inputs:amount
    WHEN TX_JSON:receipt:logs[4]:decoded:inputs:amount IS NOT NULL THEN TX_JSON:receipt:logs[4]:decoded:inputs:amount
    WHEN TX_JSON:receipt:logs[5]:decoded:inputs:amount IS NOT NULL THEN TX_JSON:receipt:logs[5]:decoded:inputs:amount
    WHEN TX_JSON:receipt:logs[6]:decoded:inputs:amount IS NOT NULL THEN TX_JSON:receipt:logs[6]:decoded:inputs:amount
    ELSE NULL
    END as amount,
    CASE
    WHEN TX_JSON:receipt:logs[1]:decoded:inputs:token IS NOT NULL THEN TX_JSON:receipt:logs[1]:decoded:inputs:token
    WHEN TX_JSON:receipt:logs[2]:decoded:inputs:token IS NOT NULL THEN TX_JSON:receipt:logs[2]:decoded:inputs:token
    WHEN TX_JSON:receipt:logs[3]:decoded:inputs:token IS NOT NULL THEN TX_JSON:receipt:logs[3]:decoded:inputs:token
    WHEN TX_JSON:receipt:logs[4]:decoded:inputs:token IS NOT NULL THEN TX_JSON:receipt:logs[4]:decoded:inputs:token
    WHEN TX_JSON:receipt:logs[5]:decoded:inputs:token IS NOT NULL THEN TX_JSON:receipt:logs[5]:decoded:inputs:token
    WHEN TX_JSON:receipt:logs[6]:decoded:inputs:token IS NOT NULL THEN TX_JSON:receipt:logs[6]:decoded:inputs:token
    Run a query to Download Data