select
label_type,
sum(amount/pow(10,6)) as amount
from terra.core.ez_transfers et join terra.core.dim_address_labels al on et.RECEIVER = al.ADDRESS
where TRANSFER_TYPE = 'IBC_Transfer_Off'
and BLOCK_TIMESTAMP::date = '2023-01-09'
and TX_SUCCEEDED = 'true'
group by 1
order by 1 desc
limit 10