SELECT block_timestamp::date AS Day,
COUNT(case when transfer_type = 'IBC_TRANSFER_IN' then 1 end ) AS IBC_IN,
COUNT(case when transfer_type = 'IBC_TRANSFER_OUT' then 1 end ) AS IBC_OUT,
(IBC_IN + IBC_OUT) AS IBC_Total
FROM cosmos.core.fact_transfers
WHERE block_timestamp::date > '2020-12-31' AND (transfer_type = 'IBC_TRANSFER_IN' OR transfer_type = 'IBC_TRANSFER_OUT')
GROUP BY Day