select block_timestamp,

tx_id

from axelar.core.fact_transfers

where currency = 'uusdc' and TX_SUCCEEDED = 'TRUE'

and block_timestamp::date >= current_date - 30

)

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

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 'Others' END as label,

count(distinct a.tx_id) as transactions,

row_number() over (order by transactions desc) as rank

from usdc_wallets a

join axelar.core.fact_msg_attributes b on a.tx_id = b.tx_id

where a.block_timestamp::date >= current_date - 30

group by 1

qualify rank <= 10

order by 1