zakkisyed#7 THORchain Arbitration ETH Bots
    Updated 2022-07-20
    select count(*) as txn_count, native_to_address,
    sum(to_amount_usd) as swap_volume,
    case when to_asset like '%/%' then 'synths'
    when to_asset like '%.%' then 'non-synths'
    else 'unknown'
    end as asset_type
    from flipside_prod_db.thorchain.swaps
    where from_address = '0x53b8021dad6dc1ca045488b399113b9083bc0988'
    and block_timestamp >='2022-01-01'
    and blockchain = 'ETH'
    group by 2,4
    order by 1 desc

    Run a query to Download Data