block_timestamp::date as day,

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,

sum(inflow) over (order by day) as cumulative_inflow,

sum(outflow) over (order by day) as cumulative_outflow,

sum(netflow) over (order by day) as cumulative_netflow

from osmosis.core.fact_transfers

where currency = 'ibc/D176154B0C63D1F9C6DCFB4F70349EBF2E2B5A87A05902F57A6AE92B863E9AEC' --STOSMO

and tx_succeeded = 1

and year(block_timestamp) >= 2022

group by 1

order by 1