Eman-RazTotal AXL Swap Stats
    Updated 2025-03-25
    with overview as (with ethereum as (select block_timestamp, tx_hash, origin_from_address as swapper, symbol_in, symbol_out, case
    when token_in=lower('0x467719ad09025fcc6cf6f8311755809d45a5e5f3') then amount_in
    when token_out=lower('0x467719ad09025fcc6cf6f8311755809d45a5e5f3') then amount_out
    end as swap_amount, case
    when token_in=lower('0x467719ad09025fcc6cf6f8311755809d45a5e5f3') then amount_in_usd
    when token_out=lower('0x467719ad09025fcc6cf6f8311755809d45a5e5f3') then amount_out_usd
    end as swap_amount_usd, 'Ethereum' as "Chain"
    from ethereum.defi.ez_dex_swaps
    where (token_in=lower('0x467719ad09025fcc6cf6f8311755809d45a5e5f3') or
    token_out=lower('0x467719ad09025fcc6cf6f8311755809d45a5e5f3'))),


    bsc as (select block_timestamp, tx_hash, origin_from_address as swapper, symbol_in, symbol_out, case
    when token_in=lower('0x8b1f4432f943c465a973fedc6d7aa50fc96f1f65') then amount_in
    when token_out=lower('0x8b1f4432f943c465a973fedc6d7aa50fc96f1f65') then amount_out
    end as swap_amount, case
    when token_in=lower('0x8b1f4432f943c465a973fedc6d7aa50fc96f1f65') then amount_in_usd
    when token_out=lower('0x8b1f4432f943c465a973fedc6d7aa50fc96f1f65') then amount_out_usd
    end as swap_amount_usd, 'Bsc' as "Chain"
    from bsc.defi.ez_dex_swaps
    where (token_in=lower('0x8b1f4432f943c465a973fedc6d7aa50fc96f1f65') or
    token_out=lower('0x8b1f4432f943c465a973fedc6d7aa50fc96f1f65'))),


    polygon as (select block_timestamp, tx_hash, origin_from_address as swapper, symbol_in, symbol_out, case
    when token_in=lower('0x6e4e624106cb12e168e6533f8ec7c82263358940') then amount_in
    when token_out=lower('0x6e4e624106cb12e168e6533f8ec7c82263358940') then amount_out
    end as swap_amount, case
    when token_in=lower('0x6e4e624106cb12e168e6533f8ec7c82263358940') then amount_in_usd
    when token_out=lower('0x6e4e624106cb12e168e6533f8ec7c82263358940') then amount_out_usd
    end as swap_amount_usd, 'Polygon' as "Chain"
    from polygon.defi.ez_dex_swaps
    where (token_in=lower('0x6e4e624106cb12e168e6533f8ec7c82263358940') or
    token_out=lower('0x6e4e624106cb12e168e6533f8ec7c82263358940'))),


    Last run: about 1 month ago
    Swap Count
    Swap Volume ($USD)
    Swap Volume
    Swapper Count
    Number of Token Pairs
    1
    9484219545503.7945217056.83454136
    1
    41B
    20s