flipside

    Top swappers
    Afonso_DiazTop swappers
    Updated 2025-05-18
    with

    main as (
    select
    tx_hash,
    block_timestamp,
    trader as swapper,
    platform,
    symbol_in,
    symbol_out,
    nvl(amount_in_usd, amount_out_usd) as amount_usd
    from
    near.defi.ez_dex_swaps
    where
    block_timestamp between '{{ start_date }}' and '{{ end_date }}'
    and 'wrap.near' in (token_in_contract, token_out_contract)
    and amount_usd < 1e6

    )

    select
    swapper,
    count(distinct tx_hash) as swaps,
    sum(amount_usd) as volume_usd,
    avg(amount_usd) as average_amount_usd
    from
    main
    where
    amount_usd > 0
    group by 1
    order by volume_usd desc
    limit 100
    Last run: 14 days ago
    SWAPPER
    SWAPS
    VOLUME_USD
    AVERAGE_AMOUNT_USD
    1
    		7c5206b1b75b8787420b09d8697e08180cdf896c5fcf15f6afbf5f33fcc3cf72633381192462105.942531303.863706387
    2
    		trader-near.near363101131275880.139002360.605423368
    3
    		96dd5e85761cb091a0af7fc906b4126048b670bdcaa66035362031857f6206e9238619102934208.095203431.374735856
    4
    		487702bab3c6caa9cf1da3845e6311f5e1dd9a82f1c53e7e0fd55f55b631ab8234913253152912.3935919152.243026688
    5
    		aldor.near39033951358217.189430265.786852919
    6
    		simpleguy.near3505026253436.9958384748.344934606
    7
    		dao-v5.near2454623571809.7039094633.514558802
    8
    		v1.near15121926664.2010134140555.539750086
    9
    		51c0b243a75ace637d883afaae4e912d8d5842bfae11e8adfc9afc269fb0b70f3315620658457.3179901623.0496522
    10
    		jreive.near12527818044230.3812924100.971597939
    11
    		kagool.near4009012817289.8459804159.858439816
    12
    		dao-v6.near880812047953.8924289704.188081853
    13
    		zalevsky.near2545010861070.6674751213.380563212
    14
    		stasiey.near1024010786838.3789569368.566589639
    15
    		relay.tg5379699706723.3669387814.823249612
    16
    		achatz64.near158249625368.92122217608.12287852
    17
    		frisky.near185729528619.90604935256.531873413
    18
    		c0c47c126faec0741dc040db0f460599c90d2bc597c04f94adafb4e40f0b50fd987750749.4549307379089.280152354
    19
    		roundshirt9942.near415037516000.60659627181.095357121
    20
    		0-relay.hot.tg3496127429078.7286932216.742340452
    100
    7KB
    646s