zakkisyed#2 THORchain Arbitration Bots
    Updated 2022-07-20
    with bots as
    (
    SELECT
    from_address,
    COUNT(DISTINCT tx_id) as swaps
    FROM flipside_prod_db.thorchain.swaps
    where block_timestamp >= '2022-01-01'
    --and from_address = '0x%'
    GROUP BY 1
    HAVING swaps > 5000
    )
    SELECT
    count(DISTINCT from_address) as swappers,
    count(DISTINCT tx_id) as swaps,
    sum(TO_AMOUNT_USD) as volume_usd
    FROM flipside_prod_db.thorchain.swaps
    WHERE from_address in (
    SELECT from_address
    from bots
    )
    Run a query to Download Data