trunc(block_timestamp,'day') as date,

case when date>='2022-12-20' then 'After incetives' else 'Before incentives' end as period,

count(distinct tx_id) as txs,

count(distinct sender) as senders,

count(distinct receiver) as receivers,

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

avg(amount/pow(10,decimal)) as avg_volume

from osmosis.core.fact_transfers

where currency ilike '%ibc/AB589511ED0DD5FA56171A39978AFBF1371DB986EC1C3526CE138A16377E39BB%'

and transfer_type ='IBC_TRANSFER_IN'

and tx_succeeded='TRUE'

group by 1,2

order by 1 asc