transfer_type,

tx_id,

unique_key,

count(tx_id) as transfered_tokens

from cosmos.core.fact_transfers

where transfer_type = 'IBC_TRANSFER_IN'

group by transfer_type, tokens, tx_id, unique_key