flipside

    failed tx type
    boomer77failed tx type
    Updated 2022-03-29
    with fail as (
    select count(distinct tx_id) as fail_count, msg_module, date_trunc('day', block_timestamp::date) as dt
    from terra.msgs
    where tx_status = 'FAILED'
    and block_timestamp > CURRENT_DATE - 90
    group by 2,3
    )

    select * from fail
    Run a query to Download Data