flipside

    pre col 5
    boomer77pre col 5
    Updated 2021-10-12
    with ass as (select date_trunc('day',block_timestamp) as block_day, sum(msg_value:execute_msg:claim:amount/1e6) as amount, msg_value:contract::string as contract
    from terra.msgs
    where msg_value:execute_msg:claim is not null and tx_status = 'SUCCEEDED' and block_timestamp >= CURRENT_DATE - 90
    group by 1,3)

    select contract
    from ass
    group by 1

    Run a query to Download Data