(SELECT

TX_ID as tx,ATTRIBUTE_VALUE as user_ID

FROM AXELAR.CORE.FACT_MSG_ATTRIBUTES

WHERE ATTRIBUTE_KEY = 'spender'),

M1 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 Table_of_user b ON a.tx_id = b.tx

where MSG_TYPE = 'coin_spent'

and ATTRIBUTE_INDEX = 1

and MSG_GROUP = '1:0'),

Table_of_Token as

( SELECT

timestamps,ATTRIBUTE_VALUE,TX_ID,users,

CASE WHEN ATTRIBUTE_VALUE ilike '%weth-wei%' then 'ETH'

when ATTRIBUTE_VALUE ilike '%uaxl%' then 'AXL'

when ATTRIBUTE_VALUE ilike '%uusd%' then 'USDC'

when ATTRIBUTE_VALUE ilike '%ibc/6F4968A73F90CF7DE6394BF937D6DF7C7D162D74D839C13F53B41157D315E05F%' then 'UST'

when ATTRIBUTE_VALUE ilike '%wbtc-satoshi%' then 'WBTC'

else 'OTHER' end AS token

FROM M1),

token_Amount_Table as

( SELECT

timestamps,TX_ID,users,token,

CASE WHEN ATTRIBUTE_VALUE ilike '%uusdc%' then cast(REPLACE(attribute_value, 'uusdc', '') as INT) / power(10, 6)

WHEN ATTRIBUTE_VALUE ilike '%uaxl%' then cast(REPLACE(ATTRIBUTE_VALUE, 'uaxl', '') as INT) / power(10,6)

WHEN ATTRIBUTE_VALUE ilike '%weth-wei%' then cast(REPLACE(attribute_value, 'weth-wei', '') as INT) / power(10, 18)

WHEN ATTRIBUTE_VALUE ilike '%ibc/6F4968A73F90CF7DE6394BF937D6DF7C7D162D74D839C13F53B41157D315E05F%' then cast(REPLACE(attribute_value, 'ibc/6F4968A73F90CF7DE6394BF937D6DF7C7D162D74D839C13F53B41157D315E05F', '') as INT) / power(10, 6)

WHEN ATTRIBUTE_VALUE ilike '%wbtc-satoshi%' then cast(REPLACE(attribute_value, 'wbtc-satoshi', '') as INT) / power(10, 9)

END AS amount

FROM Table_of_Token),