flipside

    LOOP
    boomer77LOOP
    Updated 2021-10-17
    select msg_value:sender::string as claimer, sum(msg_value:execute_msg:claim:amount/1e6) as LOOP_claimed
    from terra.msgs
    where msg_value:contract::string = 'terra1atch4d5t25csx7ranccl48udq94k57js6yh0vk' and tx_status = 'SUCCEEDED' and msg_value:execute_msg:claim:amount is not null
    group by 1
    order by 2 desc
    Run a query to Download Data