John_GaltASTRO Staking 2
    Updated 2023-01-13
    select
    attributes:message:sender as mint_address,
    sum(attributes:wasm:"amount_0") / pow(10, 6) as mint_amount
    from terra.core.ez_messages
    where (attributes:wasm:"_contract_address_1" = 'terra1x62mjnme4y0rdnag3r8rfgjuutsqlkkyuh4ndgex0wl3wue25uksau39q8' and
    attributes:wasm:"action_1" = 'mint')
    and tx_succeeded = 'true'
    group by mint_address
    order by mint_amount DESC

    Run a query to Download Data