hessTop 15 Tokens by Number of Users (Swap to)
    Updated 2024-10-13
    with swap as ( select block_timestamp,
    tx_id,
    from_address,
    blockchain,
    pool_name,
    from_asset,
    to_asset,
    case when from_amount_usd is null then to_amount_usd else from_amount_usd end as amount_usd
    from thorchain.defi.fact_swaps)
    ,
    bots as ( select trunc(block_timestamp,'minute') as minutes,
    from_address,
    count(DISTINCT tx_id) as total_tx
    from swap
    group by 1,2
    having total_tx > 10)
    ,
    bot as ( select DISTINCT from_address
    from bots )

    select
    case when to_asset = 'THOR.RUNE' then 'RUNE'
    when to_asset = 'BTC/BTC' then 'BTC'
    when to_asset = 'ETH/ETH' then 'ETH'
    when to_asset = 'BTC.BTC' then 'BTC'
    when to_asset = 'ETH/USDT-0XDAC17F958D2EE523A2206206994597C13D831EC7' then 'USDT'
    when to_asset = 'ETH/USDC-0XA0B86991C6218B36C1D19D4A2E9EB0CE3606EB48' then 'USDC'
    when to_asset = 'ETH.ETH' then 'ETH'
    when to_asset = 'BNB.BUSD-BD1' then 'BUSD'
    when to_asset = 'BNB/BUSD-BD1' then 'BUSD'
    when to_asset = 'ETH.USDT-0XDAC17F958D2EE523A2206206994597C13D831EC7' then 'USDT'
    when to_asset = 'BNB.BNB' then 'BNB'
    when to_asset = 'ETH.USDC-0XA0B86991C6218B36C1D19D4A2E9EB0CE3606EB48' then 'USDC'
    when to_asset = 'AVAX/AVAX' then 'AVAX'
    when to_asset = 'DOGE/DOGE' then 'DOGE'
    when to_asset = 'BSC/BNB' then 'BNB'
    Last run: 3 months ago
    TOKEN
    USERS
    Active Days
    Swaps
    Volume (USD)
    Avg Volume (USD)
    Max Volume (USD)
    Median Volume (USD)
    From Tokens
    To Tokens
    Blockchains
    1
    RUNE64294013031700553044751177979.18112112.62112632573868618.7624813828.9593773841391012
    2
    ETH216852126726066057957886183.917532778.9059180991041599.53462372866.7397400011312
    3
    BTC1499681303378739516436813451.48363706.546401132383377.787046271224.43439347411311
    4
    BNB129091130310484041553526163.125631234.025781947248157.710690084877.8547336821411
    5
    USDT82529124922137435449970944.834381742.9872994181359560.500011441042.58359761811211
    6
    LTC344921270392587582733209.9840591163.943981241228761.538215019900.1080766171211
    7
    DOGE322031075588625908106664.3918881423.447228745119958.045632115992.7339021441411
    8
    ATOM20246911448738299480413.09274579.78501654898873.546031116473.5123124591311
    8
    785B
    45s