flipside

    avg GP pool
    boomer77avg GP pool
    Updated 2021-11-03
    with raw as (select tx_id, block_timestamp, msg_value:execute_msg:send:amount/1e6 as amount_deposit
    from terra.msgs
    where msg_value:contract::string = 'terra126zhrrpkckjs82elgutz5qmqa4zjndfwk5dr2t' and tx_status = 'SUCCEEDED')

    select avg(amount_deposit), median(amount_deposit) from raw
    Run a query to Download Data