BlockTrackerGMP based on chains
    Updated 2023-10-30
    with tb0 as
    (
    SELECT
    DISTINCT tx_id
    FROM axelar.core.fact_msg_attributes
    WHERE ATTRIBUTE_VALUE = 'Event_ContractCallWithToken'

    )
    ,
    tb1 as (
    SELECT
    'squid' as platform,
    tx_id,
    block_timestamp,
    ATTRIBUTE_VALUE as chain
    FROM axelar.core.fact_msg_attributes a
    JOIN tb0 b using(tx_id)
    WHERE MSG_TYPE = 'eventConfirmation' AND ATTRIBUTE_KEY = 'chain'
    ),
    tb3 as (
    SELECT
    DISTINCT tx_id
    FROM axelar.core.fact_msg_attributes
    WHERE ATTRIBUTE_VALUE = 'Event_ContractCall'

    )
    ,
    tb4 as (
    SELECT
    '[MintDAO Bridge | Prime Protocol | etc]' as platform,
    tx_id,
    block_timestamp,
    ATTRIBUTE_VALUE as chain
    FROM axelar.core.fact_msg_attributes a
    JOIN tb3 b using(tx_id)
    WHERE MSG_TYPE = 'eventConfirmation' AND ATTRIBUTE_KEY = 'chain'
    Run a query to Download Data