zakkisyedTHORchain Arbitration Bots
    Updated 2022-07-20
    SELECT
    date_trunc('day', block_timestamp) as block_time,
    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 (
    SELECT
    from_address,
    COUNT(DISTINCT tx_id) as swaps
    FROM flipside_prod_db.thorchain.swaps
    GROUP BY 1
    HAVING swaps > 5000
    )
    )
    and block_timestamp >= '2022-01-01'
    GROUP BY 1
    order by 1 desc

    Run a query to Download Data