flipside

    swap
    BlockTrackerswap
    Updated 3 days ago
    select
    affiliate_address,
    sum(from_amount_usd) as volume
    from maya.defi.fact_swaps
    group by 1
    order by 2 desc


    select max(block_timestamp)
    from maya.defi.fact_swaps

    -- wr : THORWallet
    -- , ts : ThorSwap
    -- dx : Asgardex
    -- ELD : Dorito
    -- cs , CS CacaoSwap
    -- rg : Rango
    -- ej : Edge Wallet
    -- vi , va ,v0 : Vultisig
    -- leo : LeoDex
    --dp : Astrolescent
    -- ms : ClioSwap
    -- ds : Defispot
    -- moca : Moca
    -- is : Instaswap
    -- be : WinBit32
    -- fs : FortunaSwap
    --







    Last run: 3 days ago
    AFFILIATE_ADDRESS
    COUNT(1)
    1
    		2574923
    2
    		wr878011
    3
    		ts788206
    4
    		dx613219
    5
    		ELD151869
    6
    		cs148404
    7
    		CS125681
    8
    		_113172
    9
    		rg104072
    10
    		ej75020
    11
    		vi66777
    12
    		leo36368
    13
    		dp29737
    14
    		ms14814
    15
    		ds13766
    16
    		moca11460
    17
    		va8991
    18
    		kf6803
    19
    		is4264
    20
    		sk2174
    ...
    128
    2KB
    2s