flipside

    user swaps
    tactical_retreat-w-n-iNuser swaps
    Updated 2025-01-15
    WITH vars AS (SELECT '0xffff003a6bad9b743d658048742935fffe2b6ed7' as token_address)
    SELECT *
    FROM avalanche.defi.ez_dex_swaps
    CROSS JOIN vars
    WHERE
    (TOKEN_IN = vars.token_address OR TOKEN_OUT = vars.token_address)
    AND ORIGIN_FROM_ADDRESS IN (lower('0xa810e8324648da89a77a3aef91128d46b0b05cf5'))
    AND BLOCK_TIMESTAMP >= '2025-01-14 00:00:00'
    QueryRunArchived: QueryRun has been archived