select
array_size(tx:body:messages) as msgz,
tx:body:messages[0]:"@type" as msg0_type,
tx:body:messages[0]:msg as msg0,
tx:body:messages[1]:msg as msg1,
tx:body:messages[1]:"@type" as msg1_type,
tx:body:messages[2]:msg as msg2,
tx:body:messages[2]:"@type" as msg2_type
from
terra.core.fact_transactions
where msgz > 1
-- and msg0 is not null
limit 10