distinct(currency),

case when transfer_type = cosmos then cosmos_transfer

when transfer_type = IBC_TRANSFER_IN THEN transfer_in

when transfer_type = IBC_TRANSFER_OUT THEN transfer_out

else null end as transfers

from cosmos.core.fact_transfers