count(distinct tx_id) as txn_count,

sum(iff(transfer_type = 'IBC_TRANSFER_IN', amount / 1e6, 0)) as inflow,

sum(iff(transfer_type = 'IBC_TRANSFER_OUT', amount / 1e6, 0)) as outflow,

inflow - outflow as netflow

from osmosis.core.fact_transfers

where currency = 'ibc/D176154B0C63D1F9C6DCFB4F70349EBF2E2B5A87A05902F57A6AE92B863E9AEC' --STOSMO

and tx_succeeded = 1

and year(block_timestamp) >= 2022