select

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 matic_transfers_to_osmosis,

count(distinct sender) as active_senders,

count(distinct receiver) as active_receivers,

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

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

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