flipside

    bots swappers
    chillbots swappers
    Updated 2022-04-27
    with bots_address as (select distinct MSG_VALUE:delegator_address as address from terra.msgs where tx_id in
    (select tx_id from terra.msgs where msg_type='market/MsgSwap' and block_timestamp > CURRENT_DATE() - interval '1 month') and MSG_MODULE ='distribution')

    select count(*) , block_timestamp::date as date from terra.swaps where trader in(select address from bots_address)
    and block_timestamp > CURRENT_DATE() - interval '1 month'
    group by date

    Run a query to Download Data