flipside

    Getting Started
    wzpGetting Started
    Updated 2025-04-03
    with buy AS(
    Select * from (
    SELECT
    sum(SWAP_FROM_AMOUNT) as buy_amount,
    SWAPPER
    FROM
    solana.defi.fact_swaps
    WHERE
    SWAP_FROM_MINT = 'So11111111111111111111111111111111111111112'
    AND SWAP_TO_MINT = '{{param_KLda}}'
    group by SWAPPER) where buy_amount > 1),


    sell AS(
    Select * from (
    SELECT
    sum(SWAP_TO_AMOUNT) as sell_amount,
    SWAPPER
    FROM
    solana.defi.fact_swaps
    WHERE
    SWAP_TO_MINT = 'So11111111111111111111111111111111111111112'
    AND SWAP_FROM_MINT = '{{param_KLda}}'
    group by SWAPPER) where sell_amount > 1)

    select buy.SWAPPER from buy inner join sell on buy.SWAPPER = sell.SWAPPER where (sell.sell_amount - buy.buy_amount) > 1

    Last run: 21 days ago
    SWAPPER
    1
    		GVm6z78yY5XKtshobt3hZ9q9WNj3STe4ctUax9xr4jVt
    2
    		F5nVFhVmBBaoYzqyGp1fs8AYhRFgsQKrmyNPVsNUGhsu
    3
    		2131GEqbpAbwCwk81cXP2gx8jZTrse1sJMAq3KyCsMno
    4
    		Fr78FexaX9XkszsUUHJFFKSQgpi7m1t9X5uwXQyJRoS6
    5
    		4cS5rhgDqhhSvCH6rjdweRCSQidvhFtjwwb4MC1o55hU
    6
    		AcJkk3CcCvtFRL9dNY4GamphB72kjhyAu6YfcwcpTnLD
    7
    		CVvJnDPcWdmUJN6YC4cHwBS2cJ9T8KoVh3xEwGquHYz1
    8
    		Bp24VPRwR3tCcRnSEK1XU9Zpw2axh1cqZsi4HPjCP2yf
    9
    		AD8jcZZBxDeUioRURusA1GLnSBXLcsUT3ff6Z5eWketg
    10
    		97UKrjY8bt1A9XAMJfxqd2TCZw18eB9xezaYM7jvVzn2
    11
    		FLAkE5D2oG5ggG5jZ8SYEHFtnh9TZVCeen2gb7mMCyqt
    12
    		5Uwd35XaEWkRk4rdZ3QejFttsT2StQ67mnukzcmSNkbF
    12
    589B
    16s