hessTop Projects by Bridge Users
    Updated 2025-01-05
    with avalanche_base as ( select DISTINCT tx_hash,
    block_timestamp,
    from_address,
    origin_from_address,
    symbol,
    amount,
    amount_usd
    from avalanche.core.ez_token_transfers
    where origin_to_address = lower('0x1231deb6f5749ef6ce6943a275a1d3e7486f4eae')
    and block_timestamp::Date >= current_date - 60
    UNION
    select DISTINCT tx_hash,
    block_timestamp,
    from_address,
    origin_from_address,
    'AVAX' as symbol,
    amount,
    amount_usd
    from avalanche.core.ez_native_transfers
    where origin_to_address = lower('0x1231deb6f5749ef6ce6943a275a1d3e7486f4eae')
    and block_timestamp::Date >= current_date - 60
    )
    ,
    avalanche_baseII as (select a.block_timestamp::date as date,
    a.tx_hash,
    b.origin_from_address,
    'Avalanche' as chain,
    decoded_log:bridgeData:bridge::string as bridge,
    b.amount_usd,
    b.symbol
    from avalanche.core.fact_decoded_event_logs a join avalanche_base b on a.tx_hash = b.tx_hash
    where a.contract_address = lower('0x1231deb6f5749ef6ce6943a275a1d3e7486f4eae')
    and decoded_log:bridgeData:destinationChainId::string = '1329'
    and b.from_address = b.origin_from_address
    and a.block_timestamp::Date >= current_date - 60
    and b.block_timestamp::date >= current_date - 60
    Last run: about 1 month ago
    PROJECTS
    ORIGIN_TO_ADDRESS
    TRANSACTIONS
    1
    Jellyswap0xfb43069f6d0473b85686a85f4ce4fc1fd8f008758771
    2
    Dragonswap0x11da6463d6cb5a03411dbf5ab6f6bc3997ac74285122
    3
    Yei Finance0x4a4d9abd36f923cba0af62a39c01dec2944fb6384749
    4
    Lifi0x1231deb6f5749ef6ce6943a275a1d3e7486f4eae4493
    5
    0x5867f5f586827317b25821f5538390b4fe0ba4850x5867f5f586827317b25821f5538390b4fe0ba4853833
    6
    0x4863a723f889162f0af9d197d97d172ec74f65ac0x4863a723f889162f0af9d197d97d172ec74f65ac2958
    7
    0x1d3a594eaf472ca2cec2a8ae44478c06d6a37e220x1d3a594eaf472ca2cec2a8ae44478c06d6a37e222497
    8
    Dragonswap0xa7fdcbe645d6b2b98639ebacbc347e2b575f6f701644
    9
    0xbc096b6a7d5404de916b3333ad223a1b32eec8aa0xbc096b6a7d5404de916b3333ad223a1b32eec8aa1495
    10
    Dragonswap0x72c0cd98d21ee3263d375437b4fdac097b596dd61449
    11
    Uniswap0xdd489c75be1039ec7d843a6ac2fd658350b067cf1040
    12
    0xc67e55dbe708ed56b65b0a3dd66ba0e683e405130xc67e55dbe708ed56b65b0a3dd66ba0e683e405131001
    13
    0x60485c5e5e3d535b16cc1bd2c9243c78773742590x60485c5e5e3d535b16cc1bd2c9243c7877374259935
    14
    0x36068f15f257896e03fb7edba3d18898d0ade8090x36068f15f257896e03fb7edba3d18898d0ade809779
    15
    Openocean0x6352a56caadc4f1e25cd6c75970fa768a3304e64774
    15
    1KB
    204s