hessDaily Share
    Updated 2025-01-05
    -- forked from Top Projects by Bridge Users @ https://flipsidecrypto.xyz/studio/queries/c354f43c-b8cc-46e2-bc2f-148aec10c8d6

    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
    Last run: about 1 month ago
    DAY
    TYPES
    TRANSACTIONS
    1
    2024-11-06 00:00:00.000Defi17
    2
    2024-11-06 00:00:00.000Unknown152
    3
    2024-11-06 00:00:00.000Dex81
    4
    2024-11-06 00:00:00.000Lend and Borrow20
    5
    2024-11-06 00:00:00.000Bridge39
    6
    2024-11-07 00:00:00.000Dex111
    7
    2024-11-07 00:00:00.000Unknown204
    8
    2024-11-07 00:00:00.000Bridge72
    9
    2024-11-07 00:00:00.000Lend and Borrow61
    10
    2024-11-07 00:00:00.000game3
    11
    2024-11-07 00:00:00.000Defi22
    12
    2024-11-08 00:00:00.000Lend and Borrow34
    13
    2024-11-08 00:00:00.000Dex92
    14
    2024-11-08 00:00:00.000Unknown134
    15
    2024-11-08 00:00:00.000game4
    16
    2024-11-08 00:00:00.000Bridge66
    17
    2024-11-08 00:00:00.000Defi14
    18
    2024-11-09 00:00:00.000Lend and Borrow30
    19
    2024-11-09 00:00:00.000Defi17
    20
    2024-11-09 00:00:00.000Bridge42
    ...
    357
    14KB
    208s