Pine AnalyticsHyperliquid ETH Bridge Metrics copy
    Updated 3 days ago
    select
    date_trunc('hour', block_timestamp) as hour,
    tx_type,
    sum(
    amount
    ) as amount,
    count(*) as events,
    count(distinct wallet) as wallets
    from (
    select
    block_timestamp,
    'Deposit' as tx_type,
    tx_hash,
    from_address as wallet,
    AMOUNT
    from ethereum.core.ez_native_transfers
    where to_address like lower('0xBEa9f7FD27f4EE20066F18DEF0bc586eC221055A')
    union all
    select
    block_timestamp,
    'Withdraw' as tx_type,
    tx_hash,
    to_address as wallet,
    AMOUNT
    from ethereum.core.ez_native_transfers
    where from_address like lower('0xBEa9f7FD27f4EE20066F18DEF0bc586eC221055A')
    )
    group by 1,2



    Last run: 3 days ago
    HOUR
    TX_TYPE
    AMOUNT
    EVENTS
    WALLETS
    1
    2025-04-16 17:00:00.000Withdraw33.63698969153
    2
    2025-04-17 05:00:00.000Deposit2.7207755411611
    3
    2025-04-09 11:00:00.000Deposit5.532455383119
    4
    2025-04-10 22:00:00.000Withdraw4.27317396622
    5
    2025-04-16 11:00:00.000Deposit21.9939185652317
    6
    2025-04-13 22:00:00.000Withdraw3.75847773621
    7
    2025-04-11 05:00:00.000Withdraw1.14905336222
    8
    2025-04-11 22:00:00.000Deposit3.77094509766
    9
    2025-04-17 12:00:00.000Withdraw11.74791694333
    10
    2025-04-14 08:00:00.000Withdraw2.61448257822
    11
    2025-04-13 17:00:00.000Withdraw5.71681405822
    12
    2025-04-14 09:00:00.000Withdraw27.59264603544
    13
    2025-04-17 20:00:00.000Withdraw7.42107848644
    14
    2025-04-04 21:00:00.000Deposit9.30489861413
    15
    2025-04-06 06:00:00.000Deposit5.57797524166
    16
    2025-04-15 18:00:00.000Deposit2.05703627877
    17
    2025-04-10 09:00:00.000Deposit46.3227371121918
    18
    2025-04-01 23:00:00.000Deposit0.0000540004136
    19
    2025-04-13 11:00:00.000Withdraw2.39516689722
    20
    2025-04-13 01:00:00.000Deposit0.94667948499
    ...
    902
    49KB
    13s