hessTotal Per Project
    Updated 2025-05-01
    WITH stables AS (
    SELECT to_address,
    from_address,
    origin_to_address,
    tx_hash,
    block_timestamp,
    amount,
    symbol
    FROM sei.core_evm.ez_token_transfers
    WHERE contract_address IN (
    LOWER('0xB75D0B03c06A926e488e2659DF1A861F860bD3d1'),
    LOWER('0x3894085Ef7Ff0f0aeDf52E2A2704928d1Ec074F1')
    ))
    ,
    labels as ( select address,
    project_name as name
    from crosschain.core.dim_labels
    UNION
    select address,
    name
    from crosschain.core.dim_contracts
    UNION
    select address,
    name
    from sei.core_evm.dim_contracts)
    ,

    final as (select block_timestamp::date as date,
    origin_to_address,
    case when ORIGIN_TO_ADDRESS = '0xa4cf2f53d1195addde9e4d3aca54f556895712f2' then 'Dragonswap'
    when ORIGIN_TO_ADDRESS = lower('0x71f6b49ae1558357bBb5A6074f1143c46cBcA03d') then 'Dragonswap'
    when origin_to_address = '0x11da6463d6cb5a03411dbf5ab6f6bc3997ac7428' then 'Dragonswap'
    when origin_to_address = '0xdd489c75be1039ec7d843a6ac2fd658350b067cf' then 'Uniswap'
    when origin_to_address = '0xd43e6bf43654a7b4985f87c77686f7900d59f1ed' then 'Pit Finance'
    when origin_to_address = '0x4a4d9abd36f923cba0af62a39c01dec2944fb638'then 'Yei Finance'
    when origin_to_address = '0x1231deb6f5749ef6ce6943a275a1d3e7486f4eae' then 'Lifi'
    Last run: 16 days ago
    PROJECT
    TRANSACTIONS
    USERS
    VOLUME
    1
    Yei Finance34016313646513239693391.1356
    2
    Dragonswap14761379744211810780762.5679
    3
    Uniswap1616614760559202082.29719
    4
    Layerzero2239014406422612427.031924
    5
    Sailor V3 Positions NFT-V144000630209722208.159659
    6
    kryptonite44000630209722208.159659
    7
    Jellyswap1783796624184255574.968852
    8
    Openocean14760852159334738.786236
    9
    Lifi307756923154500378.443593
    10
    Stargate12350983498458731.802706
    10
    438B
    49s