with

attributes as (

SELECT

tx_id,attribute_value as chain FROM axelar.core.fact_msg_attributes WHERE attribute_key = 'destinationChain'

),

tokens as (

select

trunc(block_timestamp,'week') as date,

CASE WHEN attribute_value LIKE '%uaxl%' THEN 'AXL'

WHEN attribute_value LIKE '%uusdc%' THEN 'USDC'

WHEN attribute_value LIKE '%ibc/6F4968A73F90CF7DE6394BF937D6DF7C7D162D74D839C13F53B41157D315E05F%' THEN 'UST'

WHEN attribute_value LIKE '%ibc/9117A26BA81E29FA4F78F57DC2BD90CD3D26848101BA880445F119B22A1E254E%' THEN 'ATOM'

WHEN attribute_value LIKE '%weth-wei%' THEN 'WETH'

WHEN attribute_value LIKE '%ibc/4627AD2524E3E0523047E35BB76CC90E37D9D57ACF14F0FCBCEB2480705F3CB8%' THEN 'LUNA'

WHEN attribute_value LIKE '%wbtc-satoshi%' THEN 'WBTC'

when attribute_value LIKE '%ibc/0CD3A0285E1341859B5E86B6AB7682F023D03E97607CCC1DC95706411D866DF7%' THEN 'DAI'

when attribute_value LIKE '%ibc/3FF92D26B407FD61AE95D975712A7C319CDE28DE4D80BDC9978D935932B991D7%' THEN 'DOT'

when attribute_value LIKE '%ibc/D3327A763C23F01EC43D1F0DB3CEFEC390C362569B6FD191F40A5192F8960049%' THEN 'LINK'

when attribute_value LIKE '%ibc/D27DDDF34BB47E5D5A570742CC667DE53277867116CCCA341F27785E899A70F3%' THEN 'MKR'

ELSE 'Other' END as axl_symbol,

chain,

count(DISTINCT axelar.core.fact_msg_attributes.tx_id) as events,

sum(

CASE WHEN attribute_value LIKE '%uaxl%' THEN cast(REPLACE(attribute_value, 'uaxl', '') as INT) / power(10, 6)

WHEN attribute_value LIKE '%uusdc%' THEN cast(REPLACE(attribute_value, 'uusdc', '') as INT) / power(10, 6)

WHEN attribute_value LIKE '%ibc/6F4968A73F90CF7DE6394BF937D6DF7C7D162D74D839C13F53B41157D315E05F%' THEN cast(REPLACE(attribute_value, 'ibc/6F4968A73F90CF7DE6394BF937D6DF7C7D162D74D839C13F53B41157D315E05F', '') as INT) / power(10, 6)

WHEN attribute_value LIKE '%ibc/9117A26BA81E29FA4F78F57DC2BD90CD3D26848101BA880445F119B22A1E254E%' THEN cast(REPLACE(attribute_value, 'ibc/9117A26BA81E29FA4F78F57DC2BD90CD3D26848101BA880445F119B22A1E254E', '') as INT) / power(10, 6)

WHEN attribute_value LIKE '%weth-wei%' THEN cast(REPLACE(attribute_value, 'weth-wei', '') as INT) / power(10, 18)

WHEN attribute_value LIKE '%ibc/4627AD2524E3E0523047E35BB76CC90E37D9D57ACF14F0FCBCEB2480705F3CB8%' THEN cast(REPLACE(attribute_value, 'ibc/4627AD2524E3E0523047E35BB76CC90E37D9D57ACF14F0FCBCEB2480705F3CB8', '') as INT) / power(10, 6)

WHEN attribute_value LIKE '%wbtc-satoshi%' THEN cast(REPLACE(attribute_value, 'wbtc-satoshi', '') as INT) / power(10, 9)

when attribute_value LIKE '%ibc/0CD3A0285E1341859B5E86B6AB7682F023D03E97607CCC1DC95706411D866DF7%' THEN cast(REPLACE(attribute_value, '%ibc/0CD3A0285E1341859B5E86B6AB7682F023D03E97607CCC1DC95706411D866DF7%', '') as INT) / power(10, 18)

when attribute_value LIKE '%ibc/3FF92D26B407FD61AE95D975712A7C319CDE28DE4D80BDC9978D935932B991D7%' THEN cast(REPLACE(attribute_value, '%ibc/3FF92D26B407FD61AE95D975712A7C319CDE28DE4D80BDC9978D935932B991D7%', '') as INT) / power(10, 10)

when attribute_value LIKE '%ibc/D3327A763C23F01EC43D1F0DB3CEFEC390C362569B6FD191F40A5192F8960049%' THEN cast(REPLACE(attribute_value, '%ibc/D3327A763C23F01EC43D1F0DB3CEFEC390C362569B6FD191F40A5192F8960049%', '') as INT) / power(10, 18)

when attribute_value LIKE '%ibc/D27DDDF34BB47E5D5A570742CC667DE53277867116CCCA341F27785E899A70F3%' THEN cast(REPLACE(attribute_value, '%ibc/D27DDDF34BB47E5D5A570742CC667DE53277867116CCCA341F27785E899A70F3%', '') as INT) / power(10, 18)