-- forked from ZkSync Bridge @ https://flipsidecrypto.xyz/edit/queries/52c45456-ee6d-4e4e-b98c-4d72eb315b40

count(distinct ORIGIN_FROM_ADDRESS) as "Unique Bridgers"

(

select

AMOUNT,

AMOUNT_USD,

date_trunc('hour', BLOCK_TIMESTAMP) as HOUR,

TX_HASH,

ORIGIN_FROM_ADDRESS,

ORIGIN_TO_ADDRESS,

ORIGIN_FUNCTION_SIGNATURE,

ETH_FROM_ADDRESS as FROM_ADDRESS,

ETH_TO_ADDRESS as TO_ADDRESS

from

ethereum.core.ez_ETH_transfers

where

AMOUNT > 0

AND HOUR > '2023-03-24'

AND HOUR < '2023-03-25'

AND ORIGIN_TO_ADDRESS = '0x32400084c286cf3e17e7b677ea9583e60a000324'

AND ORIGIN_FUNCTION_SIGNATURE in ('0xeb672419') -- Deposit ETH

ORDER BY

BLOCK_TIMESTAMP

)