select block_timestamp::date as date,
transfer_type,
count (distinct tx_id) as TX_Count
from osmosis.core.fact_transfers
where tx_status = 'SUCCEEDED'
and transfer_type in ('IBC_TRANSFER_IN','IBC_TRANSFER_OUT')
and block_timestamp >= CURRENT_DATE - 90
group by 1,2
order by 1