SUM(case when transfer_type = 'IBC_TRANSFER_IN' then amount/1000000 end ) AS atom_in,

SUM(case when transfer_type = 'IBC_TRANSFER_OUT' then amount/1000000 end ) AS atom_out,

(atom_in - atom_out) AS atom_net

FROM cosmos.core.fact_transfers

WHERE block_timestamp::date > '2020-12-31' AND currency = 'uatom'

GROUP BY Day