flipside

    Near1 total Eth--> Near
    FatemeTheLadyNear1 total Eth--> Near
    Updated 2022-10-05
    WITH bridge_to_near as (
    SELECT
    *
    FROM
    (
    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
    Run a query to Download Data