SELECT

TX_ID as tx,

ATTRIBUTE_VALUE as user_ID

FROM

AXELAR.CORE.FACT_MSG_ATTRIBUTES

where

ATTRIBUTE_KEY = 'spender'

),

mix1 as

SELECT

user_ID as users,

BLOCK_TIMESTAMP::date as timestamps,

a.TX_ID,

a.ATTRIBUTE_VALUE

FROM

AXELAR.CORE.FACT_MSG_ATTRIBUTES a

JOIN user_Table b ON a.tx_id = b.tx

WHERE

MSG_TYPE = 'coin_spent'

AND

ATTRIBUTE_INDEX = 1

),

token_Table as

SELECT

timestamps,

ATTRIBUTE_VALUE,

TX_ID,

users,

CASE WHEN ATTRIBUTE_VALUE ilike '%uaxl%' then 'AXL'

WHEN ATTRIBUTE_VALUE ilike '%uusd%' then 'USDC'