MasiTotal Numbers
    Updated 2025-03-08
    with tb1 as ( select block_timestamp,
    tx_hash,
    origin_to_address,
    origin_from_address as swapper,
    from_address as dyor_router,
    contract_address as token_in,
    symbol as symbol_in,
    amount as amount_in,
    amount_usd as amount_in_usd
    from ink.core.ez_token_transfers
    where from_address = '0x9b17690de96fcfa80a3acaefe11d936629cd7a77'
    union
    select block_timestamp,
    tx_hash,
    origin_to_address,
    origin_from_address as swapper,
    from_address as dyor_router,
    contract_address as token_in,
    symbol as symbol_in,
    amount as amount_in,
    amount_usd as amount_in_usd
    from ink.core.ez_token_transfers
    where origin_to_address = lower('0x9b17690de96fcfa80a3acaefe11d936629cd7a77')
    and origin_from_address = from_address)
    ,
    tb2 as ( select b.*,
    contract_address as token_out,
    symbol as symbol_out,
    amount as amount_out,
    amount_usd as amount_out_usd
    from ink.core.ez_token_transfers a join tb1 b on a.tx_hash = b.tx_hash
    where to_address = b.swapper
    union
    select b.*,
    contract_address as token_out,
    symbol as symbol_out,
    Last run: about 2 months ago
    Swappers
    Swaps
    Avg Swap Per User
    Volume
    Avg Volume Per User
    Average Volume
    Median Volume
    Max Volume
    Token (IN)
    Token (OUT)
    1
    331001150903.47703911791668356.24374622489226623169211
    1
    67B
    28s