binhachonAstroport Rewards Analysis - Adjust reward per block
    Updated 2022-04-19
    select
    *
    from (
    select
    block_id,
    block_timestamp,
    msg_value:execute_msg:set_tokens_per_block:amount::float/1e6 as amount
    from terra.msgs
    where msg_value:contract::string = 'terra1zgrx9jjqrfye8swykfgmd6hpde60j0nszzupp9'
    and msg_value:execute_msg:set_tokens_per_block is not null
    union all
    select
    5918639 as block_id,
    '2022-01-02 21:26:02' as block_timestamp,
    8403094/1e6 as amount
    )
    order by block_id


    Run a query to Download Data