(SELECT block_id, block_timestamp, tx_id,sender, receiver, amount::real/1e6 AS amount,

split(message_value:receiver,1)[0] AS rec_chain,split(message_value:sender,1)[0] AS send_chain ,message_type,transfer_type

FROM terra.core.ez_transfers

WHERE currency = 'uluna'

AND tx_succeeded = 'TRUE'),

ibc_trf AS

(SELECT *

FROM total_luna_trf

WHERE message_type = '/ibc.applications.transfer.v1.MsgTransfer')

SELECT

(SELECT SUM(amount)

FROM ibc_trf

) AS "# LUNA IBC-ed out",

(SELECT SUM(amount)

FROM total_luna_trf

) AS "Total Transferred LUNA",

"# LUNA IBC-ed out"*100/"Total Transferred LUNA" AS "% LUNA IBC-ed out"