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

AND

MSG_GROUP = '1:0'

),

token_Table as

SELECT

timestamps,

ATTRIBUTE_VALUE,

TX_ID,

users,