flipside

    Accounts with both aUST Transfer Ins and Outs
    shreyash-5873Accounts with both aUST Transfer Ins and Outs
    Updated 2021-09-09
    select
    m.msg_value:execute_msg:transfer:recipient::string as recipient
    from terra.msgs m
    where m.msg_value:execute_msg:transfer is not null
    and m.msg_value:contract::string = 'terra1hzh9vpxhsk8253se0vv5jj6etdvxu3nv8z07zu'
    union
    select
    m.msg_value:execute_msg:transfer:sender::string as sender
    from terra.msgs m
    where m.msg_value:execute_msg:transfer is not null
    and m.msg_value:contract::string = 'terra1hzh9vpxhsk8253se0vv5jj6etdvxu3nv8z07zu'
    Run a query to Download Data