Eman-RazAXL Swap Count By Chain
    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: 20 days ago
    Chain
    Swap Count
    Swap Volume ($USD)
    Swap Volume
    Swapper Count
    Number of Token Pairs
    1
    Osmosis7552910094487.7323601016.9113338
    2
    Ethereum109179168381.6820946927.2412807
    3
    Bsc388193540.48227431.5380312
    4
    Base3357160025.13374305.978006
    5
    Polygon7404506.5511053.333197
    6
    Arbitrum41824562.2256321.861223
    6
    258B
    21s