flipside

    floor hourly GP
    boomer77floor hourly GP
    Updated 2021-10-21
    select date_trunc('hour', block_timestamp) as dt, min(msg_value:execute_msg:post_order:"order":"order":taker_asset:amount/1e6) as amount
    from terra.msgs
    where msg_value:execute_msg:post_order:"order":"order":maker_asset:info:nft:contract_addr::string = 'terra103z9cnqm8psy0nyxqtugg6m7xnwvlkqdzm4s4k' --GP contract add
    and msg_value:execute_msg:post_order:"order":"order":taker::string = 'terra1eek0ymmhyzja60830xhzm7k7jkrk99a60q2z2t' -- RandomEarth
    group by 1
    order by 1 desc
    Run a query to Download Data