date(block_timestamp),

case

when event_attributes:packet_data:receiver like 'osmo%' then 'Osmosis'

when event_attributes:packet_data:receiver like 'axelar%' then 'Axelar'

when event_attributes:packet_data:receiver like 'secret%' then 'Secret'

when event_attributes:packet_data:receiver like 'inj%' then 'Injective'

end as chain,

sum(event_attributes:packet_data:amount)/power(10,6) as amount

from terra.msg_events

where

event_attributes:packet_data:receiver like any ('osmo%','secret%','inj%','axelar%')

and event_attributes:packet_data:denom = 'uusd'

group by 1,2