forgashUntitled Query
    Updated 2022-10-11
    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
    Run a query to Download Data