Cipher009-CpUJ5kBots on THOR copy
    Updated 2023-06-29
    -- forked from KowalskiDeFi / Bots on THOR @ https://flipsidecrypto.xyz/KowalskiDeFi/q/3PBxMZBBG3a4/bots-on-thor
    with
    bot_swappers as (
    select
    date_trunc('minute', block_timestamp) AS datetime,
    from_address as address,
    count(*) AS transaction_count
    from
    flipside_prod_db.thorchain.swaps
    WHERE
    block_timestamp >= CURRENT_DATE -20
    group by
    1,
    2
    having
    transaction_count > 10
    order by
    3 desc
    )
    SELECT
    date_trunc('day', datetime) as datetime,
    address,
    SUM(transaction_count) total_count
    from
    bot_swappers
    group by
    1,
    2
    order by
    3 desc
    Run a query to Download Data