flipside

    GP minter
    boomer77GP minter
    Updated 2021-10-28
    select msg_value:sender::string as minter,
    sum(msg_value:execute_msg:reserve_nft:payment:amount/1e6) as mint_payment,
    msg_value:execute_msg:reserve_nft:payment:info:native_token:denom::string as Currency,
    count(tx_status) as GP_minted
    from terra.msgs
    where msg_value:contract::string = 'terra16wuzgsx3tz4hkqu73q5s7unxenefkkvefvewsh' and msg_value:execute_msg:reserve_nft:operator::string = 'terra1lglmepz64mlcus2f7zq9gxzhtucpf080hf0997'
    and tx_status = 'SUCCEEDED'
    group by 1,3
    Run a query to Download Data