t1 as (

select

distinct tx_sender as wallet,

sum(asset_amount/pow(10,decimals)) as total_amount

from algorand.core.ez_transaction_asset_transfer

where block_timestamp::date >= current_date -30

and asset_id = 31566704 group by 1

),

t2 as (

select distinct sender as wallet,

sum(amount/pow(10,decimal)) as total_amount

from axelar.core.fact_transfers

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

and block_timestamp::date >= current_date -30 group by 1

),

t3 as (

select distinct FLOW_WALLET_ADDRESS as wallet,

sum(amount) as total_amount

from flow.core.ez_bridge_transactions

where token_contract = 'A.b19436aae4d94622.FiatToken'

and block_timestamp::date >= current_date -30 group by 1

),

t4 as (

select distinct split(tx:receipt[0]['outcome']['logs'], ' ')[3] as wallet,

sum(cast(split(tx:receipt[0]['outcome']['logs'], ' ')[1] as INT)/pow(10,6)) as total_amount

from near.core.fact_transactions

where tx_receiver like 'a0b86991c6218b36c1d19d4a2e9eb0ce3606eb48.factory.bridge.t4'

and split(tx:receipt[0]['outcome']['logs'], ' ')[1] <> 'account'

and block_timestamp::date >= current_date -30 group by 1

),

t5 as (

select distinct sender as wallet,

sum(amount/pow(10,decimal)) as total_amount

from osmosis.core.fact_transfers x

join osmosis.core.dim_labels on currency = address